Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| UserID | int identity | 4 | null |
|
|
User identifier - Unique identifier for the user account |
||
| UserName | varchar | 102 | null |
|
|
Formatted user name - Concatenated last name, first name format for display |
||
| companyID | varchar | 20 | √ | null |
|
|
Company identifier - Company or organization ID associated with the user |
|
| DisTypeID | int | 4 | √ | null |
|
|
Discipline type identifier - Type of discipline based on user role (1=Provider, 2=Service Coordinator) |
|
| programId | int | 4 | null |
|
|
Program identifier - Program ID associated with the user (default 118) |
||
| userStatus | varchar | 10 | √ | null |
|
|
User status - Current status of the user account |
|
| AgencyStatus | varchar | 20 | √ | null |
|
|
Agency status - Status of the user within the agency |
|
| siteID | int | 4 | √ | null |
|
|
Site identifier - Site ID where the user is assigned (currently null) |
|
| DisStatus | varchar | 6 | null |
|
|
Discipline status - Status of the user’s discipline assignment (default ‘Active’) |
Relationships
Close relationships within degrees of separation
