06 selection mailing file earselm
Selection for Mailing File (EARSELM)
EARSELM - Length 439 - Revised 9/7/2007
| Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 15 | 15 | Key | Char | SELM-EMPL-ACCT | SESA ID of selected employer to receive refiling form in this mailing |
| 1 | 10 | 10R | Key | Char | SELM-ACCT | U-I account number portion of SESA ID |
| 11 | 15 | 5R | Key | Num | SELM-RPT-UNIT | Reporting unit number portion of SESA ID |
| 16 | 17 | 2 | Key | Num | SELM-SEQ-NUM | Line sequence number; the first line provides all necessary address data, while the remaining lines provide the multi-line NAICS code descriptions associated with this SIC code's refiling options; an alpha-numeric version of this field is also listed as SELM-SEQ-NUM-X, in case the numeric nature must be verified |
| 18 | 23 | 6 | Key | Char | SELM-SORT-NAICS | NAICS code tied to the refiling form's descriptions that follow |
| 24 | 27 | 4 | Key | Num | SELM-SORT-TRS-OR-PAGE | TSR indicator (single (NVS) forms only) or page count value (multi-family (NVM) forms only), used as an added sorting parameter, applying only to the type of forms noted |
| 28 | 32 | 5 | Key | Char | SELM-SORT-ZIP-5 | Standard 5-digit zip code of mailing address, if this is used as a sorting mechanism |
| 33 | 36 | 4 | Key | Char | SELM-SORT-ZIP-4 | ZIP+4 extension to mailing zip code when zip code sorting has been selected |
| --- Standard Data Record (Used for Sequence # 01 record) --- | ||||||
| 37 | 42 | 6 | Char | SELM-ORIGINAL-NAICS | Original NAICS serves as a benchmark value for refiling, even when revision is included | |
| 43 | 48 | 6 | Char | SELM-NAICS | NAICS code for current page of the multi-family refiling form | |
| 49 | 83 | 35 | Char | SELM-LEGAL-NAME | Legal/corporate name for the firm being refilled | |
| 84 | 118 | 35 | Char | SELM-TRADE-NAME | DBA/trade name of the firm being refilled | |
| 119 | 153 | 35 | Char | SELM-ATTN-NAME | Attention name for inclusion on refiling form, if needed | |
| 154 | 188 | 35 | Char | SELM-RPT-UNIT-DESCR | Reporting unit description for the refiled firm | |
| 189 | 197 | 9 | Char | SELM-EIN | Federal Employer Identification Number (EIN) | |
| 198 | 232 | 35 | Char | SELM-MAIL-ADDRESS | First line of mailing address for refiled company | |
| 233 | 267 | 35 | Char | SELM-MAIL-ADDRESS2 | Second street address line of mailing address | |
| 268 | 295 | 28 | Char | SELM-MAIL-CITY | Mailing address city | |
| 296 | 297 | 2 | Char | SELM-MAIL-STATE | Mailing address state postal abbreviation | |
| 298 | 306 | 9 | Char | SELM-MAIL-ZIP-CODE | Full nine-digit zip code, broken out below | |
| 298 | 302 | 5R | Char | SELM-MAIL-ZIP-5 | Standard 5-digit zip code for mailing address | |
| 303 | 306 | 4R | Char | SELM-MAIL-ZIP-4 | ZIP+4 extension to mailing address zip code | |
| 307 | 341 | 35 | Char | SELM-ADDRESS | Physical address street address line | |
| 342 | 376 | 35 | Char | SELM-ADDRESS2 | Second line of physical address street address | |
| 377 | 404 | 28 | Char | SELM-CITY | Physical address city | |
| 405 | 406 | 2 | Char | SELM-STATE | Physical address state postal abbreviation | |
| 407 | 415 | 9 | Char | SELM-ZIP-CODE | Physical address full 9-digit zip code, with subdivisions below | |
| 407 | 411 | 5R | Char | SELM-ZIP-5 | Standard 5-digit zip code | |
| 412 | 415 | 4R | Char | SELM-ZIP-4 | ZIP+4 extension to physical address zip code | |
| 416 | 416 | 1 | Char | SELM-ADDR-TYPE | Address type code for mailing address, '1' = Physical location, '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown/unconfirmed address type | |
| 417 | 419 | 3 | Char | SELM-COUNTY | FIPS county code | |
| 420 | 421 | 2 | Char | SELM-OWNER | Ownership code, '10' = Federal, '20' = State, '30' = Local, '50' = Private | |
| 422 | 425 | 4 | Char | SELM-ZONE | Sub-county zone or township code | |
| 426 | 426 | 1 | Char | SELM-MEEI | Multi-establishment employer identification (MEEI) code; '1' = Single account, '2' = Master account, '3' = Worksite, '4' = Refusal, '5' = Composite worksite, '6' = Known multi-family not broken out due to low combined employment | |
| 427 | 432 | 6 | Char | SELM-AME | Formatted rendition of the average monthly employment (AME; ZZZZZ9 format) | |
| 427 | 432 | 6R | Num | SELM-AME-NUM | Numeric value of the AME | |
| 433 | 437 | 5 | Num | SELM-PAGE-COUNT | Number of pages involved in the refiling form | |
| 438 | 439 | 2 | Num | SELM-CMI | Collection Mode Indicator (CMI) used for TSR clients; isolates a specific CMI if used; blank = No CMI specification; '00', '01' or '07' – specific CMI utilization | |
| --- Multi-Account and Single-Account Description Record --- | ||||||
| 37 | 134 | 98 | Char | SELM-IND-DESC-DATA | One of multiple lines in the NAICS descriptions for either single account (NVS) or multi-family (NVM) refiling forms; ;up to 11 such lines can exist for each NAICS | |
| 135 | 439 | 305 | Char | FILLER | spaces | |
Selections for Mailing File Data Set Names: EAR.SEL.SINGLES, -MULTIS Service Center DSNs YBUssW.A145.SEL.SINGLES, -MULTIS ('ss' = State FIPS code) Type of File: Sequential File Layout: EARSELM This is a dual-format file used for storing both single account and multi-family refiling form data. The difference is in the forms output, since NVS (single-account) forms have a one-to-one mapping with the refiled single accounts, whereas NVM (multi-family) refiling forms split out and group the component worksites of the family by NAICS code, either severally or individually. The output forms will vary markedly in volume and complexity with the number of worksites and the range of industries involved. The initial data for this file are loaded from the Refiling File using the single, multi, and non-classified data collection programs. Except for non-classified account processing (which doesn't need industry-specific descriptions), the initial file is sorted into industry sequence to process in a separate additional batch program that adds the multi-line NAICS description data to the records. This produces a "mailing ready" file in the same format, which needs to be externally sorted once more before the forms can be printed in U-I account number order by the forms printing programs of the 103D/G or 104D/G jobs (the 117D job is exempt from these extra processing steps). After the forms have been generated, all four versions of this file are deleted. The SIC code and auxiliary code were removed for Version 9; simultaneously, the "N7R" switch was added to segregate establishments that are involved with the NAICS 2007 revision from those that have no 2007-revision-involvement. | ||||||
Related Links
