- Any of the "CD" columns have descriptions available in the _PM_CODE_LOOKUP table.
- This table is available for client applications to obtain the list of codes that may be entered by the user for the column of a specific table.
- The NAME_CHAR has the descriptive name of the code.
- The LOOKUP_KEYS_CHAR is a string with a bar-type-delimiter that allows strings to be used to lookup subsets of codes.
- An @ in the TABLE_CD or the COLUMN_CD columns for a specific code is similar to a wild card character and implies that the code can be used in any column with a similar name in any table or any column in the table.
PM_CODE_LOOKUP |
|
|
PK |
TABLE_CD |
varchar(50) |
PK |
COLUMN_CD |
varchar(50) |
PK |
CODE_CD |
varchar(50) |
|
NAME_CHAR |
varchar(2000) |
|
LOOKUP_KEYS_CHAR |
varchar(2000) |