!!!Alias: MEX Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ 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]| | User Fields: Not Allowed\\ Audit Logging: Not Allowed\\