HR_SRCH_DR_4

(SQL Table)
Index Back

SES:DirectReports AccessType 4

Access Type 4 - Reports To This table uses Full Position Management. The relationship between an employee/job and a supervisor is defined by the "Reports To" position on the Job record.

# 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 JOB_EFFDT Date(10) DATE Job Effective Date
8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
9 POSITION_EFFDT Date(10) DATE Report To Position Effective Date
10 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
11 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data
12 SUPERVISOR_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if a employee is a supervisor on the direct reports tables.
13 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.
14 HR_SRCH_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id
15 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
16 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.