Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

View file
nameRE_ Spring 2020 MIS Overload Report.msg

...

Academic Services Executive Assistant will need to submit a helpdesk ticket or email to Technology Services to run the script for position number and suffix and assignment type code for “CN” in banner

...

Once the script is complete, Academic Services Executive Assistant will be notified.

...

Academic Services Executive Assistant will then manually update the “assignment type” code for overload class in banner directly and not in Access.

...

Jira Legacy
serverSystem JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQuerykey = AP-260
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
  1. Chronjob runs every Saturday. It populates the ASTY on SIAASGN when it is empty:

    Code Block
    languagesql
    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.

Note

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.