line_item_view

Materialized: false

Definition

 SELECT line_item.line_item_id,
    line_item.claim_id,
    line_item.line_number,
    line_item.rev_code,
    line_item.procedure_qualifier,
    line_item.procedure_code,
    line_item.procedure_modifiers,
    line_item.procedure_description,
    line_item.line_item_procedure_code_id,
    line_item.billed_amount,
    line_item.quantity,
    line_item.units,
    line_item.place_of_service,
    line_item.diagnosis_code_pointers,
    line_item.facility_non_covered_amount,
    line_item.is_emergency_professional,
    line_item.is_epsdt_professional,
    line_item.is_family_planning_professional,
    line_item.copay_status,
    line_item.dental_oral_cavity_designations,
    line_item.dental_prosthesis_crown_or_inlay_placement,
    line_item.dme_length_of_medical_necessity_units,
    line_item.dme_length_of_medical_necessity_quantity,
    line_item.dme_rental_price,
    line_item.dme_purchase_price,
    line_item.dme_rental_billing_frequency,
    line_item.ambulance_transport_reason,
    line_item.ambulance_transport_distance_units,
    line_item.ambulance_transport_distance_quantity,
    line_item.ambulance_round_trip_purpose_description,
    line_item.ambulance_stretcher_purpose_description,
    line_item.ambulance_pickup_address_id,
    line_item.ambulance_dropoff_address_id,
    line_item.ambulance_applicable_conditions,
    line_item.ambulance_not_applicable_conditions,
    line_item.ambulance_patient_count,
    line_item.dme_certification_type,
    line_item.dme_need_duration_units,
    line_item.dme_need_duration_quantity,
    line_item.dme_applicable_conditions,
    line_item.dme_not_applicable_conditions,
    line_item.dme_certification_date,
    line_item.rendering_provider_is_hospice_employee,
    line_item.service_date_from,
    line_item.service_date_through,
    line_item.tpa_processed_date,
    line_item.prescription_date,
    line_item.begin_therapy_date,
    line_item.last_certification_date,
    line_item.last_seen_date,
    line_item.most_recent_hemoglobin_or_hematocrit_date,
    line_item.most_recent_serum_creatine_date,
    line_item.shipped_date,
    line_item.last_x_ray_date,
    line_item.initial_treatment_date,
    line_item.estimated_prior_placement_date,
    line_item.prior_placement_date,
    line_item.appliance_placement_date,
    line_item.replacement_date,
    line_item.treatment_start_date,
    line_item.treatment_completion_date,
    line_item.obstetric_anesthesia_additional_units,
    line_item.contract_type,
    line_item.contract_amount,
    line_item.contract_billed_percentage,
    line_item.contract_identification_code,
    line_item.contract_terms_discount_percent,
    line_item.contract_version_identifier,
    line_item.repriced_line_item_number,
    line_item.adjusted_repriced_line_item_number,
    line_item.line_item_prior_authorization_number,
    line_item.line_item_provider_control_number,
    line_item.mammography_certification_number,
    line_item.clia_number,
    line_item.referring_clia_number,
    line_item.immunization_batch_number,
    line_item.referral_number,
    line_item.predetermination_of_benefits_identifier,
    line_item.tpa_network_identifier,
    line_item.tpa_network_name,
    line_item.tpa_network_status,
    line_item.tpa_line_item_status,
    line_item.sales_tax_amount,
    line_item.service_tax_amount,
    line_item.facility_tax_amount,
    line_item.postage_amount,
    line_item.purchased_service_provider_identifier,
    line_item.purchased_service_billed_amount,
    line_item.reprice_methodology,
    line_item.reprice_allowed_amount,
    line_item.reprice_savings_amount,
    line_item.reprice_organization_id,
    line_item.reprice_per_diem_or_flat_rate_amount,
    line_item.reprice_approved_drg_or_apg_code,
    line_item.reprice_approved_drg_or_apg_amount,
    line_item.reprice_approved_revenue_code,
    line_item.reprice_approved_procedure_qualifier,
    line_item.reprice_approved_procedure_code,
    line_item.reprice_approved_units,
    line_item.reprice_approved_quantity,
    line_item.reprice_reject_reason,
    line_item.reprice_policy_compliance,
    line_item.reprice_exception,
    line_item.drug_ndc,
    line_item.drug_quantity,
    line_item.drug_units,
    line_item.drug_link_sequence_number,
    line_item.drug_prescription_number,
    line_item.data_errors,
    line_item.payment_limit,
    line_item.billed_adjustment,
    line_item.allowed_amount,
    line_item.not_covered_amount,
    line_item.allowed_adjustment_amount,
    line_item.plan_payment_amount,
    line_item.cob_paid_amount,
    line_item.copay_amount,
    line_item.coinsurance_amount,
    line_item.deductible_amount,
    line_item.payment_identification_code,
    line_item.payment_method_type,
    line_item.payment_date,
    line_item.payment_to_provider,
    line_item.payment_to_member,
    nubc_revenue_code_lookup.title AS revenue_code_title,
    nubc_revenue_code_group_lookup.title AS revenue_code_group_title,
    line_item_procedure_code_lookup.long_description AS procedure_long_description,
    line_item_procedure_code_lookup.short_description AS procedure_short_description,
    line_item_procedure_code_lookup.medium_description AS procedure_medium_description,
    line_item_procedure_code_lookup.consumer_friendly_description AS procedure_consumer_friendly_description,
    hcup_hcpcs_group_lookup.hcup_hcpcs_group_code,
    hcup_hcpcs_group_lookup.description AS hcup_hcpcs_group_description
   FROM claims.line_item
     LEFT JOIN claims.line_item_procedure_code_lookup ON line_item_procedure_code_lookup.line_item_procedure_code_id = line_item.line_item_procedure_code_id
     LEFT JOIN claims.hcpcs_hcup_group ON hcpcs_hcup_group.line_item_procedure_code_id = line_item.line_item_procedure_code_id
     LEFT JOIN claims.nubc_revenue_code_lookup ON nubc_revenue_code_lookup.revenue_code = line_item.rev_code
     LEFT JOIN claims.nubc_revenue_code_group_lookup ON nubc_revenue_code_group_lookup.revenue_code_group = nubc_revenue_code_lookup.revenue_code_group
     LEFT JOIN claims.cpt_hcup_group ON cpt_hcup_group.line_item_procedure_code_id = line_item.line_item_procedure_code_id
     LEFT JOIN claims.hcup_hcpcs_group_lookup ON hcup_hcpcs_group_lookup.hcup_hcpcs_group_id = COALESCE(hcpcs_hcup_group.hcup_hcpcs_group_id, cpt_hcup_group.hcup_hcpcs_group_id);

