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_name_payer_identification_code_cms_plan_id_idx (Unique) - name, payer_identification_code, cms_plan_id, ein, claim_office_number, naic_code, address_id

Column	Data Type	Nullable	Indexed	Description
insurer_payer_id	bigint	No	Yes	-
payer_identification_code	text	No	Yes	Unique identifier for a payer (From NM1 PI or REF 2U)
cms_plan_id	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])
address_id	bigint	Yes	Yes	Address (From N3, N4)
name	text	No	Yes	Name (From NM1)