06 census wage deliverable new old files es2cenn es2ceno
Census Wage Deliverable New/Old Files (ES2CENN / ES2CENO)
ES2CENN/ES2CENO - Length 77 - Revised 9/10/2004
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 9 | 9 | Key | Char | CENN-SSN / CENO-SSN | Social security number of an employee in either the newer or older quarter's wage record data |
10 | 24 | 15 | Char | CENN-F-NAME / CENO-F-NAME | Employee's first name | |
25 | 25 | 1 | Char | CENN-M-INIT / CENO-M-INIT | Employee's middle initial | |
26 | 45 | 20 | Char | CENN-L-NAME / CENO-L-NAME | Employee's last name | |
46 | 47 | 2 | Char | CENN-ST-FIPS / CENO-ST-FIPS | State FIPS code | |
48 | 57 | 10 | Char | CENN-UI-ACCT / CENO-UI-ACCT | U-I account number of this person's employer | |
58 | 62 | 5 | Char | CENN-RPT-UNIT / CENO-RPT-UNIT | Reporting unit number of SESA ID to which this employee belongs | |
63 | 71 | 9 | Char | CENN-EIN / CENO-EIN | Employer's federal employer identification number (EIN) | |
72 | 76 | 5 | Char | CENN-YEARQ / CENO-YEARQ | Year/quarter for which employee is affiliated with this employer (yyyyq format) | |
77 | 77 | 1 | Char | CENN-WAGES / CENO-WAGES | Flag denoting whether the employee earned wages during the quarter | |
Census Wage Deliverable New/Old Files Data Set Name: WS.ES202.? (unknown) Service Center DSN: YBUssX.A145.? (unknown, 'ss' = State FIPS code) Type of File: Flat File File Layout: ES2CENN or ES2CENO This pair of identical-format files still requires more development and implementation time. The intention of these files is to provide a standardized interface method for states to develop a wage-record input data source that can be translated into the EXPO standard Employee Transfer Transaction (ETT) format. This converted file can then be loaded into the system to produce the VSAM Employment Transfer File. There may be significant issues with the content of data represented in this file, as it lists confidential information, including the employee's social security number (filtered out of EXPO ETT data) and the full employee name. It is not yet known whether such a format will be acceptable for interfacing with the QCEW system. It is only listed here because the format was released by BLS. |
Related Links