Meta data - Table and Field

Properties

Description

Tables

CI_​MD_​TBL, CI_​MD_​TBL_​FLD, CI_​MD_​TBL_​L, CI_​MD_​TBL_​FLD_​L, CI_​MD_​FLD, CI_​MD_​FLD_​L

Standard Data Fields

  • Table Name(TBL_​NAME)
  • Table names must match with the physical table name or view name in the database.

    Field Name(FLD_​NAME)

  • Field name must match with the physical column name in the database unless the field is a work field. Field name does not have to follow the prefixing standard unless the field is a work field or customer modification field.

Customer Modification

Audit Switches (AUDIT_​INSERT_​SW, AUDIT_​UPDATE_​SW, AUDIT_​DELETE_​SW), Audit Program Name (AUDIT_​PGM_​NAME), Audit Table Name (AUDIT_​TBL_​NAME), Override label (OVRD_​LABEL)