Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| UserID | int | 4 | null |
|
|
Provider reference - Links to AccessUser table for the assigned healthcare provider |
|||||
| AuthID | int | 4 | null |
|
|
Authorization reference - Links to Authorize table for the service authorization |
|||||
| provStatus | varchar | 30 | √ | null |
|
|
Provider status - Current status of the provider assignment (Active, Inactive, etc.) |
||||
| Mon | int | 4 | √ | null |
|
|
Monday availability - Provider availability on Mondays |
||||
| Tues | int | 4 | √ | null |
|
|
Tuesday availability - Provider availability on Tuesdays |
||||
| Wed | int | 4 | √ | null |
|
|
Wednesday availability - Provider availability on Wednesdays |
||||
| Thu | int | 4 | √ | null |
|
|
Thursday availability - Provider availability on Thursdays |
||||
| Fri | int | 4 | √ | null |
|
|
Friday availability - Provider availability on Fridays |
||||
| Sat | int | 4 | √ | null |
|
|
Saturday availability - Provider availability on Saturdays |
||||
| Sun | int | 4 | √ | null |
|
|
Sunday availability - Provider availability on Sundays |
||||
| provDateActive | smalldatetime | 16 | √ | null |
|
|
Provider active date - Date when provider assignment became active |
||||
| provDateInActive | smalldatetime | 16 | √ | null |
|
|
Provider inactive date - Date when provider assignment was deactivated |
||||
| provComments | varchar | 500 | √ | null |
|
|
Provider comments - Notes about the provider assignment |
||||
| provNumOfMinute | int | 4 | √ | null |
|
|
Provider session minutes - Duration of sessions for this provider |
||||
| provSessions | decimal | 7,2 | √ | null |
|
|
Provider sessions - Number of sessions assigned to this provider |
||||
| provSessionType | varchar | 10 | √ | null |
|
|
Provider session type - Type of sessions this provider delivers |
||||
| provFreqType | varchar | 10 | √ | null |
|
|
Provider frequency type - Frequency of services for this provider |
||||
| provFrequency | int | 4 | √ | null |
|
|
Provider frequency - Specific frequency number for this provider |
||||
| provUnits | decimal | 12,2 | √ | null |
|
|
Provider units - Number of service units assigned to this provider |
||||
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Timestamp when the provider assignment was created |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Timestamp of the most recent assignment update |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this assignment |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this assignment |
||||
| pkAuthTherpID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each provider-authorization assignment |
||||
| SAN | nvarchar | 100 | √ | (convert(int,round((rand() * 100000000),0))) |
|
|
Service authorization number - Unique service authorization number |
||||
| provRate | money | 21,4 | √ | null |
|
|
Provider rate - Rate paid to this provider for services |
||||
| customDate1 | smalldatetime | 16 | √ | null |
|
|
Custom date 1 - Configurable date field for provider-specific tracking |
||||
| customDate2 | smalldatetime | 16 | √ | null |
|
|
Custom date 2 - Configurable date field for provider-specific tracking |
||||
| customDate3 | smalldatetime | 16 | √ | null |
|
|
Custom date 3 - Configurable date field for provider-specific tracking |
||||
| offHourClaims | bit | 1 | √ | null |
|
|
Off-hours claims - Flag indicating if provider can submit off-hours claims |
||||
| RoleId | uniqueidentifier | 16 | √ | null |
|
|
Role reference - Links to Roles table for provider’s role permissions |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AuthorizeTherapist | Primary key | Asc | pkAuthTherpID |
| IX_AuthorizeTherapist_AuthID | Performance | Asc | AuthID |
| IX_provDateActive | Performance | Asc | provDateActive |
| IX_provDateInactive | Performance | Asc | provDateInActive |
| IX_ProvStatus | Performance | Asc | provStatus |
| IX_SAN | Must be unique | Asc | pkAuthTherpID |
| IX_UserID | Performance | Desc | UserID |
Relationships
Close relationships within degrees of separation
