Overview and Caveats

Readmits can be identified primarily by program reasons of '4' or '9'. Unlike a New Student for whom the program reason '2' or '3' can be associated with the current term by the field for admit term, the program reasons indicating a readmit have be filtered by the effective date in the program plan stack. The range currently being used to calculate readmits in CBIL covers the period from five months prior to the begin date of the current term until the end date of the current term.

Because such a wide range of dates could also include readmits who enrolled in the previous term, there must also be at least one fall or spring term between the current term and the most recent term enrolled as a degree-seeking student within the same academic career and institution Using.Prior STRM as Degree or Prior STRM as Nondegree to compute the number of terms between the current term and the previous term cannot be used, however, without programs reasons to determine Admission Type for readmits because students taking hiatus from their studies for one or more semesters could be confused with students transferring back into the original institution after transferring out and matriculating at another institution.

Academic career and primary academic program are used to distinguish among undergraduate readmits, graduate readmits, and nondegree reamits.

Also see Admission Type. Degree Status, Prior STRM as Degree, and Prior STRM as Nondegree

Definitions

Undergraduate Readmit ('74'): A student in an undergraduate academic career and a degree-seeking academic program who has a program reason of '4' or '9' where the program effective date ranges between five months prior to the begin date of the current term and the end date of the current term. Furthermore, the student could not be enrolled in any courses as a degree-seeking student for at least one fall or spring term prior to the current term.

Graduate Readmit ('86'): A student in graduate academic career and a degree-seeking academic program who has a program reason of '4' or '9' where the program effective date ranges between five months prior to the begin date of the current term and the end date of the current term. Like an undergraduate readmit, the student could not be enrolled in any courses as a degree-seeking student for at least one fall or spring term prior to the current term.

Nondegree Readmit ('96'): A student in either an undergraduate or graduate academic career but a nondegree academic program who has a program reason of '4' or '9' where the program effective date ranges between five months prior to the begin date of the current term and the end date of the current term. The student could not be enrolled in any courses as a nondegree student for at least one fall or spring term prior to the current term.

Sample Mapping from CUNYfirst

CF_STDNT_CAR_TERM.
STRM
CF_STDNT_CAR_TERM.
ACAD_CAREER
CF_STDNT_CAR_TERM.
ACAD_PROG_PRIMARY
CF_ACAD_PROG.
PROG_REASON
CF_ACAD_PROG.
EFFDT
CF_TERM_TBL.
TERM_BEGIN_DT
CF_TERM_TBL.
TERM_END_DT
CBIL_HISTORY_FACTS.
IR_PRIOR_STRM_AS_DEGREE
CBIL_HISTORY_FACTS.
IR_PRIOR_STRM_AS_NONDEGREE
CBIL_HISTORY_FACTS.
IR_ADMISSION_TYPE_CODE
CBIL_HISTORY_FACTS.
IR_ADMISSION_TYPE_DESC
1139
UGRD
UGRD
4
4/16/2013
8/28/2013
12/23/2013
1112

74
Undergraduate Readmit
1139
UKCC
UGRD
9
10/12/2013
9/7/2013
2/26/2014
1119

74
Undergraduate Readmit
1139
GRAD
MA
4
5/15/2013
8/28/2013
12/23/2013
1122

86
Graduate Readmit
1139
LAW
LAW
9
8/27/2013
8/26/2013
12/20/2013
1129

86
Graduate Readmit
1139
UGRD
NDEGU
4
6/21/2013
8/28/2013
12/23/2013

1129
96
Nondegree Readmit
1139
GRAD
NDEGG
9
9/1/2013
8/28/2013
12/23/2013

1122
96
Nondegree Readmit

SQL Code for Finding Program Reasons for Readmits

create table IR.CBIL_CF_ADM5
tablespace CBIL_DATA
as
select
distinct SUBQ.CF_EMPLID,
SUBQ.CF_ACAD_CAREER,
SUBQ.CF_INSTITUTION,
SUBQ.CF_STRM,
SUBQ.IR_TERM_ENROLLED_DATE,
SUBQ.EFFDT,
SUBQ.EFFSEQ,
SUBQ.PROG_ACTION,
SUBQ.PROG_REASON
from (select
CART.CF_EMPLID,
CART.CF_ACAD_CAREER,
CART.CF_INSTITUTION,
CART.CF_STRM,
CART.IR_TERM_ENROLLED_DATE,
CART.CF_STDNT_CAR_NBR,
PROG.EFFDT,
PROG.EFFSEQ,
PROG.PROG_ACTION,
PROG.PROG_REASON,
PROG.PROG_STATUS,
rank() over (partition by CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM
order by PROG.EFFDT desc, PROG.EFFSEQ desc, PROG.PROG_ACTION asc) as MAX_RANK
from IR.CBIL_CF_CAR_TERM CART,
IR.CF_TERM_TBL TERM,
IR.CF_ACAD_PROG PROG
where TERM.INSTITUTION = CART.CF_INSTITUTION
and TERM.ACAD_CAREER = CART.CF_ACAD_CAREER
and TERM.STRM = CART.CF_STRM
and PROG.EMPLID = CART.CF_EMPLID
and PROG.ACAD_CAREER = CART.CF_ACAD_CAREER
and PROG.INSTITUTION = CART.CF_INSTITUTION
and PROG.STDNT_CAR_NBR = CART.CF_STDNT_CAR_NBR
and PROG.PROG_REASON in ('4','9')
and PROG.EFFDT >= ADD_MONTHS(TERM.TERM_BEGIN_DT,-5)
and PROG.EFFDT <= TERM.TERM_END_DT) SUBQ
where SUBQ.MAX_RANK = 1
and SUBQ.PROG_STATUS = 'AC';

SQL Code for Combining Readmit Program Reasons with Prior STRM as Degree

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 ('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'

SQL Code for Combining Readmit Program Reasons with Prior STRM as Nondegree


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'