Difference between revisions of "06 standard extract predecessor successor file es2sups"
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_summary_file_es2wage|Wage Summary File (ES2WAGE)]] | * [[06_wage_summary_file_es2wage|Wage Summary File (ES2WAGE)]] | ||
* [[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
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