Alias: MLN#

(P2K_AM_LEXICON_NAMES)

Unique Keys: LEXICON_NAME

ERD: ERD-AM30

Lexicon names and characteristics

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LEXICON_NAMEVarchar2(30)VARCHAR30Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
LEXICON_TYPEVarchar2(2)X_LEXICON_TYPEY
VALUE_LENGTHNumber(5)NUMBER5
COUNTRY_SENSITIVEVarchar2(1)TOGGLE

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page