ProcCodeInCPT


Description

Procedure code CPT associations linking internal procedure codes to standard CPT codes for billing and service documentation. This junction table manages the relationship between internal procedure codes and CPT codes including service type associations, supporting accurate billing, procedure coding, and service documentation for healthcare reimbursement and compliance.

Columns

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

Procedure code reference - Links to internal procedure code identifier
fkCPTID int 4 null
CPTCode.pkCPTID FK_ProcCodeInCPT_CPTCode R

CPT code reference - Links to CPTCode table for the associated Current Procedural Terminology code
fkServiceTypeID int 4 √ null

Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions associated with this procedure-CPT mapping

Indexes

Constraint Name Type Sort Column(s)
PK_ProcCodeInCPT Primary key Asc/Asc fkProcCodeID + fkCPTID

Relationships

Close relationships within degrees of separation