insurances

The insurances table manages informationd about a payer or insurance provider for the related patient.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the insurances table.

planidentifier VARCHAR
planname VARCHAR
groupnumber VARCHAR
groupname VARCHAR
startdate VARCHAR
enddate VARCHAR
medicarecardnumber VARCHAR
medicaidcasename VARCHAR
medicaidcasenumber VARCHAR
pharmacycoverage VARCHAR
comment VARCHAR
sponsor VARCHAR
policynumber VARCHAR
insurancecompanyname VARCHAR
insurancecompanyaddress VARCHAR
insurancecompanycity VARCHAR
insurancecompanystate VARCHAR
insurancecompanypostalcode VARCHAR
insurancecompanyphone VARCHAR
groupempid VARCHAR
groupempname VARCHAR
insuredname VARCHAR
insuredaddress VARCHAR
insuredcity VARCHAR
insuredstate VARCHAR
insuredpostalcode VARCHAR
insuredphone VARCHAR
insuredaltphone VARCHAR
insureddob VARCHAR
insuredssn VARCHAR
insuredgender VARCHAR
coordinationofbenefitspriority VARCHAR
authorizationnumber VARCHAR
authorizationdate VARCHAR
authorizationsource VARCHAR
patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

plantypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

ratecodeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

statusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

segmentterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

primarycaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

insuredrelationshipterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

encounter_id VARCHAR

Surrogate key. Foreign key reference to encounters.id

typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

modifieddate TIMESTAMP

Timestamp (UTC) indicating the date the row was last modified.

modifiedbyapplication_id SMALLINT

The application that last modified the row. Foreign key reference to applications.id.

modifiedbyuser_id VARCHAR

The user associated with the process that last modified the row. Foreign key reference to users.id.

datasource_id VARCHAR

Surrogate key. Foreign key reference to datasources.id. The external data source from which the data in this row originated.

productterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

classterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

networkterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

productgroupterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id

sitecaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

priority INTEGER

Back to Tables