Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata
  • 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)


  • No labels