EOQF_SAN_USE_VW

(SQL View)
 Index Back

Answer Use View

Answer Use

SELECT DISTINCT A.EOQF_SMART_ANS_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 , PS_EOQF_SMANS_TBL C WHERE A.EOQF_QSTNR_CODE = B.EOQF_QSTNR_CODE AND C.EOQF_SMART_ANS_ID = A.EOQF_SMART_ANS_ID

  • Related Language Record: EOQF_SAN_USE_LN

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