HR_SRCH_RPT_TO (SQL Table)	Index Back
SES:Reports To Position Temp Used by the Direct Reports table build to resolve the reports to reporting structure where the reports to position is not on the job Table. The positions is then resolved from the POSITION_DATA table.

HR_SRCH_RPT_TO

(SQL Table)

SES:Reports To Position Temp

Used by the Direct Reports table build to resolve the reports to reporting structure where the reports to position is not on the job Table. The positions is then resolved from the POSITION_DATA table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 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

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

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

8 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.

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	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
5	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
8	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.
9	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.