HR_DIRECT_REP_6

(SQL Table)
Index Back

Direct Reports Access Type 6

Access Type 6 - Partial Position Management / Department Manager Id This table contains a combination of "Reports To" and "Department Manager Id". First, the "Reports To" method is executed, and then the "Department Manager Id" method is executed. The results of these two methods are combined, giving preference to the "Reports To" method. This method should be used only when Partial Position Management has been implemented.

# 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 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
9 DEPT_EFFDT Date(10) DATE Department Table Effective Date
10 JOB_EFFDT Date(10) DATE Job Effective Date
11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
12 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
13 SUPERVISOR_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if a employee is a supervisor on the direct reports tables.
14 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.