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 authorization becomes effective |
|
| DateEnd | datetime | 16,3 | √ | null |
|
|
Authorization end date - Date when authorization expires |
|
| NumOfMinute | int | 4 | √ | null |
|
|
Number of minutes - Total minutes authorized for service |
|
| NumOfDay | decimal | 7,2 | √ | null |
|
|
Number of days - Total days authorized for service |
|
| Weeks | int | 4 | √ | null |
|
|
Number of weeks - Total weeks authorized for service |
|
| Units | decimal | 12,2 | √ | null |
|
|
Authorized units - Total units authorized for service |
|
| UnitUsed | decimal | 12,2 | √ | null |
|
|
Units used - Number of units already used |
|
| TargetUnit | decimal | 20,5 | √ | null |
|
|
Target units - Target number of units to be used |
|
| PercentComplete | decimal | 20,5 | √ | null |
|
|
Completion percentage - Percentage of authorization completed |
|
| Location | int | 4 | √ | null |
|
|
Location reference - Links to Locations table for service location |
|
| 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 |
|
| ProcedureID | int | 4 | √ | null |
|
|
Procedure reference - Links to ProcCode table for authorized procedure |
|
| ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Links to Modifier table for procedure modifier |
|
| ServiceTypeID | int | 4 | √ | null |
|
|
Service type reference - Links to ServiceType table for type of service |
|
| Type | char | 10 | √ | null |
|
|
Authorization type - Type of authorization (Regular, Emergency, etc.) |
|
| Waiver | char | 5 | √ | null |
|
|
Waiver code - Waiver code if applicable |
|
| DateClosed | smalldatetime | 16 | √ | null |
|
|
Closure date - Date when authorization was closed |
|
| AuthTypeID | int | 4 | √ | null |
|
|
Authorization type reference - Links to authorization type configuration |
|
| Comments | varchar | 300 | √ | null |
|
|
Authorization comments - Comments and notes about the authorization |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when 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 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 payer |
|
| SessionType | varchar | 10 | √ | null |
|
|
Session type - Type of session (Individual, Group, etc.) |
|
| FreqType | varchar | 10 | √ | null |
|
|
Frequency type - Frequency type for service delivery |
|
| AmountTuition | money | 21,4 | √ | null |
|
|
Tuition amount - Tuition amount if applicable |
|
| category | int | 4 | √ | null |
|
|
Category reference - Category classification for the authorization |
|
| subcategory | int | 4 | √ | null |
|
|
Subcategory reference - Subcategory classification for the authorization |
|
| Rate | money | 21,4 | √ | null |
|
|
Authorization rate - Rate 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 - Rate charged per unit of service |
|
| UnitsPerSession | decimal | 12,2 | √ | null |
|
|
Units per session - Number of units per session |
|
| ImportID | int | 4 | √ | null |
|
|
Import reference - Reference ID for data import tracking |
|
| NumCoVisits | int | 4 | √ | null |
|
|
Number of co-visits - Number of co-visits authorized |
|
| UserID | int | 4 | √ | null |
|
|
Therapist user ID - UserID of the assigned therapist |
|
| Provider | varchar | 101 | √ | null |
|
|
Provider full name - Full name of the assigned provider |
|
| ProviderLastName | varchar | 50 | √ | null |
|
|
Provider last name - Last name of the assigned provider |
|
| ProviderFirstName | varchar | 50 | √ | null |
|
|
Provider first name - First name of the assigned provider |
|
| modifierName | varchar | 151 | √ | null |
|
|
Modifier full name - Full name and description of the modifier |
|
| modifierAbbrev | varchar | 50 | √ | null |
|
|
Modifier abbreviation - Abbreviated name of the modifier |
|
| servicetypedesc | varchar | 111 | √ | null |
|
|
Service type description - Full description of the service type |
|
| servicetypeAbbrev | varchar | 10 | √ | null |
|
|
Service type abbreviation - Abbreviated name of the service type |
|
| roomTitle | varchar | 35 | √ | null |
|
|
Room title - Title/name of the assigned room |
|
| RoomID | int | 4 | √ | null |
|
|
Room reference - Links to Rooms table for assigned room |
|
| UnitRemain | decimal | 13,2 | √ | null |
|
|
Units remaining - Number of units remaining on the authorization |
|
| AuthTypeName | varchar | 50 | √ | null |
|
|
Authorization type name - Name of the authorization type |
|
| SAN | nvarchar | 100 | √ | null |
|
|
Service authorization number - Service authorization number |
|
| claimtypeid | int | 4 | √ | null |
|
|
Claim type reference - Links to claim type for billing |
|
| RelationshipStatus | char | 10 | √ | null |
|
|
Relationship status - Status of provider-patient relationship |
|
| FirstServiceDate | datetime | 16,3 | √ | null |
|
|
First service date - Date of first service delivery |
|
| ReasonForDelay | nvarchar | 1073741823 | √ | null |
|
|
Reason for delay - Reason for any delays in service delivery |
|
| AccessUserID | int | 4 | √ | null |
|
|
Access user reference - Links to AccessUser table for user relationship |
Relationships
Close relationships within degrees of separation
