G_Participant

TABLE G_Participant

Records all partipants. A participant is any user that has the “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

For Perception 5.7 and Questionmark OnDemand Classic and OnDemand with Classic Participants, this table is authoritative.

Primary Key: Participant_ID int NOT NULL

The integer key used to uniquely identify the participant. This number is assigned randomly when the participant is created.

Participant_Name varchar(200) NOT NULL

The participant’s user name. On creation this value is checked for uniqueness. The following characters are considered illegal in participant names:

" ' & \\ / , | £ < > : #

Password varchar(80)

Legacy field for internal use only.

Authenticate_Ext int NOT NULL

First_Name varchar(200)

Last_Name varchar(200)

Middle_Name varchar(200)

Use_Correspondence int

Primary_Address_1 varchar(200)

Primary_Address_2 varchar(200)

Primary_City varchar(200)

Primary_State varchar(200)

Primary_ZIP_Code varchar(200)

Primary_Country varchar(200)

Primary_Phone varchar(200)

Primary_Fax varchar(200)

Primary_Email varchar(255)

Secondary_Address_1 varchar(200)

Secondary_Address_2 varchar(200)

Secondary_City varchar(200)

Secondary_State varchar(200)

Secondary_ZIP_Code varchar(200)

Secondary_Country varchar(200)

Secondary_Phone varchar(200)

Secondary_Fax varchar(200)

Secondary_Email varchar(255)

Salutation varchar(100)

Organization_Name varchar(200)

Department varchar(200)

Title varchar(200)

Assistant_Name varchar(200)

Manager_Name varchar(200)

Gender varchar(50)

URL varchar(255)

Date_Registration datetime

Details varchar(100)

Details_1 varchar(100)

Details_2 varchar(100)

Details_3 varchar(100)

Details_4 varchar(100)

Details_5 varchar(100)

Details_6 varchar(100)

Details_7 varchar(100)

Details_8 varchar(100)

Details_9 varchar(100)

Details_10 varchar(100)

Details_11 varchar(100)

Details_12 varchar(100)

Details_13 varchar(100)

Details_14 varchar(100)

Details_15 varchar(100)

Details_16 varchar(100)

Details_17 varchar(100)

Details_18 varchar(100)

Details_19 varchar(100)

Details_20 varchar(100)

Preferred_Lang varchar(10)