06 refiling master file earref
Refiling Master File (EARREF)
EARREF - Length 108 - Revised 9/7/2007
| Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 15 | 15 | Key | Char | REF-SESA-ID | SESA ID (Combined U-I account and reporting unit number), broken out below |
| 1 | 10 | 10R | Key | Char | REF-ACCT | U-I account number (right-justified, zero-filled) |
| 11 | 15 | 5R | Key | Char | REF-RPT-UNITX | Reporting unit number (00000 to 99999) |
| 16 | 16 | 1 | Char | REF-CHECK-DIGIT | Check digit | |
| 17 | 20 | 4 | Char | REF-CARS-SEQ-NUM | Sequence number used by the Centralized ARS process | |
| 21 | 26 | 6 | Char | FILLER | spaces (reserved for NAICS07 in 2012 NAICS revision; previously used as NAICS02 for 2007 NAICS revision) | |
| 27 | 32 | 6 | Char | REF-OLD-NAICS | Pre-refiling NAICS code | |
| 33 | 33 | 1 | Char | REF-OLD-OWN | Pre-refiling ownership code | |
| 34 | 36 | 3 | Char | REF-OLD-CNTY | FIPS county code at the beginning of refiling | |
| 37 | 40 | 4 | Char | REF-OLD-ZONE | Pre-refiling sub-county zone or New England township code | |
| 37 | 39 | 3R | Char | REF-OLD-TOWN | Township portion of sub-county zone | |
| 41 | 41 | 1 | Char | REF-OLD-MEEI | Pre-refiling multi-establishment employer indicator (MEEI) code; '1' = Single account; '2' = Multi-master; '3' = Worksite; '4' = Refusal; '5' = Composite worksite; '6' = Low-employment would-be multi-family kept as single | |
| 42 | 53 | 12 | Char | FILLER | spaces (once was new SIC code, new NSTA and Old and New Aux codes) | |
| 54 | 59 | 6 | Char | REF-NEW-NAICS | Post-refiling NAICS code | |
| 60 | 60 | 1 | Char | REF-NEW-OWN | Post-refiling ownership code | |
| 61 | 63 | 3 | Char | REF-NEW-CNTY | Post-refiling county FIPS code | |
| 64 | 67 | 4 | Char | REF-NEW-ZONE | Post-refiling sub-county zone code (township sub-defined below) | |
| 64 | 66 | 3R | Char | REF-NEW-TOWN | Post-refiling sub-county township code | |
| 68 | 68 | 1 | Char | REF-NEW-MEEI | Post-refiling MEEI code with values as shown earlier | |
| 69 | 74 | 6 | Num | REF-AME | Average monthly employment (AME) | |
| 75 | 75 | 1 | Char | REF-CARRY-OVER-IND | Flag to denote whether account is carried over from last year's refiling (non-respondent); '1' = Not a carry-over, '2' Carry-over without response, '3' = Carry-over with late response received last year, '4' = Same as #3, but received this year | |
| 76 | 79 | 4 | Char | REF-BATCH-NO | Batch ID denoting grouped returned forms from which this form may be extracted | |
| 80 | 87 | 8 | Char | REF-UPDATE-DATE | Date of most recent change (yyyymmdd format) | |
| 88 | 89 | 2 | Char | REF-RESP-CODE | Refiling response code; '00' = Form mailable, not sent, '01' = Form mailed once, '02' = Form mailed twice, '03' = Form mailed thrice, '04' = Form mailed four times, '12' = Clean record in non-mailable family (other worksite with errors), '30' = Responded but has "I" errors, '31' = Not reviewed, pending, '32' = Changed by BLS from '46'/'50' due to "I" errors (Central Collections), '41' = Reviewed, no CCS change exists, '42' = Misunderstood industry description, '46' = Clean record with CCS change, '50' = Code change from external source, '63' = Returned by USPS, '64' = Out of business, '65' = Refused to respond, '98' = Carry-over nonrespondent, probably out of business, '99' = Unmailable due to errors | |
| 90 | 98 | 9 | Char | REF-ERRORS | Set of up to three edit codes (drawn from the standard micro edits of EXPO); individual fields are listed below | |
| 90 | 92 | 3R | Char | REF-ERROR-CODE(1) | First error code | |
| 93 | 95 | 3R | Char | REF-ERROR-CODE(2) | Second error code | |
| 96 | 98 | 3R | Char | REF-ERROR-CODE(3) | Third error code | |
| 99 | 100 | 2 | Char | REF-CMI | TRS collection mode indicator (CMI) code; '00' = Ineligible to participate in Touchtone Response System; '01' = TRS-eligible employer; '02' = Successfully responded to TRS mailing; '07' = TRS participant requiring follow-up data; '08' = TRS employer responding both by phone and by mail; '09' = TRS eligible employer with mailable response | |
| 101 | 108 | 8 | Char | REF-USER | Identification for most recent person to update this refiling record | |
| 101 | 106 | 6R | Char | REF-USERID | CICS Logon ID of person who last modified this record | |
Refiling File Data Set Name: WS.ES202.EARS.REFILE Service Center DSN: YBUssW.A145.EARS.REFILE ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: EARREF CICS ID: EARREF (EssREF for Service Center; 'ss' = State Postal Abbr.) The Refiling File stands at the center of the Exportable Annual Refiling System. Next to the Lookup File, it is the most widely used EARS file. It contains a record for each account (single, master, or worksite) that has been selected for refiling for the current year, both new refilers and carry-over accounts. The file is initially created in Job EARJ100A, which has all of the selection parameters hard-coded for the current year, found in the EARRF00 program. New account data are drawn from the EXPO Micro File, while carry-overs are brought in from last year's Refiling File. The sequential file is used to build the new VSAM Refiling File via two IDCAMS steps. The file is then ready to use. EARC is one of the on-line applications that uses the Refiling File; this transaction is the avenue for performing most of the maintenance on the file. The EARF transaction uses the Refiling File to produce a list of accounts on the Refiling File. EARR screens enable the entry of refiling form data in batches. Changes to refiling data are displayed on EARP. Batch applications are even more prevalent. As was already mentioned, the EARJ100A job builds the new year's Refiling File from prior year carry-overs and current year extractions. The 101D job enacts batch updates to the Refiling File from the State-developed Input Refiling Transactions (IRT) File. Job 102D is used to edit refiling data according to BLS standards (using a subset of the EXPO edit codes). Job 107D extracts data from the Refiling File in order to produce the Refiling Selections Reports. Jobs 103D, 103E, 103G, 104D, 104E, and 104G require Refiling File data to select accounts for preparation of NVS and NVM refiling forms. Non-classified accounts, used to produce the NCA refiling forms, draw their data directly from the Micro File, so they do not enter the standard annual cycle of other refiling processes. | ||||||
Related Links
