Skip to main content

claim_value

Provides information about the NUBC value codes associated with a claim. (https://med.noridianmedicare.com/web/jea/topics/claim-submission/value-codes)

Primary Key:

claim_id
claim_value_index

Checks:

claim_value_value_code_check - (value_code <> ''::text)

Foreign Keys:

claim_id => claim.claim_id

Indexes:

claim_value_claim_id_idx - claim_id
claim_value_code_idx - value_code

Column	Data Type	Nullable	Indexed	Description
`claim_id`	`bigint`	No	Yes	Link to the claim record. Generated through expression:
`claim_value_index`	`smallint`	No	Yes	Order of claim value code found in the claim. Indexes are 0-based so the first diagnosis code in the claim will have an index of 0, second will have an index of 1 and so on. Generated through expression:
`value_code`	`text`	No	Yes	Code specifying the type of the supplied value. For example: 01 for 'Most Common Semi-Private Rate'. (Loop 2300, HIxx_02 when HIxx_01=BE / UB04 FL39-41). Generated through expression:
`value_amount`	`text`	No	No	Additional monetary amount that applies to the claim. (Loop 2300 HIxx_05 / UB04 FL39-41). Generated through expression: