PTSF_INDEXDSEC

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_INDEX_NAME Character(65) VARCHAR2(65) NOT NULL Index Name

2 PTSF_SRCATTR_NAME Character(65) VARCHAR2(65) NOT NULL Search Attribute (see PSPTSF_ATTRS).

3 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

4 PTSF_DOCACL_PVLG Character(1) VARCHAR2(1) NOT NULL PTSF Doc ACL Privilege
1=Allow
2=Deny

5 PTSF_SQLTEXT Long Character CLOB SQL Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_INDEX_NAME	Character(65)	VARCHAR2(65) NOT NULL	Index Name
2	PTSF_SRCATTR_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Attribute (see PSPTSF_ATTRS).
3	QRYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name
4	PTSF_DOCACL_PVLG	Character(1)	VARCHAR2(1) NOT NULL	PTSF Doc ACL Privilege 1=Allow 2=Deny
5	PTSF_SQLTEXT	Long Character	CLOB	SQL Text