3.0 Sprint 8

1. Sprint Release

• 3.0 - Sprint 8
• Release date – May 27, 2016

2. Tag Name: 3.0 Sprint 8

3.  Deliverables

Database Changes: (Relevant only for upgrades)

Oracle: https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-8/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-8/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/mysql/3.0.sql

1) OLE-8857

             Added DATE_UPDATED column to the following tables

OLE_DS_BIB_INFO_T
OLE_DS_BIB_HOLDINGS_T
OLE_DS_ITEM_HOLDINGS_T
OLE_CAT_SHVLG_SCHM_T
OLE_CAT_RCPT_STAT_T
OLE_DS_HOLDINGS_URI_T
OLE_DS_EXT_OWNERSHIP_T
OLE_CAT_TYPE_OWNERSHIP_T
OLE_DS_EXT_OWNERSHIP_NOTE_T
OLE_DS_HOLDINGS_NOTE_T
OLE_CAT_STAT_SRCH_CD_T
OLE_CAT_ITM_TYP_T
OLE_DLVR_ITEM_AVAIL_STAT_T
OLE_DS_HIGH_DENSITY_STORAGE_T
OLE_DS_ITEM_NOTE_T
OLE_DS_ITM_FORMER_IDENTIFIER_T
OLE_DS_LOC_CHECKIN_COUNT_T
OLE_DS_HOLDINGS_COVERAGE_T
OLE_DS_PERPETUAL_ACCESS_T
OLE_DS_ACCESS_LOCATION_CODE_T
OLE_DS_ACCESS_LOCATION_T
OLE_DS_HOLDINGS_STAT_SEARCH_T
OLE_DS_ITEM_STAT_SEARCH_T
OLE_DS_AUTHENTICATION_TYPE_T
OLE_DS_ITEM_DONOR_T
OLE_DS_HOLDINGS_DONOR_T
OLE_DS_DOC_TYPE_T
OLE_DS_DOC_FORMAT_T
OLE_DS_DOC_FIELD_T
OLE_DS_SEARCH_RESULT_PAGE_T
OLE_DS_SEARCH_FACET_SIZE_T

Added the following triggers

BIB_INFO_TR_INSERT
BIB_INFO_TR_UPDATE
BIB_HLD_TR_INSERT
BIB_HLD_TR_UPDATE
ITM_HLD_TR_INSERT
ITM_HLD_TR_UPDATE
SHVLG_SCHM_TR_INSERT
SHVLG_SCHM_TR_UPDATE
RCPT_STAT_TR_INSERT
RCPT_STAT_TR_UPDATE
HLD_URI_TR_INSERT
HLD_URI_TR_UPDATE
EXT_OWNR_TR_INSERT
EXT_OWNR_TR_UPDATE
TYP_OWNR_TR_INSERT
TYP_OWNR_TR_UPDATE
EXT_OWNR_NOTE_TR_INSERT
EXT_OWNR_NOTE_TR_UPDATE
HLD_NOTE_TR_INSERT
HLD_NOTE_TR_UPDATE
STAT_SRCH_CD_TR_INSERT
STAT_SRCH_CD_TR_UPDATE
ITM_TYP_TR_INSERT
ITM_TYP_TR_UPDATE
ITEM_AVAIL_STAT_TR_INSERT
ITEM_AVAIL_STAT_TR_UPDATE
HIGH_DEN_STRG_TR_INSERT
HIGH_DEN_STRG_TR_UPDATE
ITEM_NOTE_TR_INSERT
ITEM_NOTE_TR_UPDATE
ITM_FRMR_ID_TR_INSERT
ITM_FRMR_ID_TR_UPDATE
LOC_CHKIN_CNT_TR_INSERT
LOC_CHKIN_CNT_TR_UPDATE
HLD_COVERAGE_TR_INSERT
HLD_COVERAGE_TR_UPDATE
PERPETUAL_ACCESS_TR_INSERT
PERPETUAL_ACCESS_TR_UPDATE
ACS_LOCN_CODE_TR_INSERT
ACS_LOCN_CODE_TR_UPDATE
ACS_LOCN_TR_INSERT
ACS_LOCN_TR_UPDATE
HLD_STAT_SEARCH_TR_INSERT
HLD_STAT_SEARCH_TR_UPDATE
ITEM_STAT_SEARCH_TR_INSERT
ITEM_STAT_SEARCH_TR_UPDATE
AUTH_TYPE_TR_INSERT
AUTH_TYPE_TR_UPDATE
ITEM_DONOR_TR_INSERT
ITEM_DONOR_TR_UPDATE
HLD_DONOR_TR_INSERT
HLD_DONOR_TR_UPDATE
DOC_TYPE_TR_INSERT
DOC_TYPE_TR_UPDATE
DOC_FORMAT_TR_INSERT
DOC_FORMAT_TR_UPDATE
DOC_FIELD_TR_INSERT
DOC_FIELD_TR_UPDATE
SRCH_RESULT_PAGE_TR_INSERT
SRCH_RESULT_PAGE_TR_UPDATE
SRCH_FACET_SIZE_TR_INSERT
SRCH_FACET_SIZE_TR_UPDATE

2) OLE-8606

            Inserted record into OLE_BAT_PRCS_TYP_T table for EDI Export
 

System parameters:

Nil

Workflow xml change:

Nil

4. Jiras