claim_pay_to_plan

Information about the subrogation demand payer

Primary Key:

• pay_to_plan_id

Checks:

• claim_pay_to_plan_claim_office_number_check - (claim_office_number = upper(claim_office_number))
• claim_pay_to_plan_naic_code_check - (naic_code = upper(naic_code))
• claim_pay_to_plan_national_plan_id_check - (national_plan_id = upper(national_plan_id))
• claim_pay_to_plan_payer_identification_code_check - (payer_identification_code = upper(payer_identification_code))
• claim_pay_to_plan_plan_name_check - (plan_name = upper(plan_name))

Foreign Keys:

• address_id => address_seen.address_id

Indexes:

• claim_pay_to_plan_uq (Unique) - plan_name, payer_identification_code, national_plan_id, claim_office_number, naic_code, tax_id, address_id

Column	Data Type	Nullable	Indexed	Description
pay_to_plan_id	bigint	No	Yes	Snowflake ID for pay to plan. Generated through expression:
plan_name	text	No	Yes	Plan name to which payment should be directed to (From NM103) Generated through expression:
payer_identification_code	text	No	Yes	Plan ID to which payment should be directed to (From NM109 PI or REF 2U) Generated through expression:
national_plan_id	text	No	Yes	HIPAA National Plan Identifier (From NM109 XV) Generated through expression:
claim_office_number	text	No	Yes	Claim Office Number (From REF FY) Generated through expression:
naic_code	text	No	Yes	National Association of Insurance Commissioners (NAIC) Code (From REF NF) Generated through expression:
tax_id	text	No	Yes	Employer Identification Number (From REF EI) Generated through expression:
address_id	bigint	Yes	Yes	Address of the plan to which payment should be directed (From N3/N4) Generated through expression:
primary_id_qualifier	identification_type	Yes	No	Data type of the primary identification code (From NM108) Generated through expression: