Difference between revisions of "06 ears job parameters file lookup subset earjprm"
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_refiling_master_file_earref|Refiling Master File (EARREF)]] | * [[06_refiling_master_file_earref|Refiling Master File (EARREF)]] | ||
* [[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
EARS Job Parameters File (Lookup File Subset) (EARJPRM)
EARJPRM - Length 132 - Revised 2/13/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 2 | 2 | Key | Char | J1-PREFIX | Identifier to distinguish EARS job parameter records from other Lookup File records; always = 'J1' |
3 | 5 | 3 | Key | Char | J1-JOBID | Batch job ID final three characters; for instance '01D' refers to EARJ101D; when combined with the record type above, this forms the last five characters of the job ID (i.e., everything except the "EAR" prefix) |
6 | 12 | 7 | Key | Char | FILLER | spaces |
13 | 110 | 98 | Char | J1-JOB-PARMS | List of parameters defined within the batch job by all parameter-driven applications; sub-defined below by individual batch job. | |
= = = Job EARJ101D Parameters = = = | ||||||
13 | 15 | 3 | Char | J101D-YRQ | Micro year/quarter alignment for Input Refiling Transaction (IRT) File data | |
16 | 16 | 1 | Char | J101D-CHG-LOG-RPT-SW | Option for listing or omitting report of refiling data changes (Y or N) | |
17 | 110 | 94 | Char | FILLER | spaces | |
= = = Job EARJ102D Parameter = = = | ||||||
13 | 17 | 5 | Char | J102D-EDIT-RPT-SORT-SEQ | Sort sequencing parameter characters; up to five letters can be selected from the following list: 'A' = U-I account number (SESA ID); 'C' = County FIPS code; 'N' = NAICS code; 'O' = Ownership code; 'R' = Most severe (lowest-numbered) error code; 'S' = SIC code; 'T' = Sub-county township code; 'Z' = Sub-county zone code | |
18 | 110 | 93 | Char | FILLER | spaces | |
= = = Job EARJ106D Parameters = = = | ||||||
13 | 13 | 1 | Char | J106D-CYCLE | Switch to note whether this is the first run of a new refiling cycle (Y/N) | |
14 | 110 | 97 | Char | FILLER | spaces | |
= = = Job EARJ107D Parameters = = = | ||||||
13 | 16 | 4 | Char | J107D-ID1 | First Refiling Parameters request ID selected for processing (EARRSEL key) | |
17 | 20 | 4 | Char | J107D-ID2 | Second refiling parameter request ID selection | |
21 | 24 | 4 | Char | J107D-ID3 | Third refiling parameter request ID selection | |
25 | 28 | 4 | Char | J107D-ID4 | Fourth refiling parameter request ID selection | |
29 | 32 | 4 | Char | J107D-ID5 | Fifth refiling parameter request ID selection | |
33 | 36 | 4 | Char | J107D-ID6 | Sixth refiling parameter request ID selection | |
37 | 40 | 4 | Char | J107D-ID7 | Seventh refiling parameter request ID selection | |
41 | 44 | 4 | Char | J107D-ID8 | Eighth refiling parameter request ID selection | |
45 | 48 | 4 | Char | J107D-ID9 | Ninth refiling parameter request ID selection | |
49 | 110 | 82 | Char | FILLER | spaces | |
= = = Job EARJ108D Parameters = = = | ||||||
13 | 13 | 1 | Char | J108D-FAX-LOAD-OPT | Option to load collected fax phone numbers into Refiling File data (Y/N) | |
14 | 110 | 97 | Char | FILLER | Spaces | |
= = = Job EARJ114D Parameters = = = | ||||||
13 | 20 | 8 | Char | J114D-DATE | ??? | |
21 | 110 | 90 | Char | FILLER | spaces | |
= = = Job EARJ116D Parameters = = = | ||||||
13 | 13 | 1 | Char | J116D-SORT-SEQ-OPT | Sorting sequence code for Refiling Transaction File Audit Trail Report; 'A' = Sort by U‑I account number; 'D' = Sort by date and time of transactions; 'U' = Sort by user ID | |
14 | 21 | 8 | Char | J116D-START-DATE | First date to select refiling transactions for printing (yyyymmdd format) | |
22 | 29 | 8 | Char | J116D-END-DATE | Last date to select refiling transactions for printing ( yyyymmdd format) | |
30 | 35 | 6 | Char | J116D-USER-ID | Specific user ID (CICS logon ID) to isolate for printing of a transactions report; if blank, select all users for inclusion in the report | |
36 | 110 | 75 | Char | FILLER | spaces | |
= = = Job EARJ117D Parameters = = = | ||||||
13 | 15 | 3 | Char | J117D-YRQ | Year/quarter for printing NCA form using micro data (yyq format) | |
16 | 16 | 1 | Char | J117D-VALUE-OPT | SIC values to look for, '1' = Look for '9999', '2' = Look for '0000', '3' = Look for either '0000' or '9999' | |
17 | 20 | 4 | Char | J117D-GROUP | Optional account group ID to select | |
21 | 25 | 5 | Num | J117D-EMPL | Cutoff employment value for account selection (printing only larger employers) | |
26 | 35 | 10 | Char | J117D-UI-BEG-RANGE | Beginning of U-I account number selection range | |
36 | 45 | 10 | Char | J117D-UI-END-RANGE | High-end of U-I account number selection range | |
46 | 53 | 8 | Char | J117D-LIAB-BEG-RANGE | Earliest initial liability date allowed for selection (yyyymmdd format) | |
54 | 61 | 8 | Char | J117D-LIAB-END-RANGE | Latest initial liability date allowed for selection (yyyymmdd format) | |
62 | 62 | 1 | Char | J117D-BAR-OPT | Barcode placement option; '1' = Print barcode on top; '2' = Print on bottom of form | |
63 | 63 | 1 | Char | J117D-ATTN-OPT | Option to include the attention name in the mailing address block (Y/N) | |
64 | 64 | 1 | Char | J117D-SLASH-OPT | Option to include slash characters to highlight high-employment accounts on the refiling form (Y/N) | |
65 | 70 | 6 | Num | J117D-EMP-LVL | Employment cutoff value associated with the "large employer" definition above | |
71 | 71 | 1 | Char | J117D-MOA-OPT | MOA priority code; '1' = MOA is first choice; '2' = Second choice; '3' = Last choice | |
72 | 72 | 1 | Char | J117D-UI-OPT | U-I address priority code; '1' = UIA is first choice; '2' = Second choice; '3' = Last choice | |
73 | 73 | 1 | Char | J117D-PL-OPT | P-L address priority code; '1' = First choice; '2' = Second choice; '3' = Last choice | |
74 | 74 | 1 | Char | J117D-CARS-RUN-SW | Mailing of Non-classified forms (Y/N) | |
75 | 110 | 36 | Char | FILLER | spaces | |
= = = Job EARJ118D Parameters = = = | ||||||
13 | 13 | 1 | Char | J118D-SORT-OPTION | Sorting code for CCS Master List Report, 'A' = Account number (SESA ID), 'C' = County/ownership/SIC sequence | |
14 | 110 | 97 | Char | FILLER | spaces | |
= = = Job EARJ120A Parameters = = = | ||||||
13 | 13 | 1 | Char | J120A-UPDATE-OPTION | Option to post the new addresses directly to the system files (Y/N) | |
14 | 110 | 97 | Char | FILLER | spaces | |
= = = Job EARJ121D Parameters = = = | ||||||
13 | 13 | 1 | Char | J121D-NAICS-CNTY-TOWN | Switch to update the NAICS, County Code and Township (Y/N) | |
14 | 14 | 1 | Char | J121D-LEGAL-NAME | Switch to update the Legal Name (Y/N) | |
15 | 15 | 1 | Char | J121D-LOCK-LEGAL-NAME | Switch to lock the Legal Name after it is Updated (Y/N) | |
16 | 16 | 1 | Char | J121D-TRADE-NAME | Switch to update the Trade/Doing-Business-As Name (Y/N) | |
17 | 17 | 1 | Char | J121D-LOCK-TRADE-NAME | Switch to lock the Trade / Doing-Business-As Name after it is Updated (Y/N) | |
18 | 18 | 1 | Char | J121D-PHYSICAL-ADDR | Switch to update the Physical Address (Y/N) | |
19 | 19 | 1 | Char | J121D-LOCK-PHYSICAL-ADDR | Switch to Lock the Physical Address after it is Updated (Y/N) | |
20 | 20 | 1 | Char | J121D-MAILING-OTHER | Switch to Update the Mailing/Other Address (Y/N) | |
21 | 21 | 1 | Char | J121D-LOCK-MAILING-OTHER | Switch to Lock the MOA after it is Updated (Y/N) | |
22 | 22 | 1 | Char | J121D-LOCK-ATTN-NAME | Switch to Lock the Attention Name after it is Updated (Y/N) | |
23 | 23 | 1 | Char | J121D-CONTACT-INFO | Switch to Update the Contact Information (Y/N) | |
24 | 24 | 1 | Char | J121D-LOCK-PHONE | Switch to Lock the Phone Number after it is Updated (Y/N) | |
25 | 110 | 86 | Char | FILLER | spaces | |
= = = Job EARJ124D Parameters = = = | ||||||
13 | 13 | 1 | Char | J124D-RC-ZERO | Select Response Code 00 Option (Y/N) | |
14 | 14 | 1 | Char | J124D-RC-ONE | Select Response Code 01 Option (Y/N) | |
15 | 15 | 1 | Char | J124D-RC-TWO | Select Response Code 02 Option (Y/N) | |
16 | 16 | 1 | Char | J124D-RC-THREE | Select Response Code 03 Option (Y/N) | |
17 | 17 | 1 | Char | J124D-RC-FOUR | Select Response Code 04 Option (Y/N) | |
18 | 23 | 6 | Num | J124D-M3-EMPL | Month-3 of the Quarter Employment (Zeroes or Not) | |
24 | 24 | 1 | Char | J124D-MEEI-ONE | Select MEEI Code 1 (single accounts - Y/N) | |
25 | 25 | 1 | Char | J124D-MEEI-TWO | Select MEEI Code 2 (multi masters - Y/N) | |
26 | 26 | 1 | Char | J124D-MEEI-THREE | Select MEEI Code 3 (standard worksites - Y/N) | |
27 | 27 | 1 | Char | J124D-MEEI-FOUR | Select MEEI Code 4 (refusals – treated as singles - Y/N) | |
28 | 28 | 1 | Char | J124D-MEEI-FIVE | Select MEEI Code 5 (composite worksites - Y/N) | |
29 | 29 | 1 | Char | J124D-MEEI-SIX | Select MEEI Code 6 (secondary employment too small for a breakout - Y/N) | |
30 | 110 | 81 | Char | FILLER | spaces | |
111 | 118 | 8 | Char | J1-USERID | CICS Log-on ID code for the person last modifying the set of job parameters | |
119 | 126 | 8 | Char | J1-LAST-CHANGE-DATE | Date on which job parameters were last changed (yyyymmdd format) | |
127 | 132 | 6 | Char | J1-LAST-CHANGE-TIME | Time of day when last job parameter changes occurred (hhmm format) | |
Job Parameters File Data Set Name: WS.ES202.LOOKUP Service Center DSN: YBUssX.A145.LOOKUP ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: EARJPRM CICS ID: ES2LKUP (EssLKUP for Service Center; 'ss' = State Postal Abbreviation) The Job Parameters File is an alias of the Lookup File, but is updated separately. It is also known as the Survey Log File. The job parameters records used here are entered and updated through the EARN transaction, which uses one screen for each batch job that requires program parameters. Every parameter-using batch job in EARS uses a common program (EARUT19) to reformat the Job Parameter data into a Program Parameters File. The converted file will include the Job ID at the beginning of each record, followed by the last four characters of the program ID referenced. This, in turn, is followed by the parameters relating to the particular referenced program. Once the conversion has been enacted, the Job Parameters record no longer needs to be accessed directly, as the parameters for other programs in the job stream are drawn from the Program Parameters File. |
Related Links