WIN-202 September 20Th Release Notes

WIN-202 System

Version 5.2 – June 11th 2003 Code Update

A)Data Entry Screens

1)ARCS Data Entry Screen

A change was made to prevent a quoted question mark from being assigned to the NAICS (aux_naics) field.

B)Screens:

1)Main Screen

The overall screen performance has been improved when navigating between the individual Tabs.
MSA Macro Screens will be released in September 2003.

2)Multi Tab/Site Ownership Change Screen

A change was made to allow only active subunits on a transfer.

C)Quarterly Processing

1)Load Screen

CES (NAICS) Load – Load procedure was changed to load the new NAICS CES (M30) file structure.

2)Edit Screen

Edits – The SIC Macro Edit and Listing have been disabled.

D)Reports:

Quarterly NAICS Listings – The procedure was restructured to improve runtime performance and to correct the firm count which is used to determine confidentiality.

There are eight (8) geography’s (Statewide, LMA, WIA, MSA, County, Residence, Zone, and City). Each has four outputs. Two are formatted and two are Unformatted. For each, one suppresses Confidential Data and the other does not.

Formatted Output files for Quarterly are:

 Confidential - All data is shown with confidential data marked with an *.

Statewide - qtr-sta-yyyy-q-confid-form.txt

LMA - qtr-sta-yyyy-q-confid-form.txt

MSA - qtr-sta-yyyy-q-confid-form.txt

County - qtr-sta-yyyy-q-confid-form.txt

LMA - qtr-sta-yyyy-q-confid-form.txt

Residence - qtr-res-yyyy-q-confid-form.txt

Zone - qtr-zon-yyyy-q-confid-form.txt

City - qtr-cit-yyyy-q-confid-form.txt

 Publishable - Only publishable lines of data are shown, confidential data is suppressed.

Statewide - qtr-sta-yyyy-q-public-form.txt

LMA - qtr-sta-yyyy-q-public-form.txt

MSA - qtr-sta-yyyy-q-public-form.txt

County - qtr-sta-yyyy-q-public-form.txt

LMA - qtr-sta-yyyy-q-public-form.txt

Residence - qtr-res-yyyy-q-public-form.txt

Zone - qtr-zon-yyyy-q-public-form.txt

City - qtr-cit-yyyy-q-public-form.txt

Unformatted Output files for Quarterly are: (See appendix A for revised File Structure)

 Confidential - All data is shown with confidential data marked with an *.

Statewide - qtr-sta-yyyy-q-confid-unform.txt

LMA - qtr-sta-yyyy-q-confid-unform.txt

MSA - qtr-sta-yyyy-q-confid-unform.txt

County - qtr-sta-yyyy-q-confid-unform.txt

LMA - qtr-sta-yyyy-q-confid-unform.txt

Residence - qtr-res-yyyy-q-confid-unform.txt

Zone - qtr-zon-yyyy-q-confid-unform.txt

City - qtr-cit-yyyy-q-confid-unform.txt

 Publishable - Only publishable lines of data are shown, confidential data is suppressed.

Statewide - qtr-sta-yyyy-q-public-unform.txt

LMA - qtr-sta-yyyy-q-public-unform.txt

MSA - qtr-sta-yyyy-q-public-unform.txt

County - qtr-sta-yyyy-q-public-unform.txt

LMA - qtr-sta-yyyy-q-public-unform.txt

Residence - qtr-res-yyyy-q-public-unform.txt

Zone - qtr-zon-yyyy-q-public-unform.txt

City - qtr-cit-yyyy-q-public-unform.txt

Annual NAICS Listings – The procedure was restructured to improve runtime performance and to correct the firm count which is used to determine confidentiality.

Formatted Output files for Quarterly are:

 Confidential - All data is shown with confidential data marked with an *.

Statewide - ann-sta-yyyy-confid-form.txt

LMA - ann-sta-yyyy-confid-form.txt

MSA - ann-sta-yyyy-confid-form.txt

County - ann-sta-yyyy-confid-form.txt

LMA - ann-sta-yyyy-confid-form.txt

Residence - ann-res-yyyy-confid-form.txt

Zone - ann-zon-yyyy-confid-form.txt

City - ann-cit-yyyy-confid-form.txt

 Publishable - Only publishable lines of data are shown, confidential data is suppressed.

Statewide - ann-sta-yyyy-public-form.txt

LMA - ann-sta-yyyy-public-form.txt

MSA - ann-sta-yyyy-public-form.txt

County - ann-sta-yyyy-public-form.txt

LMA - ann-sta-yyyy-public-form.txt

Residence - ann-res-yyyy-public-form.txt

Zone - ann-zon-yyyy-public-form.txt

City - ann-cit-yyyy-public-form.txt

Unformatted Output files for Quarterly are: (See appendix B for revised File Structure)

 Confidential - All data is shown with confidential data marked with an *.

Statewide - ann-sta-yyyy-confid-unform.txt

LMA - ann-sta-yyyy-confid-unform.txt

MSA - ann-sta-yyyy-confid-unform.txt

County - ann-sta-yyyy-confid-unform.txt

LMA - ann-sta-yyyy-confid-unform.txt

Residence - ann-res-yyyy-confid-unform.txt

Zone - ann-zon-yyyy-confid-unform.txt

City - ann-cit-yyyy-confid-unform.txt

 Publishable - Only publishable lines of data are shown, confidential data is suppressed.

Statewide - ann-sta-yyyy-public-unform.txt

LMA - ann-sta-yyyy-public-unform.txt

MSA - ann-sta-yyyy-public-unform.txt

County - ann-sta-yyyy-public-unform.txt

LMA - ann-sta-yyyy-public-unform.txt

Residence - ann-res-yyyy-public-unform.txt

Zone - ann-zon-yyyy-public-unform.txt

City - ann-cit-yyyy-public-unform.txt

The NAICS Listings also produces the Almis 2.2 file. The file contains all eight (8) geographic regions and all levels. Confidential data is included. (See appendix C for revised File Structure).

E)Miscellaneous

1)Batch Data Corrections

fix051503.r – Procedure to be run via “Create Process” screen to check for a quoted question mark in the NAICS (aux_naics) field. If found, it will be changed to a regular question mark.

Select Monitor Tab

Select ‘Create Process’ button.

Program Name: FIX051503.R

Job Description: NAICS ? Fix

Select ‘OK’ Button

Note: This procedure only needs to be run for states that are loading CES data. If you do not load CES data, you need not run this job.

cesnaics.r – Procedure to be run via “Create Process” screen to populate the NACIS field in the CES table for year greater then 2000. This will eliminate the question marks in the reports. The procedure attempts to load a NAICS code in the following order:

1. Use the naics-xwalk table for a direct (one to one) relationship.

2. Use the first available quarterly code for the same UI/Run (Current quarter of less).

a. If invalid, a hex 9 is assigned.

3. If no quarterly is found, looks for Admin pred/succ and uses the first available quarterly code (Current quarter of less)

a. if invalid, a hex 9 is assigned.

b. if no quarterly found, record is sent to an output file (ces-naics.txt)

4. If no admin record is found using admin pred/succ, that record is sent to an output file (ces-naics.txt).

Select Monitor Tab

Select ‘Create Process’ button.

Program Name: CESNAICS.R

Job Description: POPULATE CES NAICS

Select ‘OK’ Button

Appendix A - Delimited File Output Format for NAICS Quarterly Reports.

Delimiter in file is the semicolon (;).

Year – Four-digit year.
Quarter – Single digit quarter.
Geography Type – (LMA, MSA, CTY, WIA, STA, Residence, Zone, City)
Geography Code – Geography code (dependant on report type) for LMA, MSA, CTY, WIA, RES, ZON, CIT, (STA=0000)
Ownership Code – Ownership code.

Federal = 1

State = 2

Local = 3

Private = 5

All Ownerships = 0

Industry Description – Industry / Ownership Description
NAICS or BLS Code – NAICS code for the Cell, or a description of the cells contents
Confidential Flag – * Indicates this is a confidential cell
Units – Number of units in the cell
Month 1 Employment – Month 1 employment for the cell
Month 2 Employment – Month 2 employment for the cell
Month 3 Employment – Month 3 employment for the cell
Total Wages – total wages for the cell
Taxable Wages – taxable wages for the cell
Contributions – Contributions for the cell
Average Monthly Employment – Average monthly employment for the cell
Average Quarterly Wage – Average quarterly wage for the cell
Average Weekly Wage – Average weekly wage for the cell
Month 1 Female Employment – Month 1 female employment for the cell
Month 2 Female Employment – Month 2 female employment for the cell
Month 3 Female Employment – Month 3 female employment for the cell

