...
The term 'active' student is derived from the student's academic program (ACAD_PROG). All students must have an academic program and the status (PROG_STATUS) of that program is derived from the last action (PROG_ACTION) in the academic program stack. An action of matriculation, quick admit and readmit will change the PROG_STATUS to active ('AC'); completion will change the status to 'CM'; cancellation will change the status to 'CN'. Some actions do not change the status. These include data change, program change and plan change. CUNYfirst uses five statuses below:
| 'AC' |
...
| Active | |
| 'CM' |
...
| Completed | |
| 'CN' |
...
| Cancelled | |
| 'DC' |
...
| Discontinued | |
| 'DM' | Dismissed |
for dismissed.
A student can be term-activated only when the academic program is active. Term activation creates the STDNT_CAR_TERM record and the student will have one of these records for each term of activation. This record maintains a running total of all credits, academic levels, GPAs, etc. for the student's career. One useful field in the STDNT_CAR_TERM record is UNT_TAKEN_PRGRSS. If this field is greater than zero, then the student is enrolled in one or more credit-bearing classes. The system totals the number of credits from class enrollment. If a student is enrolled in a three-credit class, UNT_TAKEN_PRGRSS will equal three; enrollment in four three-credit classes will yield a value of twelve. A student with a value greater than zero in this field means that this active student is also enrolled. If you are trying to determine whether a student is enrolled for the term, checking UNT_TAKEN_PRGRSS is the first step. If however a student is enrolled in non-credit classes only and that student should be included in the enrolled-student count, it would be necessary to go to the next level.
...