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 |