ub04_value_view

Materialized: false

Definition

 SELECT claim.claim_id,
    val.claim_value_index AS value_number,
    val.value_code,
    val.value_amount
   FROM claims.claim
     JOIN claims.claim_value val USING (claim_id)
  WHERE claim.form_type = 'UB-04'::claims.form_type;

Column	Data Type	Indexed
claim_id	bigint	No
value_number	smallint	No
value_code	text	No
value_amount	text	No