PTAI_QUES_LVW

 index back
Questionnaire page language view
SELECT A.PTAI_LIST_ID , A.PTAI_QUESTION_ID , L.LANGUAGE_CD , L.PTAI_QUESTION FROM PS_PTAI_QUES_LIST A , PS_PTAI_QUES_LNG L WHERE A.PTAI_QUESTION_ID=L.PTAI_QUESTION_ID AND A.PTAI_LIST_ID=L.PTAI_LIST_ID AND L.PTAI_QUESTION_ID IN ( SELECT DISTINCT C.PTAI_QUESTION_ID FROM PS_PTAI_ITEM C , PS_PTAI_LIST B WHERE C.PTAI_ACTIVE_FLG='Y' AND C.PTAI_LIST_ID=B.PTAI_LIST_ID)

  • Related language record for PTAI_QUES_SVW

    • PeopleSoft Field Name Field Type Column Type Description
    PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    PTAI_QUESTION_ID Character(31) VARCHAR2(31) NOT NULL Questionnaire ID
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    PTAI_QUESTION Character(254) VARCHAR2(254) NOT NULL Questionnaire Question
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20