06 micro omni omnifarious auxiliary file es2moa
Jump to navigation
Jump to search
Micro Omni (or Omnifarious) Auxiliary File (ES2MOA)
ES2MOA - Length 128 - Revised 1/31/2007
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 15 | 15 | Key | Char | MOA-SESA-ID | SESA ID (U-I account plus reporting unit number) of the account with the particular auxiliary-format record delineated below |
| 1 | 10 | 10R | Key | Char | MOA-ACCT | U-I Account number portion of the SESA ID |
| 11 | 15 | 5R | Key | Num | MOA-RPT-UNIT | Reporting Unit number portion of the SESA ID, 00000 = Single or master, 00001-99999 = Worksite record |
| 16 | 16 | 1 | Key | Num | MOA-REC-TYPE | Record type code, used to distinguish among the various kinds of records available on this file; values include- 'A' = Mailing/other address record; 'C' = Contact (e.g., attention name) data; 'D' = Data disparity record; 'E' = E-mail and fax record; 'P' = Auxiliary predecessor/successor data; 'W' = Website address record |
| 17 | 128 | 112 | Char | MOA-DATA | Data portion of the record, formatted uniquely according to the record type above; each possible record layout is listed below | |
| Mailing/Other Address Record Data (Record Type 'A') | ||||||
| 17 | 17 | 1 | Char | MOA-ADDR-TYPE | Address type code, '1' = Physical location address (rarely used for MOA), '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown/unverified address | |
| 18 | 52 | 35 | Char | MOA-ADDRESS1 | First line of street address for MOA | |
| 53 | 87 | 35 | Char | MOA-ADDRESS2 | Second street address line | |
| 88 | 117 | 30 | Char | MOA-CITY | Mailing/other address city | |
| 118 | 119 | 2 | Char | MOA-STATE | Mailing/other address state postal abbreviation | |
| 120 | 128 | 9 | Char | MOA-ZIP | Full 9-digit MOA zip code (subdivided below) | |
| 120 | 124 | 5R | Char | MOA-ZIP-5 | Five-digit zip code (or first five positions of Canadian 6-digit zip code) | |
| 125 | 128 | 4R | Char | MOA-ZIP-4 | MOA ZIP+4 extension (or last digit of Canadian zip code followed by three spaces) | |
| Contact Information Record Data (Record Type 'C') | ||||||
| 17 | 51 | 35 | Char | MOA-CONTACT-NAME | Name of the contact person at the establishment when inquiries are needed | |
| 17 | 51 | 35R | Char | MOA-ATTN-NAME | Attention name (alias of "Contact name" in use with EXPO for many years); kept for consistency and readability | |
| 52 | 86 | 35 | Char | MOA-CONTACT-TITLE | Title by which the contact person is addressed | |
| 87 | 128 | 52 | Char | FILLER | spaces | |
| Data Disparity Record Data (Record Type 'D') | ||||||
| 17 | 40 | 24 | Char | MOA-FIRST-DISPARITY | First set of data discrepancy fields for resolution of conflicting data between this system and other federal systems (BEA, LAUS, Census, etc.); sub-divided below | |
| 17 | 17 | 1R | Char | MOA-FD-NAICS | Indicator flag within the first disparity set to detect a discrepancy between federal systems with regard to the NAICS code; values not yet known | |
| 18 | 18 | 1R | Char | MOA-FD-CNTY | Indicator flag in the first set denoting a discrepancy in county codes between federal programs; values are not yet known | |
| 19 | 19 | 1R | Char | MOA-FD-PLA | Indicator flag within the first set for display of physical-location-address (PLA) disparities between CEW and other federal systems; values not yet disclosed | |
| 20 | 20 | 1R | Char | MOA-FD-MEEI | Indicator flag in the first set to show multi-establishment employer field disparities between this system and other federal systems; values unknown | |
| 21 | 21 | 1R | Char | MOA-FD-EMPL | Indicator flag within the first disparity set noting a conflict in employment (apparently for single of multiple months; values not known | |
| 22 | 22 | 1R | Char | MOA-FD-WAGE | Indicator flag in the first group used to show disparity in total wage values between the CEW/202 and another Federal data source; values not yet listed | |
| 23 | 23 | 1R | Char | MOA-FD-FACT-A | Indicator flag within the first set for a not-yet-determined data field to be checked for disagreement with the same field in another source of data; no values yet known | |
| 24 | 24 | 1R | Char | MOA-FD-FACT-B | Second not-yet-identified field's disparity flag within the first set of such flags; it may be used to flag disagreements in this field's value compared to another data source in the Federal government; values have not yet been identified | |
| 25 | 28 | 4R | Num | MOA-FD-NOTIFY-YEAR | Year (4-digit) during which the ES-202 unit was notified that a discrepancy exists in the field(s) indicated in the flags shown above; if present, this field will be numeric and show a valid year value (e.g., 2004); otherwise, it will be blank; the character- based redefinition of this field is called MOA-FD-NOTIFY-YEAR-X | |
| 29 | 32 | 4R | Num | MOA-FD-REVIEW-YEAR | 4-digit year during which the fields shown above were reviewed, and a resolution was attained as to the true value of these fields; if present, this field will be numeric, a valid year format (e.g., 2005), and either match or exceed the Notify Year field shown above; otherwise it will be blank; the character-based equivalent field is MOA-FD-REVIEW-YEAR-X | |
| 33 | 40 | 8R | Char | MOA-FD-RESULTS | A set of eight result indicator flags associated with the disparate fields indicated above; these are shown individually below | |
| 33 | 33 | 1R | Char | MOA-FDR-NAICS | Indicator in the first disparity set noting the result of a review of the NAICS code value to resolve a conflict with another federal program regarding its value; valid values of this field are not yet known | |
| 34 | 34 | 1R | Char | MOA-FDR-CNTY | Indicator in the first set to declare the county discrepancy review result, if it had been flagged in the above indicator set; values yet to be determined | |
| 35 | 35 | 1R | Char | MOA-FDR-PLA | Result indicator for the physical location address discrepancy noted in the first set of disparity indicators; values unknown | |
| 36 | 36 | 1R | Char | MOA-FDR-MEEI | First disparity set indicator for the review result of MEEI certification following receipt of a discrepancy notification as noted in the indicator fields above; unknown values | |
| 37 | 37 | 1R | Char | MOA-FDR-EMPL | Flag to note the result of a review of the employment value(s) that were questioned by the disparity indicator shown earlier; values not yet released | |
| 38 | 38 | 1R | Char | MOA-FDR-WAGE | Total wage discrepancy review result flag among the first disparity set; conflict resolution values are not known | |
| 39 | 39 | 1R | Char | MOA-FDR-FACT-A | Review result indicator for the not-yet-identified "Fact A" field, if it needed to be verified due to a disparity identified in the first set of indicators above; unknown values | |
| 40 | 40 | 1R | Char | MOA-FDR-FACT-B | Indicator flag noting the resolution of a data conflict for the as yet unidentified "Fact B" field according to the discrepancy flags shown earlier; values as yet undeclared | |
| 41 | 64 | 24 | Char | MOA-SECOND-DISPARITY | Second set of disparity data, broken out as shown in the fields that follow | |
| 41 | 41 | 1R | Char | MOA-SD-NAICS | Indicator flag within the second disparity set to detect a discrepancy between federal systems with regard to the NAICS code; values not yet known | |
| 42 | 42 | 1R | Char | MOA-SD-CNTY | Indicator flag in the second set denoting a discrepancy in county codes between federal programs; values are not yet known | |
| 43 | 43 | 1R | Char | MOA-SD-PLA | Indicator flag within the second set for display of physical-location-address (PLA) disparities between CEW and other federal systems; values not yet disclosed | |
| 44 | 44 | 1R | Char | MOA-SD-MEEI | Indicator flag in the second set to show multi-establishment employer field disparities between this system and other federal systems; values unknown | |
| 45 | 45 | 1R | Char | MOA-SD-EMPL | Indicator flag within the second disparity set noting a conflict in employment (apparently for single or multiple months; values not known | |
| 46 | 46 | 1R | Char | MOA-SD-WAGE | Indicator flag in the second group used to show disparity in total wage values between the CEW/202 and another Federal data source; values not yet listed | |
| 47 | 47 | 1R | Char | MOA-SD-FACT-A | Indicator flag within the second set for a not-yet-determined data field to be checked for disagreement with the same field in another source of data; no values yet known | |
| 48 | 48 | 1R | Char | MOA-SD-FACT-B | Second not-yet-identified field's disparity flag within the second set of such flags; it may be used to flag disagreements in this field's value compared to another data source in the Federal government; values have not yet been identified | |
| 49 | 52 | 4R | Num | MOA-SD-NOTIFY-YEAR | Year (4-digit) during which the ES-202 unit was notified that a discrepancy exists in the field(s) indicated in the flags shown above; if present, this field will be numeric and show a valid year value (e.g., 2004); otherwise, it will be blank; the character-based redefinition of this field is called MOA-FD-NOTIFY-YEAR-X | |
| 53 | 56 | 4R | Num | MOA-SD-REVIEW-YEAR | 4-digit year during which the fields shown above were reviewed, and a resolution was attained as to the true value of these fields; if present, this field will be numeric, a valid year format (e.g., 2005), and either match or exceed the Notify Year field shown above; otherwise it will be blank; the character-based equivalent field is MOA-FD-REVIEW-YEAR-X | |
| 57 | 64 | 8R | Char | MOA-SD-RESULTS | A set of eight result indicator flags associated with the disparate fields indicated above; these are shown individually below | |
| 57 | 57 | 1R | Char | MOA-SDR-NAICS | Indicator in the second disparity set noting the result of a review of the NAICS code value to resolve a conflict with another federal program regarding its value; valid values of this field are not yet known | |
| 58 | 58 | 1R | Char | MOA-SDR-CNTY | Indicator in the second set to declare the county discrepancy review result, if it had been flagged in the above indicator set; values yet to be determined | |
| 59 | 59 | 1R | Char | MOA-SDR-PLA | Result indicator for the physical location address discrepancy noted in the second set of disparity indicators; values unknown | |
| 60 | 60 | 1R | Char | MOA-SDR-MEEI | Second disparity set indicator for the review result of MEEI certification following receipt of a discrepancy notification as noted in the indicator fields above; unknown values | |
| 61 | 61 | 1R | Char | MOA-SDR-EMPL | Flag to note the result of a review of the employment value(s) that were questioned by the disparity indicator shown earlier; values not yet released | |
| 62 | 62 | 1R | Char | MOA-SDR-WAGE | Total wage discrepancy review result flag among the second disparity set; conflict resolution values are not known | |
| 63 | 63 | 1R | Char | MOA-SDR-FACT-A | Review result indicator for the not-yet-identified "Fact A" field, if it needed to be verified due to a disparity identified in the second set of indicators above; unknown values | |
| 64 | 64 | 1R | Char | MOA-SDR-FACT-B | Indicator flag noting the resolution of a data conflict for the as yet unidentified "Fact B" field according to the discrepancy flags shown earlier; values as yet undeclared | |
| 65 | 128 | 64 | Char | FILLER | spaces | |
| E-mail and Fax Record Data (Record Type 'E') | ||||||
| 17 | 76 | 60 | Char | MOA-EMAIL-ADDRESS | E-mail address of contact person at this establishment; maintained on ES2C Geocode Screen | |
| 77 | 86 | 10 | Char | MOA-FAX-PHONE | Facsimile machine phone number for contact person or agency; broken out below | |
| 77 | 79 | 3R | Char | MOA-FAX-AREA | Area code portion of the fax phone number | |
| 80 | 82 | 3R | Char | MOA-FAX-EXCHANGE | Exchange (or prefix) portion of fax phone number | |
| 83 | 86 | 4R | Char | MOA-FAX-SUFFIX | Suffix portion of fax phone number | |
| Website Address Record Layout (Record Type "W") | ||||||
| 17 | 76 | 60 | Char | MOA-WEBSITE-ADDRESS | This company's website address that can be used to access corporate news that may be helpful in verifying establishment placement, industrial coding, etc. | |
| 77 | 128 | 52 | Char | FILLER | spaces | |
Micro Omnifarious Auxiliary (MOA) File Data Set Name: WS.ES202.MAILOTH.ADDR Service Center DSN: YBUssX.A145.MAILOTH.ADDR, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2MOA CICS ID: ES2MOA (standard); EssMOA (Service Center; ss=State) The MOA File stores several types of records to provide auxiliary data to micro-level data queries. In addition to the original mailing-address records (now record type 'A'), the file stores contact information, data disparity notations, e-mail and fax phone number data, and corporate website addresses. Each type of record is tracked for changes within the MOA Transaction File, which is described next. Mailing addresses are generally placed here for establishments that have a different U-I tax address. Since the U-I address is immutable, according to BLS precepts, the MOA's address record may also often contain a corrected version of the U-I address (such as a misspelled street name or city, incorrect zip code, etc.). These MOA records represent the first choice of EXPO batch jobs for preparation of mailing address information. These addresses are also more strictly edited than U-I addresses (UIA's), but come in second place to physical location addresses (PLA's). Contact information may be useful in MWR printing and in questioning the employer about suspicious data. Data disparity fields have not yet been utilized by the system, but will eventually be used to note conflicting values in key data fields between this system and other federal systems. The e-mail address and fax phone numbers assist the contact information in seeking feedback from the employer regarding questionable data. The website address record can provide valuable information about changes in corporate structure and other CEW-related information. | ||||||
Related Links
