Data Integrity Checks Before ETL
Oracle Argus Safety must complete the following data integrity checks before performing the ETL:
- Every case must have at least one suspect product.
- Every case must have at least one event where the DESC_REPTD column is not null.
- Every case must have one and only one primary event.
- Every case must have a State record (CASE_MASTER.STATE_ID).
- Every case must have a Report Type record (CASE_MASTER.RPT_TYPE_ID).
- Every case must have a Country of Incidence record (CASE_MASTER.COUNTRY_ID).
- Every case must have a Study record (CASE_STUDY).
- Every case must have an Assessment record (CASE_ASSESS).
- Every product in CASE_PRODUCT must have a record in CASE_PROD_DRUGS.
- If there are reporters on the case, there must be only one primary reporter
Parent topic: Run the Extract, Transform, and Load Process