Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillID | int identity | 4 | null |
|
|
Primary key - Unique identifier for the billing batch record |
||
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when the billing batch was processed and submitted |
|
| TotalClaim | int | 4 | √ | null |
|
|
Total claims - Number of individual claims included in this billing batch |
|
| TotalInvoice | int | 4 | √ | null |
|
|
Total invoices - Number of invoices generated in this billing batch |
|
| TotalInvPaid | money | 21,4 | √ | null |
|
|
Total invoices paid - Total monetary amount of invoices that have been paid |
|
| TotalAmount | money | 21,4 | null |
|
|
Total batch amount - Total monetary value of all claims in this billing batch |
||
| BilledBy | int | 4 | null |
|
|
Billed by user - User ID of the person who processed this billing batch |
||
| Status | varchar | 20 | √ | null |
|
|
Batch status - Current status of the billing batch (Pending, Submitted, Processed, Rejected, etc.) |
|
| DateFileGenerated | datetime | 16,3 | √ | null |
|
|
File generation date - Date when the billing file was generated for submission |
|
| FiledBy | int | 4 | √ | null |
|
|
Filed by user - User ID of the person who filed or submitted the billing batch |
|
| FiledByName | varchar | 101 | √ | null |
|
|
Filed by name - Full name of the person who filed or submitted the billing batch |
|
| MsgID | varchar | 1000 | √ | null |
|
|
Message identifier - Reference ID for tracking messages or communications related to this batch |
|
| BatchByName | varchar | 101 | √ | null |
|
|
Batch creator name - Full name of the person who created this billing batch |
|
| fileName | varchar | 255 | √ | null |
|
|
File name - Name of the billing file generated for this batch |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program foreign key - Links to the program type this billing batch belongs to |
|
| ProgramTypeName | varchar | 255 | √ | null |
|
|
Program type name - Descriptive name of the program type (Early Intervention, Special Education, etc.) |
|
| PaySrcName | varchar | 145 | √ | null |
|
|
Payment source name - Name of the payment source or insurance company |
|
| fkSourceID | varchar | 65 | √ | null |
|
|
Source foreign key - Identifier linking to the payment source configuration |
|
| MCN | varchar | 50 | √ | null |
|
|
Master control number - Control number assigned by the payment source for tracking |
|
| agencyName | varchar | 50 | √ | null |
|
|
Agency name - Name of the healthcare agency submitting the billing batch |
|
| BBSFileName | varchar | 50 | √ | null |
|
|
BBS file name - Name of the file used for BBS (Billing Batch System) processing |
|
| FileType | varchar | 30 | √ | null |
|
|
File type - Type of billing file format (EDI, CSV, XML, etc.) |
|
| NumOfInvoices | int | 4 | √ | null |
|
|
Number of invoices - Count of invoices included in this billing batch |
|
| BilledAmount | money | 21,4 | null |
|
|
Billed amount - Total amount billed in this batch submission |
||
| ConfirmedBy | int | 4 | √ | null |
|
|
Confirmed by user - User ID of the person who confirmed receipt or processing of the batch |
|
| DateConfirmed | datetime | 16,3 | √ | null |
|
|
Confirmation date - Date when the billing batch was confirmed as received or processed |
|
| ConfirmedByName | varchar | 101 | √ | null |
|
|
Confirmed by name - Full name of the person who confirmed the billing batch |
|
| UserID | int | 4 | √ | null |
|
|
User identifier - Foreign key linking to the user associated with this billing batch |
|
| AppId | int | 4 | √ | null |
|
|
Application identifier - Identifier for the specific application or module that generated this batch |
Relationships
Close relationships within degrees of separation
