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
|