PTSF_SBO_NAMEPTSF_SRCATTR_NAMEPTSF_ATTR_VW(SQL View) |
Index Back |
|---|
| SELECT A.PTSF_SBO_NAME , A.PTSF_SRCATTR_NAME , B.DESCR254 FROM PSPTSF_SD_ATTR A ,PS_PTSF_ALL_ATTRS B WHERE A.PTSF_ISFIELDTOIDX='Y' AND B.PTSF_SRCCAT_NAME = A.PTSF_SBO_NAME AND A.PTSF_SRCATTR_NAME = B.PTSF_SRCATTR_NAME |
| # | 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 | PTSF_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Attribute (see PSPTSF_ATTRS). |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |