ColumnName |
Domain |
Datatype |
NULL |
Definition |
LIFE_EVENT_CD |
|
VARCHAR2(12) |
NO |
Name: Life Event. Description: Life Event Code |
LIFE_EVENT_DESC |
|
VARCHAR2(30) |
NO |
Name: Life Event Description. Description: Description of Life Event Code |
MED_PRIORITY_DAYS |
|
NUMBER(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 |
|
NUMBER(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(10) |
YES |
Name: Functional Role 1. Description: First functional role that should be notified upon employee confirming life event. |
FUNCTIONAL_ROLE_CD_2 |
|
VARCHAR2(10) |
YES |
Name: Functional Role 2. Description: Second functional role that should be notified upon employee confirming life event. |
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. |
EMAIL_ROLE_PREAPPROVE_FL |
|
VARCHAR2(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. |