Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ProcedureID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each procedure code |
||||
| Code | char | 10 | √ | null |
|
|
Procedure code - Standard procedure code identifier |
||||
| Name | char | 10 | √ | null |
|
|
Procedure name - Short name or title of the procedure |
||||
| Description | varchar | 500 | √ | null |
|
|
Procedure description - Detailed description of the procedure and its purpose |
||||
| Rate | money | 21,4 | √ | null |
|
|
Billing rate - Standard billing rate for this procedure |
||||
| BillingTypeID | int | 4 | √ | null |
|
|
Billing type reference - Links to billing type for this procedure |
||||
| claimtypeid | int | 4 | √ | null |
|
|
Claim type reference - Links to claim type associated with this procedure |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_procedures | Primary key | Asc | ProcedureID |
Relationships
Close relationships within degrees of separation
