G_Participant
-------------


..  qm: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.
        
    ..  qm:field:: Participant_ID int
        :key:
        :notnull:

        The integer key used to uniquely identify the participant.  This
        number is assigned randomly when the participant is created.
        
    ..  qm:field:: Participant_Name varchar(200)
        :notnull:

        The participant's user name.  On creation this value is checked
        for uniqueness.  The following characters are considered illegal
        in participant names::
        
            " ' & \\ / , | £ < > : #
        
    ..  qm:field:: Password varchar(80)

        Legacy field for internal use only.
        
    ..  qm:field:: Authenticate_Ext int
        :notnull:

    ..  qm:field:: First_Name varchar(200)

    ..  qm:field:: Last_Name varchar(200)

    ..  qm:field:: Middle_Name varchar(200)

    ..  qm:field:: Use_Correspondence int

    ..  qm:field:: Primary_Address_1 varchar(200)

    ..  qm:field:: Primary_Address_2 varchar(200)

    ..  qm:field:: Primary_City varchar(200)

    ..  qm:field:: Primary_State varchar(200)

    ..  qm:field:: Primary_ZIP_Code varchar(200)

    ..  qm:field:: Primary_Country varchar(200)

    ..  qm:field:: Primary_Phone varchar(200)

    ..  qm:field:: Primary_Fax varchar(200)

    ..  qm:field:: Primary_Email varchar(255)

    ..  qm:field:: Secondary_Address_1 varchar(200)

    ..  qm:field:: Secondary_Address_2 varchar(200)

    ..  qm:field:: Secondary_City varchar(200)

    ..  qm:field:: Secondary_State varchar(200)

    ..  qm:field:: Secondary_ZIP_Code varchar(200)

    ..  qm:field:: Secondary_Country varchar(200)

    ..  qm:field:: Secondary_Phone varchar(200)

    ..  qm:field:: Secondary_Fax varchar(200)

    ..  qm:field:: Secondary_Email varchar(255)

    ..  qm:field:: Salutation varchar(100)

    ..  qm:field:: Organization_Name varchar(200)

    ..  qm:field:: Department varchar(200)

    ..  qm:field:: Title varchar(200)

    ..  qm:field:: Assistant_Name varchar(200)

    ..  qm:field:: Manager_Name varchar(200)

    ..  qm:field:: Gender varchar(50)

    ..  qm:field:: URL varchar(255)

    ..  qm:field:: Date_Registration datetime

    ..  qm:field:: Details varchar(100)

    ..  qm:field:: Details_1 varchar(100)

    ..  qm:field:: Details_2 varchar(100)

    ..  qm:field:: Details_3 varchar(100)

    ..  qm:field:: Details_4 varchar(100)

    ..  qm:field:: Details_5 varchar(100)

    ..  qm:field:: Details_6 varchar(100)

    ..  qm:field:: Details_7 varchar(100)

    ..  qm:field:: Details_8 varchar(100)

    ..  qm:field:: Details_9 varchar(100)

    ..  qm:field:: Details_10 varchar(100)

    ..  qm:field:: Details_11 varchar(100)

    ..  qm:field:: Details_12 varchar(100)

    ..  qm:field:: Details_13 varchar(100)

    ..  qm:field:: Details_14 varchar(100)

    ..  qm:field:: Details_15 varchar(100)

    ..  qm:field:: Details_16 varchar(100)

    ..  qm:field:: Details_17 varchar(100)

    ..  qm:field:: Details_18 varchar(100)

    ..  qm:field:: Details_19 varchar(100)

    ..  qm:field:: Details_20 varchar(100)

    ..  qm:field:: Preferred_Lang varchar(10)