Batch applying FTF and TRF cohort codes when census is called - REG_FTF_TRF_COHORTS_C

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

    • 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