Table:

BillingClaim

Claim header data

Name	Type	Description	Remarks
BillingDate	datetime	The date and time the claim was set to billed status
BillingModeID	int	Billing Mode of claim - designates how claim will be billed	88 = Manual HCFA 89 = EDI 837 90 = Web 91 = Statement 92 = Review claim 93 = PMI
BillingProviderNumber
BillingReferenceNumber	nvarchar(50)	Billing Reference Number for EDI	This is populated from looking up the linked record in the InsEDI837 table. By default, this will be looked up by carrier unless the plan has the override carrier info set to yes then it will be looked up by carrier and plan.
BillingReferenceQualifier	nvarchar(50)	Billing Reference Qualifier for EDI	This is populated from looking up the linked record in the InsEDI837 table. By default, this will be looked up by carrier unless the plan has the override carrier info set to yes then it will be looked up by carrier and plan.
ClaimAccounts
ClaimDate	datetime	The date and time the claim was created
ClaimId	int	Claim number
ClaimLineDetails		BillingLineDetails records related to claim
ExternalClaimNum	nvarchar(50)	External Claim Number for claim
ID
InsType	int	Type of Insurance Carrier	This field links to the InsHCFA table, GroupHealthType field. Possible choices: 0 = Medicare 1 = Medicaid 4 = Group Health
OfficeAddress		OfficeAddress
OfficeCity		OfficeCity
OfficeID		OfficeID
OfficeName		OfficeName
OfficeState		OfficeState
OfficeZip		OfficeZip
OrderInsuranceId	int	Order Insurance linked to this claim	Foreign key to OrderInsurance table
OutputCodeCategory	nvarchar(50)		Set to "E1" for Eyeglass order Set to "E2" for Contact lens order Otherwise set to blank
OutputCondition
OutputConditionIndicator
PatientID	int	Key to the Patient table
PayerID	nvarchar(50)	The Payer ID for the claim
PrimaryFlag	char(1)	Indicates if the claim is a primary or secondary claim	P = Primary S = Secondary
RelatedClaims		Related Claims
RenderingReferenceQualifier
SerializedClaimDetails		Serialized BillingClaimData records
SerializedClaimLineDetails		Serialized BillingLineDetail records
ServiceDate	datetime	The service date of the claim
SubscirberReferenceName	nvarchar(50)	Subscriber Reference Name for EDI	This is populated from looking up the linked record in the InsEDI837 table. By default, this will be looked up by carrier unless the plan has the override carrier info set to yes then it will be looked up by carrier and plan.
SubscriberReferenceIdentification	nvarchar(50)	Subscriber Reference Identification for EDI	This is populated from looking up the linked record in the InsEDI837 table. By default, this will be looked up by carrier unless the plan has the override carrier info set to yes then it will be looked up by carrier and plan.
TransNum	nchar(10)	PosTransaction record linked to this claim	Foreign key to PosTransaction table