insurance_type_codes


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

Contains a list of different insurance types or categories that an insurance company is related to. This type includes both public and private payer types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
insurance_companies.ins_type_code Defined in XML R
type VARCHAR 60 null
claim_type TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation