Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| userID | int | 4 | null |
|
|
Provider user ID - 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, Pending) |
|
| provDateActive | smalldatetime | 16 | √ | null |
|
|
Provider active date - Date when the provider assignment becomes active |
|
| provDateInActive | smalldatetime | 16 | √ | null |
|
|
Provider inactive date - Date when the provider assignment becomes inactive |
|
| patientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the patient receiving services |
|
| accessuserid | int | 4 | √ | null |
|
|
Access user ID - User ID for the provider in the access control system |
|
| sc_Type | char | 10 | √ | null |
|
|
Service coordination type - Type of service coordination relationship |
|
| RelationshipStatus | char | 10 | √ | null |
|
|
Relationship status - Status of the provider-patient relationship |
|
| DateActive | smalldatetime | 16 | √ | null |
|
|
Relationship active date - Date when the provider-patient relationship becomes active |
|
| DateInactive | smalldatetime | 16 | √ | null |
|
|
Relationship inactive date - Date when the provider-patient relationship becomes inactive |
|
| caseid | int | 4 | √ | null |
|
|
Case reference - Links to the patient case |
|
| fkdistypeID | int | 4 | √ | null |
|
|
Discipline type reference - Links to the discipline type for the provider |
|
| userLName | varchar | 50 | √ | null |
|
|
Provider last name - Last name of the assigned healthcare provider |
|
| userFName | varchar | 50 | √ | null |
|
|
Provider first name - First name of the assigned healthcare provider |
|
| SAN | nvarchar | 100 | √ | null |
|
|
Service authorization number - Unique service authorization number |
|
| provSessions | decimal | 7,2 | √ | null |
|
|
Provider sessions - Number of sessions assigned to the provider |
|
| provSessionType | varchar | 10 | √ | null |
|
|
Provider session type - Type of sessions (Individual, Group, etc.) |
|
| provFreqType | varchar | 10 | √ | null |
|
|
Provider frequency type - Type of frequency (Weekly, Monthly, etc.) |
|
| provFrequency | int | 4 | null |
|
|
Provider frequency - Frequency of service delivery |
||
| provNumOfMinute | int | 4 | null |
|
|
Provider minutes - Number of minutes per session for the provider |
Relationships
Close relationships within degrees of separation
