PA_RA_PERS_SRC2

(SQL View)

SELECT b.EMPLID , a.NAME , c.NATIONAL_ID FROM PS_PERSON_NAME a , PS_PA_RT_EMP_SETUP b , PS_PERS_NID c WHERE a.EMPLID=b.EMPLID_PAYEE AND c.NATIONAL_ID_TYPE = 'PR' AND a.EMPLID=c.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID