AG_IDQS_IDITEM_IDN=No
Y=Yes
GL_BU_QS_VW(SQL View) |
Index Back |
|---|---|
GL BU Template Question View |
| SELECT A.AG_ID , D.QS_ID , A.ITEM_ID , D.ITEM_QUESTION , B.PTAI_SUMMARY , C.PTAI_PARENT_ACTION , B.PTAI_SEQ ,E.ENABLED FROM PS_GL_BU_QS A , PS_PTAI_ITEM B , PS_PTAI_HIER C , PS_GL_BU_QUESTION D ,PS_GL_BU_QS_SRC E WHERE A.AG_ID = B.PTAI_LIST_ID AND A.ITEM_ID = B.PTAI_ITEM_ID AND B.PTAI_ITEM_ID = C.PTAI_ITEM_ID AND B.PTAI_ACTIVE_FLG='Y' AND C.PTAI_RELATION = 'S' AND A.QS_ID = D.QS_ID AND D.GL_QUES_SRC = E.GL_QUES_SRC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AG_ID |
Character(31) | VARCHAR2(31) NOT NULL | Activity Guide ID |
| 2 | QS_ID |
Character(31) | VARCHAR2(31) NOT NULL | Questionnaire ID |
| 3 | ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 4 | ITEM_QUESTION | Character(254) | VARCHAR2(254) NOT NULL | Item question |
| 5 | SUMMARY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Summary
N=No Y=Yes |
| 6 | PARENT_ACTION | Character(31) | VARCHAR2(31) NOT NULL | Parent action |
| 7 | ITEM_SEQ | Number(4,0) | SMALLINT NOT NULL | Item sequence |
| 8 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag indicates whether this row is enabled or not. |