EOQF_QS_USE_LN

(SQL View)
 Index Back

Question Use View

Question Use

SELECT A.EOQF_QSTN_ID ,A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , B.LANGUAGE_CD , B.EOQF_QSTNR_NAME FROM PS_EOQF_QQSTN_TBL A , PS_EOQF_QSTNR_LANG B WHERE A.EOQF_CATEGORY = B.EOQF_CATEGORY AND A.EOQF_QSTNR_CODE = B.EOQF_QSTNR_CODE

  • Related Language Record for EOQF_EVN_USE_VW EOQF_QS_USE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EOQF_QSTNR_NAME Character(50) VARCHAR2(50) NOT NULL Questionnaire Name