Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each deleted billing record |
|
| BillID | int | 4 | null |
|
|
Billing batch ID - Identifier of the deleted billing batch |
||
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when the billing batch was processed |
|
| MCN | varchar | 20 | √ | null |
|
|
Media control number - Control number for the billing batch |
|
| TotalClaim | int | 4 | √ | null |
|
|
Total claims - Number of claims in the deleted batch |
|
| TotalInvoice | int | 4 | √ | null |
|
|
Total invoices - Number of invoices in the deleted batch |
|
| TotalAmount | money | 21,4 | √ | null |
|
|
Total amount - Total monetary amount of the deleted batch |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to Agency table for the billing organization |
|
| BilledBy | int | 4 | √ | null |
|
|
Billed by user - UserID of the person who processed the billing |
|
| 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 |
|
| Status | varchar | 20 | √ | null |
|
|
Billing status - Status of the billing at time of deletion |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to the program type for the billing |
|
| MsgID | varchar | 1000 | √ | null |
|
|
Message identifier - Associated message or error ID |
|
| fkSourceID | varchar | 50 | √ | null |
|
|
Source identifier - Reference to the source system or organization that generated the billing |
|
| Filename | varchar | 255 | √ | null |
|
|
File name - Name of the billing file that was generated |
|
| ConfirmedBy | int | 4 | √ | null |
|
|
Confirmed by user - UserID of the person who confirmed the billing |
|
| 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 - Links to the form used for this billing |
|
| BatchControlNumber | varchar | 9 | √ | null |
|
|
Batch control number - Control number for the billing batch |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the billing record was deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted the billing |
Relationships
Close relationships within degrees of separation
