Difference between revisions of "06 alpha locator file es2alph"
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_abbreviated_quarterly_address_file_es2aqui|Abbreviated Quarterly U-I Address File (ES2AQUI)]] | * [[06_abbreviated_quarterly_address_file_es2aqui|Abbreviated Quarterly U-I Address File (ES2AQUI)]] | ||
* [[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:38, 11 July 2019
Alpha Locator File (ES2ALPH)
ES2ALPH - Length 137 - Revised 3/12/2004
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 35 | 35 | Key | Char | ALPH-NAME | Employer's legal or trade (DBA) name |
36 | 50 | 15 | Key | Char | ALPH-SESA-ID | U-I account number and 5-digit reporting unit number of employer |
51 | 51 | 1 | Num | ALPH-STATUS | Current quarter account status ('1' = Active, '2' = Inactive, '9' = Pending) | |
52 | 59 | 8 | Num | ALPH-END-LIAB-DATE | End of Liability date (yyyymmdd format) | |
60 | 62 | 3 | Num | ALPH-COUNTY | Current quarter county FIPS code | |
63 | 63 | 1 | Num | ALPH-TYPE-COV | Current quarter type of coverage code ('0' = Experience-rated, '1' = Reimbursable, '2' = Experience-rated with employee contributions, '3' = Reimbursable with employee contributions, '8' = Non-subject, '9' = Federal) | |
64 | 64 | 1 | Num | ALPH-MEEI | Current quarter multi-establishment employer indicator (MEEI) code ('1' = Single, '2' = Multi master account, '3' = Worksite location, '4' = Known multi refusing to provide worksite detail, '5' = Composite worksite (grouped sites), '6' = Multi with worksite detail omitted due to low total employment (fewer than 10 employees) | |
65 | 99 | 35 | Char | ALPH-ADDRESS | Establishment's location: street address | |
100 | 129 | 30 | Char | ALPH-CITY | Establishment's location: city | |
130 | 131 | 2 | Char | ALPH-STATE | Establishment's location: state | |
132 | 136 | 5 | Char | ALPH-ZIP | Establishment's location: 5-digit zip code | |
137 | 137 | 1 | Char | ALPH-ADDR-TYPE | Type of address represented above ('U' = U-I tax address, 'P' = Physical location address | |
Alpha Locator File Data Set Name: WS.ES202.ALPHA Service Center DSN: YBUssX.A145.ALPHA, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout ES2ALPH CICS ID: ES2ALPH (standard); EssALPH (Service Center, ss = state) The Alpha Locator File is a VSAM-indexed file, used to find an establishment's U-I account number from the trade or legal name. Program ES2UT08 collects data from the Micro File to generate a sequential Alpha Locator File in SESA ID sequence. Both the legal/corporate name and the DBA/trade name are used in establishing Alpha Locator records. If a firm has both names, one record will be written for each name, so that either can be used as a search parameter. If both names are identical, only one record is written to represent the common name. Should both names be blank, no record is written for the establishment. These records are sorted alphabetically in order to rebuild the VSAM File. This update should take place periodically throughout the quarter, on a weekly to monthly basis, through submittal of Job ES2J050D, depending on the level of name change activity and the importance of up-to-date alpha data. The file is also rebuilt automatically in the quarterly data extraction process of Job ES2J001Q. The file is accessed on a read-only basis by CICS transaction ES2S, which displays boxes containing the name, U-I account number, address, and various indicator codes (MEEI, county, etc.). A firm can be singled out for further examination in the ES2C and other CICS screens as well. |
Related Links