InsurCarrier


Description

Insurance carriers and payers managing insurance company information including contact details, addresses, and communication preferences. This table stores comprehensive insurance carrier data including company names, addresses, phone numbers, email contacts, and lock status to support insurance billing, claims processing, and payer relationship management for healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
InsurCariID int identity 4 √ null
PatientInsurance.InsurCariID FK__PatientIn__Insur__43EBED27 C

Primary key - Unique identifier for each insurance carrier
InsName varchar 100 √ null

Insurance name - Name of the insurance carrier or company
Address varchar 50 √ null

Carrier address - Street address of the insurance carrier
City varchar 50 √ null

Carrier city - City where the insurance carrier is located
State varchar 50 √ null

Carrier state - State where the insurance carrier is located
Zip varchar 10 √ null

Carrier ZIP code - ZIP code for the insurance carrier address
Telephone varchar 30 √ null

Carrier phone - Primary telephone number for the insurance carrier
Fax varchar 30 √ null

Carrier fax - Fax number for the insurance carrier
Email varchar 50 √ null

Carrier email - Email address for the insurance carrier
ContactName varchar 100 √ null

Primary contact - Name of the primary contact person at the insurance carrier
Lock int 4 √ (0)

Lock status - Lock status indicator for the carrier record (0=unlocked, 1=locked)

Indexes

Constraint Name Type Sort Column(s)
PK__InsurCarrier__396E5EB4 Primary key Asc InsurCariID

Relationships

Close relationships within degrees of separation