P 2 K_AM_CHANGE_LOG_DETAILS

Alias: MCLD#

(P2K_AM_CHANGE_LOG_DETAILS)

Unique Keys: None

ERD: ERD-AM30

Details of changes made.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MCL_IDNumber(10)IDYlink to P2K_AM_CHANGE_LOGS
MCD_IDNumber(10)IDYlink to P2K_AM_COLUMN_DETAILS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
BEFORE_VALUEVarchar2(4000)VARCHAR4000
AFTER_VALUEVarchar2(4000)VARCHAR4000
MUF_IDNumber(10)ID link to P2K_AM_USER_FIELDS

Derived Fields#

Column Name
DRV_AFTER_VALUE_FORMATTED
DRV_BEFORE_VALUE_FORMATTED
DRV_MCL_REFERENCE_ID

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page