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)