136 · ARL Statistics 2008–2009
Question
Number
Footnote
MINNESOTA, cont.
5 Unique title count is done at the institutional level for U of M Libraries, including Health Sciences and Law. Unique titles
counts are not calculated separately for branches. Count uses same methodology as previous years:
A. Purchased
1. Identify all purchased electronic titles using query
a. W85=http and WFT=SE not (W85=gpo or W85=gov or WGP=F or WGP=I or WGP=S) and WSL=?INTE not
WSL=AINTE (i.e. purchased)
b. Removes gov docs
c. Eser_pur
d. 36,160 in 2007
e. 44,702 in 2008
f. 78,239 in 2009
2. Run bib IDs through p_print_03 to get ISSNs from 022
a. Not all the records retrieved in 1a have an 022 field
b. Not unique
c. 34,108 in 2007
d. 40,760 in 2008
e. 48,467 in 2009
3. Run ARC query to get all Bib IDs and ISSNs associated with a Purchase Method order record
a. ser_pur_ord
b. We first made the mistake of limiting to AC and AP order statuses
c. Later we realized that we need to get all our holdings, not just active subscriptions so we removed the status
filter
d. Not unique
e. 21,775 in 2007
f. 30,992 in 2008
g. 32,959 in 2009
4. Compare the ISSNs from #2 with the ISSNs from #3 using Erik’s script and dedupe into two buckets:
a. Purchased electronic titles
i. Includes any overlap between electronic and other formats
ii. 29,486 in 2007
iii. 35,513 in 2008
iv. 47,632 in 2009
b. Purchased titles in print/other format only (i.e., not held electronically)
i. Not counting active subscriptions – counting held titles
ii. 20,752 in 2007
iii. 20,812 in 2008
iv. 22,865 in 2009
c. Overlap (i.e., in both files)
i. 10,227 in 2007
ii. 10,170 in 2008
iii. 10,094 in 2009
Question
Number
Footnote
MINNESOTA, cont.
5 Unique title count is done at the institutional level for U of M Libraries, including Health Sciences and Law. Unique titles
counts are not calculated separately for branches. Count uses same methodology as previous years:
A. Purchased
1. Identify all purchased electronic titles using query
a. W85=http and WFT=SE not (W85=gpo or W85=gov or WGP=F or WGP=I or WGP=S) and WSL=?INTE not
WSL=AINTE (i.e. purchased)
b. Removes gov docs
c. Eser_pur
d. 36,160 in 2007
e. 44,702 in 2008
f. 78,239 in 2009
2. Run bib IDs through p_print_03 to get ISSNs from 022
a. Not all the records retrieved in 1a have an 022 field
b. Not unique
c. 34,108 in 2007
d. 40,760 in 2008
e. 48,467 in 2009
3. Run ARC query to get all Bib IDs and ISSNs associated with a Purchase Method order record
a. ser_pur_ord
b. We first made the mistake of limiting to AC and AP order statuses
c. Later we realized that we need to get all our holdings, not just active subscriptions so we removed the status
filter
d. Not unique
e. 21,775 in 2007
f. 30,992 in 2008
g. 32,959 in 2009
4. Compare the ISSNs from #2 with the ISSNs from #3 using Erik’s script and dedupe into two buckets:
a. Purchased electronic titles
i. Includes any overlap between electronic and other formats
ii. 29,486 in 2007
iii. 35,513 in 2008
iv. 47,632 in 2009
b. Purchased titles in print/other format only (i.e., not held electronically)
i. Not counting active subscriptions – counting held titles
ii. 20,752 in 2007
iii. 20,812 in 2008
iv. 22,865 in 2009
c. Overlap (i.e., in both files)
i. 10,227 in 2007
ii. 10,170 in 2008
iii. 10,094 in 2009
