| Original Column Name | Expanded Column Name | Description |
|---|---|---|
| PtBalID | Patient Balance Details | Unique identifier for each patient balance record, detailing financial transactions and balances for patient accounts. |
| PtID | Patient Details | Unique identifier for the patient, linking to their personal and medical information within the EHR system. |
| BalIns | Balance Insurance | Total outstanding balance owed by insurance companies for the patient's medical care. |
| BalPt | Balance Patient | Total outstanding balance owed by the patient for their medical care. |
| BalIns0_30 | Balance Insurance 0-30 Days | Insurance balance amount that is 0 to 30 days old, indicating recent insurance claims or payments. |
| BalIns31_60 | Balance Insurance 31-60 Days | Insurance balance amount that is 31 to 60 days old, showing pending or overdue payments from insurance providers. |
| BalIns61_90 | Balance Insurance 61-90 Days | Insurance balance amount that is 61 to 90 days old, highlighting potentially delinquent insurance payments. |
| BalIns91_ | Balance Insurance Over 91 Days | Insurance balance amount that is over 91 days old, indicating significantly overdue payments from insurance. |
| BalPt0_30 | Balance Patient 0-30 Days | Patient balance amount that is 0 to 30 days old, representing recent charges or payments by the patient. |
| BalPt31_60 | Balance Patient 31-60 Days | Patient balance amount that is 31 to 60 days old, indicating pending or overdue payments by the patient. |
| BalPt61_90 | Balance Patient 61-90 Days | Patient balance amount that is 61 to 90 days old, suggesting potential delinquencies in patient payments. |
| BalPt91_ | Balance Patient Over 91 Days | Patient balance amount that is over 91 days old, showing significantly overdue payments by the patient. |
| DateLastStmt | Date Last Statement | The date of the last financial statement issued, either to the patient or insurance, regarding their balance. |
| IsUndistPayIns | Is Undistributed Pay Insurance | Indicates whether there are undistributed or unallocated insurance payments in the patient's account. |
| IsUndistPayPt | Is Undistributed Pay Patient | Indicates whether there are undistributed or unallocated patient payments in the patient's account. |
| LastInsPaymentID | Last Insurance Payment Details | Identifier for the most recent insurance payment made for the patient's account, useful for tracking and reconciliation. |
| LastPtPaymentID | Last Patient Payment Details | Identifier for the most recent payment made by the patient, important for financial tracking and account management. |
| SiteID | Site Details | Identifier for the healthcare facility or site where the financial transactions or patient care occurred. |
| ZUChkSum | ZU Checksum | Checksum value used for audit logs, ensuring data integrity and tracking changes in the patient balance records. |
| ZUDate | ZU Date | Date stamp used in audit logs, indicating when entries related to patient balances were made or modified. |
| ZULogonHisID | ZU Logon History Details | Identifier for logon history in the audit logs, potentially linking user access and actions to specific patient balance records. |