ModifierRelation


Description

Billing modifier relationships - Hierarchical relationship table defining parent-child relationships between billing modifiers for complex billing scenarios. This table manages modifier dependencies, inheritance rules, and hierarchical modifier structures to support advanced billing logic, modifier combinations, and compliance with healthcare billing regulations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkModRelID int identity 4 √ null

Relation primary key - Unique identifier for each modifier relationship
parentModifierID int 4 √ null

Parent modifier reference - Links to parent modifier in the hierarchy
childModifierID int 4 √ null

Child modifier reference - Links to child modifier in the hierarchy
DateCreated smalldatetime 16 √ (getdate())

Creation date - Date when this modifier relationship was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this relationship
DateUpdated smalldatetime 16 √ null

Last update date - Date when this relationship was last modified
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated this relationship
Deleted bit 1 √ ((0))

Deletion flag - Soft delete flag for audit trail purposes

Indexes

Constraint Name Type Sort Column(s)
PK_ModifierRelation Primary key Asc pkModRelID

Relationships

Close relationships within degrees of separation