PTAI_LIST_IDPTAI_QUESTION_IDLANGUAGE_CDPTAI_QUES_LVW(SQL View) |
Index Back |
|---|
| 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) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | PTAI_QUESTION | Character(254) | VARCHAR2(254) NOT NULL | Questionnaire Question |