Created by Miki Yanagi on May 29, 2020
This table contains student's academic plan information.
ACAD_PLAN_TBL - Academic Plan Table contains the data regarding academic plan.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | N | Career |
| → | ACAD_PLAN - Academic Plan | Char10 | Acad Plan | |
| ADVIS_STATUS - Advisement Status | Char4 | N | Status | |
| COMPLETION_TERM - Completion Term | Char4 | Compl Term | ||
| DECLARE_DT - Declare Date | Date | Decl Date | ||
| DEGR_CHKOUT_STAT - Degree Checkout Status | Char2 | N | ChkoutStat | |
| → | EFFDT - Effective Date | Date | Eff Date | |
| → | EFFSEQ - Effective Sequence | Num3.0 | Sequence | |
| → | EMPLID - Empl ID | Char11 | ID | |
| PLAN_SEQUENCE - Plan Sequence | Num2.0 | Plan Seq | ||
| 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 | ||
| SSR_APT_INSTANCE - APT Instance | Num3.0 | Instance | ||
| SSR_YR_OF_PROG - Year of Program | Char4 | N | Year of Program | |
| → | STDNT_CAR_NBR - Student Career Nbr | Num3.0 | Career Nbr | |
| STDNT_DEGR - Student Degree Nbr | Char2 | Degree 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.