line_item_everything_view

Materialized: false

Definition

 SELECT c.claim_id,
    c.trading_partner_submission_id,
    c.usage_indicator,
    c.transaction_purpose,
    c.transaction_time,
    c.transaction_type,
    c.receiver_identifier_qualifier,
    c.receiver_identifier,
    c.submitter_identifier_qualifier,
    c.submitter_identifier,
    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_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.rx_patient_amount_paid_submitted,
    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.property_and_casualty_carrier_identifier,
    c.other_coverage_indicator,
    c.ambulance_patient_weight_units,
    c.ambulance_patient_weight_quantity,
    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_identifier,
    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,
    c.rx_authorization_number,
    c.rx_original_authorization_number,
    c.rx_bin,
    c.rx_processor_control_number,
    c.rx_facility_is_part_d_qualified,
    c.rx_billing_type,
    c.rx_transmission_accepted,
    c.rx_transaction_response_status,
    c.trading_partner_id,
    c.solution_id,
    c.external_solution_id,
    c.solution_name,
    c.principal_diagnosis,
    c.principal_diagnosis_description,
    c.principal_diagnosis_hcup_group,
    c.principal_diagnosis_hcup_group_description,
    c.other_diagnosis1,
    c.other_diagnosis2,
    c.other_diagnosis3,
    c.other_diagnosis4,
    c.other_diagnosis5,
    c.other_diagnosis6,
    c.other_diagnosis7,
    c.other_diagnosis8,
    c.other_diagnosis9,
    c.other_diagnosis10,
    c.other_diagnosis11,
    c.other_diagnosis12,
    c.other_diagnosis13,
    c.other_diagnosis14,
    c.other_diagnosis15,
    c.other_diagnosis16,
    c.other_diagnosis17,
    c.other_diagnosis18,
    c.other_diagnosis19,
    c.other_diagnosis20,
    c.other_diagnosis21,
    c.other_diagnosis22,
    c.other_diagnosis23,
    c.other_diagnosis24,
    c.other_diagnosis25,
    c.other_diagnosis26,
    c.other_diagnosis27,
    c.other_diagnosis28,
    c.other_diagnosis29,
    c.other_diagnosis30,
    c.other_diagnosis_description1,
    c.other_diagnosis_description2,
    c.other_diagnosis_description3,
    c.other_diagnosis_description4,
    c.other_diagnosis_description5,
    c.other_diagnosis_description6,
    c.other_diagnosis_description7,
    c.other_diagnosis_description8,
    c.other_diagnosis_description9,
    c.other_diagnosis_description10,
    c.other_diagnosis_description11,
    c.other_diagnosis_description12,
    c.other_diagnosis_description13,
    c.other_diagnosis_description14,
    c.other_diagnosis_description15,
    c.other_diagnosis_description16,
    c.other_diagnosis_description17,
    c.other_diagnosis_description18,
    c.other_diagnosis_description19,
    c.other_diagnosis_description20,
    c.other_diagnosis_description21,
    c.other_diagnosis_description22,
    c.other_diagnosis_description23,
    c.other_diagnosis_description24,
    c.other_diagnosis_description25,
    c.other_diagnosis_description26,
    c.other_diagnosis_description27,
    c.other_diagnosis_description28,
    c.other_diagnosis_description29,
    c.other_diagnosis_description30,
    c.other_diagnosis_hcup_group1,
    c.other_diagnosis_hcup_group2,
    c.other_diagnosis_hcup_group3,
    c.other_diagnosis_hcup_group4,
    c.other_diagnosis_hcup_group5,
    c.other_diagnosis_hcup_group6,
    c.other_diagnosis_hcup_group7,
    c.other_diagnosis_hcup_group8,
    c.other_diagnosis_hcup_group9,
    c.other_diagnosis_hcup_group10,
    c.other_diagnosis_hcup_group11,
    c.other_diagnosis_hcup_group12,
    c.other_diagnosis_hcup_group13,
    c.other_diagnosis_hcup_group14,
    c.other_diagnosis_hcup_group15,
    c.other_diagnosis_hcup_group16,
    c.other_diagnosis_hcup_group17,
    c.other_diagnosis_hcup_group18,
    c.other_diagnosis_hcup_group19,
    c.other_diagnosis_hcup_group20,
    c.other_diagnosis_hcup_group21,
    c.other_diagnosis_hcup_group22,
    c.other_diagnosis_hcup_group23,
    c.other_diagnosis_hcup_group24,
    c.other_diagnosis_hcup_group25,
    c.other_diagnosis_hcup_group26,
    c.other_diagnosis_hcup_group27,
    c.other_diagnosis_hcup_group28,
    c.other_diagnosis_hcup_group29,
    c.other_diagnosis_hcup_group30,
    c.other_diagnosis_hcup_group_description1,
    c.other_diagnosis_hcup_group_description2,
    c.other_diagnosis_hcup_group_description3,
    c.other_diagnosis_hcup_group_description4,
    c.other_diagnosis_hcup_group_description5,
    c.other_diagnosis_hcup_group_description6,
    c.other_diagnosis_hcup_group_description7,
    c.other_diagnosis_hcup_group_description8,
    c.other_diagnosis_hcup_group_description9,
    c.other_diagnosis_hcup_group_description10,
    c.other_diagnosis_hcup_group_description11,
    c.other_diagnosis_hcup_group_description12,
    c.other_diagnosis_hcup_group_description13,
    c.other_diagnosis_hcup_group_description14,
    c.other_diagnosis_hcup_group_description15,
    c.other_diagnosis_hcup_group_description16,
    c.other_diagnosis_hcup_group_description17,
    c.other_diagnosis_hcup_group_description18,
    c.other_diagnosis_hcup_group_description19,
    c.other_diagnosis_hcup_group_description20,
    c.other_diagnosis_hcup_group_description21,
    c.other_diagnosis_hcup_group_description22,
    c.other_diagnosis_hcup_group_description23,
    c.other_diagnosis_hcup_group_description24,
    c.other_diagnosis_hcup_group_description25,
    c.other_diagnosis_hcup_group_description26,
    c.other_diagnosis_hcup_group_description27,
    c.other_diagnosis_hcup_group_description28,
    c.other_diagnosis_hcup_group_description29,
    c.other_diagnosis_hcup_group_description30,
    c.principal_procedure,
    c.principal_procedure_description,
    c.principal_procedure_hcup_group,
    c.principal_procedure_hcup_group_description,
    c.other_procedure1,
    c.other_procedure2,
    c.other_procedure3,
    c.other_procedure4,
    c.other_procedure5,
    c.other_procedure6,
    c.other_procedure7,
    c.other_procedure8,
    c.other_procedure9,
    c.other_procedure10,
    c.other_procedure11,
    c.other_procedure12,
    c.other_procedure13,
    c.other_procedure14,
    c.other_procedure15,
    c.other_procedure16,
    c.other_procedure17,
    c.other_procedure18,
    c.other_procedure19,
    c.other_procedure20,
    c.other_procedure21,
    c.other_procedure22,
    c.other_procedure23,
    c.other_procedure24,
    c.other_procedure25,
    c.other_procedure26,
    c.other_procedure27,
    c.other_procedure28,
    c.other_procedure29,
    c.other_procedure30,
    c.other_procedure_description1,
    c.other_procedure_description2,
    c.other_procedure_description3,
    c.other_procedure_description4,
    c.other_procedure_description5,
    c.other_procedure_description6,
    c.other_procedure_description7,
    c.other_procedure_description8,
    c.other_procedure_description9,
    c.other_procedure_description10,
    c.other_procedure_description11,
    c.other_procedure_description12,
    c.other_procedure_description13,
    c.other_procedure_description14,
    c.other_procedure_description15,
    c.other_procedure_description16,
    c.other_procedure_description17,
    c.other_procedure_description18,
    c.other_procedure_description19,
    c.other_procedure_description20,
    c.other_procedure_description21,
    c.other_procedure_description22,
    c.other_procedure_description23,
    c.other_procedure_description24,
    c.other_procedure_description25,
    c.other_procedure_description26,
    c.other_procedure_description27,
    c.other_procedure_description28,
    c.other_procedure_description29,
    c.other_procedure_description30,
    c.other_procedure_hcup_group1,
    c.other_procedure_hcup_group2,
    c.other_procedure_hcup_group3,
    c.other_procedure_hcup_group4,
    c.other_procedure_hcup_group5,
    c.other_procedure_hcup_group6,
    c.other_procedure_hcup_group7,
    c.other_procedure_hcup_group8,
    c.other_procedure_hcup_group9,
    c.other_procedure_hcup_group10,
    c.other_procedure_hcup_group11,
    c.other_procedure_hcup_group12,
    c.other_procedure_hcup_group13,
    c.other_procedure_hcup_group14,
    c.other_procedure_hcup_group15,
    c.other_procedure_hcup_group16,
    c.other_procedure_hcup_group17,
    c.other_procedure_hcup_group18,
    c.other_procedure_hcup_group19,
    c.other_procedure_hcup_group20,
    c.other_procedure_hcup_group21,
    c.other_procedure_hcup_group22,
    c.other_procedure_hcup_group23,
    c.other_procedure_hcup_group24,
    c.other_procedure_hcup_group25,
    c.other_procedure_hcup_group26,
    c.other_procedure_hcup_group27,
    c.other_procedure_hcup_group28,
    c.other_procedure_hcup_group29,
    c.other_procedure_hcup_group30,
    c.other_procedure_hcup_group_description1,
    c.other_procedure_hcup_group_description2,
    c.other_procedure_hcup_group_description3,
    c.other_procedure_hcup_group_description4,
    c.other_procedure_hcup_group_description5,
    c.other_procedure_hcup_group_description6,
    c.other_procedure_hcup_group_description7,
    c.other_procedure_hcup_group_description8,
    c.other_procedure_hcup_group_description9,
    c.other_procedure_hcup_group_description10,
    c.other_procedure_hcup_group_description11,
    c.other_procedure_hcup_group_description12,
    c.other_procedure_hcup_group_description13,
    c.other_procedure_hcup_group_description14,
    c.other_procedure_hcup_group_description15,
    c.other_procedure_hcup_group_description16,
    c.other_procedure_hcup_group_description17,
    c.other_procedure_hcup_group_description18,
    c.other_procedure_hcup_group_description19,
    c.other_procedure_hcup_group_description20,
    c.other_procedure_hcup_group_description21,
    c.other_procedure_hcup_group_description22,
    c.other_procedure_hcup_group_description23,
    c.other_procedure_hcup_group_description24,
    c.other_procedure_hcup_group_description25,
    c.other_procedure_hcup_group_description26,
    c.other_procedure_hcup_group_description27,
    c.other_procedure_hcup_group_description28,
    c.other_procedure_hcup_group_description29,
    c.other_procedure_hcup_group_description30,
    c.occurrence_code1,
    c.occurrence_code2,
    c.occurrence_code3,
    c.occurrence_code4,
    c.occurrence_code5,
    c.occurrence_code6,
    c.occurrence_code7,
    c.occurrence_code8,
    c.occurrence_code9,
    c.occurrence_code10,
    c.occurrence_code11,
    c.occurrence_code12,
    c.occurrence_code13,
    c.occurrence_code14,
    c.occurrence_code15,
    c.occurrence_code16,
    c.occurrence_code17,
    c.occurrence_code18,
    c.occurrence_code19,
    c.occurrence_code20,
    c.occurrence_code21,
    c.occurrence_code22,
    c.occurrence_code23,
    c.occurrence_code24,
    c.occurrence_code25,
    c.occurrence_code26,
    c.occurrence_code27,
    c.occurrence_code28,
    c.occurrence_code29,
    c.occurrence_code30,
    c.occurrence_date1,
    c.occurrence_date2,
    c.occurrence_date3,
    c.occurrence_date4,
    c.occurrence_date5,
    c.occurrence_date6,
    c.occurrence_date7,
    c.occurrence_date8,
    c.occurrence_date9,
    c.occurrence_date10,
    c.occurrence_date11,
    c.occurrence_date12,
    c.occurrence_date13,
    c.occurrence_date14,
    c.occurrence_date15,
    c.occurrence_date16,
    c.occurrence_date17,
    c.occurrence_date18,
    c.occurrence_date19,
    c.occurrence_date20,
    c.occurrence_date21,
    c.occurrence_date22,
    c.occurrence_date23,
    c.occurrence_date24,
    c.occurrence_date25,
    c.occurrence_date26,
    c.occurrence_date27,
    c.occurrence_date28,
    c.occurrence_date29,
    c.occurrence_date30,
    c.occurrence_description1,
    c.occurrence_description2,
    c.occurrence_description3,
    c.occurrence_description4,
    c.occurrence_description5,
    c.occurrence_description6,
    c.occurrence_description7,
    c.occurrence_description8,
    c.occurrence_description9,
    c.occurrence_description10,
    c.occurrence_description11,
    c.occurrence_description12,
    c.occurrence_description13,
    c.occurrence_description14,
    c.occurrence_description15,
    c.occurrence_description16,
    c.occurrence_description17,
    c.occurrence_description18,
    c.occurrence_description19,
    c.occurrence_description20,
    c.occurrence_description21,
    c.occurrence_description22,
    c.occurrence_description23,
    c.occurrence_description24,
    c.occurrence_description25,
    c.occurrence_description26,
    c.occurrence_description27,
    c.occurrence_description28,
    c.occurrence_description29,
    c.occurrence_description30,
    c.value_code1,
    c.value_code2,
    c.value_code3,
    c.value_code4,
    c.value_code5,
    c.value_code6,
    c.value_code7,
    c.value_code8,
    c.value_code9,
    c.value_code10,
    c.value_code11,
    c.value_code12,
    c.value_code13,
    c.value_code14,
    c.value_code15,
    c.value_code16,
    c.value_code17,
    c.value_code18,
    c.value_code19,
    c.value_code20,
    c.value_code21,
    c.value_code22,
    c.value_code23,
    c.value_code24,
    c.value_code25,
    c.value_code26,
    c.value_code27,
    c.value_code28,
    c.value_code29,
    c.value_code30,
    c.value_amount1,
    c.value_amount2,
    c.value_amount3,
    c.value_amount4,
    c.value_amount5,
    c.value_amount6,
    c.value_amount7,
    c.value_amount8,
    c.value_amount9,
    c.value_amount10,
    c.value_amount11,
    c.value_amount12,
    c.value_amount13,
    c.value_amount14,
    c.value_amount15,
    c.value_amount16,
    c.value_amount17,
    c.value_amount18,
    c.value_amount19,
    c.value_amount20,
    c.value_amount21,
    c.value_amount22,
    c.value_amount23,
    c.value_amount24,
    c.value_amount25,
    c.value_amount26,
    c.value_amount27,
    c.value_amount28,
    c.value_amount29,
    c.value_amount30,
    c.value_description1,
    c.value_description2,
    c.value_description3,
    c.value_description4,
    c.value_description5,
    c.value_description6,
    c.value_description7,
    c.value_description8,
    c.value_description9,
    c.value_description10,
    c.value_description11,
    c.value_description12,
    c.value_description13,
    c.value_description14,
    c.value_description15,
    c.value_description16,
    c.value_description17,
    c.value_description18,
    c.value_description19,
    c.value_description20,
    c.value_description21,
    c.value_description22,
    c.value_description23,
    c.value_description24,
    c.value_description25,
    c.value_description26,
    c.value_description27,
    c.value_description28,
    c.value_description29,
    c.value_description30,
    c.drg_code,
    c.grouped_drg_code,
    c.mdc,
    c.medical_or_surgical,
    c.drg_description,
    c.base_drg_description,
    c.mdc_description,
    c.payer_responsibility_sequence,
    c.relationship_to_subscriber,
    c.group_or_policy_number,
    c.group_name,
    c.insurance_type,
    c.claim_filing_indicator,
    c.member_subscriber_or_patient_id,
    c.member_ssn,
    c.member_identification_code,
    c.insurer_payer_id,
    c.patient_subscriber_or_patient_id,
    c.member_address_id,
    c.member_date_of_birth,
    c.member_name_prefix,
    c.member_name_first,
    c.member_name_middle,
    c.member_name_last,
    c.member_name_suffix,
    c.member_gender_or_sex,
    c.member_address1,
    c.member_address2,
    c.member_city,
    c.member_state_or_province,
    c.member_postal_code,
    c.member_phone_number,
    c.patient_name_prefix,
    c.patient_name_first,
    c.patient_name_middle,
    c.patient_name_last,
    c.patient_name_suffix,
    c.patient_gender_or_sex,
    c.patient_address1,
    c.patient_address2,
    c.patient_city,
    c.patient_state_or_province,
    c.patient_postal_code,
    c.patient_date_of_birth,
    c.patient_phone_number,
    c.member_canonical_id_chosen,
    c.coverage_description,
    c.coverage_level,
    c.benefit_begin,
    c.benefit_end,
    c.plan_id,
    c.plan_sponsor_id,
    c.coverage_group_name,
    c.coverage_plan_name,
    c.insurance_line,
    c.plan_start_date,
    c.plan_end_date,
    c.plan_status,
    c.billprov_npi,
    c.billprov_tax_identifier,
    c.billprov_tpa_specialty_code,
    c.billprov_name_last_or_organization,
    c.billprov_name_first,
    c.billprov_name_middle,
    c.billprov_name_prefix,
    c.billprov_name_suffix,
    c.billprov_taxonomy,
    l.line_item_id,
    l.line_number,
    l.rev_code,
    l.revenue_code_title,
    l.revenue_code_group_title,
    l.product_service_code_qualifier,
    l.product_service_code,
    l.procedure_modifiers,
    l.procedure_description,
    l.product_service_long_description,
    l.product_service_short_description,
    l.product_service_medium_description,
    l.product_service_consumer_friendly_description,
    l.hcup_hcpcs_group_code,
    l.hcup_hcpcs_group_description,
    l.billed_amount,
    l.quantity,
    l.units,
    l.place_of_service,
    l.service_date_from AS line_item_service_date_from,
    l.service_date_through AS line_item_service_date_through,
    l.line_item_provider_control_number,
    l.line_item_prior_authorization_number,
    l.tpa_network_identifier,
    l.tpa_network_name,
    l.tpa_network_status,
    l.payment_limit,
    l.billed_adjustment,
    l.allowed_amount,
    l.not_covered_amount,
    l.allowed_adjustment_amount,
    l.plan_payment_amount,
    l.cob_paid_amount,
    l.copay_amount,
    l.coinsurance_amount,
    l.deductible_amount,
    l.payment_identification_code,
    l.payment_method_type,
    l.payment_date,
    l.payment_to_provider,
    l.payment_to_member
   FROM claims.claim_validation_wide_view c
     LEFT JOIN claims.line_item_view l ON l.claim_id = c.claim_id;

