Batch applying FTF and TRF cohort codes when census is called - REG_FTF_TRF_COHORTS_C
Overview
This APPWORX process is run immediately after Census has been called in fall and spring semesters. The job assigns RFTF and RTRF cohort codes to two populations of students: incoming NTC first-time freshmen (student type = N) and incoming NTC transfer students (student type = T). Applying cohorts to students allows for tracking time to degree, retention, and completion rates.
If new cohort codes need to be created, this can be done in STVCHRT. When setting up the new FTF and TRF codes, STVTERM must be built out at least 6 years in the future, as cohort completion rates are calculated based on 6 years from the students' entry term. STVTERM is dependent on the creation of academic years in STVACYR. All of these validation forms can be built out years in advance, but they all may need to be updated prior to running the cohort assignment job, so it is best to ensure all of the necessary future codes have been built in the validation tables in preparation for the census call.
Create cohort codes
If cohort FTF and TRF codes do not already exist for the current term, create them on STVCHRT:
Cohort Code
FTF codes will begin with “RFTF” and end with the six-digit cohort term
TRF codes will begin with “RTRF” and end with the six-digit cohort term
Description
Follow standard naming format
Start Term
The current, cohort term
End Term
The completion term, six years in the future
Degree Level
Since we are only using this process to code NTC undergraduates, enter a bachelor level degree code, BA
Print Indicator
Check this box
Appworx request
REG_FTF_TRF_COHORTS_C
Parameters
Term
The current, cohort term
Run Mode - required
Run in Audit (A) mode to check output
Compare the output total to the FTF and TRF Enrollment report as of census call
This report is located in the Cognos shared directory
Instructions for accessing the directory can be found here: https://tulaneu.atlassian.net/wiki/spaces/REGISTRAR/pages/134414431
Run in Update (U) mode to update student records
Verify
Ensure the update run of the job’s numbers match the FTF and TRF Enrollment report
Spot check N and T student types' cohort coding in SGASADD
On this page