Accounts
Home Up Data Relationship Examples ODBC Driver Settings Accounts Appointments Attorneys Bills Conditions CPTCodes Doctors Employers Facilities Guarantors ICDCodes Patients PatientCases Payors PersonalInjury Profiles Referrals SOAP StateForms Submitters WorkComp

 

[Under Construction]

Up

ACCOUNTS

Description

This file contains all services and credits for each patient case.

Data Fields

SerialID.   

 [I KEY] A numeric integer value unique to each member of the table. This value is used to determine links for line item payments. Example: If a payment has been credited to this service, the LinkedTo member will contain the SerialID of this member record.

PatientID   

 [I KEY] The patient ID associated with this transaction.

Date   

 [D KEY] The date set by the user.

ToDate   

 [D] The through date set by the user.

PatientCaseID   

 [I KEY] The patient case associated with this transaction.

EntryType   

 [I] Determines the type of entry. Possible values are as follows:

1 Service
2 Sales tax
3 Interest
4 Late charge
55 Payor payment
56 Cash payment
57 Check payment
58 Credit card payment
59-108 User defined payments
109 Payor write-off
110 Patient write-off
111-160 User defined write-offs (adjustments)

SubEntryType   

 Not currently used.

OfficeCode   

 [C-15 KEY] If this is a service: corresponds to a member in the CPTCODES table.

CPT Code   

 [C-15] If this is a service

Modifiers   

 [C-15] If this is a service

PlaceOfService   

 [C-3] If this is a service

TypeOfService   

 [C-3] If this is a service

ICD1   

 [C-10 KEY] If this is a service

ICD2   

 [C-10 KEY] If this is a service

ICD3   

 [C-10 KEY] If this is a service

ICD4   

 [C-10 KEY] If this is a service

ESPDT   

 [C-1] If this is a service

Emergency   

 [B] If this is a service:

COB   

 [B] If this is a service:

CheckNumber   

 [C-27] If this is a service

Units   

 [F] If this is a service

Amount   

 [F] Dollar amount of this transaction.

SalesTax   

 [F] If this is a service

DeductibleApplied   

 [F] If this is a service

PatientOwes   

 [F] If this is a service

PatientPaid   

 [F] If this is a service

PayorPaid   

 [F] If this is a service

BalanceForward   

 [F] Used only during RAM-based operations.

GuarantorID   

 [I KEY]If this is a credit: Assigned guarantor in GUARANTORS.

PayorID   

 [I KEY]If this is a credit: Assigned payor in PAYORS.

DoctorID   

 [I KEY]Assigned physician (part 1) in DOCTORS.

OfficeID   

 [I KEY]Assigned physician (part 2) in DOCTORS.

FacilityID   

 [I KEY]Assigned facility in FACILITIES.

ReferralID   

 [I KEY]If this is a service: Assigned billing referral in REFERRALS.

LinkedTo   

 [I] If this is a credit: contains the SerialID of the service to which it is linked.

FirstUnbilled   

 Not currently used.

BillingCode   

 [I] If this is a service: Filter based on member of the same name in CPTCODES. This filter determines — based on category — whether this service will be included on non-patient bills.

Condition   

 [I KEY] If this is a service: assigned condition in CONDITIONS based on this patient case.

Bill#   

 [I] The bill number to which this member is currently assigned. "0" (zero) represents unbilled transactions.

Comments   

 [C-31]

Available Indexes

AccountPatIDKey: PatientID / PatientCaseID / Date / SerialID. This index is used to quickly obtain all entries for a given patient case.

AccountDateKey: Date / : PatientID / PatientCaseID. This index is used to traverse the table in date order.

 

 

 

Send mail to feedback@huntfamily.com with questions or comments about this web site.
Last modified: March 07, 2001