Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProcedureID | int identity | 4 | √ | null |
|
|
Primary key - Procedures unique identifier for each procedure |
|
| Code | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Procedures records |
|
| Name | int | 4 | √ | null |
|
|
Name field - Descriptive name or identifier for Procedures records |
|
| Description | varchar | 500 | √ | null |
|
|
Description field - Detailed description or explanation of Procedures information |
|
| Rate | money | 21,4 | √ | null |
|
|
Financial amount - Monetary value or rate for Procedures financial calculations |
|
| BillingTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| claimtypeid | int | 4 | √ | null |
|
|
Type classification - Category or classification type for Procedures records |
|
| Duration | Unknown | 0 | null |
|
|
Duration - Typical duration of the procedure |
||
| fkProcCodeID | Unknown | 0 | null |
|
|
Procedure code reference - Reference to the associated procedure code |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this procedure is currently available |
||
| ProcedureDescription | Unknown | 0 | null |
|
|
Procedure description - Detailed description of the procedure |
||
| ProcedureName | Unknown | 0 | null |
|
|
Procedure name - Name of the medical procedure |