Querying for Academic Level Differentials

Use the delivered public query STDENT_TERM_ADMIT_LEVEL to identify individuals with differences between their academic level on the admissions application, as defined on the Application Data page, and their academic level at term start, as seen on the Term Activation page. This query, which you can access through Query Manager, compares an individual's academic level in the Recruiting and Admissions table ADM_APPL_DATA to that same individual's academic level in the Student Records table ACAD_PROG through a view. If the values are different, the query captures these rows and displays them for you in Query Manager.

If the individual's academic level in the ACAD_PROG table is lower than the academic level in the ADM_APPL_DATA table and you want to increase the ACAD_PROG academic level, you must complete one of the following actions:

• Grant the student additional other credit units for a special course through the transfer credit process, provided that the student's academic program bases level and load determination on units.

• Grant the student additional terms in residence credit through the Transfer In Residence Terms field on the Terms In Residence page of the Term Activation component, provided that the student's academic program bases level and load determination on terms.

If the individual's academic level in the ACAD_PROG table is higher than the academic level in the ADM_APPL_DATA table and you want to decrease the ACAD_PROG academic level, you must complete one of the following actions:

• Enter a negative credit amount in the TC Units Adjustment field on the Terms in Residence page of the Term Activation component, provided that the student's academic program bases level and load determination on units.

• Enter a negative terms in residence amount in the Transfer In Residence Terms field on the Terms In Residence page of the Term Activation component, provided that the student's academic program bases level and load determination on terms.