ColumnName |
Domain |
Datatype |
NULL |
Definition |
SCREEN_CD |
|
VARCHAR2(10) |
NO |
Name: Screen. Description: The identifier for the screen. |
PARAMETER_CD |
|
VARCHAR2(10) |
NO |
Name: Parameter Code. Description: The identifier for the parameters. |
RECURRENCE_CD |
|
VARCHAR2(10) |
NO |
Name: Recurrence Code. Description: The identifier for the recurrence code. |
PROCESS_START_HRS |
|
NUMBER(5, 0) |
NO |
Name: Start Hour. Description: The hour in which the process should be started. |
PROCESS_START_MINS |
|
NUMBER(5, 0) |
NO |
Name: Start Minute. Description: The minute in which the process should be started. |
S_PROCESS_START_CD |
|
VARCHAR2(2) |
NO |
Name: Start AM/PM Indicator. Description: The time of day for the process. This is used with PROCESS_START_HRS and PROCESS_START_MINS to determine when the process will begin. The valid values are: AM – the time from midnight to noon.. PM – the time from noon to midnight. |
EXECUTE_EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Execute Employee ID. Description: The unique identifier of the employee whose rights will be used when running the scheduled process. |
SERVER_ID |
|
VARCHAR2(254) |
NO |
Name: Server ID. Description: Name of the server where the process should be run. |
NEXT_RUN_DTT |
|
DATE |
YES |
Name: Next Run Date/Time. Description: The next date and time the process should run. |
EMAIL_EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Email Employee ID. Description: The unique identifier of the employee who will receive the report results from the scheduled process. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record as been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |