This page (revision-21) was last changed on 11-Mar-2022 15:52 by Lilia Urtan

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
21 11-Mar-2022 15:52 2 KB Lilia Urtan to previous

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 24 changed one line
;[Day Repeat|SCHEDULE_DAYREPEAT]:
;[Day Repeat|SCHEDULE_DAYREPEAT]:This field specifies which weekday of the month the process should be run on. (e.g. First, Second, Third, Fourth, Fifth).
At line 41 removed 41 lines
||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]| |
|[SCHEDULE_START_DATE]|Date()|[TIMESTAMP]| |