EVENT 
Default Table Name  EVENT 
Definition 
 Name: Events .     Description: This table contains the valid system defined events.
 

EVENT Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EVENT_CD(PK)    VARCHAR2(5)  NO 
Name: Event. Description: The event unique identifier.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether this event is active.
 
S_INIT_PRIORITY_CD    VARCHAR2(1)  NO 
Name: Initial Priority. Description: The initial priority for the event. The valid values areL - Low. M - Medium. H - High. 
 
MED_PRIORITY_DAYS    NUMBER(5, 0)  NO 
Name: Number of Days to Medium Priority. Description: The number of days that need to expire before event is upgraded to medium priority.
 
MED_PRIORITY_HRS    NUMBER(5, 0)  NO 
Name: Number of Hours to Medium Priority. Description: The number of hours that need to expire before event is upgraded to medium priority.
 
MED_PRIORITY_MINS    NUMBER(5, 0)  NO 
Name: Number of Minutes to Medium Priority. Description: The number of minutes that need to expire before event is upgraded to medium priority.
 
HIGH_PRIORITY_DAYS    NUMBER(5, 0)  NO 
Name: Number of Days to High Priority. Description: The number of days that need to expire before event is upgraded to high priority.
 
HIGH_PRIORITY_HRS    NUMBER(5, 0)  NO 
Name: Number of Hours to High Priority. Description: The number of hours that need to expire before event is upgraded to high priority.
 
HIGH_PRIORITY_MINS    NUMBER(5, 0)  NO 
Name: Number of Minutes to High Priority. Description: The number of minutes that need to expire before event is upgraded to high priority.
 
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 has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
EVENT_DESC    VARCHAR2(60)  NO 
Name: Event Description. Description: The description of the event.
 
S_ACTION_CD    VARCHAR2(10)  NO 
Name: Action. Description: The action performed for the event. The valid values are:OPENTS - Open Timesheet. SAVEREGTS - Save Regular Timesheet . SAVECORTS - Save Correcting Timesheet. SIGNREGTS - Sign Regular Timesheet . SIGNCORTS - Sign Correcting Timesheet. APPREGTS - Approve Regular Timesheet . APPCORTS - Approve Correcting Timesheet. REJREGTS - Reject Regular Timesheet . REJCORTS - Reject Correcting Timesheet. FLOORCHK - Floor Check. MISSSTAT - Missing Timesheet at Status . OPENSTAT - Open Timesheet at Status. SIGNSTAT - Signed Timesheet at Status . REJREGHRS – Reject Regular Timesheet Hours . REJCORHRS – Reject Correcting Timesheet Hours. RECSTAT – Expense Report Receipts Missing at Status Check. DRAFTSTAT – Expense Report Draft at Status Check. REVIEWSTAT – Expense Report In Review at Status Check. ERPAYMENT – Expense Report Paid. REJER – Reject Expense Report. REQUESTVAC – Requested Vacation. APPVAC – Approve Vacation Request. REJVAC – Reject Vacation Request . REJER – Reject Expense Report. REJEXP – Reject Expense Report Expense. 
 
FUNCTIONAL_ROLE_CD(FK)    VARCHAR2(10)  NO 
Name: Functional Role. Description: The functional role of the supervisor/owner.
 
S_EVENT_TYPE_CD    VARCHAR2(1)  NO 
Name: Event Type. Description: The type of event. The valid values are:T – Timesheet. E – Expense Report. S - Schedule. 
 

EVENT Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0114  PrimaryKey  EVENT_CD 

EVENT Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
FUNCTIONAL_ROLE  Non-Identifying  One To Zero or More  F00104      FUNCTIONAL_ROLE_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
EVENT_NOTIFICATION  Identifying  One To Zero or More  F00085        NO  NO 
CLASS_EVENT  Identifying  One To Zero or More  F00087        NO  NO 
DESKTOP_TASKS  Identifying  One To Zero or More  F00089        NO  NO 
DESKTOP_ALERTS  Identifying  One To Zero or More  F00091        NO  NO 
DESKTOP_SCHEDULE_TASKS  Identifying  One To Zero or More  F00248        NO  NO