Understanding Contract validation

The BL_021__VS_CONTRACT job sequencer orchestrates the execution of the Contract validation jobs.

In order to save processing time, the sequencer first checks the parsed datasets produced by SIF Import phase to see if records specific to each RT/ST being processed exist before executing the validation logic. If there are no records to be validated for a specific RT/ST, the validation job will be bypassed for that RT/ST. An empty dataset with correct metadata and name (to be consumed by downstream jobs) will be created instead

An image depicting a portion of the BL_021__VS_EC_CONTRACT job sequence
Note: For each of the Contract sub-types ( namely Contract, ContractComponent, ContractCompVal, ContractRole, Alert, RoleLocation and MiscValue), if the input dataset is empty, special care is taken to make sure the corresponding output dataset is valid and consumable by the downstream jobs. This includes making sure the output dataset name contains required prefix (Valid_*) as expected by Error Consolidation jobs. Besides, it is also ensured that specific interrelated metadata is properly provided in the dataset to assist in the assignment of keys and loading of data into InfoSphere® MDM. These tasks are handled through the use of the Contract “preparation” jobs.

Contract validation jobs

BIL Contract validation jobs check all the code types against the code tables in the MDM database and applying business rules when necessary. The validation jobs capture, format and output Data Quality Errors it encounters into a related Data Quality Error Message text file.

Contract Validation jobs consists of a VSVAL* shared containers containing RT/ST specific validation logic and an Edit/Extension Point shared container. The Edit/Extension Point shared containers are an advanced feature to allow for customization by the client / customer.

The new BIL Import SIF process creates a RI_Contract_SUBSET dataset that will overwritten by the BL_021_VS_Contract job when validation is required.

The following table summarizes the BIL Contract Validation jobs. It presents each BIL job with their corresponding RT/ST and the validation shared container it references.

RT/ST BIL Contract Validation Job Reference Shared Container
C/C BL_021_VS_ContractComponent VSVALContractComponent
C/H BL_021_VS_Contract VSVALContract
C/L BL_021_VS_RoleLocation VLVALRoleLocation
C/M BL_021_VS_MiscValue_Contract VSVALMiscValue
C/R BL_021_VS_ContractRole VSVALContractRole
C/V BL_021_VS_ContractCompVal VSVALContractCompVal
C/T BL_021_VS_Alert_Contract VSVALAlert