WIN-202 User Group Meeting

1. WIN-202User Group Meeting March 2005 Boston, Massachusetts

2. Plans for Sept. 2005 & Beyond Predecessor/Successor Changes CIPSEA Correction Policy Agenda Welcome March 2005 System Changes Regional Data Analysis Tool User Roundtable Upcoming Events

3. March 2005 System Changes • New Accounts Setup Date & Status Log • Micro Error Screen Sort Order • County MAC/NAICS Tab • MAC/MSA Inquiry Screen Yearly Graph • Quarterly Load Screen Default Behavior • System Edits Modifications • Estimation by MEEI Code • Macro Screen Roll Programs • Full & Subset EQUI • Lookup Edit and Transaction Screens • Administrative Screens • New & Changed Reports • Automatic Batch Jobs

4. New Accounts Changes • When an admin account is created, the following occurs: • Online: • The account’s setup date is assigned the current day’s date • A transaction record is added to the status-log with the user ID identified, the current date as the posted-date, and “CREATE” as the table name • Batch (admin load): • The accounts’ setup date is assigned the current day’s date unless a date already exists on the input record. In this case, the date from the incoming record is used. • A transaction record is added to the status-log with the run date as its posted-date and “CREATE” as the table name. A transaction record that is created via the admin load will not contain a user name, as it is a batch process

5. Micro Error Screen • The sort order of the main window’s error browser is now year/quarter within error code • This means that errors of the same number will display together and the year/quarter to which each relates is a sub-level

6. Wage Record Pred/Succ • The Cancel button on the Update Predecessor/ Successor input box was corrected to prevent fields from being updated when “Cancel” was selected

7. Tabs converted to Radio Buttons Mac/NAICS Tab • Changed the MAC/NAICS tab label to MAC/CTY • Adjusted Inquiry Screen to Look and Work Like Mac/MSA Inquiry Screen • All data is rolled up during the Macro Roll process, which increases screen performance • Note: Increases the time a Macro Roll takes in Batch

8. Mac/MSA Inquiry Screen • The Yearly graph on the MSA Inquiry screen was changed to include another year • This allows four years to display instead of three years • The Trend graph already displays four years, therefore has not been changed

9. Quarterly Processing - Load • The Quarterly Load selection allows the option of preventing the overwriting of Employment & Wage data with the indicators of only “C”, or only “R”, or both “C” & “R” or All if no check box is checked • The female employment fields and Indicators are loaded only if the "Include Female Data" option is set to "Yes" (State Info Screen) to prevent unnecessary transactions

10. Quarterly Processing - System Edits • Admin Edit 111 has been corrected to follow specifications: • A Canadian zip code in the mail/other address must be correctly structured or it will flag as an error • Zip codes cannot be comprised solely of numbers • Zip code extensions must have a number in the first position only, followed by blanks in positions 2-4 • Edit 129: A bypass for subunits has been added when the reported only option has been chosen • Edits 160 & 161: These two edits have switch priority from the “B” list edits to the “A” list edits • Batch Edits have been changed to use both the “R” or “C” indicators for the “Reported Only” option

11. Quarterly Processing - Estimate • The Estimate screen includes options to select “All Records”, “Singles Only”, or “Masters & Subunits Only” when running the batch Estimations

12. Quarterly Processing - Macro • The Macro roll programs have been modified to populate the modified MAC/NAICS table • Note: This increases run time for this batch job

13. Quarterly Processing - EQUI • Full & Subset EQUI • A change was made to both the Full & Subset EQUI programs to prevent any data in the Residence code field from being sent on the output file unless the Use Town Codes option has been selected on the State Info Screen • If the Use Town Codes is not selected, the output field is zero filled

14. Lookup Tables – Edit Parameters • Parameter values have changed per BLS for Parameters that are used in the large new record error (96/139) and large discontinued record error (97/140) • 73: State default 250; BLS default 250 • 74: State default 250; BLS default 250 • 75: State default 50; BLS default 50 • 76: State default 50; BLS default 50

15. Lookup Tables - Transaction • Lookup Transaction Screen no longer displays the User ID of the individual who made the change

16. Administrative - Monitor • Screen was widened to better display the report description and to remove the bottom scroll bar

17. Administrative - Transaction • The Administrative Transaction Screen is now the same as the Lookup Transaction Screen, however the User ID of the individual who made the change is displayed

18. Administrative - Maintenance • The move Quarters & Archive Quarters buttons include the option of Canceling or Continuing

19. Reports Screen • Selection of the NAICS code digit level is available for some reports • This option is provided for the Regional Data Analysis listings (3, 4 or 6 digit levels) and the Location Quotient Report • The Auto Reports Menu has been changed in a similar fashion

