EOQF_QSTNR_TBL

(SQL Table)
 Index Back

Questionnaire Table

Questionnaire Table

  • Related Language Record: EOQF_QSTNR_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field

    Prompt Table: EOQF_CAT_VW

    2 EOQF_QSTNR_CODE Character(30) VARCHAR2(30) NOT NULL Questionnaire Code
    3 EOQF_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Questionnaire Active Flag
    N=No
    Y=Yes
    4 EOQF_QSTNR_NAME Character(50) VARCHAR2(50) NOT NULL Questionnaire Name
    5 EOQF_DESCR254 Character(254) VARCHAR2(254) NOT NULL Description
    6 EOQF_QSTN_STRT_INS Character(254) VARCHAR2(254) NOT NULL Start Instructions(Optional)
    7 EOQF_QSTN_CMP_INST Character(254) VARCHAR2(254) NOT NULL Completed instructions(Option)
    8 EOQF_RANDOM_QUES Character(1) VARCHAR2(1) NOT NULL Randomize Question
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 EOQF_RANDOM_ANS Character(1) VARCHAR2(1) NOT NULL Randomize Answer
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    10 EOQF_ANON_QSTNR Character(1) VARCHAR2(1) NOT NULL Anonymous Questionnaire
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 EOQF_ALLOW_UPD Character(1) VARCHAR2(1) NOT NULL Allow User Updates After Save
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    12 EOQF_QSTNR_ACCESS Character(1) VARCHAR2(1) NOT NULL Questionnaire Access
    D=Read Only
    P=Public
    R=Restricted
    T=Private
    13 EOQF_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 EOQF_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 EOQF_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 EOQF_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id