Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AuthID | int | 4 | null |
|
|
Authorization primary key - Unique identifier for each service authorization |
||
| DateBegin | datetime | 16,3 | √ | null |
|
|
Authorization start date - Date when the authorization becomes effective |
|
| 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 |
|
|
Number of days - Number of days per week for service delivery |
|
| Weeks | int | 4 | √ | null |
|
|
Number of weeks - Total number of weeks for the authorization period |
|
| Units | decimal | 12,2 | √ | null |
|
|
Total units authorized - Total number of service units authorized |
|
| UnitUsed | decimal | 12,2 | √ | null |
|
|
Units used - Number of service units already used |
|
| TargetUnit | decimal | 20,5 | √ | null |
|
|
Target units - Target number of units to be delivered |
|
| PercentComplete | decimal | 20,5 | √ | null |
|
|
Completion percentage - Percentage of authorized units completed |
|
| Location | int | 4 | √ | null |
|
|
Service location - Links to Locations table for where services are provided |
|
| IFSPID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table for Individualized Family Service Plan |
|
| Status | char | 20 | √ | null |
|
|
Authorization status - Current status of the authorization (Active, Pending, Closed) |
|
| ProcedureID | int | 4 | √ | null |
|
|
Procedure reference - Links to ProcCode table for the authorized procedure |
|
| ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Links to iCS2.dbo.Modifier for centralized procedure modifier definitions and billing codes |
|
| ServiceTypeID | int | 4 | √ | null |
|
|
Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions and standardized service codes |
|
| Type | char | 10 | √ | null |
|
|
Authorization type - Type classification for the authorization |
|
| Waiver | char | 5 | √ | null |
|
|
Waiver flag - Indicates if this authorization is under a waiver program |
|
| DateClosed | smalldatetime | 16 | √ | null |
|
|
Closure date - Date when the authorization was closed |
|
| AuthTypeID | int | 4 | √ | null |
|
|
Authorization type ID - Links to authorization type classification table |
|
| Comments | varchar | 300 | √ | null |
|
|
Authorization comments - Comments and notes about the authorization |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the authorization was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the authorization |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when the authorization was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the authorization |
|
| PANumber | varchar | 50 | √ | null |
|
|
Prior authorization number - Prior authorization number from insurance |
|
| SessionType | varchar | 10 | √ | null |
|
|
Session type - Type of service session (Individual, Group, etc.) |
|
| FreqType | varchar | 10 | √ | null |
|
|
Frequency type - Frequency type for service delivery (Weekly, Monthly, etc.) |
|
| AmountTuition | money | 21,4 | √ | null |
|
|
Tuition amount - Tuition or fee amount for the service |
|
| 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 per unit for the authorized service |
|
| fkCPID | int | 4 | √ | null |
|
|
Claim type program reference - Links to claim type program configuration |
|
| RatePerUnit | money | 21,4 | √ | null |
|
|
Rate per unit - Billing rate per service unit |
|
| UnitsPerSession | decimal | 12,2 | √ | null |
|
|
Units per session - Number of units per individual session |
|
| ImportID | int | 4 | √ | null |
|
|
Import reference - Reference ID for data import tracking |
|
| NumCoVisits | int | 4 | √ | null |
|
|
Number of co-visits - Number of co-visit sessions authorized |
|
| FirstServiceDate | datetime | 16,3 | √ | null |
|
|
First service date - Date of the first service delivery |
|
| ReasonForDelay | nvarchar | 1073741823 | √ | null |
|
|
Delay reason - Reason for any delays in service delivery |
|
| DiagnosisCodes | nvarchar | 1073741823 | √ | null |
|
|
Diagnosis codes - Medical diagnosis codes for the authorization |
|
| NumberOfMakeUps | int | 4 | √ | null |
|
|
Number of make-ups - Number of make-up sessions authorized |
|
| CoVisitUnitsAuthorized | int | 4 | √ | null |
|
|
Co-visit units authorized - Number of co-visit units authorized |
|
| CoVisitUnitsUsed | int | 4 | √ | null |
|
|
Co-visit units used - Number of co-visit units already used |
|
| MakeUpUnitsAuthorized | int | 4 | √ | null |
|
|
Make-up units authorized - Number of make-up units authorized |
|
| MakeUpUnitsUsed | int | 4 | √ | null |
|
|
Make-up units used - Number of make-up units already used |
|
| CoVisitFreqType | varchar | 10 | √ | null |
|
|
Co-visit frequency type - Frequency type for co-visit sessions |
|
| MakeUpFreqType | varchar | 10 | √ | null |
|
|
Make-up frequency type - Frequency type for make-up sessions |
|
| CoVisitNumOfDay | int | 4 | √ | null |
|
|
Co-visit days per week - Number of days per week for co-visit sessions |
|
| MakeUpNumOfDay | int | 4 | √ | null |
|
|
Make-up days per week - Number of days per week for make-up sessions |
|
| ClaimType | varchar | 20 | √ | null |
|
|
Claim type - Type of claim for billing purposes |
|
| modifierName | varchar | 151 | √ | null |
|
|
Modifier name - Full name and description of the procedure modifier from iCS2.dbo.Modifier centralized lookup |
|
| modifierAbbrev | varchar | 50 | √ | null |
|
|
Modifier abbreviation - Abbreviated name of the procedure modifier from iCS2.dbo.Modifier for billing and reporting |
|
| servicetypedesc | varchar | 111 | √ | null |
|
|
Service type description - Full description of the service type from iCS2.dbo.ServiceType centralized service definitions |
|
| servicetypeAbbrev | varchar | 10 | √ | null |
|
|
Service type abbreviation - Abbreviated service type code from iCS2.dbo.ServiceType for billing and reporting |
|
| roomTitle | varchar | 35 | √ | null |
|
|
Room title - Name or title of the room where services are provided |
|
| roomID | int | 4 | √ | null |
|
|
Room identifier - Unique identifier for the service room |
|
| UnitRemain | decimal | 13,2 | √ | null |
|
|
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 |
|
| PlanStartDate | datetime | 16,3 | √ | null |
|
|
Plan start date - Start date from the associated IFSP retrieved via subquery for service planning coordination |
|
| PlanEndDate | smalldatetime | 16 | √ | null |
|
|
Plan end date - End date from the associated IFSP retrieved via subquery for service planning coordination |
|
| LocationName | varchar | 50 | √ | null |
|
|
Location name - Name of the service location retrieved from Locations table for service delivery coordination |
Relationships
Close relationships within degrees of separation
