AuthWaivers


Description

Authorization waivers managing waiver programs and special authorization conditions for healthcare services. This table tracks waiver status, types, and visit configurations for authorizations that operate under special waiver programs or have modified service delivery requirements.

Columns

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

Primary key - Unique identifier for each authorization waiver record
FkAuthID int 4 √ null

Authorization reference - Links to Authorize table for the authorization with waiver conditions
Status varchar 50 √ null

Waiver status - Current status of the waiver (Active, Pending, Approved, Denied)
Type varchar 50 √ null

Waiver type - Type or category of waiver program
VisitType int 4 null

Visit type - Type of visits covered under the waiver program
Date datetime 16,3 √ null

Waiver date - Date when the waiver was granted or becomes effective
UnitsAuthorized int 4 √ null

Authorized units - Total number of service units authorized under the waiver
UnitsUsed int 4 √ null

Units used - Number of service units that have been utilized
UnitsRemaining int 4 √ null

Remaining units - Number of service units still available under the waiver

Indexes

Constraint Name Type Sort Column(s)
PK__AuthWaiv__3214EC27163A62DA Primary key Asc ID

Relationships

Close relationships within degrees of separation