PTAI_QUES_SVW

index back

SELECT A.PTAI_LIST_ID , A.PTAI_QUESTION_ID , A.PTAI_QUESTION 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 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
    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