PTSF_CAT_ATTRS (SQL Table)	Index Back
category specfic attributes This will have a reefernce to the source from which the attribute label can be used by UI , currently this is auto mapped by the code where local attribute labels are used if not found remote PTSF attributes are user and if not found remote SES attributes are used.if is common is set the attrbute is common across all SD's in the category .

PTSF_CAT_ATTRS

(SQL Table)

category specfic attributes

This will have a reefernce to the source from which the attribute label can be used by UI , currently this is auto mapped by the code where local attribute labels are used if not found remote PTSF attributes are user and if not found remote SES attributes are used.if is common is set the attrbute is common across all SD's in the category .

Parent record: PSPTSF_SRCCAT

# 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_SD_SOURCE Character(1) VARCHAR2(1) NOT NULL Property Name Type
L=Local
N=Node
S=SES

3 PTSF_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name

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

5 PTSF_IS_COMMON Character(1) VARCHAR2(1) NOT NULL Is Common
Y/N Table Edit
Default Value: N

#	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_SD_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Property Name Type L=Local N=Node S=SES
3	PTSF_SOURCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Source Name
4	PTSF_SRCATTR_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Attribute (see PSPTSF_ATTRS).
5	PTSF_IS_COMMON	Character(1)	VARCHAR2(1) NOT NULL	Is Common Y/N Table Edit Default Value: N