Position Number and Suffix Process

Owned by Jordan Lamb
Last updated: Oct 09, 2023
1 min read

key summary type created updated due assignee reporter priority status resolution
Refresh

  1. Chronjob runs every Saturday. It populates the ASTY on SIAASGN when it is empty:

    Update SCBCRSE set SIRASGN_ASTY_CODE = 'CN' where SIRASGN_ASTY_CODE is NULL and scbcrse_credit_status_code="Y" Update SCBCRSE set SIRASGN_ASTY_CODE = 'NN' where SIRASGN_ASTY_CODE is NULL and scbcrse_credit_status_code<>"Y"

  2. Khantee goes in and changes the Assignment Type to CO on SIAASGN for those sections that exceed at least 50% of their standard workload (previously decided threshold). That work to be completed by 11/15 annually and an email of completion will be sent to Data Steward.

We may have to eventually run this on spring semesters if there are issues with our custom XE report (related to XE01) or if we have to go to XE baseline at some point. A change to FLAC may also necessitate this.

If a section is added after 10/31-11/15 we’ll accept that deviation or correct it if appears in the error report. The expectation is that the number of late add CRNs is negligible and may not take a faculty member over the load thresholds.