EOQF_AN_USE_VW

(SQL View)
 Index Back

Answer Use View

Answer Use

SELECT DISTINCT A.EOQF_ANS_ID ,A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , B.EOQF_QSTNR_NAME ,B.EOQF_ACTIVE_FLAG FROM PS_EOQF_QANS_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_AN_USE_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOQF_ANS_ID Number(15,0) DECIMAL(15) NOT NULL Answer 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