P 2 K_AM_USER_FIELD_VALUES

Alias: MUV#

(P2K_AM_USER_FIELD_VALUES)

Unique Keys: User Field (MUF_ID) + REFERENCE_ID + VALUE

ERD: ERD-AM35

Stores the content of user fields.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MUF_IDNumber(10)IDYlink to P2K_AM_USER_FIELDS
REFERENCE_IDNumber(10)NUMBER10Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
VALUEVarchar2(4000)VARCHAR4000

Derived Fields#

Column Name
DRV_MUV_EFFECTIVE
DRV_MUV_EXPIRY

User Fields: Not Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page