Alias: MEX#

(P2K_AM_EXECUTIONS)

Unique Keys: None

ERD: ERD-AM25

An occurrence of a non-interactive function.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
MFN_ID	Number(10)	ID	Y	link to P2K_AM_FUNCTIONS
MUS_ID	Number(10)	ID	Y	link to P2K_AM_USERS
DESTINATION	Varchar2(30)	VARCHAR30
SUBMIT_FRAME	Varchar2(30)	VARCHAR30
TIME_WINDOW	Varchar2(30)	VARCHAR30
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
EXECUTION_STATUS	Varchar2(2)	X_EXECUTION_STATUS	Y
EXECUTION_START_DATE	Date()	TIMESTAMP
EXECUTION_END_DATE	Date()	TIMESTAMP
PRIORITY	Number(5)	NUMBER5
PRINT_IMMEDIATELY	Varchar2(1)	TOGGLE
RETURN_CODE	Varchar2(2)	X_RETURN_CODE
CPU_ELAPSED_TIME	Number(10)	NUMBER10
DESFORMAT	Varchar2(10)	X_DESFORMAT
DESNAME	Varchar2(4000)	VARCHAR4000
DESTYPE	Varchar2(7)	X_DESTYPE
REPORT_MODE	Varchar2(10)	X_REPORT_MODE
PRINT_ORIENTATION	Varchar2(9)	X_PRINT_ORIENTATION
PROGRESS_MESSAGE	Varchar2(200)	VARCHAR200
SCHEDULE_FREQUENCY	Varchar2(10)	X_REPORT_FREQUENCY
SCHEDULE_SUFFIX	Varchar2(10)	X_REPORT_SUFFIX
SCHEDULE_SUFFIX_AMOUNT	Number(10)	NUMBER10
SCHEDULE_DAYREPEAT	Varchar2(2)	X_DAYREPEAT
SCHEDULE_WEEKDAYS	Varchar2(2)	X_WEEKDAYS
SCHEDULE_DATE_OPTIONS	Varchar2(2)	X_DATE_OPTIONS
SCHEDULE_START_DAY	Varchar2(16)	VARCHAR16
SCHEDULE_START_TIME	Number(5)	MINUTES
EXPIRES_DATE_OPTIONS	Varchar2(2)	X_DATE_OPTIONS
EXPIRES_VALUE	Varchar2(16)	VARCHAR16
PAGESTREAM	Varchar2(1)	TOGGLE
JOB_NAME	Varchar2(30)	VARCHAR30
SCHEDULE_START_DATE	Date()	DATE
SCHEDULE_EXPIRY_DATE	Date()	DATE
SCHEDULE_START_DATE	Date()	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