P 2 K_AM_PROCEDURE_STEPS

Alias: MPC#

Unique Keys: Function MFN_ID_CHILD_OF + STEP_SEQUENCE

Parent Table: P2K_AM_FUNCTIONS

ERD: ERD-AM15

Procedure Steps

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MFN_ID_CHILD_OFNumber(10)IDYsteps for the function P2K_AM_FUNCTIONS
STEP_SEQUENCENumber(5)NUMBER5Y
MFN_ID_EXECUTINGNumber(10)ID to execute function P2K_AM_FUNCTIONS
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CREATE_ALLOWEDVarchar2(1)TOGGLE
RETRIEVE_ALLOWEDVarchar2(1)TOGGLE
UPDATE_ALLOWEDVarchar2(1)TOGGLE
DELETE_ALLOWEDVarchar2(1)TOGGLE
MANDATORYVarchar2(1)TOGGLE
PROCEDURE_COMMANDVarchar2(2000)VARCHAR2000
DISPLAY_FINDVarchar2(1)TOGGLE

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page