EMPLIDSAD_SL_NATIONALITYSAD_SL_NATIONALTY2SAD_SL_NAT_BND(SQL View) |
Index Back |
|---|---|
Msg 51 Nationality Bind ViewThe Msg 51 Nationality PopSelect bind view |
| SELECT DISTINCT A.EMPLID , A.SSR_NATIONAL_NLD , B.SSR_NATIONAL_NLD FROM PS_SAD_SL_NAT_1_VW A FULL OUTER JOIN PS_SAD_SL_NAT_2_VW B ON A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SAD_SL_NATIONALITY |
Character(4) | VARCHAR2(4) NOT NULL | Nationality |
| 3 | SAD_SL_NATIONALTY2 |
Character(4) | VARCHAR2(4) NOT NULL | Nationality2 |