ServiceType


Description

Service type definitions managing healthcare service type classifications and descriptions for early intervention and healthcare services. This lookup table defines service types including codes and descriptions to support service categorization, billing classification, and service delivery management for therapy services, evaluations, and other healthcare interventions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
serviceTypeid int identity 4 √ null
ClaimMedical.ServiceTypeID FK__ClaimMedi__Servi__47BC7E0B C

Primary key - Unique identifier for each service type
ServiceType varchar 10 √ null

Service type code - Short code identifying the service type (e.g., ‘ST’, ‘OT’, ‘PT’, ‘SC’)
ServiceDesc varchar 100 √ null

Service description - Detailed description of the service type and its purpose

Indexes

Constraint Name Type Sort Column(s)
PK__ServiceType__5535A963 Primary key Asc serviceTypeid

Relationships

Close relationships within degrees of separation