claim_pay_to_plan
Information about the subrogation demand payer
Primary Key: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_identifier_check-(national_plan_identifier = upper(national_plan_identifier))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))
address_id=>address_seen.address_id
claim_pay_to_plan_address_id_idx-address_idclaim_pay_to_plan_uq(Unique) -plan_name,payer_identification_code,national_plan_identifier,claim_office_number,naic_code,tax_identifier,address_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
pay_to_plan_id | bigint | No | Yes | Snowflake ID for pay to plan. |
plan_name | text | No | Yes | Plan name to which payment should be directed to (From NM103) |
payer_identification_code | text | No | Yes | Plan ID to which payment should be directed to (From NM109 PI or REF 2U) |
national_plan_identifier | text | No | Yes | HIPAA National Plan Identifier (From NM109 XV) |
claim_office_number | text | No | Yes | Claim Office Number (From REF FY) |
naic_code | text | No | Yes | National Association of Insurance Commissioners (NAIC) Code (From REF NF) |
tax_identifier | text | No | Yes | Employer Identification Number (From REF EI) |
address_id | bigint | Yes | Yes | Address of the plan to which payment should be directed (From N3/N4) |
primary_id_qualifier | identification_type | Yes | No | Data type of the primary identification code (From NM108) |