EOQF_QANS_TBL

(SQL Table)
 Index Back

Questionnaire Answers

Questionnaire Answers

  • Related Language Record: EOQF_QANS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field
    2 EOQF_QSTNR_CODE Character(30) VARCHAR2(30) NOT NULL Questionnaire Code
    3 EOQF_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question Id
    4 EOQF_ANS_ID Number(15,0) DECIMAL(15) NOT NULL Answer ID
    5 EOQF_ANS_ORDER Number(3,0) SMALLINT NOT NULL Answer Order
    6 EOQF_ENAB_COMM Character(1) VARCHAR2(1) NOT NULL Enable Answer Comments
    N=No
    Y=Yes

    Default Value: N

    7 EOQF_COMM_LABEL Character(254) VARCHAR2(254) NOT NULL Comment Label
    8 EOQF_DEFAULT_POINT Signed Number(4,0) DECIMAL(3) NOT NULL Default Points
    9 EOQF_COMMENT_REQ Character(1) VARCHAR2(1) NOT NULL Comments Required

    Y/N Table Edit

    10 EOQF_IS_CORRECT Character(1) VARCHAR2(1) NOT NULL Correct Answer
    N=No
    Y=Yes

    Default Value: N

    11 EOQF_INPOOL Character(1) VARCHAR2(1) NOT NULL Question/Answer Present in Pool
    N=No
    Y=Yes

    Default Value: N

    12 EOQF_IS_NEW Character(1) VARCHAR2(1) NOT NULL Is New
    N=No
    Y=Yes

    Default Value: N