/
PM_CODE_LOOKUP Table

PM_CODE_LOOKUP Table

Sep 04, 2018

  • 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)