SAD_SL_STDLNK_NBRSAD_SL_EXTS2_VW(SQL View) |
Index Back |
|---|---|
View from PS_EXTERNAL_SYSTEMView from PS_EXTERNAL_SYSTEM |
| SELECT %Substring(A.EXTERNAL_SYSTEM_ID,1,9 ) , A.EMPLID FROM PS_EXTERNAL_SYSTEM A WHERE A.EXTERNAL_SYSTEM='SLN' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_EXTERNAL_SYSTEM B WHERE A.EMPLID =B.EMPLID AND A.EXTERNAL_SYSTEM =B.EXTERNAL_SYSTEM AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_SL_STDLNK_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Studielink Number |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |