CHRS Knowledge Base

Dataset Specification_AdHoc_DependentHealthBenefit

Updated on

Dataset: AdHoc_DependentHealthBenefit
Datalake Tables: CHRS.DL_BENEF_COMMENT
CHRS.DL_JOB_MINASEQ
CHRS.DL_DEPENDENT_BENEFIT
CHRS.DL_HEALTH_DEPEDNT
CHRS.DL_CSU_BEN_RPT_TBL
PS Tables: PS_BENEF_COMMENT
PS_JOB
"PS_DEP_BEN
PS_DEP_BEN_ADDR
PS_DEP_BEN_NAME
PS_DEP_BEN_EFF
PS_CSU_DEP_ID_TBL"
PS_HEALTH_DEPENDNT
PS_CSU_BEN_RPT_TBL
Dataset Data Elements: business_unit
Emplid
Dependent Benef
Empl Rcd
Cobra Event Id
Plan Type
Benefit Nbr
Effdt
Hlth Provider Id
Previously Seen
Oth Insurance Ind
Oth Insurance Name
Country Nm Format
Country
Name
Name Initials
Name Prefix
Name Suffix
Name Royal Prefix
Name Royal Suffix
Name Title
Last Name Srch
First Name Srch
Last Name
First Name
Middle Name
Second Last Name
Second Last Srch
Name Ac
Pref First Name
Partner Last Name
Partner Roy Prefix
Last Name Pref Nld
Name Display
Name Formal
Same Address Empl
Country
Country
Address1
Address2
Address3
Address4
City
City
Num1
Num2
House Type
Addr Field1
Addr Field2
Addr Field3
County
County
State
State
Postal
Postcode
Geo Code
In City Limit
City
Country Code
Country
Phone
Relationship
Dep Benef Type
Mar Status
Mar Status Dt
Sex
Birthdate
Birthplace
Birthstate
Birthcountry
Occupation
Dt Of Death
Student
Disabled
Disabled Status Dt
Medicare Entld Dt
Cobra Event Dt
Csb Elig
Cobra Action
Cobra Emplid
Student Status Dt
Smoker
Depben Rider Flg
Gvt Fehb Ind
Gvt Dep Benef Plan
Same Phone Empl
Phone Type
Address Type
Dep Eligible Uk
Dep Adopted Uk
Dep Adoption Dt Uk
Dep Certificate Uk
Fp Depend Emplid
Fp Stat Fonc
Fp Employer Name
Fp Same Publ Sce
Last Update Date
CSU Dep Calpers Id
Oprid
Comment Dt
Comments By Name
Action Dt
Comments

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) Dataset Specification_AdHoc_BenefitsPayroll
Next Article (job aid) Dataset Specification_AdHoc_dl_employment
Do you need an article? Contact Us