HR_SRCH_CONTROL (SQL Table)	Index Back
SES: DirectReports Control Tbl Direct Reports control table being used by Search direct reports build process. Will have once row per Search Definition

HR_SRCH_CONTROL

(SQL Table)

SES: DirectReports Control Tbl

Direct Reports control table being used by Search direct reports build process. Will have once row per Search Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_SBONAME Character(30) VARCHAR2(30) NOT NULL Search Business Object Name , This is the key to SES DataSource

2 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=By Dept Security Tree
2=By Supervisor ID
3=By Department Manager ID
4=By Reports To Position
5=By Part Posn Mgmt Supervisor
6=By Part Posn Mgmt Dept Mgr ID
7=By Group ID

3 PROCESSED Character(1) VARCHAR2(1) NOT NULL Processed?
I=In Process
N=Not Processed
Y=Processed

4 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_SBONAME	Character(30)	VARCHAR2(30) NOT NULL	Search Business Object Name , This is the key to SES DataSource
2	ACCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Access Type 1=By Dept Security Tree 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group ID
3	PROCESSED	Character(1)	VARCHAR2(1) NOT NULL	Processed? I=In Process N=Not Processed Y=Processed
4	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.