Definition

The worksheet "Enrollment by Admission Category" in the Oracle Discoverer workbook 'IRABH.CBILEnrollment Report" may have rows for "Unclassified New Undergraduates" or "Unclassified New Graduates".

Unclassified New Undergraduates are students in an undergraduate career for whom the current term is the first fall or spring term enrolled as a degree-seeking student but for whom there is no record in the ACAD_PROG table where the admission term equals the current term and the program reason has a value (e.g., '2' or '3') that would classify the student as a first-time freshman or an undergraduate advanced standing transfer.

Unclassified New Graduates are students in a graduate career for whom the current term is the first fall or spring term enrolled as a degree-seeking student but for whom there is no record in the ACAD_PROG table where the admission term equals the current term and the program reasons has a value (e.g., '2' or '3') that would classified the student as a first-time graduate student or a graduate advanced standing transfer.

Caveats

Students may fall into the categories of Unclassified New Undergraduates or Unclassified New Graduates because they deferred matriculation for a semester (e.g., CUNYStart participants), because they dropped all of their courses before the cutoff date of their original term of admission, or because they do not have program reasons that could be used to classify them as first-time students or transfers.

A list of such students can be found in the worksheet "Unclassified New Degree Students" in the Oracle Discoverer workbook "IRABH.CBIL.Enrollment". The registrar may be able to resolve the type of admission of such students by updating the field ADMIT_TERM or the field PROG_REASON in the table ACAD_PROG. If unable to correct the problem in CUNYfirst, the registrar can send OIRA a list of EMPLID's with the proper codes for type of admission.

Unclassified New Undergraduates are not included in the worksheet "New Undergraduate Students" in the Oracle Discoverer workbook "IRABH.CBIL Flash Dataset", but they are included in the degree headcount of the worksheet "Undergraduate Enrollment".

Unclassified New Graduates are not included in the worksheet "New Graduate Students" in the Oracle Discoverer workbook "IRABH.CBIL Flash Dataset", but they are included in the degree headcount of the worksheet "Graduate (Non-Doctoral) Enrollment" or the worksheet "Doctoral Enrollment".

When Unclassified New Undergraduates can be matched with records in the CAS file, their Admission Category in the CBIL Enrollment Report is reclassified as "New Undergraduates in CAS File" and they are included with "First-time Freshmen" in the CBIL Flash Dataset.

When Unclassified New Undergraduates can be matched with records in the ASTA file, their Admission Category in the CBIL Enrollment Report is reclassified as "New Undergraduates in ASTA File" and they are included with "Advanced Standing Transfers" in the CBIL Flash Dataset.

All summer admission terms in the table CF_ACAD_PROG are recoded to fall admission terms when comparing them to current terms of enrollment or first terms as a degree student.

Also see Degree Status, New Student, and First STRM as Degree

Sample Mapping from CUNYfirst

CF_STDNT_CAR_TERM.
INSTITUTION
CF_STDNT_CAR_TERM.
STRM
CF_STDNT_CAR_TERM.
ACAD_CAREER
CF_STDNT_CAR_TERM.
ACAD_PROG_PRIMARY
CF_ACAD_PROG.
ADMIT_TERM
CF_ACAD_PROG.
PROG_REASON
CAS_FILE
ASTA_FILE
CBIL_HISTORY_FACTS.
IR_FIRST_STRM_AS_DEGREE
CBIL_HISTORY_FACTS.
IR_ADMISSION_CATEGORY_CODE
CBIL_HISTORY_FACTS.
IR_ADMISSION_CATEGORY_DESC
KCC01
1139
UKCC
UGRD
1136
2


1139
01
First-time Freshmen


BKL01
1139
UGRD
CBUIS
1139
3


1139
02
Undergraduate Advanced Standing Tranfers
QCC01
1139
UGRD
UGRD
1139

201309

1139
03
New Undergraduates in CAS File
QCC01
1139
UGRD
UGRD
1139


201309
1139
04
New Undergraduates in ASTA File
QCC01
1139
UGRD
UGRD
1139



1139
06
Unclassified New Undergraduates
QCC01
1142
UGRD
UGRD
1139
2


1142
06
Unclassified New Undergraduates
QNS01
1139
GRAD
MA
1139
2


1139
10
First-time Graduate Matriculants
HTR01
1139
DOCT
DNP
1139
3


1139
11
Graduate Advanced Standing Transfers
QNS01
1139
GRAD
MS
1139



1139
13
Unclassified New Graduates
QNS01
1142
GRAD
MSW
1139
2


1142
13
Unclassified New Graduates