Created by Corina C Larsen, last modified by Cori Schneider on Sep 19, 2019
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | BENEFIT_NBR - (Not Implemented!) | Num3.0 | (Always = 0) | |
| BENEFIT_PLAN - Benefit Plan | Char6 | Plan | ||
| → | COBRA_EVENT_ID - COBRA Event Identification | Num3.0 | CBR Evt ID | |
| COVERAGE_BEGIN_DT - Coverage Begin Date | Date | Covg Bgn | ||
| COVERAGE_ELECT - Coverage Election | Char1 | N | Covrg Elec | |
| COVERAGE_ELECT_DT - Coverage Elect Date | Date | Elect Date | ||
| COVERAGE_END_DT - Coverage End Date | Date | Covg End | ||
| COVRG_CD - Coverage Code | Char2 | Covg Cd | ||
| DEDUCTION_END_DT - Deduction End Date | Date | Ded End | ||
| → | EFFDT - Effective Date | Date | Eff Date | |
| → | EMPLID - Empl ID | Char11 | ID | |
| → | EMPL_RCD - Empl Record | Num3.0 | Empl Record | |
| HIPAA_DEP_RPT_DT - HIPAA Report Date (Dep) | Date | HIPAA-DEP-DT | ||
| HIPAA_REPORT_DT - HIPAA Report Date (Emp) | Date | HIPAA_EMP_DT | ||
| HLTH_PROVIDER_ID - Health Provider ID | Char30 | Provider ID | ||
| MED_PREM_PRETAX - Pre-Tax Medical Premium Value | Num5.2 | Pre-Tx Prm | ||
| OTH_INSURANCE_IND - Other Insurance Indicator | Char1 | Other Insur? | ||
| OTH_INSURANCE_NAME - Other Insurance Name | Char30 | Oth Insur Name | ||
| → | PLAN_TYPE - Plan Type | Char2 | N | Plan Typ |
| PRETAX_CD - Allow Pre-Tax Medical Premium | Char1 | Pre-Tax | ||
| PREVIOUSLY_SEEN - Previously Seen | Char1 | Prev Seen |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.