HRDR_RPTTO_EMTY (SQL Table)	Index Back
Direct Reports Empty Positions This table is used by direct reports to resolve positions or reporting values that have no incumbents.

HRDR_RPTTO_EMTY

(SQL Table)

Direct Reports Empty Positions

This table is used by direct reports to resolve positions or reporting values that have no incumbents.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

3 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.

4 SUPERVISOR_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if a employee is a supervisor on the direct reports tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
3	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.
4	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.