Alias: MPF#

(P2K_AM_PREFERENCES)

Unique Keys: PREFERENCE_CODE

ERD: ERD-AM20

Preferences

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
PREFERENCE_CODE	Varchar2(16)	CODE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PREFERENCE_NAME	Varchar2(30)	VARCHAR30	Y
DATA_TYPE	Varchar2(2)	X_DATA_TYPE(QMS)	Y
VALUE_LENGTH	Number(5)	NUMBER5
VALUE_FORMAT	Varchar2(30)	VARCHAR30
LOV_QUERY	Varchar2(2000)	VARCHAR2000
VALIDATION_CLAUSE	Varchar2(2000)	VARCHAR2000
ERROR_CODE	Varchar2(16)	CODE
APPLIES_TO_SITE	Varchar2(1)	TOGGLE
SEQUENCE_SITE	Number(5)	NUMBER5
MANDATORY_SITE	Varchar2(1)	TOGGLE
APPLIES_TO_USER	Varchar2(1)	TOGGLE
SEQUENCE_USER	Number(5)	NUMBER5
MANDATORY_USER	Varchar2(1)	TOGGLE
APPLIES_TO_FUNCTION	Varchar2(1)	TOGGLE
SEQUENCE_FUNCTION	Number(5)	NUMBER5
GLOBAL_USED	Varchar2(30)	VARCHAR30
FUNCTIONS_LIST	Varchar2(2000)	VARCHAR2000
PREFERENCE_CATEGORY	Varchar2(2)	X_PREFERENCE_CATEGORY
PREFERENCE_USAGE	Varchar2(2)	X_FUNCTION_USAGE	Y
MANDATORY_FUNCTION	Varchar2(1)	TOGGLE
APPLIES_TO_IDENTITY	Varchar2(1)	TOGGLE
MANDATORY_IDENTITY	Varchar2(1)	TOGGLE
SEQUENCE_IDENTITY	Number(5)	NUMBER5
APPLIES_TO_ROLE	Varchar2(1)	TOGGLE
MANDATORY_ROLE	Varchar2(1)	TOGGLE
SEQUENCE_ROLE	Number(5)	NUMBER5
APPLIES_TO_CANDIDATE	Varchar2(1)	TOGGLE
MANDATORY_CANDIDATE	Varchar2(1)	TOGGLE
SEQUENCE_CANDIDATE	Number(5)	NUMBER5
INFORMATION	Varchar2(4000)	VARCHAR4000

User Fields: Not Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page