LIFE_EVENT 
Default Table Name  LIFE_EVENT 
Definition 
 Name: Life Events.     Description: This table contains a master list of the valid life events.
 

LIFE_EVENT Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
LIFE_EVENT_CD(PK)    VARCHAR(12)  NO 
Name: Life Event. Description: Life Event Code
 
LIFE_EVENT_DESC    VARCHAR(30)  NO 
Name: Life Event Description. Description: Description of Life Event Code
 
MED_PRIORITY_DAYS    NUMERIC(5, 0)  NO 
Name: Medium Priority Days. Description: The number of days before change period end date that employee should be first notified for this life event to be completed.
 
HIGH_PRIORITY_DAYS    NUMERIC(5, 0)  NO 
Name: Hight Priority Days. Description: The number of days before change period end date that employee should be notified for final time for this life event to be completed.
 
S_LOW_NOTIFY_EMPL_CD    VARCHAR(1)  NO 
Name: Low Priority Life Event Rule. Description: Indicates how employee shall be notified when task is at low priority when life event is escalated. The valid values are as follows: E – E-mail. A – Alert. P – Based on Employee Preference
 
S_MED_NOTIFY_EMPL_CD    VARCHAR(1)  NO 
Name: Medium Priority Life Event Rule. Description: Indicates how employee shall be notified when task is medium priority when escalated. The valid values are as follows: E – E-mail. A – Alert. P – Based on Employee Preference
 
S_HIGH_NOTIFY_EMPL_CD    VARCHAR(1)  NO 
Name: High Priority Life Event Rule. Description: Indicates how employee shall be notified when task is at high priority when escalated. The valid values are as follows: E – E-mail. A – Alert. P – Based on Employee Preference
 
EMAIL_EMPL_CONFIRM_FL    VARCHAR(1)  NO 
Name: E-mail Employee on Life Event Confirmation Flag. Description: Logical as to whether employee shall receive e-mail when they confirm life event.
 
EMAIL_ROLE_CONFIRM_FL    VARCHAR(1)  NO 
Name: E-mail Functional Role on Life Event Confirmation Flag. Description: Logical as to whether functional roles shall receive e-mail when employee confirms life event.
 
EMAIL_ROLE_APPROVE_FL    VARCHAR(1)  NO 
Name: E-mail Functional Role for Life Event Approval Flag. Description: Logical as to whether functional role shall receive e-mail when employee confirms life event that requires approval.
 
FUNCTIONAL_ROLE_CD_1(FK)    VARCHAR(10)  YES 
Name: Functional Role 1. Description: First functional role that should be notified upon employee confirming life event.
 
FUNCTIONAL_ROLE_CD_2(FK)    VARCHAR(10)  YES 
Name: Functional Role 2. Description: Second functional role that should be notified upon employee confirming life event.
 
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 has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
EMAIL_ROLE_PREAPPROVE_FL    VARCHAR(1)  NO 
Name: E-mail Functional Role for Pre-approval Flag. Description: Logical as to whether functional role shall receive e-mail when employee starts life event that requires pre-approval.
 

LIFE_EVENT Keys 
Key Name  Key Type  Keys 
RI_F00377  Inversion Entry  FUNCTIONAL_ROLE_CD_2 
RI_F00376  Inversion Entry  FUNCTIONAL_ROLE_CD_1 
PI_0250  PrimaryKey  LIFE_EVENT_CD 

LIFE_EVENT Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
FUNCTIONAL_ROLE  Non-Identifying  Zero or One to Zero or More        FUNCTIONAL_ROLE_CD_1  NO 
FUNCTIONAL_ROLE  Non-Identifying  Zero or One to Zero or More        FUNCTIONAL_ROLE_CD_2  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
DESKTOP_SELF_SERVICE_TASKS  Non-Identifying  One To Zero or More          NO