SQL queries

Name Size Modified
.. — —
STF Automation —
Training —
ATBS and Pending WIP by JX.sql 6 KB
Active Municipality documents.sql 780 bytes
ActualAndStandard-productivityComparison-.sql 10 KB
ActualVsStandard_WithMetrics.sql 8 KB
BNA_PwC approvals.sql 215 bytes
Carolyn Barcode documents.sql 795 bytes
Carolyn JavaScript and Ruby docs.sql 871 bytes
Carolyn Published docs without conversion.sql 1 KB
CarolynActiveInWorkflowWorkingCopy.sql 672 bytes
CarolynDefectCount.sql 861 bytes
CarolynInnodata.sql 6 KB
CarolynJavaScript Forms.sql 1 KB
CarolynJavaScriptConversionProgress2018.sql 683 bytes
Carolyn_Active JXs on SF build.sql 285 bytes
Carolyn_DAS_Productivity_Improvement_MSA.sql 623 bytes
Carolyn_DefectNotes.sql 968 bytes
Carolyn_Doc properties.sql 681 bytes
Carolyn_Docs by JX.sql 988 bytes
Carolyn_Logout_Times.sql 1 KB
Carolyn_Minutes Logged into WF per Day.sql 2 KB
Carolyn_Workflow Backlog.sql 498 bytes
Carolyn_attempted time to publish.sql 361 bytes
Carolyn_combineQueries.sql 12 KB
Download Count.sql 917 bytes
Forms_start_end.sql 1 KB
Glen PWC k-1 property documents last version.sql 1 KB
Glen Processed Docs by Date Time Jx.sql 5 KB
GlenAcquisitionRawDataForProductivityCorrelation.sql 3 KB
GlenActualAndStandard-Total by Team by Week-.sql 11 KB
GlenActualAndStandard-by user output-.sql 10 KB
GlenActualAndStandard.sql 9 KB
GlenDownloadsYearOverYearByWeek.sql 2 KB
GlenLeadTimeRevamp.sql 9 KB
GlenMonthlyCalcChangesByYear.sql 1 KB
GlenNewDoc-NewVer-OverwritePercentages.sql 1 KB
GlenPwC_SALT_Data.sql 1 KB
GlenRawCycle.sql 3 KB
Glen_Capacity_ActualVsSTandardDetail-Cleaned up.sql 6 KB
Glen_Corrections.sql 4 KB
Glen_Defects for Create Operations By Operator over date range.sql 7 KB
Glen_DocumentsProcessedCreated_ForJessicaCalvosa.sql 1 KB
Glen_ForWarren_CapacityByOperation_04-01-2016-Current.sql 5 KB
Glen_PwC documents that are Variables with end dates.sql 1 KB
Glen_Std and Actual CapacityByOperation_.sql 7 KB
Glen_StdActual_For Year End 2020.sql 7 KB
Glen_Stub Automation Scope.sql 2 KB
Glen_TestDataUpdate.sql 2 KB
Innodata report -defect notes IN PROGRESS.sql 798 bytes
Joe - Cycle Time - Audit Logs.sql 143 KB
Joe ATBS Wait Time.sql 165 KB
Joe Actual Appr-AcqTime.sql 1 KB
Joe Annual Forms Without End Dates.sql 590 bytes
Joe Appr Reqs Hardcopy Forms 21MAR2022.sql 376 bytes
Joe Approval Pending Time Query 12APR2018.sql 3 KB
Joe Approval Required Docs in Workflow 18MAR2022.sql 1 KB
Joe Backlog History.sql 124 bytes
Joe DL By Week 24AUG2022.sql 1 KB
Joe Docs Published by Time Period.sql 540 bytes
Joe Fed DL By Week 08AUG2018.sql 890 bytes
Joe Friday Operation Backlogs by Week.sql 514 bytes
Joe Jx List By Assigned DAS.sql 187 bytes
Joe Operation Backlogs By Date 11MAR2022.sql 112 bytes
Joe Processed Docs by Date Time Jx Updated 2019MAR26.sql 4 KB
Joe Processed Docs by Date Time Jx 12JUL2021.sql 4 KB
Joe Processed Docs by Date Time Jx.sql 4 KB
Joe PwC 2D Forms.sql 3 KB
Joe PwC Actual Document Count 01MAR2022.sql 1 KB
Joe PwC Docs Uploaded to Portal 08MAR2022.sql 1 KB
Joe PwC Files Without Specs.sql 1 KB
Joe PwC Release Dates 02MAY2022.sql 1 KB
Joe PwC Time Calculation 01MAR2022.sql 641 bytes
Joe PwC Time Calculation.sql 1 KB
Joe PwC in Arrival Pending.sql 696 bytes
Joe STF and Innodata Time Spent by Operation.sql 2 KB
Joe SuperForm Complete List.sql 2 KB
Joe TRK Docs with Calculations.sql 77 bytes
Joe Test Audit Log.sql 1 KB
Joe Time Spent Per Document.sql 1 KB
Joe Wait Time By Operation - Audit Log.sql 1 KB
Joe Wait Time By Operation - Manifest.sql 564 bytes
Orphaned instruction.sql 633 bytes
SQLQuery15.sql 337 bytes
TIME & EFFICIENCY - production.sql 9 KB
Time per document with jx.sql 585 bytes
TimeSpentCalcs2D.sql 717 bytes
WEEKLY METRIC-WorkFlowX Update.sql 18 KB
Workflow_Audit.sql 301 KB
attempted_join standards properties.sql 9 KB
daily.sql 440 bytes
master list DocID_JXcode.sql 316 bytes
msa_Joe Poor Calc Attempt.sql 1 KB
stuff.sql 283 bytes