3.7.2 Requirement For Table Classification

Specific column requirements for each table property can be obtained by querying REV_COLUMN_REQUIREMENTS table.

OFSAAI requires specific table structures, column names and column characteristics for OFSAA operations. These structures and requirements are embodied by the User-Assignable Table Classifications.

Each Table Classification comprises individual Table Properties that define the requirements for that classification. Table Properties are two distinct types: those encompassing specific column requirements and those encompassing logic requirements via stored procedures.

The following table provides the validation checks that are being done for each of the table classification: