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_identifier, ein, claim_office_number, naic_code, health_plan_identifier, hin, bin, medicare_carrier_number, address_id

Column	Data Type	Nullable	Indexed	Description
insurer_payer_id	bigint	No	Yes	Snowflake ID for insurer or payer.
payer_identification_code	text	No	Yes	Unique identifier for a payer (From NM1 PI or REF 2U)
national_plan_identifier	text	No	Yes	Centers for Medicare and Medicaid Services (CMS) plan ID (From NM1 XV [837 and 834])
ein	text	No	Yes	Employer Identification Number (EIN) (From REF EI [837] or NM1 FI [834])
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 [837] or NM1 NI [834] / NCPDP 340-7C)
address_id	bigint	Yes	Yes	Address (From N3, N4)
name	text	No	Yes	Name (From NM1 / NCPDP 340-7C)
primary_id_qualifier	identification_type	Yes	No	Data type of the primary identification code (From NM108)
health_plan_identifier	text	No	Yes	HIPPA mandated Health Plan Identifier (From NCPDP 340-7C)
hin	text	No	Yes	Health Industry Number (From NCPDP 340-7C)
bin	text	No	Yes	Bank Identification Number (From NCPDP 340-7C)
medicare_carrier_number	text	No	Yes	Identifier assigned by a carrier or intermediary which administers Medicare (From NCPDP 340-7C)
medicare_part_d_contract_number	text	No	No	Number assigned by CMS to the Medicare Part D contract (From NCPDP 569-J8)
medicare_pbp_identifier	text	No	No	Identifier assigned by CMS to the benefit package (From NCPDP 569-J8)
other_identifier	text	No	No	Other payer identifier (From NCPDP 569-J8)