Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BBSlogID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each billing batch submission log entry |
|
| fkAgencyid | int | 4 | √ | null |
|
|
Agency reference - Links to the Agency table for the submitting healthcare provider |
|
| fkBillID | int | 4 | √ | null |
|
|
Billing reference - Links to the specific billing record or batch |
|
| DateEntered | datetime | 16,3 | √ | (getdate()) |
|
|
Entry timestamp - Date and time when the billing batch was logged |
|
| agencyName | varchar | 50 | √ | null |
|
|
Agency name - Name of the healthcare provider agency submitting the batch |
|
| FileName | varchar | 50 | √ | null |
|
|
File name - Name of the billing batch file submitted |
|
| Records | int | 4 | √ | null |
|
|
Record count - Number of billing records included in the batch file |
|
| FileType | varchar | 30 | √ | null |
|
|
File type - Type of billing file (EDI, flat file, etc.) |
|
| NumOfInvoices | int | 4 | √ | null |
|
|
Invoice count - Number of invoices included in the billing batch |
|
| MCN | varchar | 50 | √ | null |
|
|
Master control number - Unique control number for the billing batch submission |
|
| BilledAmount | money | 21,4 | √ | null |
|
|
Total billed amount - Total monetary amount billed in the batch submission |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AgencyBBSLog__2D729C23 | Primary key | Asc | BBSlogID |
Relationships
Close relationships within degrees of separation
