Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
AccountStatementItem
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AccountSID | INTEGER | ? | MANDATORY | System generated unique id using the Account sequence. |
| StmntNumber | INTEGER | 0 | MANDATORY | System generated id to tie the records for a single report together. |
| ActivityType | INTEGER | 0 | MANDATORY | Type of activity. 1 - Charge , 2 - Charge Void, 3 - Copay , 4 - Adjustment , 5 - RISStudy , 8 - Payment Assignment , 12 - Payment Reversal , 14 - Transfer , 16 - UC Assignment , 20 - UC Reversal , 24 - Rolled Up Account , 26 - Payment Void , 28 - Refund , 32 - Account Transfer In , 36 - Account Transfer Out , 40 - Admin Charge , 44 - Interest Charge , 48 - Separator (Used only for Statement/Receipt formatting purposes) , 50 - Payment Header, 52 - Appointment , 54 - Appointment Location Data and 60 - Finance Charge To Be Rolled Up |
| ActivitySID | INTEGER | ? | MANDATORY | SID of the activity of the current item. The activity SID can be ChargeSID, PaymentSID, AdjustmentSID, UnappliedCreditSID or RefundSID. |
| ActivityCount | INTEGER | 0 | MANDATORY | This field is the number of the activity that has occurred against this statement item. |
| ActivityDescription | CHARACTER(60) | OPTIONAL | Description of adjustment. | |
| PostDate | DATE | OPTIONAL | Post date of charge | |
| Amount | DECIMAL(10,2) | 0 | OPTIONAL | Amount of the charge. |
| MedicareReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Total medicare receipts for the current charge. |
| OtherInsReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Total insurance receipts (except Medicare) for the current charge. |
| PatientReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Total patient receipts for the current charge. |
| Adjustments | DECIMAL(10,2) | 0 | OPTIONAL | Total adjustments for the current charge. |
| Balance | DECIMAL(10,2) | 0 | OPTIONAL | Current balance of the statement item. |
| PatientID | INTEGER | ? | OPTIONAL | FK |
| StaffCode | CHARACTER(6) | OPTIONAL | Staff code. | |
| AgingCategory | INTEGER | 0 | OPTIONAL | Indicator of the aging status (0 months, 1 month, 2 months, 3 months, 4 months, over 5 months). |
| POSDescription | CHARACTER(60) | OPTIONAL | Place of service description. | |
| POSCode | CHARACTER(3) | OPTIONAL | Place of service for the charge. | |
| TOSDescription | CHARACTER(60) | OPTIONAL | Type of service description. | |
| TOSCode | CHARACTER(3) | OPTIONAL | Type of service for the charge. | |
| ProcedureDescription | CHARACTER(60) | OPTIONAL | Description of the procedure for the charge. | |
| ProcedureCode | CHARACTER(10) | OPTIONAL | Procedure code for the charge. | |
| DiagnosisDescription | CHARACTER(60) | OPTIONAL | Diagnosis descriptions (array of 4). | |
| DiagnosisCode | CHARACTER(10) | OPTIONAL | Diagnosis codes for this charge (array of 4). | |
| CurrentStatus | CHARACTER(8) | OPTIONAL | Current status of charge. User selects charge status. | |
| AdminChargeCode | CHARACTER(10) | OPTIONAL | Administration charge code. | |
| ChargeComment | CHAR(28000) | OPTIONAL | Comment text. | |
| ChargeType | CHARACTER(1) | MANDATORY | Charge type indicates if the charge was a procedure charge or admin charge. Possible values are (P)rocedure or (A)dmin. | |
| ChargeNote | CHAR(28000) | OPTIONAL | Assigned charge note. | |
| PaymentNote | CHAR(28000) | OPTIONAL | Assigned payment note. | |
| PatientName | CHAR(200) | OPTIONAL | Patient name. | |
| ApptDate | DATE | OPTIONAL | Date of next appointment. | |
| ApptTime | CHARACTER(5) | OPTIONAL | Time of next appointment. | |
| ApptReason | CHARACTER(60) | OPTIONAL | Reason for next appointment. | |
| SubType | INTEGER | 0 | OPTIONAL | This field is used to define a sort order. |
| ReportSID | INTEGER | ? | OPTIONAL | Unique report run identifier. |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| AccountStatement | AccountStatementItem.AccountSID = AccountStatement.AccountSID and AccountStatementItem.StmntNumber = AccountStatement.StmntNumber |
CASCADE if AccountStatementItem exists |
| Child Table | Join Phrase | When deleting AccountStatementItem record... |
|---|