Identifying and updating student types and time status for dissertation and practicum enrollment

REG_STATUS_UPDATE_C

• The AppWorx “REG_STATUS_UPDATE_C” process flow runs three jobs:

  • REG_DISSERT_TYPE_M

  • SFRTMST

  • REG_UPDATE_RS_TMST_M  

   

  Open

  

REG_DISSERT_TYPE_M

Calls the “tulane.zp_main_dissertType.pz_main_dissertType procedure.  This procedure performs two functions:

• Call the “tulane.zp_translate_dissertType.pz_translate_dissertType_pr” procedure to promote students enrolled in dissertation courses and are identified by a graduate or professional student type to the graduate research or professional research student types.  The translation mapping is stored in the GZVCODE table where GZVCODE_CODE_TYPE = 'Promote'.  The new student type is set in SGBSTDN_STYP_CODE.

• Call the “tulane.zp_translate_dissertType.pz_translate_dissertType_de” procedure to demote students with a graduate research or professional research student type that are not enrolled in a dissertation course to the graduate or professional student type.  The translation mapping is stored in the GZVCODE table where GZVCODE_CODE_TYPE = 'Demote'.

SFRTMST

• Executes the Banner baseline “SFRTMST” job to update student’s time statuses based on the configured time status rules in the “SFRTMST” table (SFATMST Banner form).

REG_UPDATE_RS_TMST_M

• Calls the “tulane.pz_update_rs_tmst” procedure to update the time status in SFBETRM to '00' if student types 8, D, E, Q have a time status 'RS' with no enrolled courses or if student types A, B, F have a time status 'FT' with no enrolled courses. Also, V (Guest) student type on any graduate or professional level (G%, P%) who is enrolled in a research course (9960, 9970, 9980, 9990) with any other time status than 'RS' will be updated to 'RS' time status.

Definitions

• Research Dissertation Courses – Courses with course numbers (SSBSECT_CRSE_NUMB) beginning with 997 or 999, and course numbers that equal 9960 and 9980.

• Teaching Certification Dissertation Courses – Courses with course numbers (SSBSECT_CRSE_NUMB) that equal EDUC-52** (3 credits).

• Graduate and Professional Student Types (SGBSTDN_STYP_CODE):

  • A - New Graduate TA or RA

  • B - Continuing Graduate TA or RA

  • G - New Graduate

  • K - Continuing Professional

  • P - New Professional

  • Y - Continuing Graduate

  • O - Continuing NUN

  • 3 - Continuing NUN Transfer

• Research Student Types (SGBSTDN_STYP_CODE):

  • 8 - Continuing PR Research

  • D - Continuing GR Research

  • E - New Graduate Research

  • Q - New Professional Research

  • R - Teaching Residency

Additional considerations

• The SHRTYPE job run at the end of the semester will reset anyone in a research student type back to the default student type.  There is a rules table that defines which student types are rolled to which student types.  The “R” student type will need to be added to this rules table.

Process goal

• Students registered in one of these 3-credit courses (EDUC 52**) will be given a fulltime time status regardless of how many total credit hours they are registered for.

  • Could be SoPA or NTC students.

  • Will always be UG.

  • Will this ever be a “new” student type?  It is possible, but not likely. Assumption = no.

  • Can we modify REG_SHRTYPE_C to have a pre-step that assigns the subsequent type based on the student type in the semester prior to the R type?

  • R = “Teaching Practicum”

• Articulation of student types below:

On this page

Related content