JCM Table: dbo.AT User

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