PatientEvaluationCPT


Description

Patient evaluation CPT code associations linking evaluations to specific CPT codes and units for billing and service documentation. This junction table manages the relationship between patient evaluations and CPT codes including unit quantities, supporting accurate billing, service documentation, and evaluation coding for healthcare reimbursement and compliance.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkEvalID int 4 null
PatientEvaluation.EvalID FK_PatientEvaluationCPT_PatientEvaluation R

Evaluation reference - Links to PatientEvaluation table for the associated evaluation (foreign key to PatientEvaluation.EvalID)
fkCPTID int 4 null
CPTCode.pkCPTID FK_PatientEvaluationCPT_CPTCode R

CPT code reference - Links to CPTCode table for the associated procedure code (foreign key to CPTCode.pkCPTID)
CptUnits int 4 √ null

CPT units - Number of units for this CPT code in the evaluation

Indexes

Constraint Name Type Sort Column(s)
PK_EvalCPT Primary key Asc/Asc fkEvalID + fkCPTID

Relationships

Close relationships within degrees of separation