insurance_data


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_data.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

Patient Insurance information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
eligibility_verification.insurance_id Defined in XML R
uuid BINARY 16 √ null
type enum('primary', 'secondary', 'tertiary') 9 √ null
provider VARCHAR 255 √ null
insurance_companies.id Defined in XML R

The insurance company that insures the patient
plan_name VARCHAR 255 √ null
policy_number VARCHAR 255 √ null
group_number VARCHAR 255 √ null
subscriber_lname VARCHAR 255 √ null
subscriber_mname VARCHAR 255 √ null
subscriber_fname VARCHAR 255 √ null
subscriber_relationship VARCHAR 255 √ null
subscriber_ss VARCHAR 255 √ null
subscriber_DOB DATE 10 √ null
subscriber_street VARCHAR 255 √ null
subscriber_postal_code VARCHAR 255 √ null
subscriber_city VARCHAR 255 √ null
subscriber_state VARCHAR 255 √ null
subscriber_country VARCHAR 255 √ null
subscriber_phone VARCHAR 255 √ null
subscriber_employer VARCHAR 255 √ null
subscriber_employer_street VARCHAR 255 √ null
subscriber_employer_postal_code VARCHAR 255 √ null
subscriber_employer_state VARCHAR 255 √ null
subscriber_employer_country VARCHAR 255 √ null
subscriber_employer_city VARCHAR 255 √ null
copay VARCHAR 255 √ null
date DATE 10 √ null
pid BIGINT 19 0
patient_data.pid Defined in XML R

The internal patient identifier
subscriber_sex VARCHAR 25 √ null
accept_assignment VARCHAR 5 TRUE
policy_type VARCHAR 25

Whether this is the ‘primary’, ‘secondary’, or ‘tertiary’ insurance
subscriber_street_line_2 TINYTEXT 255 √ null
subscriber_employer_street_line_2 TINYTEXT 255 √ null
date_end DATE 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid_type_date Must be unique Asc/Asc/Asc pid + type + date
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation