Created by Miki Yanagi on May 29, 2020
This table contains academic subplan information.
ACAD_SUBPLAN - Student Academic Subplan Table contains the data for each student.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | ACAD_PLAN - Academic Plan | Char10 | Acad Plan | |
| → | ACAD_SUB_PLAN - Academic Sub-Plan | Char10 | Sub-Plan | |
| ACAD_SUBPLAN_TYPE - Academic Sub-Plan Type | Char3 | N | Sub-Pl Typ | |
| CIP_CODE - CIP Code | Char13 | CIP Code | ||
| DESCR - Description | Char30 | Descr | ||
| DESCRSHORT - Short Description | Char10 | Short Desc | ||
| DIPLOMA_DESCR - Diploma Description | Char100 | Dipl Descr | ||
| DIPLOMA_INDENT - Number of Characters to Indent | Num2.0 | Indent | ||
| DIPLOMA_PRINT_FL - Print on Diploma | Char1 | Diploma | ||
| EFF_STATUS - Status as of Effective Date | Char1 | N | Status | |
| → | EFFDT - Effective Date | Date | Eff Date | |
| EVALUATE_SUBPLAN - Evaluate SubPlan Before Plan? | Char1 | Eval SubPlan | ||
| FIRST_TERM_VALID - First Term Valid | Char4 | First Term | ||
| HEGIS_CODE - HEGIS Code | Char8 | HEGIS Code | ||
| → | INSTITUTION - Academic Institution | Char5 | Institution | |
| SAA_WHIF_DISP_ADVR - Show In What-If Advisor | Char1 | Show Advisor | ||
| SAA_WHIF_DISP_PREM - Show in What-If Prematric Std | Char1 | Show Premat Std | ||
| SAA_WHIF_DISP_STD - Show in What-If Student | Char1 | Show Student | ||
| SSR_LAST_ADM_TERM - Last Admit Term | Char4 | Last Admit | ||
| SSR_LAST_PRS_DT - Last Prospect Date | Date | Last Prospect | ||
| SUBPLN_REQTRM_DFLT - Sub-Plan Req Term Default | Char1 | N | Default | |
| TRANSCRIPT_LEVEL - Transcript Level | Char2 | N | Tran Level | |
| TRNSCR_DESCR - Transcript Description | Char100 | Trns Descr | ||
| TRNSCR_INDENT - Nbr of Chars Indnt on Transcr | Num2.0 | Indent | ||
| TRNSCR_PRINT_FL - Print on Transcript | Char1 | Transcript |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.