GPBR_EMP_NID_VW

(SQL View)
Index Back

Employee National ID View

Employee CPF National ID.

SELECT B.EMPLID , B.NATIONAL_ID FROM PS_PERS_NID B WHERE B.COUNTRY = 'BRA' AND B.NATIONAL_ID_TYPE = 'CPF'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

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