06 wage file creator es2wfc
Wage File Creator File (ES2WFC)
ES2WFC - Length 233 - Revised 2/20/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 2 | 2 | Char | WFC-STATE-FIPS | The State FIPS code (e.g. Alabama = '01') | |
3 | 12 | 10 | Char | WFC-ACCT | Account number portion of the SESA ID (or SWA ID) | |
13 | 17 | 5 | Char | WFC-REPORTING-UNIT | Reporting unit identifier of the account | |
13 | 17 | 5R | Num | WFC-RUN | Redefinition of the RUN field, as a numeric reporting unit field | |
18 | 22 | 5 | Char | WFC-YEARQ | Year/quarter of data (yyyyq format) | |
23 | 28 | 6 | Num | WFC-EMPL | Employment of the wage file, using the 999999 format | |
29 | 34 | 6 | Num | WFC-EMPL-WITH-WAGES | Not used by EXPO; the amount of employment accompanied by wages | |
35 | 40 | 6 | Num | WFC-EMPL-NO-WAGES | Not used by EXPO; the amount of employment that has zero wages (999999 format) | |
41 | 52 | 12 | Num | WFC-TOTW | Wage-record wages; saved as total wages (999999999999 format) | |
53 | 64 | 12 | Num | WFC-HIGHEST-WAGE | Not used by EXPO; highest-wages found for an employer | |
65 | 76 | 12 | Num | WFC-SECOND-WAGE | Not used by EXPO; second-highest wages found for an employer | |
77 | 88 | 12 | Num | WFC-THIRD-WAGE | Not used by EXPO; third highest wages found for an employer | |
89 | 94 | 6 | Num | WFC-EMPL-LESS-1000 | Not used by EXPO; employment sum for under 1000 employment | |
95 | 100 | 6 | Num | WFC-EMPL-GREATER-100000 | Not used by EXPO; employment sum for over 100,000 employment (very few) | |
101 | 112 | 12 | Num | WFC-SUM-WAGE-GREATER-25000 | Not used by EXPO; sum of wages exceeding $25,000 per account | |
113 | 124 | 12 | Num | WFC-MEAN-WAGE | Not used by EXPO; arithmetic mean of wages that were processed in this group | |
125 | 136 | 12 | Num | WFC-MEDIAN-WAGE | Not used by EXPO; arithmetic median for wages for companies in this group | |
137 | 138 | 1 | Char | WFC-WAGE-IND | Not used by EXPO; indicator for wage data; set to a "Y", but unsure what it means | |
138 | 149 | 12 | Num | WFC-PERCENT-FIRST | Not used by EXPO; first percentile of wages, 99% of the wages exceed this value | |
150 | 161 | 12 | Num | WFC-PERCENT-FIFTH | Not used by EXPO; fifth percentile of wages, 95% of the wages exceed this value | |
162 | 173 | 12 | Num | WFC-PERCENT-TENTH | Not used by EXPO; tenth percentile of wages; 90% of the wages exceed this value | |
174 | 185 | 12 | Num | WFC-PERCENT-TWENTY-FIFTH | Not used by EXPO; 25th percentile of wages; 75% of the wages exceed this value | |
186 | 197 | 12 | Num | WFC-PERCENT-SEVENTY-FIFTH | Not used by EXPO; 75th percentile of wages; 25% of the wages exceed this value | |
198 | 209 | 12 | Num | WFC-PERCENT-NINETIETH | Not used by EXPO; 90th percentile of wages; 10% of the wages exceed this value | |
210 | 221 | 12 | Num | WFC-PERCENT-NINETY-FIFTH | Not used by EXPO; 95th percentile of wages; 5% of the wages exceed this value | |
222 | 233 | 12 | Num | WFC-PERCENT-NINETY-NINTH | Not used by EXPO; 99th percentile of wages; 1% of the wages exceed this value | |
Wage File Creator File (optional) Data Set Name: ES2.WAGE.SUMMARY.FILE Service Center DSN: YBUssX.A145.WAGE.SUMMARY.FILE, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2WFC This file is an alternative way to get at the Wage Summary File using the LEHD File that is produced at the U-I section; it is only needed for States that have no other way of obtaining the Wage Summary File from a Wage Data Temp File, which is processed by the 60D job. This file is processed by the 60S job instead, and would be brought in as part of the Wage File comparison load. All of these percentiles are interesting, but they have no part in the WRC and WRW fields that are entered into the Wage Summary File. |
Related Links