04 job es2j040d micro selection report not data sharing
Job ES2J040D - Micro Selection Report - Not for Data Sharing
RUN THIS JOB - As required.
This job executes the following programs (click to link to each program description):
Job Features and Functions
- Produces a micro-level report, file or delimited file of selected Micro records as specified in the ES2N parameter(s)
- All Micro File fields along with selected MOA file fields can be selected
- Parameters are flexible and can use any field in the Micro file to base a selection on.
- Single-byte values for a field can be listed together, separated by commas
- E.g., MEEI=1,4,6 will be treated as MEEI is 1 or 4 or 6
- Parameters allow comparison of any field against a specified value or range of values or comparison of one field against another field
- Parameter screen allows for up to nine selection conditions
- Individual parameters can be saved under separate request ID’s and re-used for future applications
- There is an option to specify year-quarter of data to appear on report/file/delinquent
- Default is to use whatever is in current quarter
- Report format is the same as 020D Job's firm listing
- File option produces a 537 byte-file - micro sequential data file - ES2MCDT
- Delimited file produces a 606-byte-file – the micro delinquent file – ES2MCDL
Job 040D parallels the output types of Job 020D, but uses field name parameters to provide the data selection criteria. These parameters are entered through one of the ES2N screens, establishing a parameter set for running the job. Similarly to the 020D, 246D, and 247D jobs, it allows up to nine sets of parameters to be processed in a single job run.
Job ES2J040D (40D) is a Micro File search program. It generates a Firm List Report or data file of Micro File records that meet the selection criteria. For reports, the output type parameter should be ‘R’. For a data file with a 537-byte record length, the output type parameter should be ‘F’.
This job is an expansion of Job 20D. Where Job 20D search capabilities are based on pre-determined fields, Job 40D is more free form in its selection capabilities. Any field in the Micro File record can be specified to compare against a specified value or range of values or against another field. In addition, ‘AND/OR/LOR’ statements are available to add more selection criteria. Up to eight sets of conditional selection criteria can be specified to identify the desired record(s) in the Micro and or MOA File search. After the selection criteria are entered in ES2N, Job 040D is run to search the Micro and or MOA Files for the desired records and produce a report or output file.
When entering the selection criteria in ES2N, the user can identify the field to be compared by either entering the beginning point of the field or by entering the abbreviated field name. If using the beginning point of the field, the parameter screen will convert it to the field abbreviation when the enter key is pressed. A Micro File layout table is provided in the Related Links (under Additional Job 040D Parameters Screen Information) to determine field beginning positions as well as a list of field name abbreviations for reference in specifying the desired field to compare or search.
Each parameter established for Job 040D can be saved under a unique four-digit request ID number. This number is entered in the upper right portion of the parameter screen. After its initial use and after it has been saved, it can be re-used and optionally modified for future applications of Job 040D. A saved request ID can be modified and re-saved under the same request ID.
Related Links
