JCM Table: dbo.AT User
From Sherlock Software
TABLE NAME: dbo.AT_User
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | UserID | int | User identifier (same as person id in AT_Person table) |
| 2 | UserType | tinyint | User type id |
| 3 | AuthenticationType | tinyint | Authentication type id |
| 4 | UserName | nvarchar(255) | Login name |
| 5 | FullName | nvarchar(255) | User full name |
| 6 | Password | nvarchar(255) | Encrypted password |
| 7 | HomeInstitutionID | smallint | Home institution id |
| 8 | IPAddress | varchar(16) | (Not in use) |
| 9 | AccessLevel | tinyint | Access level |
| 10 | AccessGroupID | smallint | (Not in use) |
| 11 | LogonAttemps | tinyint | Number of failed login attempts |
| 12 | MustChangePwd | bit | User must change password indicator |
| 13 | RowStatus | tinyint | Row status |
| 14 | CanViewPatientID | bit | View patient identifier indicator |
Back to JCM Database tables
