HGA_SCH_DR_7 (SQL View)	Index Back
Direct Reports Type 7 This view extracts the direct reports based on access type 7.

HGA_SCH_DR_7

(SQL View)

Direct Reports Type 7

This view extracts the direct reports based on access type 7.

SELECT A7.SUPERVISOR_ID ,A7.EMPLID ,A7.EMPL_RCD ,A7.HR_SRCH_ASSOC_CD ,A7.HR_DR_LEVEL ,' ' ,A7.LASTUPDDTTM FROM PS_HR_SRCH_DR_7 A7 , PS_HR_SRCH_CONTROL C7 WHERE C7.ACCESS_TYPE='7' AND C7.PTSF_SBONAME='HC_GP_ABS_SRCH_BAL' AND A7.SUPERVISOR_ID<>A7.EMPLID UNION SELECT EMPLID ,EMPLID ,0 ,'SLF' ,0 ,' ' ,%Sql(HR_SRCH_DT_TO_DTTM,PRD_END_DT) FROM PS_HGA_BALSS_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

4 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

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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	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
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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
7	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.