insurance_companies


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of insurance_companies.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Insurance company

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 0
ar_session.payer_id Defined in XML R
billing.payer_id Defined in XML R
billing.provider_id Defined in XML R
claims.payer_id Defined in XML R
insurance_data.provider Defined in XML R
name VARCHAR 255 √ NULL
attn VARCHAR 255 √ NULL
cms_id VARCHAR 15 √ NULL
ins_type_code INT 10 √ NULL
insurance_type_codes.id Defined in XML R

The type of insurance company this record is
x12_receiver_id VARCHAR 25 √ NULL
x12_default_partner_id INT 10 √ NULL
alt_cms_id VARCHAR 15 √ NULL
inactive BOOLEAN 3 0
eligibility_id VARCHAR 32 √ NULL
x12_default_eligibility_id INT 10 √ NULL
uuid BINARY 16 √ NULL
cqm_sop INT 10 √ NULL

HL7 Source of Payment for eCQMs
date_created DATETIME 19 current_timestamp()
last_updated DATETIME 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation