SubclaimCPT


Description

Sub-claim CPT code associations linking service coordination sub-claims to Current Procedural Terminology codes. This junction table establishes many-to-many relationships between service coordination claims and CPT codes, supporting accurate billing, procedure coding, and compliance with healthcare coding standards for service coordination activities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkSubClaimID int 4 null
scClaim.SclaimID FK_SubclaimCPT_scClaim R

Sub-claim reference - Links to the service coordination claim (scClaim.SclaimID)
fkCPTID int 4 null
CPTCode.pkCPTID FK_SubclaimCPT_CPTCode R

CPT code reference - Links to the CPT code record (CPTCode.pkCPTID)

Indexes

Constraint Name Type Sort Column(s)
PK_SubclaimCPT Primary key Asc/Asc fkSubClaimID + fkCPTID

Relationships

Close relationships within degrees of separation