3.0 Sprint 4

1. Sprint Release

• 3.0 - Sprint 4
• Release date – April 1, 2016

2. Tag Name:  3.0 Sprint 4 Items

3.  Deliverables

Database Changes: (Relevant only for upgrades)

Oracle: https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-4/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/oracle/3.0.sql

MySQL: https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-4/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/mysql/3.0.sql

1) OLE-6445

            Added system parameters CR_ITEMS_COUNT_TOWARD_LOANED_ITEMS_COUNT,

            NOTIFY_CLAIMS_RETURNED_TO_PATRON, CLAIMS_RETURNED_NOTICE_TITLE,
            CLAIMS_RETURNED_NOTICE_CONTENT, CLAIMS_RETURNED_FOUND_NO_FEES_NOTICE_TITLE,
            CLAIMS_RETURNED_FOUND_NO_FEES_NOTICE_CONTENT, CLAIMS_RETURNED_FOUND_FINES_OWED_NOTICE_TITLE,
            CLAIMS_RETURNED_FOUND_FINES_OWED_NOTICE_CONTENT, CR_ITEM_SEARCH_COUNT_BEFORE_ITEM_BILLED,
            CLAIMS_RETURNED_NOT_FOUND_FINES_OWED_NOTICE_TITLE, CLAIMS_RETURNED_NOT_FOUND_FINES_OWED_NOTICE_CONTENT,
            CLAIMS_RETURNED_NOT_FOUND_NOTICE_TITLE, CLAIMS_RETURNED_NOT_FOUND_NOTICE_CONTENT,
            CLAIMS_RETURNED_NOT_FOUND_NO_FEES_NOTICE_TITLE, CLAIMS_RETURNED_NOT_FOUND_NO_FEES_NOTICE_CONTENT

            Inserted record to the table OLE_PTRN_PAY_STA_T with PAY_STA_CODE=PAY_SUSPENDED.

            Inserted record to the table OLE_DLVR_ITEM_AVAIL_STAT_T with ITEM_AVAIL_STAT_CD=MISSING.

            Added columns NUM_CLAIMS_RTRN_NOTICES_SENT ,  CLAIMS_SEARCH_COUNT,  LAST_CLAIMS_RTRN_SEARCH_DT to the table OLE_DLVR_LOAN_T.

           Increased the field size to 100 for the column NTC_TYP in table OLE_DLVR_LOAN_NOTICE_T and OLE_DLVR_LOAN_NOTICE_HSTRY_T.

2) OLE-7917

             Added system parameter POBA_CANCEL_PDF_CREATION to the table KRCR_PARM_T to control PDF generation in PO.

System parameters:

1) OLE-6445

            Added system parameters CR_ITEMS_COUNT_TOWARD_LOANED_ITEMS_COUNT,

            NOTIFY_CLAIMS_RETURNED_TO_PATRON, CLAIMS_RETURNED_NOTICE_TITLE,
            CLAIMS_RETURNED_NOTICE_CONTENT, CLAIMS_RETURNED_FOUND_NO_FEES_NOTICE_TITLE,
            CLAIMS_RETURNED_FOUND_NO_FEES_NOTICE_CONTENT, CLAIMS_RETURNED_FOUND_FINES_OWED_NOTICE_TITLE,
            CLAIMS_RETURNED_FOUND_FINES_OWED_NOTICE_CONTENT, CR_ITEM_SEARCH_COUNT_BEFORE_ITEM_BILLED,
            CLAIMS_RETURNED_NOT_FOUND_FINES_OWED_NOTICE_TITLE, CLAIMS_RETURNED_NOT_FOUND_FINES_OWED_NOTICE_CONTENT,
            CLAIMS_RETURNED_NOT_FOUND_NOTICE_TITLE, CLAIMS_RETURNED_NOT_FOUND_NOTICE_CONTENT,
            CLAIMS_RETURNED_NOT_FOUND_NO_FEES_NOTICE_TITLE, CLAIMS_RETURNED_NOT_FOUND_NO_FEES_NOTICE_CONTENT

2) OLE-7917

             Added system parameter POBA_CANCEL_PDF_CREATION to the table KRCR_PARM_T to control PDF generation in PO.

Workflow xml change:

Nil

Drools files:

1) OLE-6445

            https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-4/ole-app/olefs/src/it/resources/org/kuali/ole/deliver/rules/demo/claimsReturned/CLAIMS-RETURNED.drl - newly created file, needs to be ingested.

2) OLE-8543

         https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-4/ole-app/olefs/src/it/resources/org/kuali/ole/deliver/rules/demo/fines/daily-fines.drl
         https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-4/ole-app/olefs/src/it/resources/org/kuali/ole/deliver/rules/demo/fines/short-term.drl

         - both the files are modified, needs to be ingested.

4. Jiras