Multi-Level Reconciliation is an ACR/Detail feature that provides the capability to extract data at the maximum level of detail, and then reconcile the extracted data at different reconciliation key levels.
Multi-Level Reconciliation is defined through Job Definitions on the Reconciliation Level Information panel. To use Multi-Level Reconciliation, set up a base level (usually the most detailed level of reconciliation key) and up to 99 subordinate levels (least detailed levels for which to reconcile data). File definitions are only used under the base level which will extract all keys (or, the most detailed level) to be used in later levels.
Base and subordinate levels are indicated by the QUAL field, also known as the Reconciliation-Level Qualifier (RLQ), of the Job ID. For the base level, the RLQ must be blank. Assign sequential, numeric RLQs for the subordinate levels (01, 02, etc.). All keys or just out-of-balance keys for each reconciliation level can be written to a filter file for use in a subsequent RLQ.
ACR/Detail extracts data from the input file according to the File Definitions defined in the base job, and then applies the Job Definitions. The Reconciliation Function will first process against the base level. ACR/Detail will then check to see if any subsequent levels exist. Subsequent RLQ levels are run automatically if no Return Code Range exists to check return codes from the prior level, or if the return code value returned from the prior level falls within the Return Code Range specified. If specified in the Basic Job Information, the Reconciliation function will process against the subset of keys stored in the filter file. This process continues until there are no more levels to process.
Reports can be produced at each reconciliation level. Data may be stored on the Detail History Database at any reconciliation level.