You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


For quite some time, CUL has been removing counts of its unpurchased PDA/DDA (Patron Driven Acquisition/Demand Driven Acquisition) titles 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)).




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'

  AND sm.sf LIKE 'a'

AND sm.CONTENT ILIKE ANY (ARRAY['DDA_pqecebks', 'PDA_casaliniebkmu'])



Links of interest from LTS:


 

Contact Linda Miller or LTS for more details.

 

And some EBA info for use in non-ADC queries (EBA titles are NOT excluded for ADC purposes):

  • Any records with 899 code starting EBA_* are not perpetual access.
  • Any records with 899 code starting CUL_EBA* are perpetual access.
  • But note that some records for EBA don’t have 899 code at all, as they are EBSCO records. See: https://confluence.cornell.edu/x/gSuZGQ
  • No labels