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
IMEX
IMEX

Version management

Difference between version and

At line 10 changed 2 lines
;[Schedule Start Date|SCHEDULE_START_DAY]:The date the report/execution are scheduled for are displayed in this field.
;[Start Date|EXECUTION_START_DATE]:This field displays the actual start date of the execution.
;[Schedule Start Date|SCHEDULED_START_DATE]:The date the report/execution are scheduled for are displayed in this field.
;[Start Date|]:This field displays the actual start date of the execution.
At line 13 removed one line
;[Identity|PERSON_CODE]:The identity information of the person running the process is displayed in this field
At line 16 changed one line
;[Schedule Start Date|SCHEDULE_START_DAY]:The date the report/execution are scheduled for are displayed in this field.
;[Schedule Start Date|SCHEDULE_START_DATE]:The date the report/execution are scheduled for are displayed in this field.
At line 22 changed 7 lines
;[Frequency|SCHEDULE_FREQUENCY]:This field specifies how often the process will run
;[Frequency Amount|SCHEDULE_SUFFIX_AMOUNT]:This field specifies the interval of time between runs if the Frequency is “Every”, expressed in the time basis of the Frequency Option. (e.g. a value of 2 with a basis of ‘Days’ means ‘Every 2 Days’)
;[Frequency Option|SCHEDULE_SUFFIX]:This field specifies the time basis of the Frequency Amount. (e.g. minutes, days, hours, weeks, months) based on the fixed lexicon.
;[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).
;[Weekdays|SCHEDULE_WEEKDAYS]:This field identifies which day of the week the process should run on. (e.g. Mon, Tues, Wed, ...)
;[Schedule Expiry Date|SCHEDULE_EXPIRY_DATE]:This field allows you indicate when the repeat run process will end.
;[Save and Schedule|]:This button allows you to save and schedule the execution/report.
;[Frequency|SCHEDULE_FREQUENCY]:
;[Frequency Amount|SCHEDULE_SUFFIX_AMOUNT]:
;[Frequency Option|SCHEDULE_SUFFIX]:
;[Day Repeat|SCHEDULE_DAYREPEAT]:
;[Weekdays|SCHEDULE_WEEKDAYS]:
;[Schedule Expiry Date|SCHEDULE_EXPIRY_DATE]:
;[Save and Schedule|]:
At line 30 changed 2 lines
;[Parameter Name|PARAMETER_NAME]:This field displays the parameters of the report.
;[Value|PARAMETER_VALUE]:The value of the parameter is displayed in this field.
;[Parameter Name|PARAMETER_NAME]:
;[Value|PARAMETER_VALUE]:
At line 32 added 3 lines
[CLEANUP]
[{If var='loginstatus' contains 'authenticated'
At line 34 changed 2 lines
![Notes|Edit:Internal.IMEX]
[{InsertPage page='Internal.IMEX' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IMEX]
[{InsertPage page='Internal.IMEX' default='Click to create a new discussion page'}]
}]
||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]| |
This page (revision-21) was last changed on 11-Mar-2022 15:52 by Lilia UrtanTop