line_item_coordination_of_benefits_adjustment

A log of all adjustments made to a line item by a Coordination of Benefits payer. Sometimes used by repricing organizations to show pricing adjustments

Foreign Keys:

• adjustment_reason_code => claim_adjustment_reason_code_lookup.code
• line_item_coordination_of_benefits_id => line_item_coordination_of_benefits.line_item_coordination_of_benefits_id

Indexes:

• line_item_coordination_of_benefits_line_item_cob_id_idx - line_item_coordination_of_benefits_id

Column	Data Type	Nullable	Indexed	Description
line_item_coordination_of_benefits_id	bigint	No	Yes	Links to the coordination of benefits this is adjusting. Generated through expression:
adjustment_group	claim_adjustment_group_type	No	No	Adjustment Group Code identifies the general category of the adjustment. For example - 'CO' for 'Contractual Obligation', 'PR' for 'Patient Responsibility', etc.). (Loop 2430 CAS01) Generated through expression:
adjustment_reason_code	text	No	No	Provides the specific reason for the adjustment. From Loop 2320 CAS03. See also https://x12.org/codes/claim-adjustment-reason-codes. (Loop 2400 CAS02/05/08/11/14/17) Generated through expression:
adjustment_amount	numeric	Yes	No	An amount added to or removed from the billed amount. For example, in order to specify the copayment amount of $25, there would be an adjustment_group of 'PR', adjustment_reason of '3' and an adjustment_amount of 25.00. Positive amounts subtract from the billed amount while negative amounts add to the billed amount (e.g. a late payment charge). See section 1.4.4.1 and 1.4.4.2 in the 837i and 837p spec for additional details on adjustments and balancing. (From Loop 2420 CAS03/06/09/12/15/18) Generated through expression:
adjustment_quantity	numeric	Yes	No	An amount added to or subtracted from the line item quantity and can be used to explain why a line item was paid at a certain amount. Positive amounts subtract from the quantity while negative amounts add to the quantity. (From Loop 2430 CAS04/07/10/13/16/19) Generated through expression: