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 Chun (yc935); 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 Uchiyama (mu44); last verified 5/2/24):
  • Couttspdbappr (changed to couttspdbcul once purchased)
• (Andy Horbal (arh269) verified there are currently no PDA/DDA for streaming videos (5/3/24). On 5/3/24, emailed Adam Chandler (alc28) 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'])

Here's one example of an unpurchased title in the catalog (a matching instance record 856 field provides access info; consult with technical services staff for more information):

Links of interest from LTS:

• E-books: Automated purchases: https://confluence.cornell.edu/x/6REFFQ
• Coutts Patron Driven Print batch loading process: https://confluence.cornell.edu/x/7E47F

Contact Linda Miller (lm15) 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