1. User Guide
  2. Object Management
  3. Object Registration and Validation
  4. Validation Procedure

3.7.3 Validation Procedure

The OFSA_TAB_CLASS_REQ package contains all of the procedures and supporting functions that validates if a table meets the requirements for a particular Table Classification.

The package performs the following validations:

  • VALIDATE_INST_KEY

    This procedure validates if a table has ID_NUMBER and IDENTITY_CODE, or ID_NUMBER, IDENTITY_CODE and AS_OF_DATE as its unique index and if the Processing key designated in Column Properties is ID_NUMBER, IDENTITY_CODE.

  • UPDATABLE_INST_REQ_FIELDS

    This procedure checks that all of the Instrument Required Fields are also listed as updatable in USER_UPDATABLE_COLUMNS for the specified table or view.

  • VALIDATE_INST_LEAVES

    This procedure will validate a table has all the required leaf columns

  • VALIDATE_TRANS_KEY

    This procedure validates if a table has ID_NUMBER and IDENTITY_CODE and one or more 'B' Leaf Columns in its unique index and that these columns match the Processing key designated in Column Properties.

  • VALIDATE_CORR_KEY

    This procedure will validate a table has a unique index with updatable columns.

    All the above procedures return a success or failure status. The REV_TAB_CLASS_ASSIGNMENT table is updated as 'Y' if a table is successfully validated and 'N' in case of failure.