G_User¶
- TABLE G_User¶
Records all administrators. An administrator is any user that has a role other than the special “Participant” role within the portal. The table does not contain the authoritative information about the user but is maintained as a mirror of the key fields for backwards compatibility.
Note
Perception 5.7 and Questionmark OnDemand Classic, this table is authoritative.
- Primary Key: User_ID int NOT NULL¶
The administrator ID.
- User_Name varchar(200) NOT NULL¶
You should pay particular attention to the issues around the storage of information in Fields defined with varchar concerning the encoding of user names with characters outside US ASCII.
In addition to this transformation there are a number of further restrictions on which graphic characters from US ASCII are allowed. The APIs don’t always implement the restrictions consistently. Sometimes illegal characters will result in an error and sometimes they will be swapped for similar characters that are allowed. Check the documentation for the API for further details.
- Password nvarchar(255) NOT NULL¶
- Authenticate_Ext int NOT NULL¶
- Profile_Record smallint NOT NULL¶
- Profile_ID int NOT NULL¶
- Authoring1 int NOT NULL¶
- Authoring2 int¶
- Admin1 int NOT NULL¶
- Admin2 int NOT NULL¶
- Admin3 int¶
- Admin4 int¶
- Grading int NOT NULL¶
- Reporting1 int NOT NULL¶
- Reporting2 int¶
- Misc1 int¶
- Misc2 int¶
- Misc3 int¶
- Misc4 int¶
- Restrict_Host int¶
- Email varchar(255)¶
- URL varchar(255)¶
- First_Name varchar(200)¶
- Last_Name varchar(200)¶
- Department varchar(200)¶
- Alternate_Name varchar(400)¶
- Profile_Description varchar(400)¶