Definitions
First-time Freshmen ('01'): Students who have not previously earned college credit at any college or university and who are enrolled at a CUNY institution as first-time matriculated freshmen: Included students enrolled as first-time freshmen during the past summer term. Students attending high school during the current term but also enrolled in enrichment courses at the college are to be coded as nondegree students,
not as first-time freshmen. (See
New Student for mapping from CUNYfirst.)
Readmit ('74','86','96): Degree-seeking students who have interrupted their attendance as a matriculant at an institution for a period of at least one full fall or spring term and are readmitted in the current term. Also include students who have interrupted their attendance as matriculants, had become nonmatriculants, and now seek reinstatement with matriculant status. (See
Readmit for mapping from CUNYfirst.)
Caveats
Because of the relative reliability of data elements in CUNYfirst used to calculate Admission Type and because of the challenges involved in filtering out the appropriate program reason from the program plan stack, some students may appear to belong to more than one admission category. For example, it can be difficult to determine whether a student has been readmitted to a degree program after a hiatus or has transferred back after attending another institution. In the script that populates the table CBIL_HISTORY_FACTS, status as a transfer based on program reasons takes precedence over status as a readmit based on program reasons, and status as a readmit based on program reasons takes precedence over status as a transfer based on admit type in the admission record. The order of operations for evaluating Admission Type can be found in the SQL code at the bottom of this page.
Sources for undergraduate advanced standing transfers (11-26) have not yet been calculated in CBIL. For example, '11' = Undergraduate Transfer from CUNY CC with Degree.
Upper/lower division transfers (41-43) have not yet been calculated in CBIL. For example, '41' = Internal Transfer from AA to BA with Degree.
Also see
New Student,
Readmit, and
Unclassified New Undergraduates or Graduates
Codes and Descriptions
CBIL_HISTORY_FACTS.
IR_ADMISSION_TYPE_CODE
|
CBIL_HISTORY_FACTS.
IR_ADMISSION_TYPE_DESC
|
CBIL_HISTORY_FACTS.
IR_NEW_STUDENT_CODE
|
CBIL_HISTORY_FACTS.
IR_NEW_STUDENT_DESC
|
01
|
First-Time Freshman
|
1
|
First-time Freshmen
|
27
|
Undergraduate Transfer from Unknown Sources
|
2
|
Advanced Standing Transfers
|
70
|
Internal Transfer from Undergraduate Nondegree
to Degree
|
|
|
74
|
Undergraduate Readmit
|
|
|
80
|
First-time Graduate Matriculant
|
3
|
First-time Graduate Matriculant
|
84
|
Internal Transfer from Graduate Nondegree to Degree
|
|
|
86
|
Graduate Readmit
|
|
|
87
|
Graduate Transfer
|
3
|
First-time Graduate Matriculant
|
92
|
College Now
|
|
|
93
|
Early College Initiative
|
|
|
94
|
Other High School Program
|
|
|
95
|
Permit-In
|
|
|
96
|
Nondegree Readmit
|
|
|
97
|
First-time Nondegree
|
|
|
98
|
Continuing Nondegree
|
|
|
99
|
Continuing Degree
|
|
|
SQL for Order of Evaluation
case when substr(MAIN.STDNT_GROUP_PERMIT_IN_CODE,1,2) = 'PI'
then '95'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and PROG_REASON_ADMIT_TYPE_6_CODE = '2'
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM
then '01'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and PROG_REASON_ADMIT_TYPE_6_CODE = '3'
then '27'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')
and substr(CF_STRM,4,1) = '2'
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) > 3
then '74'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')
and substr(CF_STRM,4,1) = '9'
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) > 7
then '74'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and MAIN.PROG_REASON_INTERN_TRANS_CODE in ('0','8')
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM
then '70'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and MAIN.ADMIT_TYPE = '2'
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM
then '01'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('CBUIS','UGRD')
and MAIN.ADMIT_TYPE = '3'
then '27'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and PROG_REASON_ADMIT_TYPE_6_CODE = '2'
then '80'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and PROG_REASON_ADMIT_TYPE_6_CODE = '3'
then '87'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')
and substr(CF_STRM,4,1) = '2'
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) > 3
then '86'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')
and substr(CF_STRM,4,1) = '9'
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) > 7
then '86'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and MAIN.PROG_REASON_INTERN_TRANS_CODE in ('0','8')
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM
then '84'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and MAIN.ADMIT_TYPE = '2'
then '80'
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')
and MAIN.ADMIT_TYPE = '3'
then '87'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('ADVCT','ADVDP','CBUIS','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP','UGRD')
and MAIN.CF_STRM <> MAIN.IR_FIRST_STRM_AS_DEGREE
then '99'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEG','NDEGU')
and MAIN.STDNT_GROUP_HIGH_SCHOOL_CODE
in ('CNOW')
then '92'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEG','NDEGU')
and MAIN.STDNT_GROUP_HIGH_SCHOOL_CODE
in ('ECI','HSCP','HSE','HSEC','HSPT')
then '93'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEG','NDEGU')
and MAIN.STDNT_GROUP_HIGH_SCHOOL_CODE
in ('CP','HIGH','HSAM','HSMD','HSS','JUMP','TWHS')
then '94'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEGG','NDEG','NDEGU')
and MAIN.IR_FIRST_STRM_AS_NONDEGREE = MAIN.CF_STRM
then '97'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEGG','NDEG','NDEGU')
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')
and substr(CF_STRM,4,1) = '2'
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_NONDEGREE)) > 3
then '96'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEGG','NDEG','NDEGU')
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')
and substr(CF_STRM,4,1) = '9'
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_NONDEGREE)) > 7
then '96'
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')
and MAIN.CF_ACAD_PROG_PRIMARY
in ('NDEGG','NDEG','NDEGU')
and MAIN.IR_FIRST_STRM_AS_NONDEGREE <> MAIN.CF_STRM
then '98'
else '00'
end as IR_ADMISSION_TYPE_CODE,
.