Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Amount | Unknown | 0 | null |
|
|
Billing amount - Monetary amount of the deleted billing record |
||
| pkId | int identity | 4 | √ | null |
|
|
Primary key - Primary key identifier for the deleted billing record |
|
| BillID | int | 4 | null |
|
|
Bill identifier - Unique identifier for the billing record |
||
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when the billing was originally processed |
|
| MCN | varchar | 20 | √ | null |
|
|
Medical control number - Medical control number for tracking |
|
| TotalClaim | int | 4 | √ | null |
|
|
Total claim amount - Total amount claimed in the billing |
|
| TotalInvoice | int | 4 | √ | null |
|
|
Total invoice amount - Total invoice amount for the billing |
|
| TotalAmount | money | 21,4 | √ | null |
|
|
Total amount - Total monetary amount of the billing |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Reference to agency associated with the deleted billing |
|
| BilledBy | int | 4 | √ | null |
|
|
Billing user - User who originally created the billing record |
|
| BillingCode | Unknown | 0 | null |
|
|
Billing code - Procedure or service code for the deleted billing |
||
| BillingId | Unknown | 0 | null |
|
|
Original billing ID - Reference to the original billing record that was deleted |
||
| DateFileGenerated | datetime | 16,3 | √ | null |
|
|
File generation date - Date when billing file was generated |
|
| DeleteReason | Unknown | 0 | null |
|
|
Deletion reason - Reason provided for deleting the billing record |
||
| FiledBy | int | 4 | √ | null |
|
|
Filing user - User who filed the billing record |
|
| Status | varchar | 20 | √ | null |
|
|
Billing status - Status of the billing record when deleted |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Foreign key to program associated with billing |
|
| MsgID | varchar | 1000 | √ | null |
|
|
Message identifier - Identifier for billing message or transaction |
|
| fkSourceID | varchar | 50 | √ | null |
|
|
Source reference - Foreign key to source of the billing record |
|
| Filename | varchar | 255 | √ | null |
|
|
File name - Name of the file containing the billing data |
|
| ConfirmedBy | int | 4 | √ | null |
|
|
Confirmation user - User who confirmed the billing record |
|
| DateConfirmed | datetime | 16,3 | √ | null |
|
|
Confirmation date - Date when the billing was confirmed |
|
| Notes | varchar | 500 | √ | null |
|
|
Billing notes - Additional notes or comments about the billing |
|
| fkFormID | int | 4 | √ | null |
|
|
Form reference - Foreign key to form associated with billing |
|
| BatchControlNumber | varchar | 9 | √ | null |
|
|
Batch control number - Control number for batch processing of billing records |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the billing record was deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted the billing record |
|
| PatientId | Unknown | 0 | null |
|
|
Patient reference - Reference to patient associated with deleted billing |
||
| ServiceDate | Unknown | 0 | null |
|
|
Service date - Date of service for the deleted billing record |