Alias: MCD#

(P2K_AM_COLUMN_DETAILS)

Unique Keys: Table Name (MTD_ID) + COLUMN_NAME

ERD: ERD-AM30

Table Details

Column Details

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
MTD_ID	Number(10)	ID	Y	link to P2K_AM_TABLE_DETAILS
COLUMN_NAME	Varchar2(200)	VARCHAR200	Y
MLN_ID	Number(10)	ID		link to P2K_AM_LEXICON_NAMES
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	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
FIELD_PROMPT	Varchar2(30)	VARCHAR30
ERROR_CODE	Varchar2(16)	CODE
DESCRIPTION	Varchar2(50)	DESCRIPTION
MANDATORY	Varchar2(1)	TOGGLE
NO_VIEW_ALLOWED	Varchar2(1)	TOGGLE
NO_UPDATE_ALLOWED	Varchar2(1)	TOGGLE
LOGGING_NOT_ALLOWED	Varchar2(1)	TOGGLE
DISABLE_LOGGING	Varchar2(1)	TOGGLE
USER_LABEL_ALLOWED	Varchar2(1)	TOGGLE
CODE_SEQUENCE_ALLOWED	Varchar2(1)	TOGGLE
TRANSLATION_ALLOWED	Varchar2(1)	TOGGLE
MUST_DATE_SPLIT	Varchar2(1)	TOGGLE
DOMAIN_NAME	Varchar2(30)	VARCHAR30
DEFAULT_TRIGGER_FIELD	Varchar2(1)	TOGGLE
DEFAULT_FROM	Varchar2(2000)	VARCHAR2000
COLUMN_SEQUENCE	Number(5)	NUMBER5
NOT_DISPLAYED	Varchar2(1)	TOGGLE
AUTOSKIP	Varchar2(1)	TOGGLE
REFERENCE_ID	Number(10)	NUMBER10
COLUMN_USAGE	Varchar2(2)	X_COLUMN_USAGE
COLUMN_ENCRYPTED	VARCHAR2(1)	TOGGLE

User Fields: Not Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page