Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ProcCodeID | int identity | 4 | √ | null |
|
|
Primary key - ProcCode unique identifier for each record |
|||||||
| Code | varchar | 30 | √ | null |
|
|
Procedure code - The actual procedure code (CPT, HCPCS) |
|||||||
| CodeDesc | varchar | 100 | √ | null |
|
|
Code description - Official description of the procedure |
|||||||
| CodeType | Unknown | 0 | null |
|
|
Code type - Type of procedure code (CPT, HCPCS, etc.) |
||||||||
| Sequence | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for ProcCode records |
|||||||
| CovCode | varchar | 1 | √ | null |
|
|
Code identifier - Standardized code or identifier for ProcCode classification |
|||||||
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this code became valid |
||||||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this procedure code is currently valid |
||||||||
| Order | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for ProcCode records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ProcCode__2235F3A1 | Primary key | Asc | ProcCodeID |