Field Name | Field Descr |
EMPLID | Student/Person ID number |
ACAD_CAREER | Code for Academic Career. Value attached to the student. |
STDNT_CAR_NBR | Career Number assigned to Academic Program |
EFFDT | Date the data or action takes effect |
EFFSEQ | Sequence for actions with the same Effective Date |
ACAD_PROG | Code for Academic Program |
PROG_STATUS | Student's status in Academic Program |
PROG_ACTION | Code of the Academic Program action taken |
ACTION_DT | Actual date the data was entered (as opposed to when it takes effect) |
PROG_REASON | Code for the reason for the Program Action |
ADMIT_TERM | Admit Term into the Academic Program |
EXP_GRAD_TERM | Expected graduation term |
REQ_TERM | Term used in degree, DPR requirements |
COMPLETION_TERM | Term the Program/Plan was completed |
Begin at this table when pulling student's Program/Plan, then to ACAD_PLAN. |
To pull active in a Program: PROG_STATUS = AC |
To pull completed Program: PROG_STATUS = CM |
Field ADMIT_TERM is when the student was admitted into the Program, not necessarily admitted into SMU. |
Codes for degree candidates. ELIG = eligible to apply for graduation. ACG = applied to graduate. CAND = approved as a degree candidate |
When joining from STDNT_CAR_TERM or STDNT_ENRL, do not include STDNT_CAR_NBR in the join. |
When joining to ACAD_PROG, do not join by EFFSEQ |