Modifier


Description

Billing modifiers that define the modifier codes used in medical billing to provide additional information about services, procedures, or circumstances affecting billing and reimbursement. This is the CENTRAL AUTHORITY table for billing modifier definitions referenced across all client databases. Client databases like Sandbox reference this table through authorization views (Authorize_vw, AuthorizationWoutAssignments_vw, Authorize_Simple_vw) to ensure consistent modifier usage and billing compliance across the entire multi-tenant healthcare system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
IsActive Unknown 0 null

Active status - Whether this modifier is currently valid for use across all integrated client systems
ModifierCode Unknown 0 null

Modifier code - Standard modifier code (e.g., 25, 59, etc.) used for consistent billing across all client databases
ModifierID int identity 4 √ null
ModifierInClaimType.fkmodifierID FK__ModifierInClaimType__Modifier C

Primary key - Modifier unique identifier ensuring referential integrity across the multi-tenant system
ModifierName varchar 50 √ null

Modifier name - Descriptive name for the modifier, displayed in cross-database views for user-friendly modifier identification
ModifierDes varchar 100 √ null

Modifier description - Detailed description of the modifier, used in client database views for comprehensive billing context and documentation
claimtypeid int 4 √ null

Claim type classification - Associates modifier with specific claim types for proper billing validation across all integrated systems
ModifierDescription Unknown 0 null

Modifier description - Description of what the modifier indicates for billing and reimbursement purposes

Indexes

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

Relationships

Close relationships within degrees of separation