For quite some time, CUL has been removing counts of its unpurchased PDA/DDA (Patron Driven Acquisition/Demand Driven Acquisition) titles for its annual data collection as requested by national definitions. These can be for physical or electronic titles, including media if any. However, CUL decided that it would not remove EBA (Evidence Based Acquisition) titles, as that model is based in part on subscription plans, and CUL does not remove e-resources purchased on a subscription basis, vs. on a permanent basis. (LTS’s Jesse K. and Weill’s Michael Wood agree on including EBA counts, and ACRL has since condoned it through its FAQs.) At least once a year, A&P consults with LTS staff to see which coding should be used to remove these counts.
899|a notes are used to identify both unpurchased and purchased PDA/DDA items. Codes are changed once an item is purchased. LTS has verified that only these 899|a codes (and no other criteria) are needed to identify those items not yet purchased:
- E-books (LTS contact: You Lee; last verified 5/2/24):
- DDA_pqecebks (changed to CUL_pqecebks once purchased)
- PDA_casaliniebkmu (changed to CUL_casaliniebksmu once purchased)
- Print books (LTS contact: Masayo; last verified 5/2/24):
- Couttspdbappr (changed to couttspdbcul once purchased)
...
- (Andy Horbal verified there are currently no PDA/DDA for streaming videos (5/3/24)
...
- . On 5/3/24, emailed Adam C. to ask if there are any other codes beyond these.)
Sample LDP SQL:
SELECT DISTINCT
sm.instance_id,
...
sm."content" AS "unpurchased"
FROM srs_marctab AS sm
WHERE sm.field LIKE '899'
AND sm.sf LIKE 'a'
AND sm."content" ILIKE 'couttspdbappr'
SELECT DISTINCT
sm.instance_hrid,
...
sm."content" AS "unpurchased"
FROM srs_marctab AS sm
...
WHERE sm.field = '899'
...
ND sm.sf LIKE 'a'
AND sm.CONTENT ILIKE ANY (ARRAY['DDA_pqecebks', 'PDA_casaliniebkmu'])
Links of interest from LTS:
...