claim_pay_to_plan

Information about the subrogation demand payer

Primary Key:

• pay_to_plan_id

Foreign Keys:

• pay_to_plan_address_id => address_seen.address_id

Indexes:

• claim_pay_to_plan_uq (Unique) - pay_to_plan_name, pay_to_plan_payer_id, pay_to_plan_national_plan_id, pay_to_plan_claim_office_number, pay_to_plan_naic_code, pay_to_plan_tax_id, pay_to_plan_address_id

Column	Data Type	Nullable	Indexed	Description
pay_to_plan_id	bigint	No	Yes	-
pay_to_plan_name	text	No	Yes	Plan name to which payment should be directed to (From NM103)
pay_to_plan_payer_id	text	No	Yes	Plan ID to which payment should be directed to (From NM109 PI or REF 2U)
pay_to_plan_national_plan_id	text	No	Yes	HIPAA National Plan Identifier (From NM109 XV)
pay_to_plan_claim_office_number	text	No	Yes	Claim Office Number (From REF FY)
pay_to_plan_naic_code	text	No	Yes	National Association of Insurance Commissioners (NAIC) Code (From REF NF)
pay_to_plan_tax_id	text	No	Yes	Employer Identification Number (From REF EI)
pay_to_plan_address_id	bigint	Yes	Yes	Address of the plan to which payment should be directed (From N3/N4)