insurer_payer

Identifies the insurer / network / carrier or other entity responsible for paying the claim on behalf of the employer

Primary Key:

• insurer_payer_id

Foreign Keys:

• address_id => address_seen.address_id

Indexes:

• insurer_payer_address_id_idx - address_id
• insurer_payer_name_idx - name
• insurer_payer_uq (Unique) - name, payer_identification_code, national_plan_id, ein, claim_office_number, naic_code, address_id

Column	Data Type	Nullable	Indexed	Description
insurer_payer_id	bigint	No	Yes	Snowflake ID for insurer or payer. Generated through expression:
payer_identification_code	text	No	Yes	Unique identifier for a payer (From NM1 PI or REF 2U) Generated through expression:
national_plan_id	text	No	Yes	Centers for Medicare and Medicaid Services (CMS) plan ID (From NM1 XV [837 and 834]) Generated through expression:
ein	text	No	Yes	Employer Identification Number (EIN) (From REF EI [837] or NM1 FI [834]) 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 [837] or NM1 NI [834]) Generated through expression:
address_id	bigint	Yes	Yes	Address (From N3, N4) Generated through expression:
name	text	No	Yes	Name (From NM1) Generated through expression:
primary_id_qualifier	identification_type	Yes	No	Data type of the primary identification code (From NM108) Generated through expression: