HR_ACTIVEPER_VW (SQL View)	Index Back
Active Person Vw - NO SECURITY NO SECURITY - Use PERSON_PROMPT when security is required. This view returns a row if a person has a current or future active job.

HR_ACTIVEPER_VW

(SQL View)

Active Person Vw - NO SECURITY

NO SECURITY - Use PERSON_PROMPT when security is required. This view returns a row if a person has a current or future active job.

SELECT P.EMPLID , N.NAME , N.LAST_NAME_SRCH , N.NAME_AC FROM PS_PERSON P , PS_PERSON_NAME N WHERE P.EMPLID = N.EMPLID AND EXISTS ( SELECT 'X' FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND P.EMPLID = J.EMPLID 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: PERSON_NAME_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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