EOQF_QS_USE_VW

(SQL View)
 Index Back

Question Use View

Question Use

SELECT A.EOQF_QSTN_ID ,A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , B.EOQF_QSTNR_NAME ,B.EOQF_ACTIVE_FLAG FROM PS_EOQF_QQSTN_TBL A , PS_EOQF_QSTNR_TBL B WHERE A.EOQF_CATEGORY = B.EOQF_CATEGORY AND A.EOQF_QSTNR_CODE = B.EOQF_QSTNR_CODE

  • Related Language Record: EOQF_QS_USE_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOQF_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question Id
    2 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field

    Prompt Table: EOQF_CAT_TBL

    3 EOQF_QSTNR_CODE Character(30) VARCHAR2(30) NOT NULL Questionnaire Code
    4 EOQF_QSTNR_NAME Character(50) VARCHAR2(50) NOT NULL Questionnaire Name
    5 EOQF_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Questionnaire Active Flag
    N=No
    Y=Yes