COMPANY_ID |
ColumnName | COMPANY_ID |
Definition | Name: Record Key. Description: The Company ID for this configuration record. |
S_TEXT_SAVE_CD |
ColumnName | S_TEXT_SAVE_CD |
Definition | 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 |
ColumnName | S_PHONE_FORMAT_CD |
Definition | 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 |
ColumnName | S_POSTAL_FORMAT_CD |
Definition | 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 |
ColumnName | MODIFIED_BY |
Definition | Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
ColumnName | ROWVERSION |
Definition | Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition | Name: Time Stamp. Description: Date and time the record was last modified. |
DD_CURR_UPDATE_FL |
ColumnName | DD_CURR_UPDATE_FL |
Definition | 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 |
ColumnName | DD_PEND_UPDATE_FL |
Definition | 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 |
ColumnName | SHOW_TOT_COMP_FL |
Definition | 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 |
ColumnName | SHOW_BEN_ELEC_FL |
Definition | 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 |
ColumnName | MED_PRIORITY_DAYS |
Definition | 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 |
ColumnName | HIGH_PRIORITY_DAYS |
Definition | 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 |
ColumnName | S_LOW_NOTIFY_EMPL_CD |
Definition | 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 |
ColumnName | S_MED_NOTIFY_EMPL_CD |
Definition | 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 |
ColumnName | S_HIGH_NOTIFY_EMPL_CD |
Definition | 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 |
ColumnName | EMAIL_EMPL_CONFIRM_FL |
Definition | 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 |
ColumnName | EMAIL_ROLE_CONFIRM_FL |
Definition | 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 |
ColumnName | EMAIL_ROLE_APPROVE_FL |
Definition | 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 |
ColumnName | FUNCTIONAL_ROLE_CD |
Definition | Name: Functional Role. Description: Functional role that should be notified upon employee confirming benefits enrollment. |
BENEFIT_ROLLOVER_FL |
ColumnName | BENEFIT_ROLLOVER_FL |
Definition | Name: Benefit Rollover Flag. Description: Logical as to whether benefits shall be rolled over to new benefit plan year. |
SUBJECT_NAME_LOCATION_CD |
ColumnName | SUBJECT_NAME_LOCATION_CD |
Definition | 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 |
ColumnName | INCLUDE_NAME_SUBJECT_LINE_FL |
Definition | Name: Include Name in Subject Line. Description: Determines whether the employee name will appear in the subject line of emails |