Versions Compared

Old Version 3

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version Current

changes.mady.by.user Jordan Lamb

Saved on

Key

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

...

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.