RB_PTSF_SATR_VW

(SQL View)
 Index Back

Search Attribute Name

Search attributes that a search category has.

SELECT DISTINCT PTSF_SBO_NAME , PTSF_SRCATTR_NAME , QRYFLDNAME FROM PSPTSF_SD_ATTR WHERE PTSF_ISFIELDTOIDX = 'Y' AND PTSF_ISATTACHMENT <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
2 PTSF_SRCATTR_NAME Character(65) VARCHAR2(65) NOT NULL Search Attribute (see PSPTSF_ATTRS).
3 QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field