Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BillID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each billing batch |
||||
| DateBilled | datetime | 16,3 | √ | (getdate()) |
|
|
Billing date - Date when the billing batch was processed and submitted |
||||
| MCN | varchar | 20 | √ | null |
|
|
Media control number - Unique control number for tracking the billing batch submission |
||||
| 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 |
||||
| TotalAmount | money | 21,4 | √ | null |
|
|
Total batch amount - Total monetary value of all claims in this billing batch |
||||
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to the healthcare provider agency submitting the batch |
||||
| BilledBy | int | 4 | √ | null |
|
|
Billed by user - UserID of the person who processed this billing batch |
||||
| DateFileGenerated | datetime | 16,3 | √ | null |
|
|
File generation date - Date when the billing file was generated |
||||
| FiledBy | int | 4 | √ | null |
|
|
Filed by user - UserID of the person who filed the billing batch |
||||
| Status | varchar | 20 | √ | null |
|
|
Batch status - Current status of the billing batch (Pending, Submitted, Processed, etc.) |
||||
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to the program type for this billing batch |
||||
| MsgID | varchar | 1000 | √ | null |
|
|
Message ID - System message or error ID associated with batch processing |
||||
| fkSourceID | varchar | 50 | √ | null |
|
|
Payment source reference - Links to the payment source or payer for this batch |
||||
| Filename | varchar | 255 | √ | null |
|
|
Generated filename - Name of the billing file generated for submission |
||||
| ConfirmedBy | int | 4 | √ | null |
|
|
Confirmed by user - UserID of the person who confirmed the billing batch |
||||
| DateConfirmed | datetime | 16,3 | √ | null |
|
|
Confirmation date - Date when the billing batch was confirmed |
||||
| Notes | varchar | 500 | √ | null |
|
|
Billing notes - Additional notes or comments about the billing batch |
||||
| fkFormID | int | 4 | √ | null |
|
|
Form reference - Links to billing form template used for this batch |
||||
| BatchControlNumber | varchar | 9 | √ | null |
|
|
Batch control number - Control number for tracking the billing batch |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Billing__38996AB5 | Primary key | Asc | BillID |
Relationships
Close relationships within degrees of separation