Column	Data Type	Indexed
line_item_id	bigint	No
claim_id	bigint	No
line_number	text	No
rev_code	text	No
procedure_qualifier	product_service_id_type	No
procedure_code	text	No
procedure_modifiers	text[]	No
procedure_description	text	No
line_item_procedure_code_id	bigint	No
billed_amount	numeric	No
quantity	numeric	No
units	text	No
place_of_service	text	No
diagnosis_code_pointers	smallint[]	No
facility_non_covered_amount	numeric	No
is_emergency_professional	boolean	No
is_epsdt_professional	boolean	No
is_family_planning_professional	boolean	No
copay_status	copay_status_type	No
dental_oral_cavity_designations	dental_oral_cavity_designation_type[]	No
dental_prosthesis_crown_or_inlay_placement	dental_prosthesis_crown_or_inlay_placement_type	No
dme_length_of_medical_necessity_units	unit_type	No
dme_length_of_medical_necessity_quantity	numeric	No
dme_rental_price	numeric	No
dme_purchase_price	numeric	No
dme_rental_billing_frequency	frequency_code	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_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
ambulance_patient_count	smallint	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
dme_certification_date	date	No
rendering_provider_is_hospice_employee	boolean	No
service_date_from	date	No
service_date_through	date	No
tpa_processed_date	date	No
prescription_date	date	No
begin_therapy_date	date	No
last_certification_date	date	No
last_seen_date	date	No
most_recent_hemoglobin_or_hematocrit_date	date	No
most_recent_serum_creatine_date	date	No
shipped_date	date	No
last_x_ray_date	date	No
initial_treatment_date	date	No
estimated_prior_placement_date	date	No
prior_placement_date	date	No
appliance_placement_date	date	No
replacement_date	date	No
treatment_start_date	date	No
treatment_completion_date	date	No
obstetric_anesthesia_additional_units	numeric	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
repriced_line_item_number	text	No
adjusted_repriced_line_item_number	text	No
line_item_prior_authorization_number	text	No
line_item_provider_control_number	text	No
mammography_certification_number	text	No
clia_number	text	No
referring_clia_number	text	No
immunization_batch_number	text	No
referral_number	text	No
predetermination_of_benefits_identifier	text	No
tpa_network_identifier	text	No
tpa_network_name	text	No
tpa_network_status	text	No
tpa_line_item_status	text	No
sales_tax_amount	numeric	No
service_tax_amount	numeric	No
facility_tax_amount	numeric	No
postage_amount	numeric	No
purchased_service_provider_identifier	text	No
purchased_service_billed_amount	numeric	No
reprice_methodology	pricing_methodology_type	No
reprice_allowed_amount	numeric	No
reprice_savings_amount	numeric	No
reprice_organization_id	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_procedure_qualifier	product_service_id_type	No
reprice_approved_procedure_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
drug_ndc	text	No
drug_quantity	numeric	No
drug_units	unit_type	No
drug_link_sequence_number	text	No
drug_prescription_number	text	No
data_errors	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
revenue_code_title	text	No
revenue_code_group_title	text	No
procedure_long_description	text	No
procedure_short_description	text	No
procedure_medium_description	text	No
procedure_consumer_friendly_description	text	No
hcup_hcpcs_group_code	smallint	No
hcup_hcpcs_group_description	text	No