Versions Compared

Old Version 7

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
Note

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.

  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.

...