INSTITUTIONACAD_PLANACAD_SUB_PLANEFFDTDefault Value: %date
ADM_WEB_SUB_VW(SQL View) |
Index Back |
|---|---|
Web Prospect Sub Plan VwAn Academic Sub Plan is a focus within an academic plan. An example of a subplan might be an American history concentration within the history major (plan). |
| SELECT a.institution , a.acad_plan , a.acad_sub_plan , a.effdt , a.descr FROM PS_ACAD_SUBPLN_TBL a WHERE (%CurrentDateIn <= a.SSR_LAST_PRS_DT OR a.SSR_LAST_PRS_DT IS NULL) AND a.effdt = ( SELECT MAX(b.effdt) FROM PS_ACAD_SUBPLN_TBL b WHERE b.institution = a.institution AND b.acad_plan = a.acad_plan AND b.acad_sub_plan = a.acad_sub_plan AND b.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
| 3 | ACAD_SUB_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Sub-Plan |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |