Below is an example of the WIN-202 Processing Schedule for the 3rd Quarter of 2009.  Dates (excluding deliverable dates) can vary depending on the situation during the quarter. 
  
DATE 	
PROCESS 	
RUN THIS	
COMMENT 	

10-01-09 to 11-7-09 	
Processing 3Q09 MWR's 	
  	
·  Vendor keys employment & wages 
·  Analyst updates addresses, adds/closes units etc 	

10-31-09 	
Create 2010 control file & ARS forms 	
·  Create control file through create a process  (program supplied by Maine) 	

11-10-09 	
Load MWR data 	

11-28-09 	
Roll down quarter for 3Q09 	
·  Lock all quarters except 2Q09
·  Quarter Maintenance – Move quarters/create new current	
·  2008-Q2 through 2009-Q3 are locked 
·  2009 quarters may be opened to allow selected on-line updates, then roll Macro Quarter so micro changes corrects the macro file, lock quarter 
·  Codes are updated for those records which had early 3Q09 data entered	

11-7-09 through end of qtr 	
3Q09 MWR (second request) data 	
  	
·  Enter data on a flow basis 	

11-7-09 through end of qtr 	
Load EDI data on flow basis 	
·  EDI Load 	

11-7-09 through end of ARS 	
Load TRS data 
Scan ARS forms 	

12-01-09 	
Load July Aug Sept CES data 	
·  CES staff runs M30 for those months 	

12-01-09 	
First 3Q09 tax extract 

·  Run mainframe tax extract 
·  COPY admin file & quarterly file to WIN202 server 
·  Load admin – input file is column formatted 
·  Load quarterly – input file is column formatted 	
·  In addition to 3Q09 data, includes 2Q09 late data and updates that pass criteria 	

12-01-09 	
Load wage record data 	
·  Create summary file from wage record extract 	
·  October release will also have a predecessor/successor wage record load 	

DATE 	
PROCESS 	
RUN THIS	
COMMENT 	

12-01-09 	
Integrated edit  	
·  Integrated edit – Produce quarterly listing – Produce integrated edit – Edit records with reported data 	
·  Edits both 3Q09 & 2Q02 data (unlocked quarters) 
·  Both quarters errors are viewable on-line 
·  Edit flags are set	

12-01-09 	
CES reporter query 	
·  Run query 	
·  Lists delinquent reporters that have reported CES data for possible use for ES-202 	

12-01-09 	
3Q09 missing employment notices mailed 	
	
·  We had existing mainframe programs to print these.  We FTP a data file created by the tax extract processing to the mainframe as the input file for the print programs. 	

12-01-09 to 
01-05-10
  	
Edit 3Q09 data 	
·  Print Micro Edit Summary (error counts) 
·  Print Multi Balance edit 
·  On-line editing- walk through the errors by error code	
·  Enter late 3Q09 & 2Q09 MWR, missing employment & reimbursable data on-line 	

12-31-09 	
4Q09 MWR’s printed & mailed 	

01-05-10 	
3Q09 missing employment data entered through batch update 	
·  COPY vendor file to WIN202 server 
·  Load quarterly – input file is column formatted	
·  Vendor keys the data to tape, file exists on the mainframe 	

01-05-10 	
Second 3Q09 tax extract 	
·  Run mainframe tax extract 
·  COPY admin file & quarterly file to WIN202 server 
·  Load admin – input file is column formatted 
·  Load quarterly – input file is column formatted	
·  Includes 3Q09 & 2Q09 late data and updates that pass criteria 	

01-05-10 	
3Q09 estimates 	
·  Estimates 3Q09 	

01-05-10 	
Look at Win-202 macro graphs  	
	
·  To see how the quarter is shaping up against prior quarters & as a quick data review	

01-05-10 	
Integrated edit	
·  Integrated edit – Produce quarterly listing – Produce integrated edit – Edit records all records	
·  Edits both 3Q09 & 2Q09 data (unlocked quarters)
·  Both quarters errors are viewable on-line
·  Edit flags are set	

CCS Edit (first quarter only) 	

01-05-10 to 01-28-10   	
Edit data 	
·  Print Micro Edit Summary (error counts) 
·  Print Multi Balance edit 
·  On-line editing – walk through the errors by error code	
·  Enter late 3Q09 & 2Q09 MWR, missing employment, and reimbursable data on-line 	

Load 2Q09 geo data from BLS   	
	
·  Load when received – before EQUI is created   	

DATE 	
PROCESS 	
RUN THIS	
COMMENT 	

01-22-10   	
Scored Edit 	
·  Run scored edit listing   	
·  Review for critical errors   	

01-22-10   	
3Q09 46F for RO   	
	
·  Review graphs   	

11-27-10, 11-28-10 AM   	
Integrated edit 	
·  Print Micro Edit Summary (error counts) 
·  On-line editing – walk through the errors by error code for critical errors only 	
·  To check for any remaining critical errors only 
·  Final review of Macro Edit 	

11-27-10, 11-28-10 AM 	
Look at Win-202 macro graphs 	
	
·  A quick, final data review   	

11-28-10   	
Create 3Q09 initial EQUI  	
·  Creates EQUI & 46f   	
·  Start run when leaving for the day. 
·  No one can be in database while this is running! 	

11-29-10   	
First 3Q09 EQUI transmittal 	

11-29-10 to 02-26-10 	
BLS review/clean up period 	
·  Make any necessary micro corrections/comments 	

02-15-10   	
4Q09 MWR & Reimbursable (first request) data entered through batch update 	
·  COPY vendor file to WIN202 server
·  Load quarterly – input file is column formatted 	
·  Vendor keys the data to tape, file exists on the mainframe 
·  4Q09 quarter record exists for updated units only 
·  Code and tax rate data for 4Q09 are stored as ? until next quarter roll down	

02-19-10   	
46F for BLS   	

02-24-10   	
Integrated edit   	
·  Print Micro Edit Summary (error counts) 
·  On-line editing – walk through the errors by error code for critical errors only 	
·  To check for any remaining critical errors only 
·  Final review of Macro Edit prior to cleanup file creation 	

02-25-10   	
3Q09 EQUI Correction file 	
·  Produce EQUI 3Q09 	
·  Includes 3Q09 & prior quarter corrections as necessary 
·  Start run when leaving for the day 
·  No one can be in database while this is running!