P 2 K_AM_EXECUTIONS

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
SCHEDULE_START_DATEDate()TIMESTAMP

Derived Fields#

Column Name
DRV_ELAPSED_TIME
DRV_EMAIL_EID_ID
DRV_EMAIL_TEXT
DRV_EMAIL_TITLE
DRV_EXECUTION_NUMBER
DRV_HAS_OUTPUT
DRV_MPS_ID
DRV_PARAMETER_SET
DRV_PRIVATE_PARAM_SET
DRV_RUN_LANGUAGE
DRV_SUBJECT_CONTEXT

User Fields: Not Allowed
Audit Logging: Not Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation