coverage_group_or_plan
Pulls together all the information available to map a set of members into one or more groups and one or more plans
Primary Key:Checks:coverage_group_or_plan_coverage_description_check-(coverage_description = upper(coverage_description))coverage_group_or_plan_department_check-(department = upper(department))coverage_group_or_plan_group_or_policy_number_check-(group_or_policy_number = upper(group_or_policy_number))coverage_group_or_plan_location_check-(location = upper(location))coverage_group_or_plan_medical_plan_identification_check-(medical_plan_identification = upper(medical_plan_identification))coverage_group_or_plan_other_identifier_check-(other_identifier = upper(other_identifier))coverage_group_or_plan_plan_sponsor_identification_check-(plan_sponsor_identification = upper(plan_sponsor_identification))coverage_group_or_plan_rx_plan_identification_check-(rx_plan_identification = upper(rx_plan_identification))
coverage_group_or_plan_insurance_line_coverage_description_idx(Unique) -insurance_line,coverage_description,plan_sponsor_identification,group_or_policy_number,medical_plan_identification,rx_plan_identification,department,location,other_identifier
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
coverage_group_or_plan_id | bigint | No | Yes | - |
insurance_line | insurance_line_type | No | Yes | Identifies the type of insurance (From HD03. Cannot be overridden) |
coverage_description | text | No | Yes | Describes the type of plan or coverage (From HD04. Cannot be overridden) |
plan_sponsor_identification | text | No | Yes | Identifies the plan sponsor (Blank by default) |
group_or_policy_number | text | No | Yes | Identifies the group or policy number (From REF 38 or REF 1L at most specific level possible. Cannot be overridden) |
medical_plan_identification | text | No | Yes | Identifies the plan (Blank by default) |
rx_plan_identification | text | No | Yes | Identifies the plan (Blank by default) |
department | text | No | Yes | Some other user-defined identifier (Blank by default) |
location | text | No | Yes | Some other user-defined identifier (Blank by default) |
other_identifier | text | No | Yes | Some other user-defined identifier (Blank by default) |