Alias: MEX#

(P2K_AM_EXECUTIONS)

Unique Keys: None

ERD: ERD-AM25

An occurrence of a non-interactive function.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MFN_IDNumber(10)IDYlink to P2K_AM_FUNCTIONS
MUS_IDNumber(10)IDYlink to P2K_AM_USERS
DESTINATIONVarchar2(30)VARCHAR30
SUBMIT_FRAMEVarchar2(30)VARCHAR30
TIME_WINDOWVarchar2(30)VARCHAR30
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EXECUTION_STATUSVarchar2(2)X_EXECUTION_STATUSY
EXECUTION_START_DATEDate()TIMESTAMP
EXECUTION_END_DATEDate()TIMESTAMP
PRIORITYNumber(5)NUMBER5
PRINT_IMMEDIATELYVarchar2(1)TOGGLE
RETURN_CODEVarchar2(2)X_RETURN_CODE
CPU_ELAPSED_TIMENumber(10)NUMBER10
DESFORMATVarchar2(10)X_DESFORMAT
DESNAMEVarchar2(4000)VARCHAR4000
DESTYPEVarchar2(7)X_DESTYPE
REPORT_MODEVarchar2(10)X_REPORT_MODE
PRINT_ORIENTATIONVarchar2(9)X_PRINT_ORIENTATION
PROGRESS_MESSAGEVarchar2(200)VARCHAR200
SCHEDULE_FREQUENCYVarchar2(10)X_REPORT_FREQUENCY
SCHEDULE_SUFFIXVarchar2(10)X_REPORT_SUFFIX
SCHEDULE_SUFFIX_AMOUNTNumber(10)NUMBER10
SCHEDULE_DAYREPEATVarchar2(2)X_DAYREPEAT
SCHEDULE_WEEKDAYSVarchar2(2)X_WEEKDAYS
SCHEDULE_DATE_OPTIONSVarchar2(2)X_DATE_OPTIONS
SCHEDULE_START_DAYVarchar2(16)VARCHAR16
SCHEDULE_START_TIMENumber(5)MINUTES
EXPIRES_DATE_OPTIONSVarchar2(2)X_DATE_OPTIONS
EXPIRES_VALUEVarchar2(16)VARCHAR16
PAGESTREAMVarchar2(1)TOGGLE
JOB_NAMEVarchar2(30)VARCHAR30
SCHEDULE_START_DATEDate()DATE
SCHEDULE_EXPIRY_DATEDate()DATE
SCHEDULED_START_DATEDate()TIMESTAMP

User Fields: Not Allowed
Audit Logging: Not Allowed

This particular version was published on 26-Nov-2021 10:22 by RForbes.Top