All pre-validation script packages (*_pkg.sql) contain the following procedures.
Table 1–1 Common Procedures
Procedure |
Purpose |
---|---|
Initialize_Profile |
Initializes the table for sharing to avoid running multiple instances by different users. |
TidyUp |
Updates sb_pass_or_fail columns in the staging table from INTERMEDIATE to PASS for records that were not marked as failed by the pre-validation rules. |
Validate |
The main validation procedure which calls the procedures that perform the pre-validations for the Interface Table. |