Page Comparison

...

...

For physical materials, see https://docs.google.com/document/d/1qBB29zs2Ztp_P2EbFrsBr8p_BpLv2Xc4-ZUkZyNM5Iw/edit#heading=h.li2chn5mjo2w used to build Prototype Version 2 (https://docs.google.com/spreadsheets/d/1eoN1qFGTYA4JQG_SY89UvhznCvgGZj6w/ ) which does not use any date variables.

If item addition and/or withdrawal For counts of items added or withdrawn by fiscal year are desired, please consider the following, options include:

• For Added counts :

  • Use “Physical Items“.”Physical Item Details”.”Lifecycle” = Active AND

  • Use “Physical Items”.”Item Creation Date” OR

  • Use “Physical Items”.”Item Receiving Date” and find out why there are research significant impacts at San Diego, Davis, Irvine, Los Angeles, Riverside, San Francisco, and Santa Barbara when dates are added into the data extract in Alma Analytics.

• For Withdrawn counts:

  • Use “Physical Items”.”Item Modification Date” = Deleted and/or None or NULL AND

  • Find out reasons behind the usage of the Deleted value AND/OR

  • Encourage identification of Harmonize on a common field to house a withdrawal/deletion note which consists of at least the initial of the person accountable for the withdrawal/deletion, date of the withdrawal/deletion, and reason behind the withdrawal/deletion for not only statistical reporting purposes but also accountability purposes.

...

• • field and values for deletion notes

Note: ExLibris is reviewing the differences in counts when dates are used in the report/data extraction buildsAnalytics reports as of May, 2023.

Impact

...

UCOP and ARL statistics ask for statistics for a snapshot in time: usually, it’s the end of the most recent fiscal year. Therefore, campuses have in the past used various approaches to exclude any material added after the end of the fiscal year when running reports after that date. For example, a report run on August 1 would be set up to exclude material added after July 1. Alma Analytics has a variety of date fields in records for physical items. However, these fields each have a variety of drawbacks for several reasons, e.g., campus procedures, migration artifacts, and expected other data issues. (Review found acceptable levels of inconsistently clean data in the context of a system with over 40 million physical item records.) The following variables were reviewed :

• Physical Items

  • Lifecycle

  • Material Type v. Resource Type

  • Item Creation Date v. Creation Date

  • Item Receiving Date v. Receiving Date v. Receiving Date (Calendar)

  • Item Modification Date v. Modification Date

Other variables were also reviewed and considered but they played minor roles for the build. They included locations, item policies, call numbers, etc.

...

• Lifecycle

  • Three values are available in this for “Physical Items“.”Physical Item Details”.”Lifecycle” variable:

    • Active items are active and discoverable in Primo.

    • Deleted items are not discoverable.

    • None items are not discoverable. These records are also associated with records without creation dates and possibly other pertinent metadata; consultation with Ex Libris is ongoing.

  • For withdrawn counts, filtering based on lifecycle , where lifecycle equals = “Deleted” and/or “None” will cause the following issuescauses:

    • Exclusion of items that were deleted from the repository after the reporting deadline but before the report run date. For example, if a weeding project happens in August 2023 and hundreds of print items and their associated records are removed, a report looking for the items from before July 2023 that runs in October 2023 will exclude those items, even though they were still in the collection before July 2023.

    • Inclusion of items deleted because they were added by mistake, but that do not actually represent items that were removed from the collection. To account for this type of deleted item would require a change to harmonized approaches, revised local procedures, or both.

