Authorize_Simple_vw

Authorization primary key - Unique identifier for each service authorization

Authorization start date - Date when the authorization becomes effective

Authorization end date - Date when the authorization expires

Minutes per session - Duration of each service session in minutes

Number of days - Number of days per week for service delivery

Number of weeks - Total number of weeks for the authorization period

Total units authorized - Total number of service units authorized

Units used - Number of service units already used

Target units - Target number of units to be delivered

Completion percentage - Percentage of authorized units completed

Service location - Links to Locations table for where services are provided

IFSP reference - Links to IFSP table for Individualized Family Service Plan

Authorization status - Current status of the authorization (Active, Pending, Closed)

Procedure reference - Links to ProcCode table for the authorized procedure

Modifier reference - Links to iCS2.dbo.Modifier for centralized procedure modifier definitions

Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions

Authorization type - Type classification for the authorization

Waiver flag - Indicates if this authorization is under a waiver program

Closure date - Date when the authorization was closed

Authorization type ID - Links to authorization type classification table

Authorization comments - Comments and notes about the authorization

Creation date - Date when the authorization was created

Created by user - UserID of the person who created the authorization

Last update date - Date when the authorization was last updated

Updated by user - UserID of the person who last updated the authorization

Prior authorization number - Prior authorization number from insurance

Session type - Type of service session (Individual, Group, etc.)

Frequency type - Frequency type for service delivery (Weekly, Monthly, etc.)

Tuition amount - Tuition or fee amount for the service

Service category - Category classification for the service

Service subcategory - Subcategory classification for the service

Service rate - Rate per unit for the authorized service

Claim type program reference - Links to claim type program configuration

Rate per unit - Billing rate per service unit

Units per session - Number of units per individual session

Import reference - Reference ID for data import tracking

Number of co-visits - Number of co-visit sessions authorized

First service date - Date of the first service delivery

Delay reason - Reason for any delays in service delivery

Diagnosis codes - Medical diagnosis codes for the authorization

Number of make-ups - Number of make-up sessions authorized

Co-visit units authorized - Number of co-visit units authorized

Co-visit units used - Number of co-visit units already used

Make-up units authorized - Number of make-up units authorized

Make-up units used - Number of make-up units already used

Co-visit frequency type - Frequency type for co-visit sessions

Make-up frequency type - Frequency type for make-up sessions

Co-visit days per week - Number of days per week for co-visit sessions

Make-up days per week - Number of days per week for make-up sessions

Claim type - Type of claim for billing purposes

Units remaining - Calculated field showing remaining authorized units using formula: CASE WHEN (UnitUsed IS NULL) OR (Unitused = 0) THEN Units ELSE (Units - UnitUsed) END for service delivery tracking

Modifier name - Name of the procedure modifier from iCS2.dbo.Modifier centralized lookup

Modifier description - Description of the procedure modifier from iCS2.dbo.Modifier for billing context

Service type code - Code for the type of service from iCS2.dbo.ServiceType centralized definitions

Service description - Description of the service type from iCS2.dbo.ServiceType for service categorization

Place of service - Place of service code from iCS2.dbo.placeservice for billing and location tracking

Case identifier - Links to PatientAdministration table for the case

Patient identifier - Links to Patient table for the patient

Place description - Description of the place of service from iCS2.dbo.placeservice for location context

IFSP date - Date of the Individualized Family Service Plan from IFSP table