ESS_CONFIG 
Default Table Name  ESS_CONFIG 
Definition 
 Name: Self Service Configuration Settings .     Description: This table contains the system’s overall self service settings.
 

ESS_CONFIG Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
COMPANY_ID(PK)(FK)    VARCHAR(10)  NO 
Name: Record Key. Description: The Company ID for this configuration record.
 
S_TEXT_SAVE_CD    VARCHAR(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    VARCHAR(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    VARCHAR(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    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.
 
DD_CURR_UPDATE_FL    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    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 benefits enrollment 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 benefits enrollment to be completed.
 
S_LOW_NOTIFY_EMPL_CD    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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(FK)    VARCHAR(10)  YES 
Name: Functional Role. Description: Functional role that should be notified upon employee confirming benefits enrollment.
 
BENEFIT_ROLLOVER_FL    VARCHAR(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    VARCHAR(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    VARCHAR(1)  NO 
Name: Include Name in Subject Line.
Description: Determines whether the employee name will appear in the subject line of emails
 

ESS_CONFIG Keys 
Key Name  Key Type  Keys 
RI_F00383  Inversion Entry  FUNCTIONAL_ROLE_CD 
PI_0238  PrimaryKey  COMPANY_ID 

ESS_CONFIG Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
COMPANY  Identifying  One To Zero or More        COMPANY_ID  NO 
FUNCTIONAL_ROLE  Non-Identifying  Zero or One to Zero or More        FUNCTIONAL_ROLE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype