Report format & data fields

Purpose: Reports generated should be in CSV format and include the following data & fields

User story statement(s):

As a librarian,
I want to have a CSV report with these data fields
so that I can find errors and discrepancies between remote storage and FOLIO

Scenarios:

1. Scenario:
   • Given Remote storage reports
   • When I export or pull a report
   • Then it will be a CVS file
2. Scenario:
   • Given remote storage reports
   • When I pull or export a report
   • Then the following fields are mandatory

     Barcode

     Bib HRID

     CaiaSoft Customer ID

     Call number

     Collection

     Error Message

     Error Type

     Exception message

     Expected CaiaSoft Customer ID

     Holding HRID

     Item HRID

     Item location

     Item state

     Temp location (Y/N)

     Title (245 subfield a)

3. Scenario:
   • Given remote storage reports
   • When I pull or export a report
   • Then the following fields are optional (selection of optional fields will be a separate story)

     Call number type

     Chronology

     Enumeration

     Item Depository ID (was LSCID)

     Loan Status

     Location

     New Collection

     New Loan Status

     New Location