Skip to main content

claim_validation_wide_view

Materialized: false

Definition
 WITH first_claim_coverage AS (
         SELECT DISTINCT ON (claim_coverage.claim_id) claim_coverage.claim_id,
            plan.plan_id,
            plan.start_date,
            plan.end_date,
            plan.plan_status,
            plan.plan_name,
            g.group_name,
            plan_sponsor.plan_sponsor_id,
            coverage_1.coverage_level,
            coverage_1.benefit_begin,
            coverage_1.benefit_end,
            coverage_1.insurance_line,
            coverage_1.coverage_description
           FROM claims.claim_coverage
             LEFT JOIN claims.plan ON plan.plan_id = claim_coverage.plan_id_chosen
             LEFT JOIN claims."group" g ON g.group_id = plan.group_id
             LEFT JOIN claims.plan_sponsor ON plan_sponsor.plan_sponsor_id = g.plan_sponsor_id
             JOIN claims.member_coverage ON claim_coverage.member_coverage_id = member_coverage.member_coverage_id
             JOIN claims.coverage coverage_1 ON member_coverage.coverage_id = coverage_1.coverage_id
          ORDER BY claim_coverage.claim_id, claim_coverage.claim_coverage_date_from
        )
 SELECT c.claim_id,
    c.trading_partner_submission_id,
    c.usage_indicator,
    c.transaction_purpose,
    c.transaction_date,
    c.transaction_type,
    c.receiver_id_qualifier,
    c.receiver_id,
    c.submitter_id_qualifier,
    c.submitter_id,
    c.submitter_name,
    c.pay_to_plan_id,
    c.claim_member_id,
    c.patient_death_date,
    c.patient_weight_units,
    c.patient_weight_quantity,
    c.patient_height_units,
    c.patient_height_quantity,
    c.patient_is_pregnant,
    c.tpa_adjudication_method,
    c.tpa_claim_status,
    c.patient_control_number,
    c.claim_billed_amount,
    c.facility_type,
    c.claim_type,
    c.form_type,
    c.claim_frequency_type,
    c.provider_signature_on_file,
    c.provider_accept_assignment,
    c.patient_assigned_benefits,
    c.release_of_information,
    c.patient_signature_source,
    c.related_causes,
    c.auto_accident_state,
    c.auto_accident_country,
    c.special_program,
    c.claim_submission_reason,
    c.delay_reason,
    c.earliest_service_date,
    c.latest_service_date,
    c.statement_date_from,
    c.statement_date_through,
    c.admit_date_or_datetime,
    c.discharge_date_or_hour,
    c.initial_treatment_date,
    c.onset_of_symptoms_or_illness_date,
    c.accident_date,
    c.last_seen_date,
    c.repricer_received_date,
    c.acute_manifestation_date,
    c.last_menstrual_period_date,
    c.last_x_ray_date,
    c.prescription_date,
    c.disability_start_date,
    c.disability_end_date,
    c.last_worked_date,
    c.return_to_work_date,
    c.assumed_care_start,
    c.relinquished_care_date,
    c.first_visit_or_consultation_date,
    c.tpa_received_date,
    c.service_date_from,
    c.service_date_through,
    c.appliance_placement_date,
    c.facility_admission_type,
    c.facility_admission_source,
    c.facility_patient_status,
    c.orthodontic_treatment_months_total,
    c.orthodontic_treatment_months_remaining,
    c.orthodontic_treatment_indicator,
    c.contract_type,
    c.contract_amount,
    c.contract_billed_percentage,
    c.contract_identification_code,
    c.contract_terms_discount_percent,
    c.contract_version_identifier,
    c.patient_amount_paid,
    c.estimated_patient_responsibility,
    c.predetermination_of_benefits_identifier,
    c.service_authorization_exception_code,
    c.mandatory_medicare_crossover_indicator,
    c.mammography_certification_number,
    c.referral_number,
    c.claim_number,
    c.payer_claim_number,
    c.repriced_claim_number,
    c.adjusted_repriced_claim_number,
    c.investigational_device_exemption_number,
    c.medical_record_number,
    c.demonstration_project_identifier,
    c.care_plan_oversight_number,
    c.its_number,
    c.icn_number,
    c.prior_authorization_number,
    c.clia_number,
    c.peer_review_organization_approval_number,
    c.property_and_casualty_claim_number,
    c.ambulance_transport_reason,
    c.ambulance_transport_distance_units,
    c.ambulance_transport_distance_quantity,
    c.ambulance_round_trip_purpose_description,
    c.ambulance_stretcher_purpose_description,
    c.ambulance_patient_count,
    c.ambulance_pickup_zip_from_value_code,
    c.ambulance_pickup_address_id,
    c.ambulance_dropoff_address_id,
    c.ambulance_applicable_conditions,
    c.ambulance_not_applicable_conditions,
    c.spinal_manipulation_condition,
    c.spinal_manipulation_patient_condition_note1,
    c.spinal_manipulation_patient_condition_note2,
    c.dme_certification_type,
    c.dme_need_duration_units,
    c.dme_need_duration_quantity,
    c.dme_applicable_conditions,
    c.dme_not_applicable_conditions,
    c.vision_spectacle_lenses_applicable_conditions,
    c.vision_spectacle_lenses_not_applicable_conditions,
    c.vision_spectacle_frames_applicable_conditions,
    c.vision_spectacle_frames_not_applicable_conditions,
    c.vision_contacts_applicable_conditions,
    c.vision_contacts_not_applicable_conditions,
    c.is_homebound,
    c.epsdt_referral_applicable_conditions,
    c.epsdt_referral_not_applicable_conditions,
    c.condition_codes,
    c.reprice_methodology,
    c.reprice_allowed_amount,
    c.reprice_savings_amount,
    c.reprice_organization_id,
    c.reprice_per_diem_or_flat_rate_amount,
    c.reprice_approved_drg_or_apg_code,
    c.reprice_approved_drg_or_apg_amount,
    c.reprice_approved_revenue_code,
    c.reprice_approved_units,
    c.reprice_approved_quantity,
    c.reprice_reject_reason,
    c.reprice_policy_compliance,
    c.reprice_exception,
    c.data_errors,
    tp.trading_partner_id,
    s.solution_id,
    s.external_solution_id,
    s.solution_name,
    diagnoses.principal_diagnosis,
    diagnoses.principal_diagnosis_description,
    diagnoses.principal_diagnosis_hcup_group,
    diagnoses.principal_diagnosis_hcup_group_description,
    diagnoses.other_diagnosis1,
    diagnoses.other_diagnosis2,
    diagnoses.other_diagnosis3,
    diagnoses.other_diagnosis4,
    diagnoses.other_diagnosis5,
    diagnoses.other_diagnosis6,
    diagnoses.other_diagnosis7,
    diagnoses.other_diagnosis8,
    diagnoses.other_diagnosis9,
    diagnoses.other_diagnosis10,
    diagnoses.other_diagnosis11,
    diagnoses.other_diagnosis12,
    diagnoses.other_diagnosis13,
    diagnoses.other_diagnosis14,
    diagnoses.other_diagnosis15,
    diagnoses.other_diagnosis16,
    diagnoses.other_diagnosis17,
    diagnoses.other_diagnosis18,
    diagnoses.other_diagnosis19,
    diagnoses.other_diagnosis20,
    diagnoses.other_diagnosis21,
    diagnoses.other_diagnosis22,
    diagnoses.other_diagnosis23,
    diagnoses.other_diagnosis24,
    diagnoses.other_diagnosis25,
    diagnoses.other_diagnosis26,
    diagnoses.other_diagnosis27,
    diagnoses.other_diagnosis28,
    diagnoses.other_diagnosis29,
    diagnoses.other_diagnosis30,
    diagnoses.other_diagnosis_description1,
    diagnoses.other_diagnosis_description2,
    diagnoses.other_diagnosis_description3,
    diagnoses.other_diagnosis_description4,
    diagnoses.other_diagnosis_description5,
    diagnoses.other_diagnosis_description6,
    diagnoses.other_diagnosis_description7,
    diagnoses.other_diagnosis_description8,
    diagnoses.other_diagnosis_description9,
    diagnoses.other_diagnosis_description10,
    diagnoses.other_diagnosis_description11,
    diagnoses.other_diagnosis_description12,
    diagnoses.other_diagnosis_description13,
    diagnoses.other_diagnosis_description14,
    diagnoses.other_diagnosis_description15,
    diagnoses.other_diagnosis_description16,
    diagnoses.other_diagnosis_description17,
    diagnoses.other_diagnosis_description18,
    diagnoses.other_diagnosis_description19,
    diagnoses.other_diagnosis_description20,
    diagnoses.other_diagnosis_description21,
    diagnoses.other_diagnosis_description22,
    diagnoses.other_diagnosis_description23,
    diagnoses.other_diagnosis_description24,
    diagnoses.other_diagnosis_description25,
    diagnoses.other_diagnosis_description26,
    diagnoses.other_diagnosis_description27,
    diagnoses.other_diagnosis_description28,
    diagnoses.other_diagnosis_description29,
    diagnoses.other_diagnosis_description30,
    diagnoses.other_diagnosis_hcup_group1,
    diagnoses.other_diagnosis_hcup_group2,
    diagnoses.other_diagnosis_hcup_group3,
    diagnoses.other_diagnosis_hcup_group4,
    diagnoses.other_diagnosis_hcup_group5,
    diagnoses.other_diagnosis_hcup_group6,
    diagnoses.other_diagnosis_hcup_group7,
    diagnoses.other_diagnosis_hcup_group8,
    diagnoses.other_diagnosis_hcup_group9,
    diagnoses.other_diagnosis_hcup_group10,
    diagnoses.other_diagnosis_hcup_group11,
    diagnoses.other_diagnosis_hcup_group12,
    diagnoses.other_diagnosis_hcup_group13,
    diagnoses.other_diagnosis_hcup_group14,
    diagnoses.other_diagnosis_hcup_group15,
    diagnoses.other_diagnosis_hcup_group16,
    diagnoses.other_diagnosis_hcup_group17,
    diagnoses.other_diagnosis_hcup_group18,
    diagnoses.other_diagnosis_hcup_group19,
    diagnoses.other_diagnosis_hcup_group20,
    diagnoses.other_diagnosis_hcup_group21,
    diagnoses.other_diagnosis_hcup_group22,
    diagnoses.other_diagnosis_hcup_group23,
    diagnoses.other_diagnosis_hcup_group24,
    diagnoses.other_diagnosis_hcup_group25,
    diagnoses.other_diagnosis_hcup_group26,
    diagnoses.other_diagnosis_hcup_group27,
    diagnoses.other_diagnosis_hcup_group28,
    diagnoses.other_diagnosis_hcup_group29,
    diagnoses.other_diagnosis_hcup_group30,
    diagnoses.other_diagnosis_hcup_group_description1,
    diagnoses.other_diagnosis_hcup_group_description2,
    diagnoses.other_diagnosis_hcup_group_description3,
    diagnoses.other_diagnosis_hcup_group_description4,
    diagnoses.other_diagnosis_hcup_group_description5,
    diagnoses.other_diagnosis_hcup_group_description6,
    diagnoses.other_diagnosis_hcup_group_description7,
    diagnoses.other_diagnosis_hcup_group_description8,
    diagnoses.other_diagnosis_hcup_group_description9,
    diagnoses.other_diagnosis_hcup_group_description10,
    diagnoses.other_diagnosis_hcup_group_description11,
    diagnoses.other_diagnosis_hcup_group_description12,
    diagnoses.other_diagnosis_hcup_group_description13,
    diagnoses.other_diagnosis_hcup_group_description14,
    diagnoses.other_diagnosis_hcup_group_description15,
    diagnoses.other_diagnosis_hcup_group_description16,
    diagnoses.other_diagnosis_hcup_group_description17,
    diagnoses.other_diagnosis_hcup_group_description18,
    diagnoses.other_diagnosis_hcup_group_description19,
    diagnoses.other_diagnosis_hcup_group_description20,
    diagnoses.other_diagnosis_hcup_group_description21,
    diagnoses.other_diagnosis_hcup_group_description22,
    diagnoses.other_diagnosis_hcup_group_description23,
    diagnoses.other_diagnosis_hcup_group_description24,
    diagnoses.other_diagnosis_hcup_group_description25,
    diagnoses.other_diagnosis_hcup_group_description26,
    diagnoses.other_diagnosis_hcup_group_description27,
    diagnoses.other_diagnosis_hcup_group_description28,
    diagnoses.other_diagnosis_hcup_group_description29,
    diagnoses.other_diagnosis_hcup_group_description30,
    procedures.principal_procedure,
    procedures.principal_procedure_description,
    procedures.principal_procedure_hcup_group,
    procedures.principal_procedure_hcup_group_description,
    procedures.other_procedure1,
    procedures.other_procedure2,
    procedures.other_procedure3,
    procedures.other_procedure4,
    procedures.other_procedure5,
    procedures.other_procedure6,
    procedures.other_procedure7,
    procedures.other_procedure8,
    procedures.other_procedure9,
    procedures.other_procedure10,
    procedures.other_procedure11,
    procedures.other_procedure12,
    procedures.other_procedure13,
    procedures.other_procedure14,
    procedures.other_procedure15,
    procedures.other_procedure16,
    procedures.other_procedure17,
    procedures.other_procedure18,
    procedures.other_procedure19,
    procedures.other_procedure20,
    procedures.other_procedure21,
    procedures.other_procedure22,
    procedures.other_procedure23,
    procedures.other_procedure24,
    procedures.other_procedure25,
    procedures.other_procedure26,
    procedures.other_procedure27,
    procedures.other_procedure28,
    procedures.other_procedure29,
    procedures.other_procedure30,
    procedures.other_procedure_description1,
    procedures.other_procedure_description2,
    procedures.other_procedure_description3,
    procedures.other_procedure_description4,
    procedures.other_procedure_description5,
    procedures.other_procedure_description6,
    procedures.other_procedure_description7,
    procedures.other_procedure_description8,
    procedures.other_procedure_description9,
    procedures.other_procedure_description10,
    procedures.other_procedure_description11,
    procedures.other_procedure_description12,
    procedures.other_procedure_description13,
    procedures.other_procedure_description14,
    procedures.other_procedure_description15,
    procedures.other_procedure_description16,
    procedures.other_procedure_description17,
    procedures.other_procedure_description18,
    procedures.other_procedure_description19,
    procedures.other_procedure_description20,
    procedures.other_procedure_description21,
    procedures.other_procedure_description22,
    procedures.other_procedure_description23,
    procedures.other_procedure_description24,
    procedures.other_procedure_description25,
    procedures.other_procedure_description26,
    procedures.other_procedure_description27,
    procedures.other_procedure_description28,
    procedures.other_procedure_description29,
    procedures.other_procedure_description30,
    procedures.other_procedure_hcup_group1,
    procedures.other_procedure_hcup_group2,
    procedures.other_procedure_hcup_group3,
    procedures.other_procedure_hcup_group4,
    procedures.other_procedure_hcup_group5,
    procedures.other_procedure_hcup_group6,
    procedures.other_procedure_hcup_group7,
    procedures.other_procedure_hcup_group8,
    procedures.other_procedure_hcup_group9,
    procedures.other_procedure_hcup_group10,
    procedures.other_procedure_hcup_group11,
    procedures.other_procedure_hcup_group12,
    procedures.other_procedure_hcup_group13,
    procedures.other_procedure_hcup_group14,
    procedures.other_procedure_hcup_group15,
    procedures.other_procedure_hcup_group16,
    procedures.other_procedure_hcup_group17,
    procedures.other_procedure_hcup_group18,
    procedures.other_procedure_hcup_group19,
    procedures.other_procedure_hcup_group20,
    procedures.other_procedure_hcup_group21,
    procedures.other_procedure_hcup_group22,
    procedures.other_procedure_hcup_group23,
    procedures.other_procedure_hcup_group24,
    procedures.other_procedure_hcup_group25,
    procedures.other_procedure_hcup_group26,
    procedures.other_procedure_hcup_group27,
    procedures.other_procedure_hcup_group28,
    procedures.other_procedure_hcup_group29,
    procedures.other_procedure_hcup_group30,
    procedures.other_procedure_hcup_group_description1,
    procedures.other_procedure_hcup_group_description2,
    procedures.other_procedure_hcup_group_description3,
    procedures.other_procedure_hcup_group_description4,
    procedures.other_procedure_hcup_group_description5,
    procedures.other_procedure_hcup_group_description6,
    procedures.other_procedure_hcup_group_description7,
    procedures.other_procedure_hcup_group_description8,
    procedures.other_procedure_hcup_group_description9,
    procedures.other_procedure_hcup_group_description10,
    procedures.other_procedure_hcup_group_description11,
    procedures.other_procedure_hcup_group_description12,
    procedures.other_procedure_hcup_group_description13,
    procedures.other_procedure_hcup_group_description14,
    procedures.other_procedure_hcup_group_description15,
    procedures.other_procedure_hcup_group_description16,
    procedures.other_procedure_hcup_group_description17,
    procedures.other_procedure_hcup_group_description18,
    procedures.other_procedure_hcup_group_description19,
    procedures.other_procedure_hcup_group_description20,
    procedures.other_procedure_hcup_group_description21,
    procedures.other_procedure_hcup_group_description22,
    procedures.other_procedure_hcup_group_description23,
    procedures.other_procedure_hcup_group_description24,
    procedures.other_procedure_hcup_group_description25,
    procedures.other_procedure_hcup_group_description26,
    procedures.other_procedure_hcup_group_description27,
    procedures.other_procedure_hcup_group_description28,
    procedures.other_procedure_hcup_group_description29,
    procedures.other_procedure_hcup_group_description30,
    occurrences.occurrence_code1,
    occurrences.occurrence_code2,
    occurrences.occurrence_code3,
    occurrences.occurrence_code4,
    occurrences.occurrence_code5,
    occurrences.occurrence_code6,
    occurrences.occurrence_code7,
    occurrences.occurrence_code8,
    occurrences.occurrence_code9,
    occurrences.occurrence_code10,
    occurrences.occurrence_code11,
    occurrences.occurrence_code12,
    occurrences.occurrence_code13,
    occurrences.occurrence_code14,
    occurrences.occurrence_code15,
    occurrences.occurrence_code16,
    occurrences.occurrence_code17,
    occurrences.occurrence_code18,
    occurrences.occurrence_code19,
    occurrences.occurrence_code20,
    occurrences.occurrence_code21,
    occurrences.occurrence_code22,
    occurrences.occurrence_code23,
    occurrences.occurrence_code24,
    occurrences.occurrence_code25,
    occurrences.occurrence_code26,
    occurrences.occurrence_code27,
    occurrences.occurrence_code28,
    occurrences.occurrence_code29,
    occurrences.occurrence_code30,
    occurrences.occurrence_start_date1,
    occurrences.occurrence_start_date2,
    occurrences.occurrence_start_date3,
    occurrences.occurrence_start_date4,
    occurrences.occurrence_start_date5,
    occurrences.occurrence_start_date6,
    occurrences.occurrence_start_date7,
    occurrences.occurrence_start_date8,
    occurrences.occurrence_start_date9,
    occurrences.occurrence_start_date10,
    occurrences.occurrence_start_date11,
    occurrences.occurrence_start_date12,
    occurrences.occurrence_start_date13,
    occurrences.occurrence_start_date14,
    occurrences.occurrence_start_date15,
    occurrences.occurrence_start_date16,
    occurrences.occurrence_start_date17,
    occurrences.occurrence_start_date18,
    occurrences.occurrence_start_date19,
    occurrences.occurrence_start_date20,
    occurrences.occurrence_start_date21,
    occurrences.occurrence_start_date22,
    occurrences.occurrence_start_date23,
    occurrences.occurrence_start_date24,
    occurrences.occurrence_start_date25,
    occurrences.occurrence_start_date26,
    occurrences.occurrence_start_date27,
    occurrences.occurrence_start_date28,
    occurrences.occurrence_start_date29,
    occurrences.occurrence_start_date30,
    occurrences.occurrence_end_date1,
    occurrences.occurrence_end_date2,
    occurrences.occurrence_end_date3,
    occurrences.occurrence_end_date4,
    occurrences.occurrence_end_date5,
    occurrences.occurrence_end_date6,
    occurrences.occurrence_end_date7,
    occurrences.occurrence_end_date8,
    occurrences.occurrence_end_date9,
    occurrences.occurrence_end_date10,
    occurrences.occurrence_end_date11,
    occurrences.occurrence_end_date12,
    occurrences.occurrence_end_date13,
    occurrences.occurrence_end_date14,
    occurrences.occurrence_end_date15,
    occurrences.occurrence_end_date16,
    occurrences.occurrence_end_date17,
    occurrences.occurrence_end_date18,
    occurrences.occurrence_end_date19,
    occurrences.occurrence_end_date20,
    occurrences.occurrence_end_date21,
    occurrences.occurrence_end_date22,
    occurrences.occurrence_end_date23,
    occurrences.occurrence_end_date24,
    occurrences.occurrence_end_date25,
    occurrences.occurrence_end_date26,
    occurrences.occurrence_end_date27,
    occurrences.occurrence_end_date28,
    occurrences.occurrence_end_date29,
    occurrences.occurrence_end_date30,
    occurrences.occurrence_description1,
    occurrences.occurrence_description2,
    occurrences.occurrence_description3,
    occurrences.occurrence_description4,
    occurrences.occurrence_description5,
    occurrences.occurrence_description6,
    occurrences.occurrence_description7,
    occurrences.occurrence_description8,
    occurrences.occurrence_description9,
    occurrences.occurrence_description10,
    occurrences.occurrence_description11,
    occurrences.occurrence_description12,
    occurrences.occurrence_description13,
    occurrences.occurrence_description14,
    occurrences.occurrence_description15,
    occurrences.occurrence_description16,
    occurrences.occurrence_description17,
    occurrences.occurrence_description18,
    occurrences.occurrence_description19,
    occurrences.occurrence_description20,
    occurrences.occurrence_description21,
    occurrences.occurrence_description22,
    occurrences.occurrence_description23,
    occurrences.occurrence_description24,
    occurrences.occurrence_description25,
    occurrences.occurrence_description26,
    occurrences.occurrence_description27,
    occurrences.occurrence_description28,
    occurrences.occurrence_description29,
    occurrences.occurrence_description30,
    "values".value_code1,
    "values".value_code2,
    "values".value_code3,
    "values".value_code4,
    "values".value_code5,
    "values".value_code6,
    "values".value_code7,
    "values".value_code8,
    "values".value_code9,
    "values".value_code10,
    "values".value_code11,
    "values".value_code12,
    "values".value_code13,
    "values".value_code14,
    "values".value_code15,
    "values".value_code16,
    "values".value_code17,
    "values".value_code18,
    "values".value_code19,
    "values".value_code20,
    "values".value_code21,
    "values".value_code22,
    "values".value_code23,
    "values".value_code24,
    "values".value_code25,
    "values".value_code26,
    "values".value_code27,
    "values".value_code28,
    "values".value_code29,
    "values".value_code30,
    "values".value_amount1,
    "values".value_amount2,
    "values".value_amount3,
    "values".value_amount4,
    "values".value_amount5,
    "values".value_amount6,
    "values".value_amount7,
    "values".value_amount8,
    "values".value_amount9,
    "values".value_amount10,
    "values".value_amount11,
    "values".value_amount12,
    "values".value_amount13,
    "values".value_amount14,
    "values".value_amount15,
    "values".value_amount16,
    "values".value_amount17,
    "values".value_amount18,
    "values".value_amount19,
    "values".value_amount20,
    "values".value_amount21,
    "values".value_amount22,
    "values".value_amount23,
    "values".value_amount24,
    "values".value_amount25,
    "values".value_amount26,
    "values".value_amount27,
    "values".value_amount28,
    "values".value_amount29,
    "values".value_amount30,
    "values".value_description1,
    "values".value_description2,
    "values".value_description3,
    "values".value_description4,
    "values".value_description5,
    "values".value_description6,
    "values".value_description7,
    "values".value_description8,
    "values".value_description9,
    "values".value_description10,
    "values".value_description11,
    "values".value_description12,
    "values".value_description13,
    "values".value_description14,
    "values".value_description15,
    "values".value_description16,
    "values".value_description17,
    "values".value_description18,
    "values".value_description19,
    "values".value_description20,
    "values".value_description21,
    "values".value_description22,
    "values".value_description23,
    "values".value_description24,
    "values".value_description25,
    "values".value_description26,
    "values".value_description27,
    "values".value_description28,
    "values".value_description29,
    "values".value_description30,
    claim_drg.drg_code,
    claim_drg.grouped_drg_code,
    claim_drg.mdc,
    claim_drg.medical_or_surgical,
    claim_drg.drg_description,
    claim_drg.base_drg_description,
    claim_drg.mdc_description,
    cm.payer_responsibility_sequence,
    cm.relationship_to_subscriber,
    cm.group_or_policy_number,
    cm.group_name,
    cm.insurance_type,
    cm.claim_filing_indicator,
    cm.member_subscriber_or_patient_id,
    cm.member_ssn,
    cm.member_identification_code,
    cm.insurer_payer_id,
    cm.patient_subscriber_or_patient_id,
    cm.member_address_id,
    cm.member_date_of_birth,
    cm.member_name_prefix,
    cm.member_name_first,
    cm.member_name_middle,
    cm.member_name_last,
    cm.member_name_suffix,
    cm.member_gender_or_sex,
    cm.member_address1,
    cm.member_address2,
    cm.member_city,
    cm.member_state_or_province,
    cm.member_postal_code,
    cm.member_phone_number,
    cm.patient_name_prefix,
    cm.patient_name_first,
    cm.patient_name_middle,
    cm.patient_name_last,
    cm.patient_name_suffix,
    cm.patient_gender_or_sex,
    cm.patient_address1,
    cm.patient_address2,
    cm.patient_city,
    cm.patient_state_or_province,
    cm.patient_postal_code,
    cm.patient_date_of_birth,
    cm.patient_phone_number,
    coverage.coverage_description,
    coverage.coverage_level,
    coverage.benefit_begin,
    coverage.benefit_end,
    coverage.plan_id,
    coverage.plan_sponsor_id,
    coverage.group_name AS coverage_group_name,
    coverage.plan_name AS coverage_plan_name,
    coverage.insurance_line,
    coverage.start_date AS plan_start_date,
    coverage.end_date AS plan_end_date,
    coverage.plan_status,
    billprov.npi AS billprov_npi,
    billprov.tax_id AS billprov_tax_id,
    billprov.tpa_specialty_code AS billprov_tpa_specialty_code,
    billprov.name_last_or_organization AS billprov_name_last_or_organization,
    billprov.name_first AS billprov_name_first,
    billprov.name_middle AS billprov_name_middle,
    billprov.name_prefix AS billprov_name_prefix,
    billprov.name_suffix AS billprov_name_suffix,
    billprov.taxonomy AS billprov_taxonomy
   FROM claims.claim c
     JOIN claims.trading_partner_submission tps ON tps.trading_partner_submission_id = c.trading_partner_submission_id
     JOIN claims.trading_partner tp ON tps.trading_partner_id = tp.trading_partner_id
     JOIN claims.solution s ON s.solution_id = tp.solution_id
     LEFT JOIN claims.claim_diagnosis_wide_view diagnoses ON diagnoses.claim_id = c.claim_id
     LEFT JOIN claims.claim_procedure_wide_view procedures ON procedures.claim_id = c.claim_id
     LEFT JOIN claims.claim_occurrence_wide_view occurrences ON occurrences.claim_id = c.claim_id
     LEFT JOIN claims.claim_value_wide_view "values" ON "values".claim_id = c.claim_id
     LEFT JOIN claims.claim_drg_view claim_drg ON claim_drg.claim_id = c.claim_id
     LEFT JOIN claims.claim_member_view cm ON cm.claim_member_id = c.claim_member_id
     LEFT JOIN first_claim_coverage coverage ON coverage.claim_id = c.claim_id
     LEFT JOIN claims.claim_provider_view billprov ON billprov.claim_id = c.claim_id AND billprov.provider_type = 'Billing Provider'::claims.entity_identifier_type;
ColumnData TypeIndexed
claim_idbigintNo
trading_partner_submission_idbigintNo
usage_indicatorusage_indicator_typeNo
transaction_purposetransaction_set_purpose_typeNo
transaction_datedateNo
transaction_typetransaction_typeNo
receiver_id_qualifieridentification_typeNo
receiver_idtextNo
submitter_id_qualifieridentification_typeNo
submitter_idtextNo
submitter_nametextNo
pay_to_plan_idbigintNo
claim_member_idbigintNo
patient_death_datedateNo
patient_weight_unitsunit_typeNo
patient_weight_quantitynumericNo
patient_height_unitsunit_typeNo
patient_height_quantitynumericNo
patient_is_pregnantbooleanNo
tpa_adjudication_methodadjudication_method_typeNo
tpa_claim_statustextNo
patient_control_numbertextNo
claim_billed_amountnumericNo
facility_typetextNo
claim_typeclaim_typeNo
form_typeform_typeNo
claim_frequency_typetextNo
provider_signature_on_fileyes_no_response_typeNo
provider_accept_assignmentprovider_accept_assignment_typeNo
patient_assigned_benefitsyes_no_response_typeNo
release_of_informationrelease_of_information_typeNo
patient_signature_sourcepatient_signature_source_typeNo
auto_accident_statetextNo
auto_accident_countrytextNo
special_programspecial_program_typeNo
claim_submission_reasonclaim_submission_reason_typeNo
delay_reasondelay_reason_typeNo
earliest_service_datedateNo
latest_service_datedateNo
statement_date_fromdateNo
statement_date_throughdateNo
admit_date_or_datetimetimestampNo
discharge_date_or_hourtimestampNo
initial_treatment_datedateNo
onset_of_symptoms_or_illness_datedateNo
accident_datedateNo
last_seen_datedateNo
repricer_received_datedateNo
acute_manifestation_datedateNo
last_menstrual_period_datedateNo
last_x_ray_datedateNo
prescription_datedateNo
disability_start_datedateNo
disability_end_datedateNo
last_worked_datedateNo
return_to_work_datedateNo
assumed_care_startdateNo
relinquished_care_datedateNo
first_visit_or_consultation_datedateNo
tpa_received_datedateNo
service_date_fromdateNo
service_date_throughdateNo
appliance_placement_datedateNo
facility_admission_typetextNo
facility_admission_sourcetextNo
facility_patient_statustextNo
orthodontic_treatment_months_totalnumericNo
orthodontic_treatment_months_remainingnumericNo
orthodontic_treatment_indicatortextNo
contract_typecontract_typeNo
contract_amountnumericNo
contract_billed_percentagenumericNo
contract_identification_codetextNo
contract_terms_discount_percentnumericNo
contract_version_identifiertextNo
patient_amount_paidnumericNo
estimated_patient_responsibilitynumericNo
predetermination_of_benefits_identifiertextNo
service_authorization_exception_codetextNo
mandatory_medicare_crossover_indicatortextNo
mammography_certification_numbertextNo
referral_numbertextNo
claim_numbertextNo
payer_claim_numbertextNo
repriced_claim_numbertextNo
adjusted_repriced_claim_numbertextNo
investigational_device_exemption_numbertextNo
medical_record_numbertextNo
demonstration_project_identifiertextNo
care_plan_oversight_numbertextNo
its_numbertextNo
icn_numbertextNo
prior_authorization_numbertextNo
clia_numbertextNo
peer_review_organization_approval_numbertextNo
property_and_casualty_claim_numbertextNo
ambulance_transport_reasonambulance_transport_reason_typeNo
ambulance_transport_distance_unitsunit_typeNo
ambulance_transport_distance_quantitynumericNo
ambulance_round_trip_purpose_descriptiontextNo
ambulance_stretcher_purpose_descriptiontextNo
ambulance_patient_countsmallintNo
ambulance_pickup_zip_from_value_codetextNo
ambulance_pickup_address_idbigintNo
ambulance_dropoff_address_idbigintNo
ambulance_applicable_conditionstext[]No
ambulance_not_applicable_conditionstext[]No
spinal_manipulation_conditionnature_of_condition_typeNo
spinal_manipulation_patient_condition_note1textNo
spinal_manipulation_patient_condition_note2textNo
dme_certification_typecertification_typeNo
dme_need_duration_unitsunit_typeNo
dme_need_duration_quantitynumericNo
dme_applicable_conditionscondition_indicator_type[]No
dme_not_applicable_conditionscondition_indicator_type[]No
vision_spectacle_lenses_applicable_conditionstext[]No
vision_spectacle_lenses_not_applicable_conditionstext[]No
vision_spectacle_frames_applicable_conditionstext[]No
vision_spectacle_frames_not_applicable_conditionstext[]No
vision_contacts_applicable_conditionstext[]No
vision_contacts_not_applicable_conditionstext[]No
is_homeboundbooleanNo
epsdt_referral_applicable_conditionstext[]No
epsdt_referral_not_applicable_conditionstext[]No
condition_codestext[]No
reprice_methodologypricing_methodology_typeNo
reprice_allowed_amountnumericNo
reprice_savings_amountnumericNo
reprice_organization_idtextNo
reprice_per_diem_or_flat_rate_amountnumericNo
reprice_approved_drg_or_apg_codetextNo
reprice_approved_drg_or_apg_amountnumericNo
reprice_approved_revenue_codetextNo
reprice_approved_unitsunit_typeNo
reprice_approved_quantitynumericNo
reprice_reject_reasonreject_reason_typeNo
reprice_policy_compliancepolicy_compliance_typeNo
reprice_exceptionrepricing_exception_typeNo
data_errorstext[]No
trading_partner_idbigintNo
solution_idbigintNo
external_solution_idtextNo
solution_nametextNo
principal_diagnosistextNo
principal_diagnosis_descriptiontextNo
principal_diagnosis_hcup_grouptextNo
principal_diagnosis_hcup_group_descriptiontextNo
other_diagnosis1textNo
other_diagnosis2textNo
other_diagnosis3textNo
other_diagnosis4textNo
other_diagnosis5textNo
other_diagnosis6textNo
other_diagnosis7textNo
other_diagnosis8textNo
other_diagnosis9textNo
other_diagnosis10textNo
other_diagnosis11textNo
other_diagnosis12textNo
other_diagnosis13textNo
other_diagnosis14textNo
other_diagnosis15textNo
other_diagnosis16textNo
other_diagnosis17textNo
other_diagnosis18textNo
other_diagnosis19textNo
other_diagnosis20textNo
other_diagnosis21textNo
other_diagnosis22textNo
other_diagnosis23textNo
other_diagnosis24textNo
other_diagnosis25textNo
other_diagnosis26textNo
other_diagnosis27textNo
other_diagnosis28textNo
other_diagnosis29textNo
other_diagnosis30textNo
other_diagnosis_description1textNo
other_diagnosis_description2textNo
other_diagnosis_description3textNo
other_diagnosis_description4textNo
other_diagnosis_description5textNo
other_diagnosis_description6textNo
other_diagnosis_description7textNo
other_diagnosis_description8textNo
other_diagnosis_description9textNo
other_diagnosis_description10textNo
other_diagnosis_description11textNo
other_diagnosis_description12textNo
other_diagnosis_description13textNo
other_diagnosis_description14textNo
other_diagnosis_description15textNo
other_diagnosis_description16textNo
other_diagnosis_description17textNo
other_diagnosis_description18textNo
other_diagnosis_description19textNo
other_diagnosis_description20textNo
other_diagnosis_description21textNo
other_diagnosis_description22textNo
other_diagnosis_description23textNo
other_diagnosis_description24textNo
other_diagnosis_description25textNo
other_diagnosis_description26textNo
other_diagnosis_description27textNo
other_diagnosis_description28textNo
other_diagnosis_description29textNo
other_diagnosis_description30textNo
other_diagnosis_hcup_group1textNo
other_diagnosis_hcup_group2textNo
other_diagnosis_hcup_group3textNo
other_diagnosis_hcup_group4textNo
other_diagnosis_hcup_group5textNo
other_diagnosis_hcup_group6textNo
other_diagnosis_hcup_group7textNo
other_diagnosis_hcup_group8textNo
other_diagnosis_hcup_group9textNo
other_diagnosis_hcup_group10textNo
other_diagnosis_hcup_group11textNo
other_diagnosis_hcup_group12textNo
other_diagnosis_hcup_group13textNo
other_diagnosis_hcup_group14textNo
other_diagnosis_hcup_group15textNo
other_diagnosis_hcup_group16textNo
other_diagnosis_hcup_group17textNo
other_diagnosis_hcup_group18textNo
other_diagnosis_hcup_group19textNo
other_diagnosis_hcup_group20textNo
other_diagnosis_hcup_group21textNo
other_diagnosis_hcup_group22textNo
other_diagnosis_hcup_group23textNo
other_diagnosis_hcup_group24textNo
other_diagnosis_hcup_group25textNo
other_diagnosis_hcup_group26textNo
other_diagnosis_hcup_group27textNo
other_diagnosis_hcup_group28textNo
other_diagnosis_hcup_group29textNo
other_diagnosis_hcup_group30textNo
other_diagnosis_hcup_group_description1textNo
other_diagnosis_hcup_group_description2textNo
other_diagnosis_hcup_group_description3textNo
other_diagnosis_hcup_group_description4textNo
other_diagnosis_hcup_group_description5textNo
other_diagnosis_hcup_group_description6textNo
other_diagnosis_hcup_group_description7textNo
other_diagnosis_hcup_group_description8textNo
other_diagnosis_hcup_group_description9textNo
other_diagnosis_hcup_group_description10textNo
other_diagnosis_hcup_group_description11textNo
other_diagnosis_hcup_group_description12textNo
other_diagnosis_hcup_group_description13textNo
other_diagnosis_hcup_group_description14textNo
other_diagnosis_hcup_group_description15textNo
other_diagnosis_hcup_group_description16textNo
other_diagnosis_hcup_group_description17textNo
other_diagnosis_hcup_group_description18textNo
other_diagnosis_hcup_group_description19textNo
other_diagnosis_hcup_group_description20textNo
other_diagnosis_hcup_group_description21textNo
other_diagnosis_hcup_group_description22textNo
other_diagnosis_hcup_group_description23textNo
other_diagnosis_hcup_group_description24textNo
other_diagnosis_hcup_group_description25textNo
other_diagnosis_hcup_group_description26textNo
other_diagnosis_hcup_group_description27textNo
other_diagnosis_hcup_group_description28textNo
other_diagnosis_hcup_group_description29textNo
other_diagnosis_hcup_group_description30textNo
principal_proceduretextNo
principal_procedure_descriptiontextNo
principal_procedure_hcup_grouptextNo
principal_procedure_hcup_group_descriptiontextNo
other_procedure1textNo
other_procedure2textNo
other_procedure3textNo
other_procedure4textNo
other_procedure5textNo
other_procedure6textNo
other_procedure7textNo
other_procedure8textNo
other_procedure9textNo
other_procedure10textNo
other_procedure11textNo
other_procedure12textNo
other_procedure13textNo
other_procedure14textNo
other_procedure15textNo
other_procedure16textNo
other_procedure17textNo
other_procedure18textNo
other_procedure19textNo
other_procedure20textNo
other_procedure21textNo
other_procedure22textNo
other_procedure23textNo
other_procedure24textNo
other_procedure25textNo
other_procedure26textNo
other_procedure27textNo
other_procedure28textNo
other_procedure29textNo
other_procedure30textNo
other_procedure_description1textNo
other_procedure_description2textNo
other_procedure_description3textNo
other_procedure_description4textNo
other_procedure_description5textNo
other_procedure_description6textNo
other_procedure_description7textNo
other_procedure_description8textNo
other_procedure_description9textNo
other_procedure_description10textNo
other_procedure_description11textNo
other_procedure_description12textNo
other_procedure_description13textNo
other_procedure_description14textNo
other_procedure_description15textNo
other_procedure_description16textNo
other_procedure_description17textNo
other_procedure_description18textNo
other_procedure_description19textNo
other_procedure_description20textNo
other_procedure_description21textNo
other_procedure_description22textNo
other_procedure_description23textNo
other_procedure_description24textNo
other_procedure_description25textNo
other_procedure_description26textNo
other_procedure_description27textNo
other_procedure_description28textNo
other_procedure_description29textNo
other_procedure_description30textNo
other_procedure_hcup_group1textNo
other_procedure_hcup_group2textNo
other_procedure_hcup_group3textNo
other_procedure_hcup_group4textNo
other_procedure_hcup_group5textNo
other_procedure_hcup_group6textNo
other_procedure_hcup_group7textNo
other_procedure_hcup_group8textNo
other_procedure_hcup_group9textNo
other_procedure_hcup_group10textNo
other_procedure_hcup_group11textNo
other_procedure_hcup_group12textNo
other_procedure_hcup_group13textNo
other_procedure_hcup_group14textNo
other_procedure_hcup_group15textNo
other_procedure_hcup_group16textNo
other_procedure_hcup_group17textNo
other_procedure_hcup_group18textNo
other_procedure_hcup_group19textNo
other_procedure_hcup_group20textNo
other_procedure_hcup_group21textNo
other_procedure_hcup_group22textNo
other_procedure_hcup_group23textNo
other_procedure_hcup_group24textNo
other_procedure_hcup_group25textNo
other_procedure_hcup_group26textNo
other_procedure_hcup_group27textNo
other_procedure_hcup_group28textNo
other_procedure_hcup_group29textNo
other_procedure_hcup_group30textNo
other_procedure_hcup_group_description1textNo
other_procedure_hcup_group_description2textNo
other_procedure_hcup_group_description3textNo
other_procedure_hcup_group_description4textNo
other_procedure_hcup_group_description5textNo
other_procedure_hcup_group_description6textNo
other_procedure_hcup_group_description7textNo
other_procedure_hcup_group_description8textNo
other_procedure_hcup_group_description9textNo
other_procedure_hcup_group_description10textNo
other_procedure_hcup_group_description11textNo
other_procedure_hcup_group_description12textNo
other_procedure_hcup_group_description13textNo
other_procedure_hcup_group_description14textNo
other_procedure_hcup_group_description15textNo
other_procedure_hcup_group_description16textNo
other_procedure_hcup_group_description17textNo
other_procedure_hcup_group_description18textNo
other_procedure_hcup_group_description19textNo
other_procedure_hcup_group_description20textNo
other_procedure_hcup_group_description21textNo
other_procedure_hcup_group_description22textNo
other_procedure_hcup_group_description23textNo
other_procedure_hcup_group_description24textNo
other_procedure_hcup_group_description25textNo
other_procedure_hcup_group_description26textNo
other_procedure_hcup_group_description27textNo
other_procedure_hcup_group_description28textNo
other_procedure_hcup_group_description29textNo
other_procedure_hcup_group_description30textNo
occurrence_code1textNo
occurrence_code2textNo
occurrence_code3textNo
occurrence_code4textNo
occurrence_code5textNo
occurrence_code6textNo
occurrence_code7textNo
occurrence_code8textNo
occurrence_code9textNo
occurrence_code10textNo
occurrence_code11textNo
occurrence_code12textNo
occurrence_code13textNo
occurrence_code14textNo
occurrence_code15textNo
occurrence_code16textNo
occurrence_code17textNo
occurrence_code18textNo
occurrence_code19textNo
occurrence_code20textNo
occurrence_code21textNo
occurrence_code22textNo
occurrence_code23textNo
occurrence_code24textNo
occurrence_code25textNo
occurrence_code26textNo
occurrence_code27textNo
occurrence_code28textNo
occurrence_code29textNo
occurrence_code30textNo
occurrence_start_date1dateNo
occurrence_start_date2dateNo
occurrence_start_date3dateNo
occurrence_start_date4dateNo
occurrence_start_date5dateNo
occurrence_start_date6dateNo
occurrence_start_date7dateNo
occurrence_start_date8dateNo
occurrence_start_date9dateNo
occurrence_start_date10dateNo
occurrence_start_date11dateNo
occurrence_start_date12dateNo
occurrence_start_date13dateNo
occurrence_start_date14dateNo
occurrence_start_date15dateNo
occurrence_start_date16dateNo
occurrence_start_date17dateNo
occurrence_start_date18dateNo
occurrence_start_date19dateNo
occurrence_start_date20dateNo
occurrence_start_date21dateNo
occurrence_start_date22dateNo
occurrence_start_date23dateNo
occurrence_start_date24dateNo
occurrence_start_date25dateNo
occurrence_start_date26dateNo
occurrence_start_date27dateNo
occurrence_start_date28dateNo
occurrence_start_date29dateNo
occurrence_start_date30dateNo
occurrence_end_date1dateNo
occurrence_end_date2dateNo
occurrence_end_date3dateNo
occurrence_end_date4dateNo
occurrence_end_date5dateNo
occurrence_end_date6dateNo
occurrence_end_date7dateNo
occurrence_end_date8dateNo
occurrence_end_date9dateNo
occurrence_end_date10dateNo
occurrence_end_date11dateNo
occurrence_end_date12dateNo
occurrence_end_date13dateNo
occurrence_end_date14dateNo
occurrence_end_date15dateNo
occurrence_end_date16dateNo
occurrence_end_date17dateNo
occurrence_end_date18dateNo
occurrence_end_date19dateNo
occurrence_end_date20dateNo
occurrence_end_date21dateNo
occurrence_end_date22dateNo
occurrence_end_date23dateNo
occurrence_end_date24dateNo
occurrence_end_date25dateNo
occurrence_end_date26dateNo
occurrence_end_date27dateNo
occurrence_end_date28dateNo
occurrence_end_date29dateNo
occurrence_end_date30dateNo
occurrence_description1textNo
occurrence_description2textNo
occurrence_description3textNo
occurrence_description4textNo
occurrence_description5textNo
occurrence_description6textNo
occurrence_description7textNo
occurrence_description8textNo
occurrence_description9textNo
occurrence_description10textNo
occurrence_description11textNo
occurrence_description12textNo
occurrence_description13textNo
occurrence_description14textNo
occurrence_description15textNo
occurrence_description16textNo
occurrence_description17textNo
occurrence_description18textNo
occurrence_description19textNo
occurrence_description20textNo
occurrence_description21textNo
occurrence_description22textNo
occurrence_description23textNo
occurrence_description24textNo
occurrence_description25textNo
occurrence_description26textNo
occurrence_description27textNo
occurrence_description28textNo
occurrence_description29textNo
occurrence_description30textNo
value_code1textNo
value_code2textNo
value_code3textNo
value_code4textNo
value_code5textNo
value_code6textNo
value_code7textNo
value_code8textNo
value_code9textNo
value_code10textNo
value_code11textNo
value_code12textNo
value_code13textNo
value_code14textNo
value_code15textNo
value_code16textNo
value_code17textNo
value_code18textNo
value_code19textNo
value_code20textNo
value_code21textNo
value_code22textNo
value_code23textNo
value_code24textNo
value_code25textNo
value_code26textNo
value_code27textNo
value_code28textNo
value_code29textNo
value_code30textNo
value_amount1textNo
value_amount2textNo
value_amount3textNo
value_amount4textNo
value_amount5textNo
value_amount6textNo
value_amount7textNo
value_amount8textNo
value_amount9textNo
value_amount10textNo
value_amount11textNo
value_amount12textNo
value_amount13textNo
value_amount14textNo
value_amount15textNo
value_amount16textNo
value_amount17textNo
value_amount18textNo
value_amount19textNo
value_amount20textNo
value_amount21textNo
value_amount22textNo
value_amount23textNo
value_amount24textNo
value_amount25textNo
value_amount26textNo
value_amount27textNo
value_amount28textNo
value_amount29textNo
value_amount30textNo
value_description1textNo
value_description2textNo
value_description3textNo
value_description4textNo
value_description5textNo
value_description6textNo
value_description7textNo
value_description8textNo
value_description9textNo
value_description10textNo
value_description11textNo
value_description12textNo
value_description13textNo
value_description14textNo
value_description15textNo
value_description16textNo
value_description17textNo
value_description18textNo
value_description19textNo
value_description20textNo
value_description21textNo
value_description22textNo
value_description23textNo
value_description24textNo
value_description25textNo
value_description26textNo
value_description27textNo
value_description28textNo
value_description29textNo
value_description30textNo
drg_codetextNo
grouped_drg_codetextNo
mdcsmallintNo
medical_or_surgicalmedical_or_surgical_typeNo
drg_descriptiontextNo
base_drg_descriptiontextNo
mdc_descriptiontextNo
payer_responsibility_sequencepayer_responsibility_sequence_typeNo
relationship_to_subscriberindividual_relationship_typeNo
group_or_policy_numbertextNo
group_nametextNo
insurance_typeinsurance_typeNo
claim_filing_indicatorclaim_filing_indicator_typeNo
member_subscriber_or_patient_idbigintNo
member_ssntextNo
member_identification_codetextNo
insurer_payer_idbigintNo
patient_subscriber_or_patient_idbigintNo
member_address_idbigintNo
member_date_of_birthdateNo
member_name_prefixtextNo
member_name_firsttextNo
member_name_middletextNo
member_name_lasttextNo
member_name_suffixtextNo
member_gender_or_sexgender_or_sex_typeNo
member_address1textNo
member_address2textNo
member_citytextNo
member_state_or_provincetextNo
member_postal_codetextNo
member_phone_numbertextNo
patient_name_prefixtextNo
patient_name_firsttextNo
patient_name_middletextNo
patient_name_lasttextNo
patient_name_suffixtextNo
patient_gender_or_sexgender_or_sex_typeNo
patient_address1textNo
patient_address2textNo
patient_citytextNo
patient_state_or_provincetextNo
patient_postal_codetextNo
patient_date_of_birthdateNo
patient_phone_numbertextNo
coverage_descriptiontextNo
coverage_levelcoverage_level_typeNo
benefit_begindateNo
benefit_enddateNo
plan_idbigintNo
plan_sponsor_idbigintNo
coverage_group_nametextNo
coverage_plan_nametextNo
insurance_lineinsurance_line_typeNo
plan_start_datedateNo
plan_end_datedateNo
plan_statusplan_status_typeNo
billprov_npibigintNo
billprov_tax_idtextNo
billprov_tpa_specialty_codetextNo
billprov_name_last_or_organizationtextNo
billprov_name_firsttextNo
billprov_name_middletextNo
billprov_name_prefixtextNo
billprov_name_suffixtextNo
billprov_taxonomytextNo