Change number Description Module Change Type SI number PRB number PC files Implementation Notes
1 Incremental ETL - Deletion from the STG_FACT_LOANS and STG_FACT_REQUEST tables is not done properly. As a result, records that still exist in Aleph are deleted from ARC. This has been corrected. REPORTS Correction 16384-317237 - - Refer to "The ARC Service Pack - v3.00" document.
2 System performance has been improved by changing the function that creates the DWH_DIM_ITEM_BARCODE table. REPORTS Correction 16384-315777 - - Refer to "The ARC Service Pack - v3.00" document.
3 Incremental ETL - When an item history record is deleted from Aleph, deletion from STG_FACT_ITEMS creates an "invalid number" error message in the ETL "General Error Messages" report. This has been corrected. REPORTS Correction 16384-357567 - - Refer to "The ARC Service Pack - v3.00" document.
4 Incremental ETL - The sublibrary in the STG_FACT_REQUEST table is sometimes empty ("-") although a sublibrary is defined for the item. This has been corrected. REPORTS Correction 16384-324296 - - Refer to "The ARC Service Pack - v3.00" document.
5 Incremental ETL - Performance improvement. The RI procedures that run on DWH_FACT_ITEMS and DWH_FACT_HISTORY_ITEMS have been changed to run on the data delta only (MRR_FACT_ITEMS). Note that when deleting records from configuration tables in Aleph, the records are not deleted from the ARC DB until running a full ETL. REPORTS Correction 16384-360442 - - Refer to "The ARC Service Pack - v3.00" document.
6 ARC EVENTS are now updated after scrubbing (p-cir-32) is executed on Z35 records. Patrons' information is scrubbed from ARC, as well. REPORTS Correction 175799 - - Refer to "The ARC Service Pack - v3.00" document.