Alias: MCN#

(P2K_AM_CONDITIONS)

Unique Keys: None

ERD: ERD-AM80

description

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MWC_IDNumber(10)IDYlink to P2K_AM_WHERE_CLAUSES
CONDITION_TYPEVarchar2(2)X_CONDITION_TYPEY
COLUMN_NAMEVarchar2(200)VARCHAR200Y
PREDEFINED_CONDITION_CODEVarchar2(16)CODE
COMPARISON_OPERATORVarchar2(2)X_COMPARISON_OPERATOR
VALUEVarchar2(4000)VARCHAR4000
DESCRIPTIONVarchar2(50)DESCRIPTION
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
SEQUENCENumber(5)NUMBER
OR_GROUPINGVarchar2(16)CODE
CONDITION_USAGEVarchar2(2)X_WHERE_CLAUSE_USAGE

Derived Fields#

Column Name
DRV_FILTER_BY_EFFECTIVE_DATE

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page