ClaimCPT


Description

Claim CPT procedure codes linking claims to specific CPT procedure codes for billing and documentation. This junction table manages the many-to-many relationship between claims and CPT codes, including unit quantities for each procedure performed during the healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkClaimID int 4 null
Claim.ClaimID FK_ClaimCPT_Claim R

Claim reference - Links to Claim table for the associated claim
fkCPTID int 4 null
CPTCode.pkCPTID FK_ClaimCPT_CPTCode R

CPT code reference - Links to CPTCode table for the procedure code
CptUnits int 4 √ null

CPT units - Number of units of this procedure performed

Indexes

Constraint Name Type Sort Column(s)
PK_ClaimCPT Primary key Asc/Asc fkClaimID + fkCPTID

Relationships

Close relationships within degrees of separation