HR_SRCH_TMP_6 (SQL Table)	Index Back
SES:DirectReports AccessType 6 Access Type 6 - Partial Position Management / Department Manager Id This table contains a combination of "Reports To" and "Department Manager Id". First, the "Reports To" method is executed, and then the "Department Manager Id" method is executed. The results of these two methods are combined, giving preference to the "Reports To" method. This method should be used only when Partial Position Management has been implemented.

HR_SRCH_TMP_6

(SQL Table)

SES:DirectReports AccessType 6

Access Type 6 - Partial Position Management / Department Manager Id This table contains a combination of "Reports To" and "Department Manager Id". First, the "Reports To" method is executed, and then the "Department Manager Id" method is executed. The results of these two methods are combined, giving preference to the "Reports To" method. This method should be used only when Partial Position Management has been implemented.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

2 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 HR_DR_LEVEL Number(3,0) SMALLINT NOT NULL Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.

6 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

7 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

9 DEPT_EFFDT Date(10) DATE Department Table Effective Date

10 JOB_EFFDT Date(10) DATE Job Effective Date

11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

12 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

13 SUPERVISOR_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if a employee is a supervisor on the direct reports tables.

14 DRILL_DOWN_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the row will appear in the dynamic drill down query. These rows appear in the getsupervisor query.

15 HR_SRCH_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id

16 HR_SRCH_ASSOC_CD Character(3) VARCHAR2(3) NOT NULL SES: Association Code: Used in Associated facets
DEL=Delegations
DIR=Direct Reports
EMP=Employee
IND=Indirect Reports
NON=Not Associated
SLF=Self

17 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	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
2	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	HR_DR_LEVEL	Number(3,0)	SMALLINT NOT NULL	Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.
6	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
7	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	DEPT_EFFDT	Date(10)	DATE	Department Table Effective Date
10	JOB_EFFDT	Date(10)	DATE	Job Effective Date
11	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
12	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
13	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.
14	DRILL_DOWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if the row will appear in the dynamic drill down query. These rows appear in the getsupervisor query.
15	HR_SRCH_CTRL_ID	Number(10,0)	DECIMAL(10) NOT NULL	EIP Control Id
16	HR_SRCH_ASSOC_CD	Character(3)	VARCHAR2(3) NOT NULL	SES: Association Code: Used in Associated facets DEL=Delegations DIR=Direct Reports EMP=Employee IND=Indirect Reports NON=Not Associated SLF=Self
17	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.