Difference between revisions of "06 micro omni aux transaction file es2mtrn"
m (1 revision imported) |
MattSteadman (talk | contribs) m (Text replacement - "[[start" to "[[EXPO_Documentation") |
||
Line 8: | Line 8: | ||
* [[06_mwr_web_collected_data_file_es2mwcd|MWR Web-Collected Data File (ES2MWCD)]] | * [[06_mwr_web_collected_data_file_es2mwcd|MWR Web-Collected Data File (ES2MWCD)]] | ||
* [[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:39, 11 July 2019
Micro-Omni-Aux Transaction File (ES2MTRN)
ES2MTRN - Length 261 - Revised 1/31/2007
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 15 | 15 | Key | Char | MTRN-SESA-ID | Combined U-I account number and reporting unit number for the establishment that has experienced the change; sub-divided below |
1 | 10 | 10R | Key | Char | MTRN-ACCT | U-I account number of the establishment involved in this MOA change |
11 | 15 | 5R | Key | Char | MTRN-RPT-UNIT | Reporting unit number of affected establishment |
16 | 27 | 12 | Key | Char | MTRN-DATE-TIME | Combined date-and-time stamp for the transaction, in the yymmddhhmmss format; subdivided below |
16 | 21 | 6R | Key | Char | MTRN-DATE | MOA Transaction date, with two-digit values for year, month and day (yymmdd) |
22 | 27 | 6R | Key | Char | MTRN-TIME | MOA Transaction time of day, with two-digit values for hour, minute and second (hhmmss format) |
28 | 28 | 1 | Key | Char | MTRN-REC-TYPE | Type of MOA record involved with the transaction, selected from the following values- 'A' = Mailing/Other Address record; 'C' = Contact person information; 'D' = Data disparity fields; 'E' = E-mail and fax phone data; 'P' = Predecessor/successor supplemental data; 'W' = Internet website address |
29 | 29 | 1 | Key | Char | MTRN-TRANS-TYPE | Type of action taken with the MOA record in question; 'A' = Used in conjunction with the adding of a Micro File record (adding a MOA record for an existing micro record does not use this code); 'C' = Change applied to the MOA record associated with a pre-existing, continuous Micro File record (adding a MOA record to an existing Micro record will show a change from spaces to non-blank values, whereas the removal of a MOA record for a micro record that remains on the file shows a change from non-blanks to spaces); 'D' = Removal of a MOA record connected to the deletion of the Micro record itself (removing a MOA record tied to a micro that continues to exist will not use this type code) |
30 | 37 | 8 | Char | MTRN-USER-ID | Identification of the CICS user ID or the batch program enacting the add, change or deletion of MOA data; batch program references like the entire program ID (e.g., 'ES2MI13'); CICS changes are broken out into the two sub-fields shown below | |
30 | 35 | 6R | Char | MTRN-UID-USER | CICS log-on ID of the person making the change | |
36 | 37 | 2R | Char | MTRN-UID-PGM | CICS transaction ID for the change (examples- '2C' = ES2C Front Screen, 'C2' = ES2C Codes Screen; 'RC' = EARC Screen, etc.) | |
38 | 149 | 112 | Char | MTRN-BEFORE-IMAGE | Data found in the MOA record before the change was enacted. In the event of an add or delete transaction (associated with the addition or deletion of a Micro File record, respectively), the before-image area represents the data after the add or before the delete; the after-image portion (described later) will be blank (unused) for additions and deletions. Individual field structures for the before image data are shown below. | |
Before-image of Address Type Record (MTRN-REC-TYPE = 'A') | ||||||
38 | 38 | 1 | Char | MTRN-BI-ADDR-TYPE | Before-change value of address type code, '1' = Physical location address, '2' = Mailing address, '3' = Corporate headquarters, '9' = Unknown/unverified address | |
39 | 63 | 35 | Char | MTRN-BI-ADDRESS1 | Before-change first line of street address for MOA | |
64 | 108 | 35 | Char | MTRN-BI-ADDRESS2 | Before-change second street address line | |
109 | 138 | 30 | Char | MTRN-BI-CITY | Before-change mailing/other address city | |
139 | 140 | 2 | Char | MTRN-BI-STATE | Before-change mailing/other address state postal abbreviation | |
141 | 149 | 9 | Char | MTRN-BI-ZIP | Before-change full 9-digit MOA zip code (subdivided below) | |
141 | 145 | 5R | Char | MTRN-BI-ZIP-5 | Before-change five-digit zip code (or first five positions of Canadian 6-digit zip code) | |
146 | 149 | 4R | Char | MTRN-BI-ZIP-4 | Before-change MOA ZIP+4 extension (or last digit of Canadian zip code followed by three spaces) | |
Before-Change Contact Information (MTRN-REC-TYPE = 'C' | ||||||
38 | 72 | 35 | Char | MTRN-BI-CONTACT-NAME | Before-change name of the contact person at the establishment when inquiries are needed | |
38 | 72 | 35R | Char | MTRN-BI-ATTN-NAME | Before-change attention name (alias of "Contact name" in use with EXPO for many years); kept for consistency and readability | |
73 | 107 | 35 | Char | MTRN-BI-CONTACT-TITLE | Before-change title by which the contact person is addressed | |
108 | 149 | 52 | Char | FILLER | spaces | |
Before-Change Image of Data Disparity Information (MTRN-REC-TYPE = 'D') | ||||||
38 | 61 | 24 | Char | MTRN-BI-FIRST-DISPARITY | Before-change value for 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 | |
38 | 38 | 1R | Char | MTRN-BI-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 | |
39 | 39 | 1R | Char | MTRN-BI-FD-CNTY | Indicator flag in the first set denoting a discrepancy in county codes between federal programs; values are not yet known | |
40 | 40 | 1R | Char | MTRN-BI-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 | |
41 | 41 | 1R | Char | MTRN-BI-FD-MEEI | Indicator flag in the first set to show multi-establishment employer field disparities between this system and other federal systems; values unknown | |
42 | 42 | 1R | Char | MTRN-BI-FD-EMPL | Indicator flag within the first disparity set noting a conflict in employment (apparently for single of multiple months; values not known | |
43 | 43 | 1R | Char | MTRN-BI-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 | |
44 | 44 | 1R | Char | MTRN-BI-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 | |
45 | 45 | 1R | Char | MTRN-BI-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 | |
46 | 49 | 4R | Num | MTRN-BI-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 MTRN-BI-FD-NOTIFY-YEAR-X | |
50 | 53 | 4R | Num | MTRN-BI-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 MTRN-BI-FD-REVIEW-YEAR-X | |
54 | 61 | 8R | Char | MTRN-BI-FD-RESULTS | A set of eight result indicator flags associated with the disparate fields indicated above; these are shown individually below | |
54 | 54 | 1R | Char | MTRN-BI-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 | |
55 | 55 | 1R | Char | MTRN-BI-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 | |
56 | 56 | 1R | Char | MTRN-BI-FDR-PLA | Result indicator for the physical location address discrepancy noted in the first set of disparity indicators; values unknown | |
57 | 57 | 1R | Char | MTRN-BI-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 | |
58 | 58 | 1R | Char | MTRN-BI-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 | |
59 | 59 | 1R | Char | MTRN-BI-FDR-WAGE | Total wage discrepancy review result flag among the first disparity set; conflict resolution values are not known | |
60 | 60 | 1R | Char | MTRN-BI-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 | |
61 | 61 | 1R | Char | MTRN-BI-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 | |
62 | 85 | 24 | Char | MTRN-BI-SECOND-DISPARITY | Second set of disparity data, broken out as shown in the fields that follow | |
62 | 62 | 1R | Char | MTRN-BI-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 | |
63 | 63 | 1R | Char | MTRN-BI-SD-CNTY | Indicator flag in the second set denoting a discrepancy in county codes between federal programs; values are not yet known | |
64 | 64 | 1R | Char | MTRN-BI-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 | |
65 | 65 | 1R | Char | MTRN-BI-SD-MEEI | Indicator flag in the second set to show multi-establishment employer field disparities between this system and other federal systems; values unknown | |
66 | 66 | 1R | Char | MTRN-BI-SD-EMPL | Indicator flag within the second disparity set noting a conflict in employment (apparently for single or multiple months; values not known) | |
67 | 67 | 1R | Char | MTRN-BI-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 | |
68 | 68 | 1R | Char | MTRN-BI-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 | |
69 | 69 | 1R | Char | MTRN-BI-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 | |
70 | 73 | 4R | Num | MTRN-BI-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 MTRN-BI-FD-NOTIFY-YEAR-X | |
74 | 77 | 4R | Num | MTRN-BI-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 MTRN-BI-FD-REVIEW-YEAR-X | |
78 | 85 | 8R | Char | MTRN-BI-SD-RESULTS | A set of eight result indicator flags associated with the disparate fields indicated above; these are shown individually below | |
78 | 78 | 1R | Char | MTRN-BI-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 | |
79 | 79 | 1R | Char | MTRN-BI-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 | |
80 | 80 | 1R | Char | MTRN-BI-SDR-PLA | Result indicator for the physical location address discrepancy noted in the second set of disparity indicators; values unknown | |
81 | 81 | 1R | Char | MTRN-BI-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 | |
82 | 82 | 1R | Char | MTRN-BI-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 | |
83 | 83 | 1R | Char | MTRN-BI-SDR-WAGE | Total wage discrepancy review result flag among the second disparity set; conflict resolution values are not known | |
84 | 84 | 1R | Char | MTRN-BI-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 | |
85 | 85 | 1R | Char | MTRN-BI-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 | |
86 | 149 | 64 | Char | FILLER | spaces | |
Before-change Values of E-mail and Fax Record Data (Record Type 'E') | ||||||
38 | 97 | 60 | Char | MTRN-BI-EMAIL-ADDRESS | E-mail address of contact person at this establishment; maintained on ES2C Geocode Screen | |
98 | 107 | 10 | Char | MTRN-BI-FAX-PHONE | Facsimile machine phone number for contact person or agency; broken out below | |
98 | 100 | 3R | Char | MTRN-BI-FAX-AREA | Area code portion of the fax phone number | |
101 | 103 | 3R | Char | MTRN-BI-FAX-EXCHANGE | Exchange (or prefix) portion of fax phone number | |
104 | 107 | 4R | Char | MTRN-BI-FAX-SUFFIX | Suffix portion of fax phone number | |
Before-Change Image of Website Address Data (Record Type 'W') | ||||||
38 | 97 | 60 | Char | MTRN-BI-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. | |
98 | 149 | 52 | Char | FILLER | spaces | |
150 | 261 | 112 | Char | MTRN-AFTER-IMAGE | Used only for a change ('C' in Trans-Type) record, shows the content of the MOA record as it existed after the change went through; format is the same as that listed above for the before-image layout (with 'AI' in place of 'BI' field names) | |
MOA Transaction File Data Set Name: WS.ES202.MOA.TRANS Service Center DSN: YBUssX.A145.MOA.TRANS, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2MTRN CICS ID: ES2MTRN (standard); EssMTRN (Service Center; ss=State) The Micro-Omni-Auxiliary Transaction (or M-Tran) File contains records generated by update actions to the various types of records found in the Micro Omnifarious (Omni) Auxiliary (MOA) File, including mailing addresses, fax phone numbers, e-mail addresses, contact information, data disparity indicators, predecessor/successor auxiliary data, and website addresses. As an extension of the Micro File, the MOA data are updated from many sources, both on-line and batch. M-Tran records form an audit trail of changes to MOA data that can be viewed on-line with the ES2P screen. Most of the functionality of this file parallels that of the Administrative Transaction and Quarterly Transaction Files. The record layout contains before-change and after-change values for all MOA data elements. Add and Delete transaction types are handled in a unique manner. In order for an M-Tran record to be considered for "Add" or "Delete" mode classification, it must be connected to the addition or removal of a Micro File record. The fact that a particular MOA record has not existed before, or is being removed (by blanking it out) is immaterial in regard to the Transaction Files review process in the ES2P screens. When a MOA record (regardless of type) is introduced into the system, but the Micro record already exists, the M-Tran record will show a change from blanks to non-blanks instead of the "add". Similarly, removing one of the MOA records by blanking it out will appear as a change from non-blanks to blanks. The "A" (for add) record type appears when one or more of the MOA records is/are added in conjunction with the addition of a new Micro File record. Conversely, when micro records are deleted, any corresponding MOA records will vanish with the "D" (delete) transaction type. Batch jobs writing records to this file include the IMT processing jobs (001D, 001Q, 001S, and 001X), and 005D, which selectively deletes records from all three transaction files older than a particular date (this is also performed automatically in Job 001Q). CICS transactions performing M-Tran updates include the ES2C screens, EARC, ES2E, ES2P, ES2V, and ES2X. |
Related Links