Authorize


Description

Service authorizations defining approved healthcare services, treatment plans, and service parameters for patients. This central table manages the authorization of specific services including therapy sessions, evaluations, and other healthcare interventions with detailed service specifications, units, rates, and approval periods.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AuthID int identity 4 √ null
AuthMonthlyAmount.AuthID FK_AuthMonthlyAmount_Authorize C
AuthorizeICD9.fkAuthID FK_AuthorizeICD9_PatientEvaluation R
AuthorizeRooms.AuthID FK__Authorize__AuthI__629A9179 C
AuthReview.authID FK__AuthRevie__authI__6A46A039 C
Goal.fkAuthID FK_Goal_Authorize R

Primary key - Unique identifier for each service authorization
DateBegin datetime 16,3 √ null

Authorization start date - Date when the authorized services can begin
DateEnd datetime 16,3 √ null

Authorization end date - Date when the authorization expires
NumOfMinute int 4 √ null

Minutes per session - Duration of each service session in minutes
NumOfDay decimal 7,2 √ null

Days per period - Number of days in the service period
Weeks int 4 √ null

Number of weeks - Duration of authorization in weeks
Units decimal 12,2 √ null

Authorized units - Total number of service units authorized
UnitUsed decimal 12,2 √ (0)

Units used - Number of service units that have been utilized
TargetUnit decimal 20,5 √ (0)

Target units - Target number of units for treatment goals
PercentComplete decimal 20,5 √ null

Completion percentage - Percentage of authorized services completed
Location int 4 √ null

Service location - Reference to place of service where care is delivered
IFSPID int 4 √ null

IFSP reference - Links to IFSP (Individualized Family Service Plan) table
Status char 20 √ null

Authorization status - Current status of the authorization (Active, Closed, Pending, etc.)
ProcedureID int 4 √ null

Procedure reference - Links to procedures table for the specific service procedure
ModifierID int 4 √ null

Modifier reference - Links to iCS2.dbo.Modifier for centralized billing modifier definitions and standardized modifier codes used across all healthcare billing processes
ServiceTypeID int 4 √ null

Service type - Links to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes across the multi-tenant healthcare system
Type char 10 √ null

Authorization type - Type or category of authorization
Waiver char 5 √ null

Waiver program - Indicates if services are under a waiver program
DateClosed smalldatetime 16 √ null

Closure date - Date when the authorization was closed
AuthTypeID int 4 √ null

Authorization type ID - Reference to authorization type classification
Comments varchar 300 √ null

Authorization comments - Notes about the authorization
DateCreated smalldatetime 16 √ null

Creation date - Timestamp when the authorization was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this authorization
DateUpdated datetime 16,3 √ null

Last update date - Timestamp of the most recent authorization update
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified this authorization
PANumber varchar 50 √ null

Prior authorization number - Insurance prior authorization number
SessionType varchar 10 √ null

Session type - Type of service session (Individual, Group, etc.)
FreqType varchar 10 √ null

Frequency type - Frequency classification (Daily, Weekly, Monthly, etc.)
AmountTuition money 21,4 √ null

Tuition amount - Tuition or educational service amount
category int 4 √ null

Service category - Category classification for the service
subcategory int 4 √ null

Service subcategory - Subcategory classification for the service
Rate money 21,4 √ null

Service rate - Rate or cost per service unit
fkCPID int 4 √ null

Care plan reference - Links to care plan identifier
RatePerUnit money 21,4 √ null

Rate per unit - Cost per individual service unit
UnitsPerSession decimal 12,2 √ null

Units per session - Number of units delivered per session
ImportID int 4 √ null

Import identifier - Reference ID for data migration and import tracking
NumCoVisits int 4 √ null

Co-visit count - Number of co-visits authorized
FirstServiceDate datetime 16,3 √ null

First service date - Date when first service was delivered
ReasonForDelay nvarchar 1073741823 √ null

Delay reason - Explanation for any delays in service delivery
DiagnosisCodes nvarchar 1073741823 √ null

Diagnosis codes - Medical diagnosis codes supporting the authorization
NumberOfMakeUps int 4 √ null

Makeup sessions - Number of makeup sessions authorized
CoVisitUnitsAuthorized int 4 √ null

Co-visit units authorized - Number of co-visit units approved
CoVisitUnitsUsed int 4 √ null

Co-visit units used - Number of co-visit units utilized
MakeUpUnitsAuthorized int 4 √ null

Makeup units authorized - Number of makeup units approved
MakeUpUnitsUsed int 4 √ null

Makeup units used - Number of makeup units utilized
CoVisitFreqType varchar 10 √ null

Co-visit frequency type - Frequency classification for co-visits
MakeUpFreqType varchar 10 √ null

Makeup frequency type - Frequency classification for makeup sessions
CoVisitNumOfDay int 4 √ null

Co-visit days - Number of days for co-visit services
MakeUpNumOfDay int 4 √ null

Makeup days - Number of days for makeup services
ClaimType varchar 20 √ null

Claim type - Type of insurance claim for billing purposes

Indexes

Constraint Name Type Sort Column(s)
PK_Authorize Primary key Asc AuthID
datebegin_indx Performance Asc DateBegin
dateend_indx Performance Asc DateEnd
IFSP_indx Performance Asc IFSPID
IX_Location Performance Asc Location
IX_ModifierID Performance Asc ModifierID
IX_ServiceTypeID Performance Asc ServiceTypeID

Relationships

Close relationships within degrees of separation