EMPLIDSA_ADVR_VW(SQL View) |
Index Back |
|---|---|
View of current AdvisorsView of current Advisors for Role Purposes |
| SELECT DISTINCT A.ADVISOR_ID AS EMPLID FROM PS_STDNT_ADVR_HIST A WHERE A.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_STDNT_ADVR_HIST Z WHERE A.EMPLID = Z.EMPLID AND A.INSTITUTION = Z.INSTITUTION AND A.ADVISOR_ROLE = Z.ADVISOR_ROLE AND A.STDNT_ADVISOR_NBR = Z.STDNT_ADVISOR_NBR AND A.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |