CPTCode


Description

CPT procedure code definitions managing Current Procedural Terminology codes for healthcare services and procedures. This master table defines CPT and HCPCS codes with descriptions, unit definitions, and classification flags to support accurate medical billing, procedure documentation, and service coding for healthcare claims processing.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkCPTID int identity 4 √ null
ClaimCPT.fkCPTID FK_ClaimCPT_CPTCode R
PatientEvaluationCPT.fkCPTID FK_PatientEvaluationCPT_CPTCode R
ProcCodeInCPT.fkCPTID FK_ProcCodeInCPT_CPTCode R
ServiceTypeInCPTCode.fkCPTID FK_ServiceTypeInCPTCode_CPTCode R
SubclaimCPT.fkCPTID FK_SubclaimCPT_CPTCode R

Primary key - Unique identifier for each CPT code record
Code varchar 10 null

CPT code - The actual CPT or HCPCS procedure code
CodeDesc varchar 2147483647 √ null

Code description - Detailed description of the procedure or service
DateCreated smalldatetime 16 √ null

Creation date - Date when the CPT code was added to the system
CreatedBy int 4 √ null

Created by user - UserID of the person who added the code
Deleted bit 1 √ null

Deleted flag - Boolean indicating if the code is no longer active
UnitDefinition varchar 20 √ null

Unit definition - Definition of billing units for this procedure
IsHSCPC bit 1 √ null

HCPCS flag - Boolean indicating if this is an HCPCS code rather than CPT
IsEncounter bit 1 √ null

Encounter flag - Boolean indicating if this code represents an encounter

Indexes

Constraint Name Type Sort Column(s)
PK__CPTCode__3AD91AE7 Primary key Asc pkCPTID

Relationships

Close relationships within degrees of separation