HB_BEN_PLAN_HDR |
Default Table Name | HB_BEN_PLAN_HDR |
Definition |
HB_BEN_PLAN_HDR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
BEN_PLAN_CD![]() |
VARCHAR2(12) | NO | ||
BEN_PLAN_DESC | VARCHAR2(30) | NO | ||
PROVIDER_CD![]() |
VARCHAR2(12) | YES | ||
S_BEN_TYPE_CD | VARCHAR2(6) | NO | ||
USR_BEN_TYPE_CD![]() |
VARCHAR2(12) | YES | ||
MIN_AGE_NO | NUMBER(5, 0) | NO | ||
MIN_HRS_WRK_NO | NUMBER(5, 0) | NO | ||
MIN_DAYS_WRK_NO | NUMBER(5, 0) | NO | ||
DEP_MAX_AGE_NO | NUMBER(5, 0) | NO | ||
STDNT_MAX_AGE_NO | NUMBER(5, 0) | NO | ||
WAIT_PD_MOS_NO | NUMBER(5, 0) | NO | ||
CORE_BEN_FL | VARCHAR2(1) | NO | ||
COBRA_CONT_FL | VARCHAR2(1) | NO | ||
MASS_ADD_FL | VARCHAR2(1) | NO | ||
DEP_COVRD_FL | VARCHAR2(1) | NO | ||
DEP_SPSE_CHILD_FL | VARCHAR2(1) | NO | ||
BENEFIC_REQD_FL | VARCHAR2(1) | NO | ||
HANDICP_EXCL_FL | VARCHAR2(1) | NO | ||
S_BEN_STATUS_CD | VARCHAR2(1) | NO | ||
ENRLL_OPEN_FL | VARCHAR2(1) | NO | ||
ENRLL_HIRE_FL | VARCHAR2(1) | NO | ||
ENRLL_SECT_125_FL | VARCHAR2(1) | NO | ||
GRACE_PD_DAY_NO | NUMBER(5, 0) | NO | ||
OPEN_ENRLL_DT | DATE | YES | ||
S_AGE_CALC_MTHD_CD | VARCHAR2(1) | NO | ||
S_SAL_CALC_MTHD_CD | VARCHAR2(1) | NO | ||
PAY_TYPE![]() |
VARCHAR2(3) | YES | ||
S_CVG_TYPE_CD | VARCHAR2(1) | NO | ||
S_RT_TBL_CD | VARCHAR2(1) | NO | ||
S_CVG_TBL_CD | VARCHAR2(1) | NO | ||
S_CVG_CALC_MTHD_CD | VARCHAR2(1) | NO | ||
S_PREM_MTHD_CD | VARCHAR2(1) | NO | ||
ELIG_HRLY_FL | VARCHAR2(1) | NO | ||
ELIG_SAL_FL | VARCHAR2(1) | NO | ||
ELIG_FLUCT_FL | VARCHAR2(1) | NO | ||
ELIG_REG_FL | VARCHAR2(1) | NO | ||
ELIG_PT_FL | VARCHAR2(1) | NO | ||
ELIG_TEMP_FL | VARCHAR2(1) | NO | ||
S_ROUND_CRIT_CD | VARCHAR2(1) | NO | ||
FIRST_MNTH_FL | VARCHAR2(1) | NO | ||
ENRLL_ANY_FL | VARCHAR2(1) | NO | ||
MISC1_FLD | VARCHAR2(20) | YES | ||
MISC1_FL | VARCHAR2(1) | YES | ||
MISC1_DT | DATE | YES | ||
MISC1_DEC | NUMBER(14, 2) | YES | ||
EMPL_CLASS_CD | VARCHAR2(12) | YES | ||
EMPL_CLASS_FL | VARCHAR2(1) | NO | ||
REQ_APPROVAL_FL | VARCHAR2(1) | NO | ||
PLAN_INFO_URL | VARCHAR2(254) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
PHYS1_REQD_FL | VARCHAR2(1) | YES | ||
AGE_BASED_ON_CD | VARCHAR2(1) | YES | ||
ADDRESS_ELIG_TYPE | VARCHAR2(1) | YES | ||
REHIRE_FL | VARCHAR2(1) | YES | ||
ESS_CE_EXCL_FL | VARCHAR2(1) | YES | ||
ESS_BO_EXCL_FL | VARCHAR2(1) | YES |
HB_BEN_PLAN_HDR Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6549 | PrimaryKey | BEN_PLAN_CD |
HB_BEN_PLAN_HDR Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
HB_PROVIDER | Non-Identifying | Zero or One to Zero or More | F20907 | PROVIDER_CD | NO | NO | NO | ||
HB_BEN_TYPE | Non-Identifying | Zero or One to Zero or More | F20908 | USR_BEN_TYPE_CD | NO | NO | NO | ||
PAY_TYPE | Non-Identifying | Zero or One to Zero or More | F20909 | PAY_TYPE | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
HB_BEN_PLAN_LN | Identifying | One To Zero or More | F20910 | NO | NO | NO |