Specialty


Description

Provider specialty definitions managing healthcare provider specialties and areas of expertise for service delivery and provider qualification tracking. This lookup table defines specialty categories including specialty names and locking controls to support provider credentialing, service matching, and specialty-based care coordination for healthcare and early intervention services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
specialtyID int identity 4 √ null
SpecialtyInDiscipline.specialtyID FK__Specialty__speci__69DC8BE5 C
UserInSpecialty.fkspecialtyID FK__UserInSpe__fkspe__2F9BA70E C

Primary key - Unique identifier for each provider specialty
Specialty varchar 50 √ null

Specialty name - Descriptive name of the provider specialty (e.g., ‘Speech Therapy’, ‘Occupational Therapy’, ‘Physical Therapy’)
Lock bit 1 √ null

Lock status - Boolean indicating if the specialty is locked from modification

Indexes

Constraint Name Type Sort Column(s)
PK__Specialty__67001F3A Primary key Asc specialtyID

Relationships

Close relationships within degrees of separation