PTSF_SD_RTI_VW(SQL View) |
Index Back |
|---|
| SELECT A.PTSF_SBO_NAME , A.PTAI_LIST_ID FROM PSPTSF_TMPLATES A , PS_PTSF_INDEX B , PS_PTSF_DEPLOY_OBJ C WHERE A.PTSF_SBO_NAME = B.PTSF_INDEX_NAME AND C.PTSF_OBJ_NAME = B.PTSF_INDEX_NAME AND B.PTSF_RTI='Y' AND C.PTSF_OBJ_TYPE ='SBO' AND C.PTSF_SRCH_ENG_INS = ( SELECT PTSF_SRCH_ENG_INS FROM PS_PTSF_SRCH_ENGN WHERE PTSF_PRIORITY = ( SELECT MIN(PTSF_PRIORITY) FROM PS_PTSF_SRCH_ENGN)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_SBO_NAME | Character(65) | VARCHAR2(65) NOT NULL | Search Definition (see PSPTSF_SD). |
| 2 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |