Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
SCREEN_CD |
|
VARCHAR(10) |
NO |
Name: Screen. Description: The identifier for the screen. |
PARAMETER_CD |
|
VARCHAR(10) |
NO |
Name: Parameter Code. Description: The identifier for the parameters. |
RECURRENCE_CD |
|
VARCHAR(10) |
NO |
Name: Recurrence Code. Description: The identifier for the recurrence code. |
PROCESS_START_HRS |
|
NUMERIC(5, 0) |
NO |
Name: Start Hour. Description: The hour in which the process should be started. |
PROCESS_START_MINS |
|
NUMERIC(5, 0) |
NO |
Name: Start Minute. Description: The minute in which the process should be started. |
S_PROCESS_START_CD |
|
VARCHAR(2) |
NO |
Name: Process Status. 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 |
|
VARCHAR(20) |
NO |
Name: Execute Employee ID. Description: The unique identifier of the employee whose rights will be used when running the scheduled process. |
LAST_RUN_DTT |
|
DATE |
NO |
Name: Last Run Date/Time. Description: The last date and time the process should run. |
START_DTT |
|
DATE |
YES |
Name: Start Date/Time. Description: The date and time the process started. |
FINISH_DTT |
|
DATE |
YES |
Name: Finish Date/Time. Description: The date and time the process finished. |
RUN_RESULT |
|
VARCHAR(4000) |
YES |
Name: Result. Description: Text as to whether the scheduled process ran successfully or not. |
S_PROCESS_STATUS_CD |
|
VARCHAR(1) |
NO |
Name: Process Status. Description: The status of the process. The valid options are: S – Scheduled. R – Running. C – Complete. F – Failed |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(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. |