06 standard extract quarterly data file es2sueq
Standard U-I Extract Quarterly Data File (ES2SUEQ)
ES2SUEQ - Length 147 - Revised 2/20/2018
| Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
|---|---|---|---|---|---|---|
| 1 | 2 | 2 | Key | Char | SUEQ-STATE-FIPS | Federal IPS Code for State (e.g., '01' = Alabama) |
| 3 | 17 | 15 | Key | Char | SUEQ-SWA-ID | The full State Workforce Agency ID (Account number plus RUN) |
| 3 | 12 | 10R | Key | Char | SUEQ-ACCT | The account number portion of the SWA ID |
| 13 | 17 | 5R | Key | Char | SUEQ-RPT-UNIT | The Reporting Unit Number portion of the SWA ID |
| 18 | 22 | 5 | Key | Char | SUEQ-YRQ | Full year and quarter of the data (yyyyq format; broken out below) |
| 18 | 21 | 4R | Key | Char | SUEQ-YEAR | Year portion of the YRQ field (yyyy format) |
| 22 | 22 | 1R | Key | Char | SUEQ-QTR | Single quarter portion of the YRQ field (1-4 values) |
| 23 | 23 | 1 | Key | Char | SUEQ-STATUS | Status of the account (ignored by EXPO, which sets the status by the dates) |
| 24 | 26 | 3 | Char | SUEQ-CNTY | County code for the quarter | |
| 27 | 27 | 1 | Char | SUEQ-OWNER | Ownership code (single-digit) for the quarter | |
| 28 | 33 | 6 | Char | SUEQ-NAICS | NAICS code (North American Industry Classification System) code for the quarter | |
| 34 | 39 | 6 | Char | SUEQ-CLASSIF-NAICS | Classification NAICS code (only valid during a revision, e.g. in 17/1 quarter) | |
| 40 | 40 | 1 | Char | SUEQ-TYPE-COV | Type of coverage for the quarter ('0', '1', '2', '3', '8', '9') | |
| 41 | 41 | 1 | Char | SUEQ-NONPROFIT-IND | Not used in EXPO; the indication that this is a non-profit organization | |
| 42 | 45 | 4 | Char | SUEQ-ZONE | Sub-county zone for the quarter (if townships are not used) | |
| 46 | 48 | 3 | Char | SUEQ-TOWN | Sub-county township for the quarter (for New England states and New Jersey) | |
| 49 | 49 | 1 | Char | SUEQ-MEEI | Multiple Establishment Employer Indicator for the quarter ('1' through '6') | |
| 50 | 50 | 1 | Char | SUEQ-DATA-SUPPLIER-IND | Used as the Data Source Code in EXPO (blank, or 'C', 'E', 'P'-'S', 'W', 'X') | |
| 51 | 60 | 10 | Char | SUEQ-AGENT-CODE | Uses first four characters in EXPO; full 10 not used | |
| 61 | 65 | 5 | Char | SUEQ-TAX-RATE | Tax rate for the quarter | |
| 66 | 71 | 6 | Char | SUEQ-M1-EMPL | First month's employment for the quarter | |
| 72 | 77 | 6 | Char | SUEQ-M2-EMPL | Second month's employment for the quarter | |
| 78 | 83 | 6 | Char | SUEQ-M3-EMPL | Third month's employment for the quarter | |
| 84 | 89 | 6 | Char | SUEQ-STATE-USE | Quarterly State Usage field for the quarter | |
| 90 | 101 | 12 | Char | SUEQ-TOTAL-WAGE | Total wages for the quarter (last 11 digits used by EXPO) | |
| 102 | 113 | 12 | Char | SUEQ-TAX-WAGE | Taxable wages for the quarter (last 11 digits used by EXPO) | |
| 114 | 123 | 10 | Char | SUEQ-CONTRIB-DUE | Contributions due for the quarter (last 9 digits used by EXPO) | |
| 124 | 129 | 6 | Char | SUEQ-COMMENT-CODE | Grouped comment code – broken out below | |
| 124 | 125 | 2R | Char | SUEQ-CMNT1 | First comment code for the quarter | |
| 126 | 127 | 2R | Char | SUEQ-CMNT2 | Second comment code for the quarter | |
| 128 | 129 | 2R | Char | SUEQ-CMNT3 | Third comment code for the quarter | |
| 130 | 147 | 18 | Char | SUEQ-FEMALE-EMPL | Grouped identification – female employment for the quarter | |
| 130 | 135 | 6R | Char | SUEQ-FEM1 | Not used in EXPO – First month of female employment for the quarter | |
| 136 | 141 | 6R | Char | SUEQ-FEM2 | Not used in EXPO – Second month of female employment for the quarter | |
| 142 | 147 | 6R | Char | SUEQ-FEM3 | Not used in EXPO – Third month of female employment for the quarter | |
Quarterly Portion of the SUE or SQUID File Data Set Name: ES2.SUE.QTR.FILE Service Center DSN: YBUssX.A145.SUE.QTR.FILE, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2SUEQ The Quarterly SUE File (also known as the Standard QUEST U-I Data (SQUID) File) is processed as a blank file in the 084I job, and is converted to the IMT format with the 084G job. It is processed along with the non-quarterly file (ES2SUEN) and the predecessor/successor file (ES2SUPS) to get the most from these files. In February of 2018, two new files were presented, called -.CENCO.NCA.ssnn.COUNTYTOWN.TXT file identifying the county/township portion, and -.CENCO.NCA.ssnn.NAICS.TXT to identify the NAICS portion of the file that would have the NCA (non-classified accounts) processing of the non-quarterly address file. It is not at present known how these two quarterly files can both fit on the 084G process, to convert these to an IMT format. It is probable that a separate file would need to be developed to process the other quarterly file. However, none of the jobs identify these CENCO files as inputs, so they would probably need to be processed independently, in spite of the documentation that says that "no change" is required. | ||||||
Related Links
