This custom process no longer works given the extensive and distributed work taking place on SIAASGN. The ongoing process will require collaboration between Academic Services and Human Resources to define correct Position Number and Suffix for this purpose. Conversations surrounding FLAC and going XE baseline Banner will be benefited by more critical eyes on positions and suffix source data.
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"
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.
Add Comment