• Modification Date

  • There exists are two available modification date options:

    • “Physical Items”.”Item Modification Date”, which cleans up and harmonizes the value available in “Physical Items”.”Physical Items Details”.”Modification Date”. ExLibris documentation reads that says: “The Item Modification date is the date of the last change to the item. Therefore, if on January 19, 2016 the item was in process type Acquisition, on January 20, 2016 the item was in process type Request, and on January 21, 2016 the item was in process type Loan (and no additional change to the item was made after January 21), the Item Modification Date is January 21, 2016.“

    • “Physical Items”.”Physical Items Details”.”Modification Date”, which allows us to know when the item record is modified. ExLibris documentation reads that this variable says it “Holds the date the physical item was modified“.

  • Alma Analytics data-based findings not yet attempted. No similar issues and findings as those found for other date variables are found for modification date variables. AASA-PT team looking for reasons to dive into a study on modification date options. So far, per common knowledge and experience, each of the modification date options suggest automatic generation due to any alteration or modifications attempted. Although not senior seasoned users, per experience in Alma Analytics thus far, the recent availability of the Physical Items Historical Event Subject Area in late 2022, and the current data available in such recent available area provides no complete historical data on the changes behind each record type, be it one on each physical item or one on each bibliographic record.

  • Alma Analytics data-based findings:

    • When crossed with Lifecycle = Delete, modification dates can be useful to determine and account for items withdrawn from the collection (see Prototype Version 1 at https://docs.google.com/spreadsheets/d/1IBV9tKyvO3xq-UZeuLoeEViSmBwgp2YO/edit#gid=552748451 ). However, due to the problems noted in the Lifecycle section of this decision page, certain institutions are requesting to opt out of reporting annual add and withdrawal counts in statistical reporting.

    • No significant findings in the values of the modification date variables.

      • Values in “Physical Items”.”Physical Items Details”.”Modification Date” suggests automatic generation by system when item records are modified. If record has not yet been modified, no modification date is available.

      • Values in “Physical Items”.”Item Modification Date” suggests that this dimension and variable was created to make use of and harmonize any discrepancies found in “Physical Items”.”Physical Items Details”.”Modification Date”. Since none was experienced there, no discrepancies are found in this variable.

  • Based on the reported knowledge and practices, “Physical Items”.”Item Modification Date” would be the best variable to use to determine when the items' records were last modified, especially when the record of the item was deleted. Doing so would encourage leaderships to consider oversights in understanding and reporting about the practices in the deletion of records in the usage of SILS.

  Creation Date

  • Per common database design knowledge, automatic date and time stamps for when records are created are expected, resulting in the choice of creation date values. There exists two available creation date options:

    • “Physical Items”.”Item Creation Date”, which cleans up and harmonizes the value available in “Physical Items”.”Physical Items Details”.”Creation Date” (variable mentioned below; ExLibris documentation reads that this variable “Stores the item creation date in a date format such as 2/29/2014” and that “All date dimensions include dates up to and including 30 years back and 20 years forward. So, for example, if today is March 17, 2021: The earliest loan date that would appear is March 17, 1991. The latest due date that would appear is March 17, 2041.“).

    • “Physical Items”.”Physical Items Details”.”Creation Date”, which allows us to know when the record on the item was created. (ExLibris documentation reads that this variable: “Holds the date the physical item was created” and that “This date is assigned by Alma when the physical item is created.“)

  • Alma-based findings:

  • The abovementioned definition in ExLibris documentations are questionable due to the Alma Analytics data-based findings mentioned in below section.

  • Location of where originating physical item creation date field in Alma which corresponds to those in Alma Analytics is unknown and not yet provided to AASA-PT analysts.

  There are three possibilities of how this field is populated in Alma for Alma Analytics:

  • Items are created on order and, as part of predictions, before the material is received AND/OR

  • Using the “Add Item” button in Physical Item Editor module upon finding bibliographic and/or holdings record AND/OR

  Using other record creation options and practices behind outside of Alma such as those needed and used for initial data migration purposes

  :

  • When crossed with Lifecycle = Delete, modification dates can be useful to determine and account for items withdrawn from the collection (see Prototype Version 1 at https://docs.google.com/spreadsheets/d/1IBV9tKyvO3xq-UZeuLoeEViSmBwgp2YO/edit#gid=552748451 ). However, due to the problems noted in the Lifecycle section of this decision page, certain institutions are requesting to opt out of reporting annual add and withdrawal counts in statistical reporting.

  • Based on the reported knowledge and practices, “Physical Items”.”Item Modification Date” would be the best variable to use to determine when the items' records were last modified, especially when the record of the item was deleted.

• Creation Date

  • Automatic date and time stamps for when records are created are a norm in relational databases. In Alma physical items, there are two creation dates:

    • “Physical Items”.”Item Creation Date”, which cleans up and harmonizes the value available in “Physical Items”.”Physical Items Details”.”Creation Date.” ExLibris documentation says this “Stores the item creation date in a date format such as 2/29/2014” and that “All date dimensions include dates up to and including 30 years back and 20 years forward. So, for example, if today is March 17, 2021: The earliest loan date that would appear is March 17, 1991. The latest due date that would appear is March 17, 2041.“).

    • “Physical Items”.”Physical Items Details”.”Creation Date”, which allows us to know when the record on the item was created. ExLibris documentation says that this “Holds the date the physical item was created” and that “This date is assigned by Alma when the physical item is created.“

  • Note: ExLibris documentation is questionable based on Alma Analytics data-based findings.

• Alma Analytics data-based findings:

  • Initial findings in usage of creation date is documented at https://docs.google.com/document/d/125dx-__jZOHNRH0ysuRLtEr1j33HjV7e/; summarizing that there are ongoing additional records with no or blank creation dates provided over time. Therefore, setting Creation Date = NULL as a data-extract-, report-development cleanup and the like or filter will not provide accurate counts of how many records were created in each specific, non-NULL fiscal year and/or date ranges. This impacts at least 14% (4.9 million records of this finding out of the 34+ million total amount of records made available in Alma Analytics) of the records. This finding continues to be an ongoing issue (see https://docs.google.com/spreadsheets/d/12B7ICBG4DLiViDerm4EwN1Y5BtKByngn/).

  • Recent findings from comparing inclusion and exclusion of creation date in report design criteria show that significant records are dropped when dates such as Creation Date is included. Compare https://docs.google.com/spreadsheets/d/1IBV9tKyvO3xq-UZeuLoeEViSmBwgp2YO/edit#gid=552748451 where Creation Date is included against https://docs.google.com/spreadsheets/d/1eoN1qFGTYA4JQG_SY89UvhznCvgGZj6w/ where Creation Date is excluded. See Table 3.

  • Based on the following and our knowledge of the campuses' current practices, “Physical Items”.”Item Creation Date” would be the best variable to use, if reporting counts of items added into the catalog by fiscal year and/or a particular date range is needed:

    • “Physical Items”.”Physical Items Details”.”Creation Date” is the raw data transferred from Alma to Alma Analytics.

    • “Physical Items”.”Item Creation Date” is the harmonization/data cleanup processed variable based on the Physical Items.Physical Items Details.Creation Date.

...