PTSF_CATSORTF_V (SQL View)	Index Back
Advanced search filters view This view can return the list of advanced search fields setup along with correspoding labels.

PTSF_CATSORTF_V

(SQL View)

Advanced search filters view

This view can return the list of advanced search fields setup along with correspoding labels.

SELECT A.PTSF_SRCCAT_NAME ,A.PTSF_SRCATTR_NAME , A.PTSF_SRCATTR_TYPE ,B.SEQNO , A.DESCR254 FROM PS_PTSF_CAT_ATRSV A , PSPTSF_CATSRTFD B WHERE A.PTSF_SRCCAT_NAME = B.PTSF_SRCCAT_NAME AND A.PTSF_SRCATTR_NAME = B.PTSF_SRCATTR_NAME

Related Language Record: PTSF_CAT_ATRSVL

# 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 PTSF_SRCATTR_TYPE Character(1) VARCHAR2(1) NOT NULL Data Type
D=DATE
M=Time
N=NUMBER
S=STRING
T=DateTime

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

#	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	PTSF_SRCATTR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data Type D=DATE M=Time N=NUMBER S=STRING T=DateTime
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254