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'