Difference between revisions of "06 wage summary file es2wage"
Daniela92H (talk | contribs) |
MattSteadman (talk | contribs) m (Text replacement - "[[start" to "[[EXPO_Documentation") |
||
(One intermediate revision by one other user not shown) | |||
Line 8: | Line 8: | ||
* [[06_wage_file_creator_es2wfc|Wage File Creator File (ES2WFC)]] | * [[06_wage_file_creator_es2wfc|Wage File Creator File (ES2WFC)]] | ||
* [[06_file_record_layouts|File Record Layouts Table of Contents]] | * [[06_file_record_layouts|File Record Layouts Table of Contents]] | ||
− | * [[ | + | * [[EXPO_Documentation|EXPO/EARS Documentation Home]] |
Latest revision as of 16:44, 11 July 2019
Wage Summary File (ES2WAGE)
ES2WAGE - Length 70 - Revised 9/8/2006
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
= = = Header Record (for quarter identification) = = = | ||||||
1 | 10 | 10 | Key | Char | WAGE-ADMIN-DATA | spaces |
11 | 13 | 3 | Char | WAGEQ-QTRS(1) | Newest Wage Summary data year/quarter data area | |
11 | 13 | 3R | Char | WAGEQ-YRQ(1) | Newest year/quarter identifier (yyq format), broken out below | |
11 | 12 | 2R | Num | WAGEQ-YR(1) | 2-digit year portion of the year/quarter identifier – newest wage quarter | |
13 | 13 | 1R | Num | WAGEQ-QTR(1) | quarter number (1 through 4) portion of newest Wage Summary File year/qtr | |
14 | 16 | 3 | Char | WAGEQ-QTRS(2) | Second (next-to-newest) Wage Summary File quarter identifier area, with the same format as shown above for the newest year/quarter | |
17 | 19 | 3 | Char | WAGEQ-QTRS(3) | Third Wage Summary year/quarter area; two quarters before newest | |
20 | 22 | 3 | Char | WAGEQ-QTRS(4) | Fourth wage quarter identification area | |
23 | 25 | 3 | Char | WAGEQ-QTRS(5) | Fifth wage quarter identification area | |
26 | 28 | 3 | Char | WAGEQ-QTRS(6) | Sixth (oldest) wage quarter identification area | |
29 | 70 | 42 | Char | FILLER | spaces | |
= = = Standard Data Record = = = | ||||||
1 | 10 | 10 | Key | Num | WAGE-ACCT | U-I account number, right-justified with leading zeroes |
11 | 20 | 10 | Char | WAGE-QUARTER-DATA(1) | Most recent quarter's employment/wage data, sub-defined below | |
11 | 14 | 4R | Pack | WAGQ-EMPL(1) | Wage record count for newest year/quarter (equivalent to employment total, 7 digits) | |
15 | 20 | 6R | Pack | WAGQ-TOTAL-WAGE(1) | Wage record wages for newest year/quarter (equivalent to total wages, 11 digits) | |
21 | 30 | 10 | Char | WAGE-QUARTER-DATA(2) | Second most recent quarter's data in the same format as described above | |
31 | 40 | 10 | Char | WAGE-QUARTER-DATA(3) | Third most recent quarter's data | |
41 | 50 | 10 | Char | WAGE-QUARTER-DATA(4) | Fourth most recent quarter's data | |
51 | 60 | 10 | Char | WAGE-QUARTER-DATA(5) | Fifth most recent quarter's data | |
61 | 70 | 10 | Char | WAGE-QUARTER-DATA(6) | Oldest quarter's wage summary data | |
Wage Summary File (optional) Data Set Name: WS.ES202.WAGE Service Center DSN: YBUssX.A145.WAGE, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2WAGE CICS ID: ES2WAGE (Standard); EssWAGE (Service Center; ss=State) Utilization of the Wage Summary File is optional. It is a collection of aggregated employee wage data, representing the summed employment and wage information for a single or master account on the Micro File. As shown above, it contains six quarters of employment and wage figures. These data are used by the Wage/Refiling ES2C screen, which provides a unique set of comparison data in the final cleanup phase of a quarter's processing. A side-by-side display of Micro File employment and total wages with this file's corresponding employee record count and wage totals gives useful benchmarking information to the 202 analyst, since the wage record counts should approximate the maximum number of employees during the quarter, and the wage totals should be close to the Micro File's total wage value. Data for this file are added, one quarter at a time, in much the same manner as both Macro File processing (with quarter replacement from aggregated micro data), and Micro File batch updates (taken from IMT records). The State's wage record file (which contains individual employee wage information, summed Statewide) is accessed by a State-specific program, ES2WA01, which aggregates a single quarter's individual employee wages and counts the number of employee records for each firm. The summed data are written to a temporary wage file. This quarter's data are merged into the Wage Summary File by Job ES2J060D, which can also shift the quarters of the file, rolling off the oldest quarter. The Wage Summary File is then used to perform the wage data edits in Job ES2J061D, in which the data are compared to the corresponding information on the Micro File, using BLS-specified editing criteria. The only other batch usage of Wage Summary File data occurs during the micro edits (Jobs 01D, 01Q, 02D, 02F, 28D, 28S, and 42D), which pass the wage record count and wage total data to the micro edit exception report if either the employment or wage fluctuation is flagged by the editing program. This information will be passed only if non-zero values are found for this quarter of the Wage Summary File. Wage data are generally made available about five months after a quarter has ended. Since this is close to the due date for preparing the BLS deliverables, the Wage Summary File will usually only be useful for current quarter processing during the last few weeks of the 202 quarter cycle. However, since there is an ongoing clean-up process for the prior quarter under the Mic-Mac regulations, this prior quarter can still be authenticated during a longer time span. Still, because future quarter data will generally not be available until that quarter becomes current, only six quarters have been established in this file; so there is no one-to-one matching of the seven quarters of the Micro File. It is assumed that the quarters to be used on the file will begin with the current quarter (2nd occurrence in the Micro File), and go back through all earlier quarters on the Micro File. However, the quarters can be shifted so that the six quarters represent the future quarter and earlier. This would only be useful if there were some wage record data available very early in the processing cycle. This configuration also means that no Wage Summary data can be stored for the oldest quarter on the Micro File. Since the file is optional, only States that have developed a wage data extraction program (ES2WA01) will have a use for this file. |
Related Links