Add effective copy number to loans exports

Purpose: Add additional call number information to the overdue loans and users' loans exports. Currently, the call number body is exported for each item, but additional fields make up the effective call number string and these should be present as separate columns in the export.

Scenarios

1. Scenario
   • Given the Overdue loans report (CSV) option in the Users pane header dropdown
   • When clicked
   • Then export a CSV file with the following headers:
     • Borrower name
     • Borrower barcode
     • Borrower ID
     • Due date
     • Loan date
     • Loan policy
     • Loan policy ID
     • Loan ID
     • Fee/Fine
     • Item title
     • Material type
     • Item status
     • Barcode
     • Call number prefix
     • Call number
     • Call number suffix
     • Volume
     • Enumeration
     • Chronology
     • Copy number
     • Sortable call number
     • Contributors
     • Location
     • Instance ID
     • Holdings ID
     • Item ID
2. Scenario
   • Given a loan that is overdue
   • When the Overdue loans export (CSV) is exported
   • Then populate call number and enumeration data for each item as follows:
     • Call number prefix: item's effective call number prefix
     • Call number: item's effective call number
     • Call number suffix: item's effective call number suffix
     • Volume: item's volume
     • Enumeration: item's enumeration
     • Chronology: item's chronology
     • Copy number: item's effective copy number
     • Sortable call number: item's sortable call number
3. Scenario
   • Given the Export to CSV option on a user's loan history for open loans
   • When clicked
   • Then export a CSV file with the following headers:
     • Action
     • Due date
     • Loan date
     • Barcode
     • Call number prefix
     • Call number
     • Call number suffix
     • Volume
     • Enumeration
     • Chronology
     • Copy number
     • Sortable call number
     • Contributors
     • Holdings record ID
     • Instance ID
     • Item status
     • Item title
     • Material type
     • Location
     • Created by
     • Updated date
     • Updated by
     • Loan policy ID
4. Scenario
   • Given a loan in a user's open loans
   • When the Export to CSV button is clicked
   • Then populate call number and enumeration data for each item as follows:
     • Call number prefix: item's effective call number prefix
     • Call number: item's effective call number
     • Call number suffix: item's effective call number suffix
     • Volume: item's volume
     • Enumeration: item's enumeration
     • Chronology: item's chronology
     • Copy number: item's effective copy number
     • Sortable call number: item's sortable call number
5. Scenario
   • Given the Export to CSV option on a user's loan history for closed loans
   • When clicked
   • Then export a CSV file with the following headers:
     • Action
     • Due date
     • Loan date
     • Barcode
     • Call number prefix
     • Call number
     • Call number suffix
     • Volume
     • Enumeration
     • Chronology
     • Copy number
     • Sortable call number
     • Contributors
     • Holdings record ID
     • Instance ID
     • Item status
     • Item title
     • Material type
     • Location
     • Created by
     • Updated date
     • Updated by
     • Loan policy ID
6. Scenario
   • Given a loan in a user's closed loans
   • When the Export to CSV button is clicked
   • Then populate call number and enumeration data for each item as follows:
     • Call number prefix: item's effective call number prefix
     • Call number: item's effective call number
     • Call number suffix: item's effective call number suffix
     • Volume: item's volume
     • Enumeration: item's enumeration
     • Chronology: item's chronology
     • Copy number: item's effective copy number
     • Sortable call number: item's sortable call number

Notes

• Bold fields are in scope for this report; all other fields are covered by previous exports and included only to indicate in what order the columns should display
• Not all items will have the in-scope fields populated.