SCHEDULED_PROCESS_HISTORY 
Default Table Name  SCHEDULED_PROCESS_HISTORY 
Definition 
 Name: Scheduled Processes History.     Description: This table contains the history of scheduled processes being run.
 

SCHEDULED_PROCESS_HISTORY Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SCREEN_CD(PK)(FK)    VARCHAR2(10)  NO 
Name: Screen. Description: The identifier for the screen.
 
PARAMETER_CD(PK)(FK)    VARCHAR2(10)  NO 
Name: Parameter Code. Description: The identifier for the parameters.
 
RECURRENCE_CD(PK)(FK)    VARCHAR2(10)  NO 
Name: Recurrence Code. Description: The identifier for the recurrence code.
 
PROCESS_START_HRS(PK)(FK)    NUMBER(5, 0)  NO 
Name: Start Hour. Description: The hour in which the process should be started. 
 
PROCESS_START_MINS(PK)(FK)    NUMBER(5, 0)  NO 
Name: Start Minute. Description: The minute in which the process should be started. 
 
S_PROCESS_START_CD(PK)(FK)    VARCHAR2(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(PK)(FK)    VARCHAR2(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(PK)    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    VARCHAR2(4000)  YES 
Name: Result. Description: Text as to whether the scheduled process ran successfully or not.
 
S_PROCESS_STATUS_CD    VARCHAR2(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    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.
 

SCHEDULED_PROCESS_HISTORY Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0237  PrimaryKey  SCREEN_CD, PARAMETER_CD, RECURRENCE_CD, PROCESS_START_HRS, PROCESS_START_MINS, S_PROCESS_START_CD, EXECUTE_EMPL_ID, LAST_RUN_DTT 

SCHEDULED_PROCESS_HISTORY Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
SCHEDULED_PROCESS  Identifying  One To Zero or More  F00335      SCREEN_CD, PARAMETER_CD, RECURRENCE_CD, PROCESS_START_HRS, PROCESS_START_MINS, S_PROCESS_START_CD, EXECUTE_EMPL_ID  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable