Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AccessUserPatientID | int | 4 | null |
|
|
User-patient association ID - Primary key for the user-patient relationship |
||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the patient record |
|
| AccessUserID | int | 4 | √ | null |
|
|
User reference - Links to the user (staff member) |
|
| UserRankTitle | char | 10 | √ | null |
|
|
User rank - Rank or title of the user in the relationship |
|
| SC_Type | char | 10 | √ | null |
|
|
Service coordinator type - Type of service coordination relationship |
|
| RelationshipStatus | char | 10 | √ | null |
|
|
Relationship status - Current status of the user-patient relationship |
|
| DateAssigned | smalldatetime | 16 | √ | null |
|
|
Assignment date - Date when the user was assigned to the patient |
|
| DateActive | smalldatetime | 16 | √ | null |
|
|
Active date - Date when the relationship became active |
|
| DateInactive | smalldatetime | 16 | √ | null |
|
|
Inactive date - Date when the relationship became inactive |
|
| caseID | int | 4 | √ | null |
|
|
Case reference - Links to the associated case |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the record |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Date when the record was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the record |
|
| fkdistypeid | int | 4 | √ | null |
|
|
Discipline type reference - Links to the discipline type |
|
| Comments | varchar | 500 | √ | null |
|
|
Comments - Additional comments about the relationship or cleanup process |
|
| aupid | int | 4 | √ | null |
|
|
Access user patient ID - Additional identifier for the user-patient relationship |
|
| newstatus | varchar | 30 | √ | null |
|
|
New status - Updated status for the relationship |
|
| inactivedate | smalldatetime | 16 | √ | null |
|
|
Inactive date - Date when the relationship was marked inactive |
Relationships
Close relationships within degrees of separation
