Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| fkProcCodeID | Unknown | 0 | null |
|
|
Procedure code reference - Reference to included procedure codes |
|||||
| PackageDescription | Unknown | 0 | null |
|
|
Package description - Description of the procedure package |
|||||
| PackageId | Unknown | 0 | null |
|
|
Primary key - ProcCodePackage unique identifier for each procedure package |
|||||
| PackageName | Unknown | 0 | null |
|
|
Package name - Name of the procedure code package |
|||||
| PackageRate | Unknown | 0 | null |
|
|
Package rate - Bundled rate for the entire package |
|||||
| PackID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| PackName | varchar | 255 | √ | null |
|
|
Name field - Descriptive name or identifier for ProcCodePackage records |
||||
| fkPrimProcCodeID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to PrimProcCode table for data relationships |
||||
| Quantity | Unknown | 0 | null |
|
|
Quantity - Number of procedures included in the package |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ProcCodePackage__64F7DB37 | Primary key | Asc | PackID |