SP_SUR_QSTN_VW

(SQL View)
 Index Back

Survey Questions Preview View

Associate Questions to a Survey used for Preview Survey

SELECT SETID , SP_SURVEY_ID , SEQNBR , SP_SUR_QUESTN , SP_SUR_RESTYP_ID , SP_ALLOW_COMMENTS FROM PS_SP_SUR_QUESTN

  • Related Language Record: SP_SUR_QSTNVLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier

    Prompt Table: SP_SUR_DEFN

    3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
    4 SP_SUR_QUESTN Character(254) VARCHAR2(254) NOT NULL s
    5 SP_SUR_RESTYP_ID Character(18) VARCHAR2(18) NOT NULL Response Type ID

    Prompt Table: SP_SUR_RESTYP

    6 SP_ALLOW_COMMENTS Character(1) VARCHAR2(1) NOT NULL Allow Comments
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N