SCHEDULED_PROCESS 
Default Table Name  SCHEDULED_PROCESS 
Definition 
 Name: Scheduled Processes.     Description: This table contains the screens, parameters and recurrence codes for the scheduled process.
 

SCHEDULED_PROCESS Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SCREEN_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Screen. Description: The identifier for the screen.
 
PARAMETER_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Parameter Code. Description: The identifier for the parameters.
 
RECURRENCE_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Recurrence Code. Description: The identifier for the recurrence code.
 
PROCESS_START_HRS(PK)    NUMERIC(5, 0)  NO 
Name: Start Hour. Description: The hour in which the process should be started. 
 
PROCESS_START_MINS(PK)    NUMERIC(5, 0)  NO 
Name: Start Minute. Description: The minute in which the process should be started. 
 
S_PROCESS_START_CD(PK)    VARCHAR(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(PK)(FK)    VARCHAR(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    VARCHAR(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(FK)    VARCHAR(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    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.
 

SCHEDULED_PROCESS Keys 
Key Name  Key Type  Keys 
RI_F00331  Inversion Entry  SCREEN_CD, PARAMETER_CD 
RI_F00334  Inversion Entry  EXECUTE_EMPL_ID 
RI_F00333  Inversion Entry  EMAIL_EMPL_ID 
RI_F00330  Inversion Entry  RECURRENCE_CD 
PI_0236  PrimaryKey  SCREEN_CD, PARAMETER_CD, RECURRENCE_CD, PROCESS_START_HRS, PROCESS_START_MINS, S_PROCESS_START_CD, EXECUTE_EMPL_ID 

SCHEDULED_PROCESS Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
RECURRENCE  Identifying  One To Zero or More        RECURRENCE_CD  NO 
SCREEN_PARAMETER  Identifying  One To Zero or More        SCREEN_CD, PARAMETER_CD  NO 
EMPL  Non-Identifying  One To Zero or More        EMAIL_EMPL_ID  NO 
EMPL  Identifying  One To Zero or More        EXECUTE_EMPL_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
SCHEDULED_PROCESS_HISTORY  Identifying  One To Zero or More          NO