Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillingCode | Unknown | 0 | null |
|
|
Billing code - Associated billing code for the discipline |
||
| ContinuingEducation | Unknown | 0 | null |
|
|
CE requirements - Continuing education requirements for the discipline |
||
| DisciplineID | int | 4 | null |
|
|
Discipline ID - Unique identifier for the discipline |
||
| Discipline | nvarchar | 100 | √ | null |
|
|
Discipline name - Name of the healthcare discipline |
|
| ProgramID | int | 4 | null |
|
|
Program reference - Links to program type |
||
| ProgramName | varchar | 255 | √ | null |
|
|
Program name - Name of the program type |
|
| pkDiscDisTypeID | int | 4 | null |
|
|
Discipline type assignment ID - Links to discipline type assignment |
||
| DisTypeID | int | 4 | null |
|
|
Discipline type ID - Identifier for the discipline type |
||
| DisTypeName | varchar | 30 | √ | null |
|
|
Discipline type name - Name of the discipline type |
|
| DPID | int | 4 | null |
|
|
Discipline program ID - Identifier for the discipline-program combination |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if the discipline is currently active |
||
| RequiresLicense | Unknown | 0 | null |
|
|
License requirement - Boolean indicating if the discipline requires professional licensing |
||
| ServiceCount | Unknown | 0 | null |
|
|
Service count - Number of services associated with this discipline |
||
| SupervisionRequired | Unknown | 0 | null |
|
|
Supervision required - Boolean indicating if supervision is required |
||
| UserCount | Unknown | 0 | null |
|
|
User count - Number of users associated with this discipline |
Relationships
Close relationships within degrees of separation
