Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FirstName | varchar | 50 | √ | null |
|
|
Therapist first name - First name of the healthcare provider assigned to the authorization |
|
| LastName | varchar | 50 | √ | null |
|
|
Therapist last name - Last name of the healthcare provider assigned to the authorization |
|
| UserID | int | 4 | null |
|
|
User identifier - Foreign key linking to AccessUser table for the assigned therapist |
||
| AuthID | int | 4 | null |
|
|
Authorization identifier - Foreign key linking to Authorize table for the patient authorization |
||
| provStatus | varchar | 30 | √ | null |
|
|
Provider status - Current status of the therapist assignment (Active, Inactive, On Hold, etc.) |
|
| Mon | int | 4 | √ | null |
|
|
Monday availability - Number of minutes or sessions the therapist is available on Mondays |
|
| Tues | int | 4 | √ | null |
|
|
Tuesday availability - Number of minutes or sessions the therapist is available on Tuesdays |
|
| Wed | int | 4 | √ | null |
|
|
Wednesday availability - Number of minutes or sessions the therapist is available on Wednesdays |
|
| Thu | int | 4 | √ | null |
|
|
Thursday availability - Number of minutes or sessions the therapist is available on Thursdays |
|
| Fri | int | 4 | √ | null |
|
|
Friday availability - Number of minutes or sessions the therapist is available on Fridays |
|
| Sat | int | 4 | √ | null |
|
|
Saturday availability - Number of minutes or sessions the therapist is available on Saturdays |
|
| Sun | int | 4 | √ | null |
|
|
Sunday availability - Number of minutes or sessions the therapist is available on Sundays |
|
| provDateActive | smalldatetime | 16 | √ | null |
|
|
Provider activation date - Date when the therapist assignment became active for this authorization |
|
| provDateInActive | smalldatetime | 16 | √ | null |
|
|
Provider deactivation date - Date when the therapist assignment was deactivated or ended |
|
| provComments | varchar | 500 | √ | null |
|
|
Provider comments - Additional notes or special instructions related to the therapist assignment |
|
| provNumOfMinute | int | 4 | √ | null |
|
|
Provider minutes allocation - Total number of minutes allocated to this therapist for the authorization |
|
| provSessions | decimal | 7,2 | √ | null |
|
|
Provider sessions allocation - Number of sessions allocated to this therapist for the authorization |
|
| provSessionType | varchar | 10 | √ | null |
|
|
Provider session type - Type of sessions the therapist will provide (Individual, Group, Evaluation, etc.) |
|
| provFreqType | varchar | 10 | √ | null |
|
|
Provider frequency type - Frequency measurement unit for service delivery (Weekly, Monthly, Daily, etc.) |
|
| provFrequency | int | 4 | √ | null |
|
|
Provider frequency - Numeric frequency value indicating how often services should be provided |
|
| provUnits | decimal | 12,2 | √ | null |
|
|
Provider units - Total service units allocated to this therapist for the authorization |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Record creation date - Timestamp when the therapist assignment record was created |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Record update date - Timestamp when the therapist assignment record was last modified |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - User ID of the person who created the therapist assignment |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - User ID of the person who last modified the therapist assignment |
|
| pkAuthTherpID | int | 4 | null |
|
|
Primary key - Unique identifier for the authorization-therapist assignment record |
||
| SAN | nvarchar | 100 | √ | null |
|
|
Service authorization number - External reference number for the authorization from insurance or funding source |
|
| provRate | money | 21,4 | √ | null |
|
|
Provider rate - Billing rate for services provided by this therapist for this authorization |
|
| customDate1 | smalldatetime | 16 | √ | null |
|
|
Custom date field 1 - Configurable date field for agency-specific tracking requirements |
|
| customDate2 | smalldatetime | 16 | √ | null |
|
|
Custom date field 2 - Configurable date field for agency-specific tracking requirements |
|
| customDate3 | smalldatetime | 16 | √ | null |
|
|
Custom date field 3 - Configurable date field for agency-specific tracking requirements |
|
| offHourClaims | bit | 1 | √ | null |
|
|
Off-hours claims flag - Boolean indicator whether this therapist can submit claims for services provided outside normal business hours |
|
| RoleId | uniqueidentifier | 16 | √ | null |
|
|
Role identifier - Unique identifier linking to the therapist’s role definition for this authorization |
Relationships
Close relationships within degrees of separation
