March 2005 Release System Changes



Internal Processing

1 New Accounts

• When an admin account is created, the following actions automatically occur:

Online:

o The account’s setup date is assigned the value of the current day’s date.

o 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):

o The accounts’ setup date is assigned the value of the current day’s date unless a value already exists on the input record that is different. In this case, the value from the incoming record is used.

o 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.

Main Screen

1 Main Screen

• Changed the MAC/NAICS tab label to MAC/CTY. The MAC/CTY tab has been updated to have the same functionality as the MAC/MSA screen, including the upper level aggregations by entering a question mark or shortening the NAICS code to 2, 3, 4 or 5 digit.

2 Wage Record Predecessor/Successor Update Screen

• The Cancel button was corrected to prevent the fields from being updated when selected.

3 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.

4 Macro (MSA/NAICS) 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 fours years, therefore has not been changed.

5 Macro (County/NAICS) Inquiry Screen

• The County Macro Inquiry now works similarly to the MSA Macro Inquiry screen. All data is rolled up during the Macro Roll process, which increases screen performance. The batch job that rolls macro data takes longer.

Lookup Screens

1 Transaction Screen

• The lookup Transaction Screen with the generally available [LOOKUP TABLES] button no longer displays the User ID of the individual who made the change.

2 Edit / Parameter Screen

• The parameters used in edits 96/139 Large New Record and 97/140 Large Discontinued Record have been changed per BLS. Parameters 73, 74, 75, & 76 have been set as follows:

o 73 – State default 250; BLS default 250.

o 74 – State default 250; BLS default 250.

o 75 – State default 50; BLS default 50.

o 76 – State default 50; BLS default 50.

Quarterly Processing

1 System Edits

• Admin Edit 111 – Unusable Mailing / Other Zip code Format – has been corrected to process according to BLS specifications. The change means that a Canadian zip code in the mail/other address must be correctly structured or it will flag as an error. The correct structure is that the zip code cannot be comprised solely of numbers and the zip code extension must have a number in the first position only, followed by blanks in positions 2-4. Edit 111 will not flag for an invalid zip code if a useable address is found in either the Tax or Physical address.

• Edit 129 – Taxable / Total Wage Ratio Exceeds Prior Year Ratio by [TAXW-TOTW-CHG-PCT] % - a bypass for subunits has been added when the reported only option has been chosen.

• Edits 160 – Both Predecessor and Successor Reported & 161 – Neither Predecessor nor Successor Reported – 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.

2 Macro Screen

• The Macro roll programs have been modified to populate the modified macnaics table.

Note: These batch jobs run longer due to more macro data being aggregated.

3 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 Residence code field in the EQUI is zero filled.

4 Load Screen

• Quarterly Load

• Check boxes have been added to allow the State analyst the option of choosing to prevent the overwriting of Employment & Wage data with the indicators of only “C”, or only “R”, or both “C” & “R”. If none of the boxes are checked then the employment and wage indicators are not used to prevent data from being overwritten.

• The female employment fields and indicators will only be loaded if the "Include Female Data" option is set to "Yes" (State Info Screen) to prevent unnecessary transactions.

[pic]

5 Estimation Screen

• The Estimations screen was changed to allow the State Analyst to select “All”, “Singles Only”, or “Masters & Subunits Only” when running the batch Estimations.

[pic]

Administrative Screens

1 Monitor Screen

• The screen was widened to better display the report description and to remove the bottom scroll bar.

2 Administrative Transaction Screen

• The Administrative Transaction Screen is now the same as the Lookup Transaction Screen with the addition of the User ID of the individual who made the change being displayed.

3 Maintenance / Quarters Screen

• Move Quarters & Archive Quarters buttons – A Message box was added to allow the State Analyst the option of Canceling or Continuing.

[pic]

Reports

1 Reports Screen

• The Reports Menu has been changed to allow the 202 Analyst to select the NAICS code digit level similar to selecting a Year and Quarter to run a batch report. Currently, this option is available for the Regional Data Analysis listings (3, 4 or 6 digit levels) and the Location Quotient Report. The Auto Reports Menu has also been changed in a similar fashion.

[pic]

2 New Batch Reports

• Location Quotient Report – These new reports look up the national industry data from BLS ftp site and compare this data with state specific WIN-202 data using the formula:

(State Private Industry Employment / State Private Total Employment)

---------------------------------------------------------------------------------------------

(National Private Industry Employment / National Private Total Employment)

The output file naming conventions are:

National-lq-YYQ-Xdigit-Public.txt

National-lq-YYQ-Xdigit.txt

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.

• Admin Transaction File – This is a new program that lists all of the transactions that have occurred on the admin table for specified date in an output file. Output file is named win202_bes_es2_adm-trans.txt (See Appendix J for file format).

