06 standard extract predecessor successor file es2sups
Standard U-I Extract / Predecessor/Successor File (ES2SUPS)
ES2SUPS - Length 64 - Revised 2/20/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 2 | 2 | Key | Char | SUPS-STATE-FIPS | The FIPS identifier for the State (e.g., Alabama = '01' |
| 3 | 17 | 15 | Key | Char | SUPS-PRED-SWA-ID | The grouped-level Predecessor State Workforce Agency ID |
| 3 | 12 | 10R | Key | Char | SUPS-PRED-ACCT | The Account Number Portion of the Predecessor's SWA ID |
| 13 | 17 | 5R | Key | Char | SUPS-PRED-RPT-UNIT | The Reporting Unit Number Portion of the Predecessor's SWA ID |
| 18 | 18 | 1 | Key | Char | SUPS-ACTION-CODE | Not used by EXPO; First appearance = blank; 'C'-hange; 'D'-elete |
| 19 | 33 | 15 | Key | Char | SUPS-SUCC-SWA-ID | The Group-level Successor State Workforce Agency ID |
| 19 | 28 | 10R | Key | Char | SUPS-SUCC-ACCT | Account Number Portion of the Successor's SWA ID |
| 29 | 33 | 5R | Key | Char | SUPS-SUCC-RPT-UNIT | Reporting Unit Number Portion of the Successor's SWA ID |
| 34 | 41 | 8 | Char | SUPS-TRANSFER-DATE | Not used by EXPO; Transfer date (yyyymmdd format) | |
| 42 | 56 | 15 | Char | SUPS-STATE-USE1 | Not used by EXPO; State use field #1 (15 characters) | |
| 57 | 57 | 1 | Char | SUPS-STATE-USE2 | Not used by EXPO; State use field #2 (1 character) | |
| 58 | 58 | 1 | Char | SUPS-STATE-USE3 | Not used by EXPO; State use field #3 (1 character) | |
| 59 | 64 | 6 | Char | SUPS-STATE-USE4 | Not used by EXPO; State use field #4 (6 characters) | |
Predecessor-Successor Portion of the SUE or SQUID File Data Set Name: ES2.SUE.PS.FILE Service Center DSN: YBUssX.A145.SUE.PS.FILE, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2SUPS The Predecessor-Successor 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 quarterly file (ES2SUEQ) to get the most from these files. The predecessor / successor SWA portion of the data could be placed in the IMT predecessor or successor if there is no other predecessor/successor on file for the employer. | ||||||
Related Links
