Alias: MPF#

(P2K_AM_PREFERENCES)

Unique Keys: PREFERENCE_CODE

ERD: ERD-AM20

Preferences

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PREFERENCE_CODEVarchar2(16)CODEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PREFERENCE_NAMEVarchar2(30)VARCHAR30Y
DATA_TYPEVarchar2(2)X_DATA_TYPE(QMS)Y
VALUE_LENGTHNumber(5)NUMBER5
VALUE_FORMATVarchar2(30)VARCHAR30
LOV_QUERYVarchar2(2000)VARCHAR2000
VALIDATION_CLAUSEVarchar2(2000)VARCHAR2000
ERROR_CODEVarchar2(16)CODE
APPLIES_TO_SITEVarchar2(1)TOGGLE
SEQUENCE_SITENumber(5)NUMBER5
MANDATORY_SITEVarchar2(1)TOGGLE
APPLIES_TO_USERVarchar2(1)TOGGLE
SEQUENCE_USERNumber(5)NUMBER5
MANDATORY_USERVarchar2(1)TOGGLE
APPLIES_TO_FUNCTIONVarchar2(1)TOGGLE
SEQUENCE_FUNCTIONNumber(5)NUMBER5
GLOBAL_USEDVarchar2(30)VARCHAR30
FUNCTIONS_LISTVarchar2(2000)VARCHAR2000
PREFERENCE_CATEGORYVarchar2(2)X_PREFERENCE_CATEGORY
PREFERENCE_USAGEVarchar2(2)X_FUNCTION_USAGEY
MANDATORY_FUNCTIONVarchar2(1)TOGGLE
APPLIES_TO_IDENTITYVarchar2(1)TOGGLE
MANDATORY_IDENTITYVarchar2(1)TOGGLE
SEQUENCE_IDENTITYNumber(5)NUMBER5
APPLIES_TO_ROLEVarchar2(1)TOGGLE
MANDATORY_ROLEVarchar2(1)TOGGLE
SEQUENCE_ROLENumber(5)NUMBER5
APPLIES_TO_CANDIDATEVarchar2(1)TOGGLE
MANDATORY_CANDIDATEVarchar2(1)TOGGLE
SEQUENCE_CANDIDATENumber(5)NUMBER5
INFORMATIONVarchar2(4000)VARCHAR4000

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page