!!!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|VARCHARnn]| |
|[SUBMIT_FRAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[TIME_WINDOW]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[EXECUTION_STATUS]|Varchar2(2)|[X_EXECUTION_STATUS]|Y|
|[EXECUTION_START_DATE]|Date()|[TIMESTAMP]| |
|[EXECUTION_END_DATE]|Date()|[TIMESTAMP]| |
|[PRIORITY]|Number(5)|[NUMBER5|NUMBERn]| |
|[PRINT_IMMEDIATELY]|Varchar2(1)|[TOGGLE]| |
|[RETURN_CODE]|Varchar2(2)|[X_RETURN_CODE]| |
|[CPU_ELAPSED_TIME]|Number(10)|[NUMBER10|NUMBERn]| |
|[DESFORMAT]|Varchar2(10)|[X_DESFORMAT]| |
|[DESNAME]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[DESTYPE]|Varchar2(7)|[X_DESTYPE]| |
|[REPORT_MODE]|Varchar2(10)|[X_REPORT_MODE]| |
|[PRINT_ORIENTATION]|Varchar2(9)|[X_PRINT_ORIENTATION]| |
|[PROGRESS_MESSAGE]|Varchar2(200)|[VARCHAR200|VARCHARnn]| |
|[SCHEDULE_FREQUENCY]|Varchar2(10)|[X_REPORT_FREQUENCY]| |
|[SCHEDULE_SUFFIX]|Varchar2(10)|[X_REPORT_SUFFIX]| |
|[SCHEDULE_SUFFIX_AMOUNT]|Number(10)|[NUMBER10|NUMBERn]| |
|[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|VARCHARnn]| |
|[SCHEDULE_START_TIME]|Number(5)|[MINUTES]| |
|[EXPIRES_DATE_OPTIONS]|Varchar2(2)|[X_DATE_OPTIONS]| |
|[EXPIRES_VALUE]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[PAGESTREAM]|Varchar2(1)|[TOGGLE]| |
|[JOB_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[SCHEDULE_START_DATE]|Date()|[DATE]| |
|[SCHEDULE_EXPIRY_DATE]|Date()|[DATE]| |
|[SCHEDULED_START_DATE]|Date()|[TIMESTAMP]| |


!![Derived Fields|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\\


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.P2K_AM_EXECUTIONS] 	
[{InsertPage page='Internal.P2K_AM_EXECUTIONS' default='Click to create a new discussion page'}] 	

}]