ServiceTypeInCPTCode


Description

Service type CPT code associations linking service types to specific CPT procedure codes for billing and documentation. This junction table manages the relationship between service types and CPT codes, supporting accurate billing code assignment, service classification, and procedure code validation for healthcare service delivery and billing processes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkServiceTypeID int 4 null

Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions and service category classification
fkCPTID int 4 null
CPTCode.pkCPTID FK_ServiceTypeInCPTCode_CPTCode R

CPT code reference - Links to CPTCode table for the associated procedure code

Indexes

Constraint Name Type Sort Column(s)
PK_ServiceTypeInCPTCode Primary key Asc/Asc fkServiceTypeID + fkCPTID

Relationships

Close relationships within degrees of separation