PTSF_SBO_NAMEPTSF_EXC_SD_VW(SQL View) |
Index Back |
|---|
| SELECT PTSF_SBO_NAME ,VERSION ,PTSF_DISPLAY_TITLE ,PTSF_KEYWORDS ,DESCR100 ,PTSF_DISPLAY_BODY FROM PSPTSF_SD WHERE PTSF_SBO_NAME NOT IN ( SELECT PTSF_INDEX_NAME FROM PS_PTSF_INDEX WHERE PTSF_RTI='Y') |
| # | 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 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 3 | PTSF_DISPLAY_TITLE | Character(254) | VARCHAR2(254) NOT NULL | *Title |
| 4 | PTSF_KEYWORDS | Character(254) | VARCHAR2(254) NOT NULL | Alternate search keywords |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | PTSF_DISPLAY_BODY | Long Character | CLOB | *Summary |