Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientAccount
Table Definition  Parent Tables  Child Tables
Table DefinitionField | 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 Table | Join Phrase | When 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 Table | Join Phrase | When 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 |