Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

PatientAccount

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to record what patients are associated with a given account.

Field Datatype Default Null Option Comment
PracticeID INTEGER ?   MANDATORY FK
PatientID INTEGER ?   MANDATORY FK
AccountSID INTEGER ?   MANDATORY FK
RelationToGuar CHARACTER(2)   OPTIONAL User selects relationship to guarantor code. Relationship to guarantor codes are defined in the LookupCode table for the lookup type 'Relation'. Codes for lookup type 'Relation' are not user definable.
DefaultAccount CHARACTER(1)   OPTIONAL User set flag that indicates if the account is the default to use for the patient. A patient may only have one default account. Valid values are (Y)es or (N)o and are validated by the confirmation lookup type.
RecordStatus CHARACTER(1)   MANDATORY User selected record status for the patient account. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive.
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.
HL7Updated CHARACTER(1)   OPTIONAL This field indicates if HL7 has processed this table entry and will be used by the DB triggers. values "Y" or "N".

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Account PatientAccount.AccountSID = Account.AccountSID CASCADE if PatientAccount exists
Patient PatientAccount.PracticeID = Patient.PracticeID and
PatientAccount.PatientID = Patient.PatientID
RESTRICT if PatientAccount exists

Child Tables
Child TableJoin PhraseWhen deleting PatientAccount record...
LabOrder LabOrder.PracticeID = PatientAccount.PracticeID and
LabOrder.PatientID = PatientAccount.PatientID and
LabOrder.AccountSID = PatientAccount.AccountSID
RESTRICT if LabOrder exists
Claim Claim.PracticeID = PatientAccount.PracticeID and
Claim.PatientID = PatientAccount.PatientID and
Claim.AccountSID = PatientAccount.AccountSID
CASCADE if Claim exists
Charge Charge.PracticeID = PatientAccount.PracticeID and
Charge.PatientID = PatientAccount.PatientID and
Charge.AccountSID = PatientAccount.AccountSID
RESTRICT if Charge exists