VC_ACT_PERS_VW (SQL View)	Index Back
Empl Rec number prompt view Variable Comp: This view returns record number for a given employee. Only active employee are returned.

VC_ACT_PERS_VW

(SQL View)

Empl Rec number prompt view

Variable Comp: This view returns record number for a given employee. Only active employee are returned.

SELECT A.EMPLID , A.EMPL_RCD FROM PS_JOB A , PS_PER_ORG_ASGN B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.PER_ORG = 'EMP' AND %EffdtCheck(JOB, A, %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX (EFFSEQ) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record