20. Reports - New • Location Quotient Reports – These new reports look up the national industry data from BLS ftp site and compare the data with state specific WIN-202 data using the formula: State Private Industry Employment ÷ State Private Total EmploymentNational Private Industry Employment ÷ National Private Total Employment) • Note: This report makes use of the shareware utility pkunzip and the ftp command native to Windows DOS. The WIN-202 server must have access to the ftp TCP/IP port in order to run this report

21. Reports – New (cont.) • Admin Transaction File • This is a new program that lists all the transactions that have occurred on the admin table for a specified date in an output file • Quarterly Transaction File • This procedure lists all the transactions that have occurred on the quarterly table for a specified date in an output file

22. Reports – New (cont.) • Macro File • This is a new program that creates a quarterly macro data file for a selected year and quarter • Quarterly Industry Cluster Reports • This new report is similar to the NAICS Sector Listings with the exception that the Industry Codes are selected into predetermined “Clusters” • This report can be run for County, Residence, Zone, Statewide, MSA, LMA, WIA, or City Geographies • Uses clusters developed in Pennsylvania and cannot be modified in this version

23. Reports – New (cont.) • Annual & Quarterly Files for the Regional Data Analysis Tool • These new reports create an unformatted file of 3, 4, and 6 digit aggregated Industry codes similar to the NAICS Sector Listings (Unformatted file) in a different file format • This report can be run for County, Residence, or Zone Geographies • Data is imported into the “State Data” table in the Microsoft Access Database customized by the individual state

24. Reports - Changed • Single Quarter EQUI (724, 1060, & 1166) • The single quarter EQUI files have been modified to output three position Zone codes in the Residences code field for those states that use Zone Codes • NAICS Sector Reports • The NAICS Sector Reports were updated to reflect 5-digit LMA & MSA codes • The “LMA”, “MSA”, and “WIA” titles in the procedure have been removed from the report so that it is not duplicated by table data (example: BANGOR MSA not BANGOR MSA MSA)

25. Automatic Batch Jobs • Reload State Data: Procedure reloads the WIN-202 database with State specific data • Build MSA Cross walk: Creates a cross walk for old and new MSA codes and descriptions. Procedure also modifies the Parameter Table for 73, 74,75, & 76 (both State & BLS values). • Load New MSA Codes & Descriptions: Loads the new MSA codes and descriptions to their respective tables • MSA, LMA, & WIA Code Update: “Pushes” the new MSA codes out to the quarterly file • Macro MSA roll: Aggregates the macro MSA data for years 2000 through the current year/quarter (Note: Runs a long time) • Macro County roll: Aggregates the macro County data for years 2000 through the current year/quarter (Note: Runs a long time) • Note: To use the Micro Error Screen with the new MSA codes, the WIN-202 System will need to run a Full Integrated Edit

26. Regional Data Analysis Tool • Microsoft Access Database to be customized by individual states • Provides Industry and Occupation Analysis • Analysis of labor data at the industry level, providing Location Quotient and Shift/Share Analysis, as well as industry employment and wage data. • Occupation Analysis providing occupational projections, wages by occupation, and other data by Metropolitan Statistical Area (MSA).

27. User Roundtable Items for the New “To Do” List June Tech Meeting Suggestions Priority of Items on the New “To Do” List Training Needs Correction Policy? Parameter Settings

28. March 2005 Changes • MSA Code and Title Changes • Changes provided to codes, field length, titles, crosswalks tables, etc • Resulted in changes to screens, lookup files, aggregation structures, files, and reports • Limited output for old structure as well as new • Analytical Tools • Location Quotients • Clustering • Shift Share • Links to National Data • Predecessor/Successor Changes • Priorities to selected edits • Parameter changes • MWR Form Changes resulting from OMB requirement • Client Requests

29. June 2005 Changes • CIPSEA Fix • Improve data fuzzy formulae • Include master records • Include employment and wage indicators • CIPSEA Macro Data • CIPSEA ALMIS--Micro and macro formats • Client Requests

30. September 2005 Changes • Annual Refiling Survey • Additional Analytical Tools • OES Sampling Format • Nondisclosure • Biweekly Study • CIPSEA • EDI • MWRweb • Data and Edit Issues • Geocoding • Predecessor/Successors and Wage Records • Client Requests

31. March 2006 Changes • Predecessor/Successor • EQUI • Monitoring • Client Requests

32. September 2006 Changes • Imputation • NAICS 2007 (this may be in September 2007!) • Client Requests

33. Timing Unknown • Annual Refiling Survey   • ARS central mailing • Correction Policy Changes  • Data • Pushback • Alternate CCS’s • EDI   • Agent Code Standardization • Agent Code Crosswalk and Conversion Needs • Edits   • Fix wage edit • Modifications to additivity parameter changes • Changes to address parameter break in small record checks • Training and Consistency Testing Database   • File information for testing • Training screens and output • Consistency testing instructions

34. Upcoming Events Query Training Class: June 22-24, Augusta, ME Tech Meeting: June 14-16, Philadelphia, PA

35. THANK YOU