PY_CO_EMP_VW (SQL View)	Index Back
VW- JOB data Information on company, emplid and employment record number.

PY_CO_EMP_VW

(SQL View)

VW- JOB data

Information on company, emplid and employment record number.

SELECT DISTINCT A.COMPANY , A.EMPLID ,B.NAME ,B.LAST_NAME ,B.FIRST_NAME ,B.SECOND_LAST_NAME ,B.NAME_AC FROM PS_Job A , PS_PERSON_NAME B WHERE A.EFFDT = ( SELECT MAX(C.EffDt) FROM PS_Job C WHERE C.EmplID = A.EmplID AND C.EMPL_RCD = A.EMPL_RCD AND C.EffDt <= %CurrentDateIn) AND A.EffSeq = ( SELECT MAX(D.EffSeq) FROM PS_Job D WHERE D.EmplID = A.EmplID AND D.EMPL_RCD = A.EMPL_RCD AND D.EffDt = A.EffDt) AND A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PERSON.EMPLID
Prompt Table: PERSON

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

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

6 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
7	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name