ub04_service_view

Materialized: false

Definition

 SELECT claim.claim_id,
    line.line_number,
    line.rev_code,
    line.procedure_description AS rev_code_description,
    line.procedure_code AS hcpcs_code,
    line.procedure_modifiers[1] AS hcpcs_code_modifier1,
    line.procedure_modifiers[2] AS hcpcs_code_modifier2,
    line.procedure_modifiers[3] AS hcpcs_code_modifier3,
    line.procedure_modifiers[4] AS hcpcs_code_modifier4,
    line.service_date_from,
    line.quantity,
    line.billed_amount AS total_charges,
    line.reprice_methodology,
    line.reprice_allowed_amount,
    line.reprice_savings_amount,
    line.adjusted_repriced_line_item_number,
    line.facility_non_covered_amount AS non_covered_charges,
    claim.claim_billed_amount AS claim_total_charges,
    claim.reprice_allowed_amount AS claim_reprice_allowed_amount
   FROM claims.claim
     LEFT JOIN claims.line_item line USING (claim_id)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
line_number	text	No
rev_code	text	No
rev_code_description	text	No
hcpcs_code	text	No
hcpcs_code_modifier1	text	No
hcpcs_code_modifier2	text	No
hcpcs_code_modifier3	text	No
hcpcs_code_modifier4	text	No
service_date_from	date	No
quantity	numeric	No
total_charges	numeric	No
reprice_methodology	pricing_methodology_type	No
reprice_allowed_amount	numeric	No
reprice_savings_amount	numeric	No
adjusted_repriced_line_item_number	text	No
non_covered_charges	numeric	No
claim_total_charges	numeric	No
claim_reprice_allowed_amount	numeric	No