line_item_adjudication

Describes the adjudication performed for a line item on behalf of the payer. According to the EDI specification, this is only used for Coordination of Benefits, but some reprices also use it for claims repricing

Primary Key:

• line_item_adjudication_id

Foreign Keys:

• claim_id => line_item.claim_id, claim_line_item_index => line_item.claim_line_item_index
• coordination_of_benefits_index_chosen_by => login.login_id

Indexes:

• line_item_adjudication_claim_id_claim_line_item_index_idx - claim_id, claim_line_item_index
• line_item_adjudication_coordination_of_benefits_index_chosen_by - coordination_of_benefits_index_chosen_by
• line_item_adjudication_coordination_of_benefits_index_chosen_id - coordination_of_benefits_index_chosen

Column	Data Type	Nullable	Indexed	Description
line_item_adjudication_id	bigint	No	Yes	-
other_payer_primary_id	text	No	No	-
paid_amount	numeric	Yes	No	-
procedure_code_qualifier	text	No	No	-
procedure_code	text	No	No	-
procedure_modifier_list	text[]	Yes	No	-
procedure_description	text	No	No	-
paid_quantity	numeric	Yes	No	-
bundled_or_unbundled_line_number	text	No	No	-
payment_date	date	Yes	No	-
other_dates	jsonb	Yes	No	DTP values that didn't fit in existing columns
remaining_patient_liability	numeric	Yes	No	-
other_amounts	jsonb	Yes	No	AMT values that didn't fit in existing columns
claim_id	bigint	No	Yes	-
claim_line_item_index	smallint	No	Yes	-
coordination_of_benefits_index_chosen	bigint	Yes	Yes	-
coordination_of_benefits_index_chosen_at	timestamp with time zone	Yes	No	-
coordination_of_benefits_index_chosen_by	bigint	Yes	Yes	-