Column	Data Type	Indexed
claim_id	bigint	No
trading_partner_submission_id	bigint	No
usage_indicator	usage_indicator_type	No
transaction_purpose	transaction_set_purpose_type	No
transaction_time	timestamp	No
transaction_type	transaction_type	No
receiver_identifier_qualifier	identification_type	No
receiver_identifier	text	No
submitter_identifier_qualifier	identification_type	No
submitter_identifier	text	No
submitter_name	text	No
pay_to_plan_id	bigint	No
claim_member_id	bigint	No
patient_death_date	date	No
patient_weight_units	unit_type	No
patient_weight_quantity	numeric	No
patient_is_pregnant	boolean	No
tpa_adjudication_method	adjudication_method_type	No
tpa_claim_status	text	No
patient_control_number	text	No
claim_billed_amount	numeric	No
facility_type	text	No
claim_type	claim_type	No
form_type	form_type	No
claim_frequency_type	text	No
provider_signature_on_file	yes_no_response_type	No
provider_accept_assignment	provider_accept_assignment_type	No
patient_assigned_benefits	yes_no_response_type	No
release_of_information	release_of_information_type	No
patient_signature_source	patient_signature_source_type	No
related_causes	related_cause_type[]	No
auto_accident_state	text	No
auto_accident_country	text	No
special_program	special_program_type	No
claim_submission_reason	claim_submission_reason_type	No
delay_reason	delay_reason_type	No
earliest_service_date	date	No
latest_service_date	date	No
statement_date_from	date	No
statement_date_through	date	No
admit_date_or_datetime	timestamp	No
discharge_date_or_hour	timestamp	No
initial_treatment_date	date	No
onset_of_symptoms_or_illness_date	date	No
accident_date	date	No
last_seen_date	date	No
repricer_received_date	date	No
acute_manifestation_date	date	No
last_menstrual_period_date	date	No
last_x_ray_date	date	No
prescription_date	date	No
disability_start_date	date	No
disability_end_date	date	No
last_worked_date	date	No
return_to_work_date	date	No
assumed_care_start	date	No
relinquished_care_date	date	No
first_visit_or_consultation_date	date	No
tpa_received_date	date	No
service_date_from	date	No
service_date_through	date	No
appliance_placement_date	date	No
facility_admission_type	text	No
facility_admission_source	text	No
facility_patient_status	text	No
orthodontic_treatment_months_total	numeric	No
orthodontic_treatment_months_remaining	numeric	No
orthodontic_treatment_indicator	text	No
contract_type	contract_type	No
contract_amount	numeric	No
contract_billed_percentage	numeric	No
contract_identification_code	text	No
contract_terms_discount_percent	numeric	No
contract_version_identifier	text	No
patient_amount_paid	numeric	No
rx_patient_amount_paid_submitted	numeric	No
estimated_patient_responsibility	numeric	No
predetermination_of_benefits_identifier	text	No
service_authorization_exception_code	text	No
mandatory_medicare_crossover_indicator	text	No
mammography_certification_number	text	No
referral_number	text	No
claim_number	text	No
payer_claim_number	text	No
repriced_claim_number	text	No
adjusted_repriced_claim_number	text	No
investigational_device_exemption_number	text	No
medical_record_number	text	No
demonstration_project_identifier	text	No
care_plan_oversight_number	text	No
its_number	text	No
icn_number	text	No
prior_authorization_number	text	No
clia_number	text	No
peer_review_organization_approval_number	text	No
property_and_casualty_claim_number	text	No
property_and_casualty_carrier_identifier	text	No
other_coverage_indicator	text	No
ambulance_patient_weight_units	unit_type	No
ambulance_patient_weight_quantity	numeric	No
ambulance_transport_reason	ambulance_transport_reason_type	No
ambulance_transport_distance_units	unit_type	No
ambulance_transport_distance_quantity	numeric	No
ambulance_round_trip_purpose_description	text	No
ambulance_stretcher_purpose_description	text	No
ambulance_patient_count	smallint	No
ambulance_pickup_zip_from_value_code	text	No
ambulance_pickup_address_id	bigint	No
ambulance_dropoff_address_id	bigint	No
ambulance_applicable_conditions	condition_indicator_type[]	No
ambulance_not_applicable_conditions	condition_indicator_type[]	No
spinal_manipulation_condition	nature_of_condition_type	No
spinal_manipulation_patient_condition_note1	text	No
spinal_manipulation_patient_condition_note2	text	No
dme_certification_type	certification_type	No
dme_need_duration_units	unit_type	No
dme_need_duration_quantity	numeric	No
dme_applicable_conditions	condition_indicator_type[]	No
dme_not_applicable_conditions	condition_indicator_type[]	No
vision_spectacle_lenses_applicable_conditions	condition_indicator_type[]	No
vision_spectacle_lenses_not_applicable_conditions	condition_indicator_type[]	No
vision_spectacle_frames_applicable_conditions	condition_indicator_type[]	No
vision_spectacle_frames_not_applicable_conditions	condition_indicator_type[]	No
vision_contacts_applicable_conditions	condition_indicator_type[]	No
vision_contacts_not_applicable_conditions	condition_indicator_type[]	No
is_homebound	boolean	No
epsdt_referral_applicable_conditions	condition_indicator_type[]	No
epsdt_referral_not_applicable_conditions	condition_indicator_type[]	No
condition_codes	text[]	No
reprice_methodology	pricing_methodology_type	No
reprice_allowed_amount	numeric	No
reprice_savings_amount	numeric	No
reprice_organization_identifier	text	No
reprice_per_diem_or_flat_rate_amount	numeric	No
reprice_approved_drg_or_apg_code	text	No
reprice_approved_drg_or_apg_amount	numeric	No
reprice_approved_revenue_code	text	No
reprice_approved_units	unit_type	No
reprice_approved_quantity	numeric	No
reprice_reject_reason	reject_reason_type	No
reprice_policy_compliance	policy_compliance_type	No
reprice_exception	repricing_exception_type	No
data_errors	text[]	No
rx_authorization_number	text	No
rx_original_authorization_number	text	No
rx_bin	text	No
rx_processor_control_number	text	No
rx_facility_is_part_d_qualified	boolean	No
rx_billing_type	rx_billing_type	No
rx_transmission_accepted	boolean	No
rx_transaction_response_status	rx_transaction_response_status_type	No
trading_partner_id	bigint	No
solution_id	bigint	No
external_solution_id	text	No
solution_name	text	No
principal_diagnosis	text	No
principal_diagnosis_description	text	No
principal_diagnosis_hcup_group	text	No
principal_diagnosis_hcup_group_description	text	No
other_diagnosis1	text	No
other_diagnosis2	text	No
other_diagnosis3	text	No
other_diagnosis4	text	No
other_diagnosis5	text	No
other_diagnosis6	text	No
other_diagnosis7	text	No
other_diagnosis8	text	No
other_diagnosis9	text	No
other_diagnosis10	text	No
other_diagnosis11	text	No
other_diagnosis12	text	No
other_diagnosis13	text	No
other_diagnosis14	text	No
other_diagnosis15	text	No
other_diagnosis16	text	No
other_diagnosis17	text	No
other_diagnosis18	text	No
other_diagnosis19	text	No
other_diagnosis20	text	No
other_diagnosis21	text	No
other_diagnosis22	text	No
other_diagnosis23	text	No
other_diagnosis24	text	No
other_diagnosis25	text	No
other_diagnosis26	text	No
other_diagnosis27	text	No
other_diagnosis28	text	No
other_diagnosis29	text	No
other_diagnosis30	text	No
other_diagnosis_description1	text	No
other_diagnosis_description2	text	No
other_diagnosis_description3	text	No
other_diagnosis_description4	text	No
other_diagnosis_description5	text	No
other_diagnosis_description6	text	No
other_diagnosis_description7	text	No
other_diagnosis_description8	text	No
other_diagnosis_description9	text	No
other_diagnosis_description10	text	No
other_diagnosis_description11	text	No
other_diagnosis_description12	text	No
other_diagnosis_description13	text	No
other_diagnosis_description14	text	No
other_diagnosis_description15	text	No
other_diagnosis_description16	text	No
other_diagnosis_description17	text	No
other_diagnosis_description18	text	No
other_diagnosis_description19	text	No
other_diagnosis_description20	text	No
other_diagnosis_description21	text	No
other_diagnosis_description22	text	No
other_diagnosis_description23	text	No
other_diagnosis_description24	text	No
other_diagnosis_description25	text	No
other_diagnosis_description26	text	No
other_diagnosis_description27	text	No
other_diagnosis_description28	text	No
other_diagnosis_description29	text	No
other_diagnosis_description30	text	No
other_diagnosis_hcup_group1	text	No
other_diagnosis_hcup_group2	text	No
other_diagnosis_hcup_group3	text	No
other_diagnosis_hcup_group4	text	No
other_diagnosis_hcup_group5	text	No
other_diagnosis_hcup_group6	text	No
other_diagnosis_hcup_group7	text	No
other_diagnosis_hcup_group8	text	No
other_diagnosis_hcup_group9	text	No
other_diagnosis_hcup_group10	text	No
other_diagnosis_hcup_group11	text	No
other_diagnosis_hcup_group12	text	No
other_diagnosis_hcup_group13	text	No
other_diagnosis_hcup_group14	text	No
other_diagnosis_hcup_group15	text	No
other_diagnosis_hcup_group16	text	No
other_diagnosis_hcup_group17	text	No
other_diagnosis_hcup_group18	text	No
other_diagnosis_hcup_group19	text	No
other_diagnosis_hcup_group20	text	No
other_diagnosis_hcup_group21	text	No
other_diagnosis_hcup_group22	text	No
other_diagnosis_hcup_group23	text	No
other_diagnosis_hcup_group24	text	No
other_diagnosis_hcup_group25	text	No
other_diagnosis_hcup_group26	text	No
other_diagnosis_hcup_group27	text	No
other_diagnosis_hcup_group28	text	No
other_diagnosis_hcup_group29	text	No
other_diagnosis_hcup_group30	text	No
other_diagnosis_hcup_group_description1	text	No
other_diagnosis_hcup_group_description2	text	No
other_diagnosis_hcup_group_description3	text	No
other_diagnosis_hcup_group_description4	text	No
other_diagnosis_hcup_group_description5	text	No
other_diagnosis_hcup_group_description6	text	No
other_diagnosis_hcup_group_description7	text	No
other_diagnosis_hcup_group_description8	text	No
other_diagnosis_hcup_group_description9	text	No
other_diagnosis_hcup_group_description10	text	No
other_diagnosis_hcup_group_description11	text	No
other_diagnosis_hcup_group_description12	text	No
other_diagnosis_hcup_group_description13	text	No
other_diagnosis_hcup_group_description14	text	No
other_diagnosis_hcup_group_description15	text	No
other_diagnosis_hcup_group_description16	text	No
other_diagnosis_hcup_group_description17	text	No
other_diagnosis_hcup_group_description18	text	No
other_diagnosis_hcup_group_description19	text	No
other_diagnosis_hcup_group_description20	text	No
other_diagnosis_hcup_group_description21	text	No
other_diagnosis_hcup_group_description22	text	No
other_diagnosis_hcup_group_description23	text	No
other_diagnosis_hcup_group_description24	text	No
other_diagnosis_hcup_group_description25	text	No
other_diagnosis_hcup_group_description26	text	No
other_diagnosis_hcup_group_description27	text	No
other_diagnosis_hcup_group_description28	text	No
other_diagnosis_hcup_group_description29	text	No
other_diagnosis_hcup_group_description30	text	No
principal_procedure	text	No
principal_procedure_description	text	No
principal_procedure_hcup_group	text	No
principal_procedure_hcup_group_description	text	No
other_procedure1	text	No
other_procedure2	text	No
other_procedure3	text	No
other_procedure4	text	No
other_procedure5	text	No
other_procedure6	text	No
other_procedure7	text	No
other_procedure8	text	No
other_procedure9	text	No
other_procedure10	text	No
other_procedure11	text	No
other_procedure12	text	No
other_procedure13	text	No
other_procedure14	text	No
other_procedure15	text	No
other_procedure16	text	No
other_procedure17	text	No
other_procedure18	text	No
other_procedure19	text	No
other_procedure20	text	No
other_procedure21	text	No
other_procedure22	text	No
other_procedure23	text	No
other_procedure24	text	No
other_procedure25	text	No
other_procedure26	text	No
other_procedure27	text	No
other_procedure28	text	No
other_procedure29	text	No
other_procedure30	text	No
other_procedure_description1	text	No
other_procedure_description2	text	No
other_procedure_description3	text	No
other_procedure_description4	text	No
other_procedure_description5	text	No
other_procedure_description6	text	No
other_procedure_description7	text	No
other_procedure_description8	text	No
other_procedure_description9	text	No
other_procedure_description10	text	No
other_procedure_description11	text	No
other_procedure_description12	text	No
other_procedure_description13	text	No
other_procedure_description14	text	No
other_procedure_description15	text	No
other_procedure_description16	text	No
other_procedure_description17	text	No
other_procedure_description18	text	No
other_procedure_description19	text	No
other_procedure_description20	text	No
other_procedure_description21	text	No
other_procedure_description22	text	No
other_procedure_description23	text	No
other_procedure_description24	text	No
other_procedure_description25	text	No
other_procedure_description26	text	No
other_procedure_description27	text	No
other_procedure_description28	text	No
other_procedure_description29	text	No
other_procedure_description30	text	No
other_procedure_hcup_group1	text	No
other_procedure_hcup_group2	text	No
other_procedure_hcup_group3	text	No
other_procedure_hcup_group4	text	No
other_procedure_hcup_group5	text	No
other_procedure_hcup_group6	text	No
other_procedure_hcup_group7	text	No
other_procedure_hcup_group8	text	No
other_procedure_hcup_group9	text	No
other_procedure_hcup_group10	text	No
other_procedure_hcup_group11	text	No
other_procedure_hcup_group12	text	No
other_procedure_hcup_group13	text	No
other_procedure_hcup_group14	text	No
other_procedure_hcup_group15	text	No
other_procedure_hcup_group16	text	No
other_procedure_hcup_group17	text	No
other_procedure_hcup_group18	text	No
other_procedure_hcup_group19	text	No
other_procedure_hcup_group20	text	No
other_procedure_hcup_group21	text	No
other_procedure_hcup_group22	text	No
other_procedure_hcup_group23	text	No
other_procedure_hcup_group24	text	No
other_procedure_hcup_group25	text	No
other_procedure_hcup_group26	text	No
other_procedure_hcup_group27	text	No
other_procedure_hcup_group28	text	No
other_procedure_hcup_group29	text	No
other_procedure_hcup_group30	text	No
other_procedure_hcup_group_description1	text	No
other_procedure_hcup_group_description2	text	No
other_procedure_hcup_group_description3	text	No
other_procedure_hcup_group_description4	text	No
other_procedure_hcup_group_description5	text	No
other_procedure_hcup_group_description6	text	No
other_procedure_hcup_group_description7	text	No
other_procedure_hcup_group_description8	text	No
other_procedure_hcup_group_description9	text	No
other_procedure_hcup_group_description10	text	No
other_procedure_hcup_group_description11	text	No
other_procedure_hcup_group_description12	text	No
other_procedure_hcup_group_description13	text	No
other_procedure_hcup_group_description14	text	No
other_procedure_hcup_group_description15	text	No
other_procedure_hcup_group_description16	text	No
other_procedure_hcup_group_description17	text	No
other_procedure_hcup_group_description18	text	No
other_procedure_hcup_group_description19	text	No
other_procedure_hcup_group_description20	text	No
other_procedure_hcup_group_description21	text	No
other_procedure_hcup_group_description22	text	No
other_procedure_hcup_group_description23	text	No
other_procedure_hcup_group_description24	text	No
other_procedure_hcup_group_description25	text	No
other_procedure_hcup_group_description26	text	No
other_procedure_hcup_group_description27	text	No
other_procedure_hcup_group_description28	text	No
other_procedure_hcup_group_description29	text	No
other_procedure_hcup_group_description30	text	No
occurrence_code1	text	No
occurrence_code2	text	No
occurrence_code3	text	No
occurrence_code4	text	No
occurrence_code5	text	No
occurrence_code6	text	No
occurrence_code7	text	No
occurrence_code8	text	No
occurrence_code9	text	No
occurrence_code10	text	No
occurrence_code11	text	No
occurrence_code12	text	No
occurrence_code13	text	No
occurrence_code14	text	No
occurrence_code15	text	No
occurrence_code16	text	No
occurrence_code17	text	No
occurrence_code18	text	No
occurrence_code19	text	No
occurrence_code20	text	No
occurrence_code21	text	No
occurrence_code22	text	No
occurrence_code23	text	No
occurrence_code24	text	No
occurrence_code25	text	No
occurrence_code26	text	No
occurrence_code27	text	No
occurrence_code28	text	No
occurrence_code29	text	No
occurrence_code30	text	No
occurrence_date1	date	No
occurrence_date2	date	No
occurrence_date3	date	No
occurrence_date4	date	No
occurrence_date5	date	No
occurrence_date6	date	No
occurrence_date7	date	No
occurrence_date8	date	No
occurrence_date9	date	No
occurrence_date10	date	No
occurrence_date11	date	No
occurrence_date12	date	No
occurrence_date13	date	No
occurrence_date14	date	No
occurrence_date15	date	No
occurrence_date16	date	No
occurrence_date17	date	No
occurrence_date18	date	No
occurrence_date19	date	No
occurrence_date20	date	No
occurrence_date21	date	No
occurrence_date22	date	No
occurrence_date23	date	No
occurrence_date24	date	No
occurrence_date25	date	No
occurrence_date26	date	No
occurrence_date27	date	No
occurrence_date28	date	No
occurrence_date29	date	No
occurrence_date30	date	No
occurrence_description1	text	No
occurrence_description2	text	No
occurrence_description3	text	No
occurrence_description4	text	No
occurrence_description5	text	No
occurrence_description6	text	No
occurrence_description7	text	No
occurrence_description8	text	No
occurrence_description9	text	No
occurrence_description10	text	No
occurrence_description11	text	No
occurrence_description12	text	No
occurrence_description13	text	No
occurrence_description14	text	No
occurrence_description15	text	No
occurrence_description16	text	No
occurrence_description17	text	No
occurrence_description18	text	No
occurrence_description19	text	No
occurrence_description20	text	No
occurrence_description21	text	No
occurrence_description22	text	No
occurrence_description23	text	No
occurrence_description24	text	No
occurrence_description25	text	No
occurrence_description26	text	No
occurrence_description27	text	No
occurrence_description28	text	No
occurrence_description29	text	No
occurrence_description30	text	No
value_code1	text	No
value_code2	text	No
value_code3	text	No
value_code4	text	No
value_code5	text	No
value_code6	text	No
value_code7	text	No
value_code8	text	No
value_code9	text	No
value_code10	text	No
value_code11	text	No
value_code12	text	No
value_code13	text	No
value_code14	text	No
value_code15	text	No
value_code16	text	No
value_code17	text	No
value_code18	text	No
value_code19	text	No
value_code20	text	No
value_code21	text	No
value_code22	text	No
value_code23	text	No
value_code24	text	No
value_code25	text	No
value_code26	text	No
value_code27	text	No
value_code28	text	No
value_code29	text	No
value_code30	text	No
value_amount1	text	No
value_amount2	text	No
value_amount3	text	No
value_amount4	text	No
value_amount5	text	No
value_amount6	text	No
value_amount7	text	No
value_amount8	text	No
value_amount9	text	No
value_amount10	text	No
value_amount11	text	No
value_amount12	text	No
value_amount13	text	No
value_amount14	text	No
value_amount15	text	No
value_amount16	text	No
value_amount17	text	No
value_amount18	text	No
value_amount19	text	No
value_amount20	text	No
value_amount21	text	No
value_amount22	text	No
value_amount23	text	No
value_amount24	text	No
value_amount25	text	No
value_amount26	text	No
value_amount27	text	No
value_amount28	text	No
value_amount29	text	No
value_amount30	text	No
value_description1	text	No
value_description2	text	No
value_description3	text	No
value_description4	text	No
value_description5	text	No
value_description6	text	No
value_description7	text	No
value_description8	text	No
value_description9	text	No
value_description10	text	No
value_description11	text	No
value_description12	text	No
value_description13	text	No
value_description14	text	No
value_description15	text	No
value_description16	text	No
value_description17	text	No
value_description18	text	No
value_description19	text	No
value_description20	text	No
value_description21	text	No
value_description22	text	No
value_description23	text	No
value_description24	text	No
value_description25	text	No
value_description26	text	No
value_description27	text	No
value_description28	text	No
value_description29	text	No
value_description30	text	No
drg_code	text	No
grouped_drg_code	text	No
mdc	smallint	No
medical_or_surgical	medical_or_surgical_type	No
drg_description	text	No
base_drg_description	text	No
mdc_description	text	No
payer_responsibility_sequence	payer_responsibility_sequence_type	No
relationship_to_subscriber	individual_relationship_type	No
group_or_policy_number	text	No
group_name	text	No
insurance_type	insurance_type	No
claim_filing_indicator	claim_filing_indicator_type	No
member_subscriber_or_patient_id	bigint	No
member_ssn	text	No
member_identification_code	text	No
insurer_payer_id	bigint	No
patient_subscriber_or_patient_id	bigint	No
member_address_id	bigint	No
member_date_of_birth	date	No
member_name_prefix	text	No
member_name_first	text	No
member_name_middle	text	No
member_name_last	text	No
member_name_suffix	text	No
member_gender_or_sex	gender_or_sex_type	No
member_address1	text	No
member_address2	text	No
member_city	text	No
member_state_or_province	text	No
member_postal_code	text	No
member_phone_number	text	No
patient_name_prefix	text	No
patient_name_first	text	No
patient_name_middle	text	No
patient_name_last	text	No
patient_name_suffix	text	No
patient_gender_or_sex	gender_or_sex_type	No
patient_address1	text	No
patient_address2	text	No
patient_city	text	No
patient_state_or_province	text	No
patient_postal_code	text	No
patient_date_of_birth	date	No
patient_phone_number	text	No
member_canonical_id_chosen	bigint	No
coverage_description	text	No
coverage_level	coverage_level_type	No
benefit_begin	date	No
benefit_end	date	No
plan_id	bigint	No
plan_sponsor_id	bigint	No
coverage_group_name	text	No
coverage_plan_name	text	No
insurance_line	insurance_line_type	No
plan_start_date	date	No
plan_end_date	date	No
plan_status	plan_status_type	No
billprov_npi	bigint	No
billprov_tax_identifier	text	No
billprov_tpa_specialty_code	text	No
billprov_name_last_or_organization	text	No
billprov_name_first	text	No
billprov_name_middle	text	No
billprov_name_prefix	text	No
billprov_name_suffix	text	No
billprov_taxonomy	text	No
line_item_id	bigint	No
line_number	text	No
rev_code	text	No
revenue_code_title	text	No
revenue_code_group_title	text	No
product_service_code_qualifier	product_service_code_type	No
product_service_code	text	No
procedure_modifiers	text[]	No
procedure_description	text	No
product_service_long_description	text	No
product_service_short_description	text	No
product_service_medium_description	text	No
product_service_consumer_friendly_description	text	No
hcup_hcpcs_group_code	smallint	No
hcup_hcpcs_group_description	text	No
billed_amount	numeric	No
quantity	numeric	No
units	text	No
place_of_service	text	No
line_item_service_date_from	date	No
line_item_service_date_through	date	No
line_item_provider_control_number	text	No
line_item_prior_authorization_number	text	No
tpa_network_identifier	text	No
tpa_network_name	text	No
tpa_network_status	text	No
payment_limit	numeric	No
billed_adjustment	numeric	No
allowed_amount	numeric	No
not_covered_amount	numeric	No
allowed_adjustment_amount	numeric	No
plan_payment_amount	numeric	No
cob_paid_amount	numeric	No
copay_amount	numeric	No
coinsurance_amount	numeric	No
deductible_amount	numeric	No
payment_identification_code	text	No
payment_method_type	payment_method_type	No
payment_date	date	No
payment_to_provider	numeric	No
payment_to_member	numeric	No