PTAI_QUES_SVW

(SQL View)
 Index Back

SELECT A.PTAI_LIST_ID , A.PTAI_QUESTION_ID , A.PTAI_QUESTION ,A.PTAI_ANSWER FROM PS_PTAI_QUES_LIST A , PS_PTAI_LIST B WHERE A.PTAI_LIST_ID=B.PTAI_LIST_ID AND A.PTAI_QUESTION_ID IN ( SELECT DISTINCT C.PTAI_QUESTION_ID FROM PS_PTAI_ITEM C WHERE C.PTAI_ACTIVE_FLG='Y' AND C.PTAI_LIST_ID=B.PTAI_LIST_ID)

  • Related Language Record: PTAI_QUES_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    2 PTAI_QUESTION_ID Character(31) VARCHAR2(31) NOT NULL Questionnaire ID
    3 PTAI_QUESTION Character(254) VARCHAR2(254) NOT NULL Questionnaire Question
    4 PTAI_ANSWER Character(1) VARCHAR2(1) NOT NULL Questionnaire Answer
    N=No
    Y=Yes