HR_JTRNOMGR_VW (SQL View)	Index Back
Active Person Vw - NO SECURITY NO SECURITY EMPLID prompt for Job Tree Builder, Build Method = By Dept Sec Tree. Used when root node is not assigned to a manager.

HR_JTRNOMGR_VW

(SQL View)

Active Person Vw - NO SECURITY

NO SECURITY EMPLID prompt for Job Tree Builder, Build Method = By Dept Sec Tree. Used when root node is not assigned to a manager.

SELECT DISTINCT J.SETID_DEPT , J.EMPLID , J.DEPTID , N.NAME , N.LAST_NAME_SRCH , N.NAME_AC FROM PS_JOB J , PS_PERSON_NAME N WHERE J.EMPLID = N.EMPLID AND J.HR_STATUS = 'A' AND (J.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = J.EMPLID AND C.EMPL_RCD = J.EMPL_RCD AND C.EFFDT <= %CurrentDateIn) OR J.EFFDT > %CurrentDateIn) AND J.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = J.EMPLID AND D.EMPL_RCD = J.EMPL_RCD AND D.EFFDT = J.EFFDT)

Related Language Record: HR_JTRNOMGR_LW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

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

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name