Appendix B - Delimited File Output Format for NAICS Annual Reports.

Delimiter in file is the semicolon (;).

Year – Four-digit year.
Quarter – Single digit quarter.
Geography Type – (LMA, MSA, CTY, WIA, STA, Residence, Zone, City)
Geography Code – Geography code (dependant on report type) for LMA, MSA, CTY, WIA, RES, ZON, CIT, (STA=0000)
Ownership Code – Ownership code.

Federal = 1

State = 2

Local = 3

Private = 5

All Ownerships = 0

Industry Description – Industry / Ownership Description
NAICS or BLS Code – NAICS code for the Cell, or a description of the cells contents
Confidential Flag – * Indicates this is a confidential cell
Units – Number of units in the cell
Month 1 Employment – Month 1 employment for the cell
Month 2 Employment – Month 2 employment for the cell
Month 3 Employment – Month 3 employment for the cell
Month 4 Employment – Month 4 employment for the cell
Month 5 Employment – Month 5 employment for the cell
Month 6 Employment – Month 6 employment for the cell
Month 7 Employment – Month 7 employment for the cell
Month 8 Employment – Month 8 employment for the cell
Month 9 Employment – Month 9 employment for the cell
Month 10 Employment – Month 10 employment for the cell
Month 11 Employment – Month 11 employment for the cell
Month 12 Employment – Month 12 employment for the cell
Total Wages – total wages for the cell
Taxable Wages – taxable wages for the cell
Contributions – Contributions for the cell
Average Monthly Employment – Average monthly employment for the cell
Average Annual Wage – Average annual wage for the cell
Average Weekly Wage – Average weekly wage for the cell
Month 1 Female Employment – Month 1 female employment for the cell
Month 2 Female Employment – Month 2 female employment for the cell
Month 3 Female Employment – Month 3 female employment for the cell
Month 4 Female Employment – Month 4 female employment for the cell
Month 5 Female Employment – Month 5 female employment for the cell
Month 6 Female Employment – Month 6 female employment for the cell
Month 7 Female Employment – Month 7 female employment for the cell
Month 8 Female Employment – Month 8 female employment for the cell
Month 9 Female Employment – Month 9 female employment for the cell
Month 10 Female Employment – Month 10 female employment for the cell
Month 11 Female Employment – Month 11 female employment for the cell
Month 12 Female Employment – Month 12 female employment for the cell

Appendix C – Delimited File Output for Almis v2.2 (NAICS Reports)

Delimiter in file is a coma (,).

State Fips – 2 digit numeric State fips code

Area Type – Code describing type of geographic area:

Statewide = 01

County = 04

MSA = 02

LMA = 10

WIA = 15

Residence = 70

Zone = 50

City = 60

Area – 6-digit numeric code assigned to represent a geographical area. Front fill with zeros.

Period Year – 4 digit year
Period Type – Code describing type of period

Annual = 01

Quarterly = 02

Period – Period code. Will be set to ‘00’ where periodtype is annual.

Annual = 00

Quarterly = 01, 02, 03, or 04

Industry Code Type – Code Describing the industry code type.

NAICS = 10

Industry Code – NAICS code
Ownership Code – Ownership code.

All Ownerships = 00

Federal = 10

State = 20

Local = 30

Private = 50

Firms – Number of firms in the industry.
Establishments – Number of employer establishments in the industry.
Avg Employment – Average Employment for either Annual or Quarterly.
Month 1 Employment – Month 1 Employment (blank for annual)
Month 2 Employment – Month 2 Employment (blank for annual)
Month 3 Employment – Month 3 Employment (blank for annual)
Top Emp Average – Average employment for the quarter or year of the top employer for the specified geography and NAICS code. Either the top single account of the top sum of subunits.
Total Wages – Total wages
Avg Weekly Wage – Average weekly wage for Annual or Quarterly.
Contributions – Employer Contributions to the UI fund.
Suppress – Confidential Data indicator.

0 = Not suppressed

1 = Suppress (Confidential)

WIN-202 System – Version 5.2 – June 11, 2003 Code Update Page 1 of 6