ColumnName |
Domain |
Datatype |
NULL |
Definition |
COMPANY_ID |
|
VARCHAR2(10) |
NO |
Name: Record Key. Description: The Company ID for this configuration record. |
S_TEXT_SAVE_CD |
|
VARCHAR2(1) |
NO |
Name: Text Save Rule. Description: Determines how and if text is converted prior to saving. Valid values are as follows:. N No Formatting. U Upper Case. P Proper Case. |
S_PHONE_FORMAT_CD |
|
VARCHAR2(1) |
NO |
Name: Phone Format Rule. Description: Determines how and if phone numbers have special formatting. The valid values are:N No Formatting. 1 (000) 000-0000. 2 000.000.0000. 3 000-000-0000. 4 000/000-0000. |
S_POSTAL_FORMAT_CD |
|
VARCHAR2(1) |
NO |
Name: Postal Format Rule. Description: Determines how and if postal codes have special formatting. The valid values are:N No Formatting. 1 00000-0000. 2 00000. The User ID of the person who last modified this record.. |
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. |
DD_CURR_UPDATE_FL |
|
VARCHAR2(1) |
NO |
Name: Direct Deposit Update Flag. Description: Logical as to whether the user can get to the Update Direct Deposit screen from Direct Deposit Summary. |
DD_PEND_UPDATE_FL |
|
VARCHAR2(1) |
NO |
Name: Direct Deposit Add Flag . Description: Logical as to whether the user can get to the Add Direct Deposit screen from Direct Deposit Summary. |
SHOW_TOT_COMP_FL |
|
VARCHAR2(1) |
NO |
Name: Show Total Compensation Flag. Description: Logical as to whether the Total Compensation Summary table will display in the Total Comp/Benefits Statement screen. |
SHOW_BEN_ELEC_FL |
|
VARCHAR2(1) |
NO |
Name: Show Benefit Elections Flag. Description: Logical as to whether the Benefit Elections table will display in the Total Comp/Benefits Statement screen. |
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 benefits enrollment 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 benefits enrollment to be completed. |
S_LOW_NOTIFY_EMPL_CD |
|
VARCHAR2(1) |
NO |
Name: Low Priority Enrollment Rule. Description: Indicates how employee shall be notified when task is at low priority when benefits enrollment task becomes low priority. 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 Enrollment Rule. Description: Indicates how employee shall be notified when benefits enrollment task becomes medium priority. 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 Enrollment Rule. Description: Indicates how employee shall be notified when benefits enrollment task becomes high priority. 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 Enrollment Confirmation Flag. Description: Logical as to whether employee shall receive e-mail when they confirm benefits enrollment. |
EMAIL_ROLE_CONFIRM_FL |
|
VARCHAR2(1) |
NO |
Name: E-mail Functional Role on Enrollment Confirmation Flag. Description: Logical as to whether functional roles shall receive e-mail when employee confirms benefits enrollment. |
EMAIL_ROLE_APPROVE_FL |
|
VARCHAR2(1) |
NO |
Name: E-mail Functional Role for Enrollment Approval Flag. Description: Logical as to whether functional role shall receive e-mail when employee confirms benefit enrollment that includes selection that requires approval. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR2(10) |
YES |
Name: Functional Role. Description: Functional role that should be notified upon employee confirming benefits enrollment. |
BENEFIT_ROLLOVER_FL |
|
VARCHAR2(1) |
NO |
Name: Benefit Rollover Flag. Description: Logical as to whether benefits shall be rolled over to new benefit plan year. |
SUBJECT_NAME_LOCATION_CD |
|
VARCHAR2(10) |
NO |
Name: Location of Name on Subject Line. Description: Determines whether the name will appear before or after the subject. Valid values are BEFORE, AFTER |
INCLUDE_NAME_SUBJECT_LINE_FL |
|
VARCHAR2(1) |
NO |
Name: Include Name in Subject Line. Description: Determines whether the employee name will appear in the subject line of emails |