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