...
To reiterate: A student is active in the system when the student's academic program is active. In order to have an academic program student has to have a career. Once active in a program, a student can be term activated. Once activated in a term, a student can enroll. The academic program (ACAD_PROG) owns the activation record (STDNT_CAR_TERM) and the activation record owns the enrollment (STDNT_ENRL) record. An active students is enrolled for the term if the STNDT_CAR_TERM.UNT_TAKEN_PRGRSS is greater than zero or there is one or more enrolled classes, STDNT_ENRL.STDNT_ENRL_STATUS = 'E'. Mockup
The image below has described the flow of an active student enrolled in course(s):