Modifier


Description

Billing modifier management storing CPT and billing modifiers used for healthcare service billing and reimbursement. This table manages billing modifiers including modifier codes, descriptions, rates, and billing type associations, supporting accurate billing, reimbursement processing, and compliance with healthcare billing standards and payer requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ModifierID int identity 4 √ null
ClaimMedical.ModifierID FK__ClaimMedi__Modif__49A4C67D C

Primary key - Unique identifier for each billing modifier
ModifierName varchar 50 √ null

Modifier code - Standard billing modifier code (e.g., ‘GT’, ‘U1’, ‘59’)
ModifierDes varchar 100 √ null

Modifier description - Detailed description of the modifier purpose and usage
ModifierRate money 21,4 √ null

Modifier rate - Rate adjustment or multiplier associated with this modifier
BillingTypeID int 4 √ null
BillingType.BillingTypeID Modifier_Billing R

Billing type reference - Links to billing type that this modifier applies to
claimtypeid int 4 √ null

Claim type reference - Links to claim type that this modifier applies to

Indexes

Constraint Name Type Sort Column(s)
PK_Modifier Primary key Asc ModifierID

Relationships

Close relationships within degrees of separation