Created by Miki Yanagi, last modified on May 29, 2020
This table contains student's academic subplan information.
ACAD_SUBPLN_TBL - Academic Sub Plan Table contains the data regarding academic subplan.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | N | Career |
| → | ACAD_PLAN - Academic Plan | Char10 | Acad Plan | |
| → | ACAD_SUB_PLAN - Academic Sub-Plan | Char10 | Sub-Plan | |
| DECLARE_DT - Declare Date | Date | Decl Date | ||
| → | EFFDT - Effective Date | Date | Eff Date | |
| → | EFFSEQ - Effective Sequence | Num3.0 | Sequence | |
| → | EMPLID - Empl ID | Char11 | ID | |
| REQ_TERM - Requirement Term | Char4 | Req Term | ||
| SCC_ROW_ADD_DTTM - Created | DateTm | Created | ||
| SCC_ROW_ADD_OPRID - Created By | Char30 | Created By | ||
| SCC_ROW_UPD_DTTM - Last Update Date/Time | DateTm | Updated | ||
| SCC_ROW_UPD_OPRID - Updated By | Char30 | By | ||
| → | STDNT_CAR_NBR - Student Career Nbr | Num3.0 | Career Nbr |
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.