HR_DRPT_TESTSUP (SQL Table)	Index Back
Direct Reports Results Used by the HR Direct Reports application class test component to display the results of the various app class methods. This record is used to display the contents of the Supervisor rowset.

HR_DRPT_TESTSUP

(SQL Table)

Direct Reports Results

Used by the HR Direct Reports application class test component to display the results of the various app class methods. This record is used to display the contents of the Supervisor 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 Rcd Nbr

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 SetID

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

6 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

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

8 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

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 EMPLID_PROXY_FOR Character(11) VARCHAR2(11) NOT NULL Used for Task Delegation, this field represents the Emplid of the user for which this user is acting as a proxy

18 EMPL_RCD_PROXY_FOR Number(3,0) SMALLINT NOT NULL Used for Task Delegation, this field represents the Empl_Rcd of the user for which this user is acting as a proxy

19 POSITION_PROXY_FOR Character(8) VARCHAR2(8) NOT NULL Used for Task Delegation when Position Management is used, this field represents the Position for which this user is acting as a proxy. This is generally relevant only when tasks for an open position have been delegated to an individual.

#	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 Rcd Nbr
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 SetID
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
7	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
8	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
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	EMPLID_PROXY_FOR	Character(11)	VARCHAR2(11) NOT NULL	Used for Task Delegation, this field represents the Emplid of the user for which this user is acting as a proxy
18	EMPL_RCD_PROXY_FOR	Number(3,0)	SMALLINT NOT NULL	Used for Task Delegation, this field represents the Empl_Rcd of the user for which this user is acting as a proxy
19	POSITION_PROXY_FOR	Character(8)	VARCHAR2(8) NOT NULL	Used for Task Delegation when Position Management is used, this field represents the Position for which this user is acting as a proxy. This is generally relevant only when tasks for an open position have been delegated to an individual.