HR_SP_DRPT_RS (SQL Table)	Index Back
Direct Reports Results Used by Manage Succession Plans Componet for the purpose of loading Dir/Ind Reports. This record definition is used to process the contents of the DirectReports rowset.

HR_SP_DRPT_RS

(SQL Table)

Direct Reports Results

Used by Manage Succession Plans Componet for the purpose of loading Dir/Ind Reports. This record definition is used to process the contents of the DirectReports rowset.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

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

7 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

8 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

9 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

10 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

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

12 NAME Character(50) VARCHAR2(50) NOT NULL Name

13 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

14 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

15 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

17 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

18 HR_DRPT_INDIRECT Character(1) VARCHAR2(1) NOT NULL This Y/N flag is used in the Direct Reports module to indicate whether a given employee/job has indirect reports.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
7	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
9	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
10	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
11	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
13	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
14	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
16	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
17	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
18	HR_DRPT_INDIRECT	Character(1)	VARCHAR2(1) NOT NULL	This Y/N flag is used in the Direct Reports module to indicate whether a given employee/job has indirect reports.