• Quarterly Transaction File – This procedure list all of the transactions that have occurred on the quarterly table for a specified date in an output file. Output file named win202_bes_es2_qtr-trans.txt (See Appendix J for file format).

• Macro File – This is a new program that creates a quarterly macro data file for a selected year and quarter. Output file named win202_bes_es2_macro.txt. (See Appendix I for file format).

• Quarterly Industry Cluster Reports – This is a new report that is similar to the NAICS Sector Listings with the exception that the Industry Codes are grouped into industry clusters (based on clusters developed in Pennsylvania). This report can be run for County, Residence, Zone, Statewide, MSA, LMA, WIA, or City geographies. Each report creates four output files:

• qtr-GEO-yyyy-q-public-unfom-CLUSTER.txt (Public Unformatted File – Same as NAICS Sector File Format)

• qtr-GEO-yyyy-q-public-form-CLUSTER.txt (Public Formatted Listing)

• qtr-GEO-yyyy-q-confid-unform-CLUSTER.txt (Confidential Unformatted File – Same as NAICS Sector File Format)

• qtr-GEO-yyyy-q-confid-form-CLUSTER.txt (Confidential Formatted Listing)

Note: the clusters used do not cover all possible NAICS codes. These reports reflect the correct total for the geography, but should not be used to cross check totals with other listings.

• Annual & Quarterly Regional DA (Data Analysis) –These are new reports that create an unformatted file of 3, 4, or 6 digit aggregated industry employment and wage data similar to the NAICS Sector Listings (unformatted file) in a different file format. This report can be run for County, Residence, or Zone Geographies. Output file name is RDTA-GEO6-yyyyQ3.txt. (See Appendix H for both file formats).

3 Changed Batch Reports

• Single Quarter EQUI (724, 1060, & 1166) – The single quarter EQUI files have been modified to output a 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. Also, 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).

Miscellaneous

1 Automatic Batch Jobs

• Reload State Data – Procedure will reload 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 will also modify 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: this job has a long run time.

• Macro County roll – Aggregates the macro County data for years 2000 through the current year/quarter. Note: this job has a long run 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.

Appendix – Regional Data Analysis File Formats (Delimited [;])

|Field |Quarterly Format |Description |

|Year |yyyyQq |Year & One letter description for type (Quarterly) & Quarter (1,2,3,4) |

|Geography |99999 |Code for County, Residences, or Zone |

|NAICS |999 |3 digit outputs 3 digit file |

| |9999 |4 digit outputs 3 & 4 digit file |

| |999999 |6 digit outputs 3, 4, & 6 digit file |

|Units |999999 |Number of units in the processed quarter |

|AME |9999999 |(m1emp + m2emp + m3emp) / 3 |

|Total Wages |999999999999 |Total wages for the quarter |

|Confidentiality |* or Blank |* if the data should be suppressed from the public blank if it is discloseable |

|Field |Annual Format |Description |

|Year |yyyyAA |Year & Two letter description for type (Annual Average) |

|Geography |99999 |Code for County, Residences, or Zone |

|NAICS |999 |3 digit outputs 3 digit file |

| |9999 |4 digit outputs 3 & 4 digit file |

| |999999 |6 digit outputs 3, 4, & 6 digit file |

|Units |999999 |Number of units in fourth quarter |

|AME |9999999 |(m1emp + m2emp + m3emp….+ m12emp) / 12 |

|Total Wages |999999999999 |Total wages for all four quarters |

|Confidentiality |* or Blank |* if the data should be suppressed from the public blank if it is discloseable |

Appendix Macro File Format

|Begin |End |Length |Type |Field Description |

|1 |3 |3 |Num |Fips County Code |

|4 |4 |1 |Num |Ownership Code: 1=Federal; 2=State; 3=Local; 5=Private |

|5 |10 |6 |Num |North American Industry Classification System Code |

|11 |14 |4 |Num |Year - YYYY |

|15 |15 |1 |Char |Quarter |

|16 |25 |10 |Num |UI Account Number of Largest Firm in Macro Cell |

|26 |35 |10 |Num |3rd Month of Employment of Largest Firm in Macro Cell |

|36 |42 |7 |Char |Number of Firms in Macro Cell (Non-Zero UI Account Numbers) |

|43 |51 |9 |Num |Number of Units in Macro Cell (Establishments) |

|52 |60 |9 |Num |Sum of 1st Month Employment In Macro Cell |

|61 |69 |9 |Num |Sum of 2nd Month Employment In Macro Cell |

|70 |78 |9 |Num |Sum of 3rd Month Employment In Macro Cell |

|79 |91 |13 |Num |Sum of Total Wages in Macro Cell |

|92 |104 |13 |Num |Sum of Taxable Wages in Macro Cell |

|105 |115 |11 |Char |Sum of Contributions in Macro Cell |

|116 |121 |6 |Num |Macro Comment Codes |

