EMPLIDPrompt Table: PEOPLE_SRCH
CIP_CODEEFFDTDefault Value: %date
SSR_STDNT_CIPVW(SQL View) |
Index Back |
|---|---|
Student Plan CIP Code ViewStudent Plan CIP Code View |
| SELECT DISTINCT B.EMPLID , C.CIP_CODE , A.EFFDT , D.DESCR FROM PS_ACAD_PROG A , PS_ACAD_PLAN B , PS_ACAD_PLAN_TBL C , PS_CIP_CODE_TBL D WHERE A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND C.INSTITUTION = A.INSTITUTION AND C.ACAD_PLAN = B.ACAD_PLAN AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_ACAD_PLAN_TBL C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.ACAD_PLAN = C.ACAD_PLAN AND C1.EFFDT <= A.EFFDT) AND D.CIP_CODE = C.CIP_CODE AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CIP_CODE_TBL D1 WHERE D1.CIP_CODE = D.CIP_CODE AND D1.EFFDT <= A.EFFDT) |
| # | 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 | CIP_CODE |
Character(13) | VARCHAR2(13) NOT NULL | CIP code |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |