FAQs

Accession

Q: Does the Accession (Ongoing) fail in SCSB despite having an unique item barcode?

A: It is possible that the different barcode have the same item id. SCSB expects the owning institution item id to be unique. This is unlikely to occur though we have seen such records among partner's data. This is a data issue and must be fixed at the partner's ILS before attempting to accession again.

Customer Code

Q: How to add new or edit / delete existing Customer Code / Delivery Locations in SCSB application?

A: The Customer Code and Delivery Locations are part of the customer_code_t table (columns CUSTOMER_CODE and DELIVERY_RESTRICTIONS). New additions, modifications or deletions needs to be handled by using appropriate SQL scripts to insert, update or delete the data.

Sample Insert query

INSERT INTO `recap`.`customer_code_t` (`CUSTOMER_CODE_ID`, `CUSTOMER_CODE`, `DESCRIPTION`, `OWNING_INST_ID`, `DELIVERY_RESTRICTIONS`, `PWD_DELIVERY_RESTRICTIONS`, `RECAP_DELIVERY_RESTRICTIONS`, `CIRC_DESK_LOCATION`) VALUES ('100', 'ZZ', 'ZZ', '1', 'ZZ', 'ZZ', 'ZZ', 'ZZ');

Sample Update query

UPDATE `recap`.`customer_code_t` 
SET 
    `CUSTOMER_CODE_ID` = '11',
    `CUSTOMER_CODE` = 'SZ',
    `DESCRIPTION` = 'ZZ',
    `DELIVERY_RESTRICTIONS` = 'ZZ',
    `PWD_DELIVERY_RESTRICTIONS` = 'ZZ',
    `RECAP_DELIVERY_RESTRICTIONS` = 'ZZ',
    `CIRC_DESK_LOCATION` = 'ZZ'
WHERE
    `CUSTOMER_CODE_ID` = '10';

Sample Delete query

DELETE FROM `recap`.`customer_code_t` WHERE `CUSTOMER_CODE_ID`='9';