SAD_SL_OND_VW

(SQL View)
Index Back

SELECT EMPLID , NATIONAL_ID FROM PS_PERS_NID WHERE COUNTRY = 'NLD' AND NATIONAL_ID_TYPE = 'OND'

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