Table:

InsCarrier

Insurance Carriers

Name	Type	Description	Remarks
Active	bit	Active Carrier Indicator
AddressID	int	Insurance Address Identifier	AddressID is a foreign key to the Address table.
AuthNumberFormat	int	Authorization Number Format Identifier	AuthNumberFormat is a foreign key to the RegularExpressionFormats table.
BillingDepartmentID	int	Insurance Billing Department Identifier	BillingDepartmentID is a foreign key to the InsuranceBillingDepartment table.
BillingModeID	int	Billing Mode Identifier	See BillingMode
CarrierName	varchar(50)	Insurance Carrier name
CarrierRequiresForm	bit	Indicator for Checkbox 'Requires Form'
CMS1500Revision	int	CMS 1500 Revision Identifier	CMS1500Revision is a foreign key to the Cms1500Revision enumeration table.
ContactName	varchar(20)	Insurance Contact Person
CustomAttributes
CustomEligibilityAttributes
EdiID	int	Identifier for insurance EDI Information Record	EdiID is a foreign key to the InsEDI837 table.
EligibilityExpirationRule	int	Eligibility Expiration Rule Identifier	EligiblilityExpirationRule is a foreign key to the CarrierEligibilityRule table.
EligibilityRequirements	int	Eligibility Requirements Identifier	1=Eligibility and Authorization; 2=Eligibility
ColumnName	int	Eligibility Type Identifier	EligibilityTypeID is a foreign key to the EligibilityType table.
FaxID	int	Insurance Fax Number Identifier	FaxID is a foreign key to the Phone table.
GLPayableId	varchar(50)	General Ledger Clearing Account Number	Remarks
GLReceivableId	varchar(50)	General Ledger Receivables Acccount Number
HcfaID	int	Identifier for insurance's HCFA Information Record	HcfaID is a foreign key to the InsHCFA table.
ICD10AcceptanceDate	datetime	ICD-10 Acceptance Date
InsuredIdFormat	int	Insured ID Number Format Identifier	InsuredIdFormat is a foreign key to the RegularExpressionFormats table.
IsMedicareDMERC	bit	Indicator for checkbox: Medicare DMERC
IsPrepaidCarrier	bit	Indicator for checkbox 'Prepaid Carrier'
IsVspCarrier	bit	Indicator for whether the carrier represents a VSP insurance	Not visible in Admin U/I
NoReceivableCarrier	bit	Indicator for the checkbox 'No Receivable'
PayerID	varchar(50)	EDI Payer Identifier
PhoneID	int	Insurance Phone Number Identifier	PhoneID is a foreign key to the Phone table.
WebsiteAddress	varchar(400)	Insurance Carrier Website Address