ESS_CONFIG |
Default Table Name | ESS_CONFIG |
Definition |
ESS_CONFIG Columns |
ColumnName | Domain | Datatype | NULL | Definition |
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
S_TEXT_SAVE_CD | VARCHAR2(1) | NO | ||
S_PHONE_FORMAT_CD | VARCHAR2(1) | NO | ||
S_POSTAL_FORMAT_CD | VARCHAR2(1) | NO | ||
DD_CURR_UPDATE_FL | VARCHAR2(1) | NO | ||
DD_PEND_UPDATE_FL | VARCHAR2(1) | NO | ||
SHOW_TOT_COMP_FL | VARCHAR2(1) | NO | ||
SHOW_BEN_ELEC_FL | VARCHAR2(1) | NO | ||
MED_PRIORITY_DAYS | NUMBER(5, 0) | NO | ||
HIGH_PRIORITY_DAYS | NUMBER(5, 0) | NO | ||
S_LOW_NOTIFY_EMPL_CD | VARCHAR2(1) | NO | ||
S_MED_NOTIFY_EMPL_CD | VARCHAR2(1) | NO | ||
S_HIGH_NOTIFY_EMPL_CD | VARCHAR2(1) | NO | ||
EMAIL_EMPL_CONFIRM_FL | VARCHAR2(1) | NO | ||
EMAIL_CONFIRM_FL | VARCHAR2(1) | NO | ||
EMAIL_APPROVE_FL | VARCHAR2(1) | NO | ||
BENEFIT_ROLLOVER_FL | VARCHAR2(1) | NO | ||
SUBJECT_NAME_LOCATION_CD | VARCHAR2(10) | NO | ||
INCLUDE_NAME_SUBJECT_LINE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO | ||
THIRD_PARTY_MAIL | VARCHAR2(60) | YES | ||
SHOW_LIMIT_FSA_FL | VARCHAR2(1) | NO | ||
SHOW_EOI_FL | VARCHAR2(1) | NO |
ESS_CONFIG Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_ESS_CONFIG_IDX | PrimaryKey | COMPANY_ID |
ESS_CONFIG Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |