Alias: MUF#

(P2K_AM_USER_FIELDS)

Unique Keys: Table Name (MTD_ID) + USER_FIELD_NAME

ERD: ERD-AM35

User Fields

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MTD_IDNumber(10)IDYlink to P2K_AM_TABLE_DETAILS
USER_FIELD_NAMEVarchar2(30)VARCHAR30Y
MLN_IDNumber(10)ID link to P2K_AM_LEXICON_NAMES
FIELD_TYPEVarchar2(2)X_FIELD_TYPEY
FIELD_PROMPTVarchar2(30)VARCHAR30Y
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CREATE_DATEDate()DATEY
FIELD_SEQUENCENumber(5)NUMBER5Y
FORMAT_MASKVarchar2(50)EDIT MASK
REFERENCE_IDNumber(10)NUMBER10
REQUIREDVarchar2(1)TOGGLE
USER_FIELD_USAGEVarchar2(2)X_LEXICON_USAGE
PURPOSEVarchar2(2000)VARCHAR2000
LOGGING_NOT_ALLOWEDVarchar2(1)TOGGLE
DISABLE_LOGGINGVarchar2(1)TOGGLE
DOMAIN_NAMEVarchar2(30)VARCHAR30

Derived Fields#

Column Name
DRV_MCL_REFERENCE_ID

User Fields: Not Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page