Appendix – Administrative & Quarterly Transaction File Format

1 Administrative Transaction File

|Begin |End |Length |Type |Field Description |

|1 |10 |10 |Num |UI Account Number |

|11 |15 |5 |Num |Reporting Unit Number |

|16 |21 |6 |Num |Date of Transaction - YYMMDD |

|22 |27 |6 |Num |Time of Transaction - HHMMSS |

|28 |28 |1 |Char |Type of Transaction |

|29 |36 |8 |Char |Batch Program ID or User ID |

|37 |45 |9 |Char |Federal Employer Identification (EIN) |

|46 |80 |35 |Char |Legal / Corporate Name |

|81 |115 |35 |Char |DBA / Trade Name |

|116 |150 |35 |Char |Physical Location Address (Line one) |

|151 |185 |35 |Char |Physical Location Address (Line two) |

|186 |220 |35 |Char |Reporting Unit Description |

|221 |250 |30 |Char |Physical City Location |

|251 |252 |2 |Char |Physical State Location |

|253 |257 |5 |Char |Physical Zip Code |

|258 |261 |4 |Char |Physical Zip Code Extension |

|262 |262 |1 |Char |UI Tax Address Type Indicator |

|263 |297 |35 |Char |UI Tax Address (Line one) |

|298 |332 |35 |Char |UI Tax Address (Line two) |

|333 |362 |30 |Char |UI Tax City |

|363 |364 |2 |Char |UI Tax State |

|365 |369 |5 |Char |UI Tax Zip Code |

|370 |373 |4 |Char |UI Tax Zip Code Extension |

|374 |376 |3 |Char |Telephone Area Code |

|377 |383 |7 |Char |Telephone Number |

|384 |388 |5 |Char |Telephone Number Extension |

|389 |396 |8 |Char |Date Account was first Established on Micro file -YYYYMMDD |

|397 |404 |8 |Char |Date of Initial Liability or Worksite effective date - YYYYMMDD |

|405 |412 |8 |Char |End of Liability Date or Termination Date - YYYYMMDD |

|413 |420 |8 |Char |Reactivation Date - YYYYMMDD |

|421 |430 |10 |Char |Predecessor UI Account Number |

|431 |435 |5 |Char |Predecessor Reporting Unit Number |

|436 |445 |10 |Char |Successor UI Account Number |

|446 |450 |5 |Char |Successor Reporting Unit Number |

|451 |451 |1 |Char |Organization Type Code |

2 Quarterly Transaction File

|Begin |End |Length |Type |Field Description |

|1 |10 |10 |Num |UI Account Number |

|11 |15 |5 |Num |Reporting Unit Number |

|16 |21 |6 |Num |Date of Transaction - YYMMDD |

|22 |27 |6 |Num |Time of Transaction - HHMMSS |

|28 |28 |1 |Char |Type of Transaction |

|29 |30 |2 |Num |Year - YY |

|31 |31 |1 |Num |Quarter |

|32 |39 |8 |Char |Batch Program or User ID |

|40 |40 |1 |Num |Status: 1=Active; 2=Closed; 9=Pending |

|41 |43 |3 |Num |Fips County Code |

|44 |45 |2 |Num |Ownership Code: 10=Federal; 20=State; 30=Local; 50=Private |

|46 |51 |6 |Num |North American Industry Classification System Code |

|52 |55 |4 |Num |Standard Industrial Classification Code |

|56 |56 |1 |Num |Type of Coverage: 0,1,2,3,8, & 9 |

|57 |58 |2 |Char |Geographic Area (Zone) Code |

|59 |64 |6 |Num |NSTA |

|65 |65 |1 |Num |Auxiliary Code: 0=Unknown; 5=Not Auxiliary; 8=Auxiliary Establishment |

|66 |66 |1 |Num |MEEI Code (Multi Establishment Employer Indicator) |

|67 |71 |5 |Num |Tax Rate |

|72 |77 |6 |Num |1st Month's Employment |

|78 |78 |1 |Char |1st Month's Employment Indicator |

|79 |84 |6 |Num |2nd Month's Employment |

|85 |85 |1 |Char |2nd Month's Employment Indicator |

|86 |91 |6 |Num |3rd Month's Employment |

|92 |92 |1 |Char |3rd Month's Employment Indicator |

|93 |103 |11 |Num |Total Wages for Quarter |

|104 |104 |1 |Char |Total Wage Indicator |

|105 |115 |11 |Num |Taxable Wages for Quarter |

|116 |116 |1 |Char |Taxable Wage Indicator |

|117 |125 |9 |Num |Contribution for Quarter |

|126 |126 |1 |Char |Contribution Indicator |

|127 |128 |2 |Char |1st Comment Code |

|129 |130 |2 |Char |2nd Comment Code |

|131 |132 |2 |Char |3rd Comment Code |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download