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.
10 Incremental ETL - Performance improvement. SCRIPTS GENERAL SCRIPTS REPORTS Enhancement 16384-443768 - - Refer to "The ARC Service Pack - v3.00" document.
11 Fix a bug in Cash package that causes data corruption in reports when using fields, such as Patron StatusID and Cash Sub Library. REPORTS Correction 00023724 - - Refer to "The ARC Service Pack - v3.00" document.
12 In the 'Acquisition Budgets' package, fields under Orders -> Periods -> Subscription From Date retrieve incorrect data. This is caused by missing relations between objects. REPORTS Correction 00070678 - - Refer to "The ARC Service Pack - v3.00" document.
13 Incremental ETL - After requests are deleted, the 'Number of current requests' is not correct in the STG_FACT_ITEMS table. This has been corrected. REPORTS Correction 00097921 - - Refer to "The ARC Service Pack - v3.00" document.