Alias: MLVC#

(P2K_AM_LIST_OF_VALUES_COLUMNS)

Unique Keys: List of Values (MLOV_ID) + COLUMN_NAME

ERD: ERD-AM85

description

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MLOV_IDNumber(10)IDYlink to P2K_AM_LIST_OF_VALUES
COLUMN_NAMEVarchar2(200)VARCHAR200Y
COLUMN_TITLEVarchar2(100)VARCHAR100
COLUMN_NUMBERNumber(5)NUMBER5
COLUMN_WIDTHNumber(5)X_ITEM_SIZE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
SORT_DIRECTIONVarchar2(2)X_SORT_DIRECTION
COLUMN_USAGEVarchar2(2)X_LEXICON_USAGEY

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page