...
B) ACAD_PLAN contains the student's plan, which is the major or minor. A student MUST have one plan but there could be more than one. The keys to this table are;Y EMPLID - Empl ID
Y ACAD_CAREER - Academic Career
Y table layout is below.
Field Description
...
Y EFFDT EFFDT - Effective Date
Y EFFSEQ EFFSEQ - Effective Sequence
Y ACAD_PLAN - Academic Plan
DECLARE_DT - Declare Date
PLAN_SEQUENCE - Plan Sequence
REQ_TERM - Requirement Term
COMPLETION_TERM - Completion Term
STDNT_DEGR - Student Degree Nbr
DEGR_CHKOUT_STAT - Degree Checkout Status
ADVIS_STATUS - Advisement Status
SSR_APT_INSTANCE - APT Instance
SSR_YR_OF_PROG - Year of Program
SCC_ROW_ADD_OPRID - Created By
SCC_ROW_ADD_DTTM - Created
SCC_ROW_UPD_OPRID - Updated By
SCC_ROW_UPD_DTTM - Last Update Date/Time
...