P 2 K_AM_COLUMN_DETAILS

Alias: MCD#

(P2K_AM_COLUMN_DETAILS)

Unique Keys: Table Name (MTD_ID) + COLUMN_NAME

ERD: ERD-AM30

Table Details

Column Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MTD_IDNumber(10)IDYlink to P2K_AM_TABLE_DETAILS
COLUMN_NAMEVarchar2(200)VARCHAR200Y
MLN_IDNumber(10)ID link to P2K_AM_LEXICON_NAMES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(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
FIELD_PROMPTVarchar2(30)VARCHAR30
ERROR_CODEVarchar2(16)CODE
DESCRIPTIONVarchar2(50)DESCRIPTION
MANDATORYVarchar2(1)TOGGLE
NO_VIEW_ALLOWEDVarchar2(1)TOGGLE
NO_UPDATE_ALLOWEDVarchar2(1)TOGGLE
LOGGING_NOT_ALLOWEDVarchar2(1)TOGGLE
DISABLE_LOGGINGVarchar2(1)TOGGLE
USER_LABEL_ALLOWEDVarchar2(1)TOGGLE
CODE_SEQUENCE_ALLOWEDVarchar2(1)TOGGLE
TRANSLATION_ALLOWEDVarchar2(1)TOGGLE
MUST_DATE_SPLITVarchar2(1)TOGGLE
DOMAIN_NAMEVarchar2(30)VARCHAR30
DEFAULT_TRIGGER_FIELDVarchar2(1)TOGGLE
DEFAULT_FROMVarchar2(2000)VARCHAR2000
COLUMN_SEQUENCENumber(5)NUMBER5
NOT_DISPLAYEDVarchar2(1)TOGGLE
AUTOSKIPVarchar2(1)TOGGLE
REFERENCE_IDNumber(10)NUMBER10
COLUMN_USAGEVarchar2(2)X_COLUMN_USAGE
COLUMN_ENCRYPTEDVARCHAR2(1)TOGGLE

User Fields: Not Allowed
Audit Logging: Not Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation