Footnotes · 141
MINNESOTA, cont.
5.a 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
h. 33,688 in 2010
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
v. 51,868 in 2010
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
v. 24,343 in 2010
c. Overlap (i.e., in both files)
i. 10,227 in 2007
ii. 10,170 in 2008
iii. 10,094 in 2009
iv. 9,344 in 2010
5.b Breakdown for categories i,ii,and iv is not available. Total non-purchased title is 33,470 of which 22,434 are electronic and 11,036 are
print. Change is due to the fact that 2008-2009 figures are incorrectly recorded due to a miscommunication. Total for 2008-2009 should
be 31,163 of which 20,263 are electronic and 10,900 are print.
B. Not Purchased
1. Identify all non-purchased electronic titles using query
a. W85=http and WFT=SE MINUS 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 (ie not purchased)
b. i.e., start with any serial record with a link and then take out those that are not gov docs
c. Eser_not_pur
d. 16,293 in 2007
e. 17,867 in 2008
f. 20,368 in 2009
g. 22,479 in 2010
2. Run bib IDs through p_print_03 to get ISSNs from 022
a. Most of these records do not have an 022 field
b. Since we don’t expect to have order records for these titles, we plan to add the full number of records without
ISSNs back into the total at the end.
i. In 2006-2007, this number was 13,000
ii. In 2007-2008, this number was 13,571
MINNESOTA, cont.
5.a 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
h. 33,688 in 2010
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
v. 51,868 in 2010
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
v. 24,343 in 2010
c. Overlap (i.e., in both files)
i. 10,227 in 2007
ii. 10,170 in 2008
iii. 10,094 in 2009
iv. 9,344 in 2010
5.b Breakdown for categories i,ii,and iv is not available. Total non-purchased title is 33,470 of which 22,434 are electronic and 11,036 are
print. Change is due to the fact that 2008-2009 figures are incorrectly recorded due to a miscommunication. Total for 2008-2009 should
be 31,163 of which 20,263 are electronic and 10,900 are print.
B. Not Purchased
1. Identify all non-purchased electronic titles using query
a. W85=http and WFT=SE MINUS 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 (ie not purchased)
b. i.e., start with any serial record with a link and then take out those that are not gov docs
c. Eser_not_pur
d. 16,293 in 2007
e. 17,867 in 2008
f. 20,368 in 2009
g. 22,479 in 2010
2. Run bib IDs through p_print_03 to get ISSNs from 022
a. Most of these records do not have an 022 field
b. Since we don’t expect to have order records for these titles, we plan to add the full number of records without
ISSNs back into the total at the end.
i. In 2006-2007, this number was 13,000
ii. In 2007-2008, this number was 13,571
