HR_SP_DRPT_WRK (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_WRK

(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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 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

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

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

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

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

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

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

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

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

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

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

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

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

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

17 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	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
4	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
7	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
8	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
10	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
13	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
14	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
15	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
16	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
17	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.