PSPTSF_CATADVFD (SQL Table)	Index Back
Advanced Search Fields

PSPTSF_CATADVFD

(SQL Table)

Advanced Search Fields

# 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).
Prompt Table: PTSF_CAT_ATRSV

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

#	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). Prompt Table: PTSF_CAT_ATRSV
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number