Alias: MOB#

(P2K_AM_OBJECTS)

Unique Keys: OBJECT_CODE + OBJECT_TYPE + ATTRIBUTE_CODE

ERD: ERD-AM70

Objects

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
OBJECT_CODEVarchar2(100)VARCHAR100Y
OBJECT_TYPEVarchar2(2)X_OBJECT_TYPEY
ATTRIBUTE_CODEVarchar2(100)VARCHAR100Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
OBJECT_USAGEVarchar2(2)X_LEXICON_USAGEY

Derived Fields#

Column Name
DRV_OBJECT_KEY
DRV_TABLE_NAME

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page