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
uuid BINARY 16 √ null
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 BIT 1 0
eligibility_id VARCHAR 32 √ null
x12_default_eligibility_id INT 10 √ null
cqm_sop INT 10 √ null

HL7 Source of Payment for eCQMs

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