P 2 K_AM_WORK_FLOW_ACTIONS

Alias: MWA#

(P2K_AM_WORK_FLOW_ACTIONS)

Unique Keys: EVENT_CODE

ERD: ERD-AM70

Work Flow Actions

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MPD_IDNumber(10)ID link to P2K_AM_PRODUCTS
MPS_IDNumber(10)ID link to P2K_AM_PARAMETER_SETS
EVENT_CODEVarchar2(16)CODEY
EVENT_STATUSVarchar2(2)X_EVENT_STATUSY
EVENT_CATEGORYVarchar2(2)X_EVENT_CATEGORYY
EVENT_ACTION_TYPEVarchar2(2)X_EVENT_ACTION_TYPEY
EVENT_RECIPIENT_TYPEVarchar2(2)X_EVENT_RECIPIENT_TYPEY
EVENT_MEDIAVarchar2(2)X_EVENT_MEDIAY
MEDIA_NAMEVarchar2(100)VARCHAR100
DESCRIPTIONVarchar2(50)DESCRIPTION
EVENT_PRIORITYVarchar2(2)X_EVENT_PRIORITY
RESPONSE_REQUIREDVarchar2(1)TOGGLE
EVENT_BATCHEDVarchar2(1)TOGGLE
RESPONSE_DAYSNumber(5)NUMBER5
EVENT_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page