INSTITUTIONPrompt Table: INSTITUTION_TBL
ACAD_PLANPrompt Table: ACAD_PLAN_TBL
EFFDTDefault Value: %date
ACAD_PLAN_DG_VW(SQL View) |
Index Back |
|---|---|
Academic Plan Tbl & Degree TblThis is a view that lists the Degrees that can be earned for Plans, including those Plans that are not Degree-bearing. It is used by another view ACAD_PLAN_DP_VW which is used to prompt the ACAD_PLAN field in the Academic Degree Plan panel. |
| select a.institution , a.acad_plan , a.effdt , b.degree , a.diploma_print_fl , a.trnscr_print_fl from PS_ACAD_PLAN_TBL a , ps_degree_tbl b where a.degree = b.degree or a.degree = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table: ACAD_PLAN_TBL |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DEGREE | Character(8) | VARCHAR2(8) NOT NULL | Degree |
| 5 | DIPLOMA_PRINT_FL | Character(1) | VARCHAR2(1) NOT NULL | Print on Diploma |
| 6 | TRNSCR_PRINT_FL | Character(1) | VARCHAR2(1) NOT NULL | Print on Transcript |