EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
SSR_PROJ_INSTVW(SQL View) |
Index Back |
|---|---|
Project Institution Prompt |
| SELECT DISTINCT a.emplid , a.institution , inst.descr , inst.descrshort FROM %Table(ACAD_PROG) A JOIN %Table(INSTITUTION_TBL) inst ON A.institution = inst.institution WHERE A.effdt=( SELECT MAX(B.effdt) FROM %Table(ACAD_PROG) B WHERE A.emplid=B.emplid AND A.acad_career=B.acad_career AND A.stdnt_car_nbr=B.stdnt_car_nbr AND B.effdt<=%CurrentDateIn ) AND A.effseq=( SELECT MAX(c.effseq) FROM %Table(ACAD_PROG) C WHERE A.emplid=C.emplid AND A.acad_career=C.acad_career AND A.stdnt_car_nbr=C.stdnt_car_nbr AND A.effdt=C.effdt) AND A.PROG_STATUS = 'AC' AND %EffdtCheck(INSTITUTION_TBL eff1, inst , %currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |