Schedule of Changes to Oregon newkeys
Note: changes are in order by CITY, not FSCSKEY. Roseburg (newkey = 'OR0068') is the one change to CITY where “OR” was removed.
FY 2005 Changes
Changes were made in the FY 2005 data and noted at the bottom of the following list of changes in newkey. They are for Wagner Community Library. This library's data were moved from one newkey for the FY 2003 data but were changed again for this year because of an anomaly in the assignment of FSCSKEYs during the processing of these data. The following table gives the detail for this library.
Wagner Community Library
| Library Name |
Year |
FSCSKEY |
newkey |
| WAGNER COMMUNITY LIBRARY |
2005 |
OR9004 |
OR9004 |
| WAGNER COMMUNITY LIBRARY |
2004 |
OR9006 |
OR9004 |
| WAGNER COMMUNITY LIBRARY |
2003 |
OR9006 |
OR9004 |
| WAGNER COMMUNITY LIBRARY |
2002 |
OR9004 |
OR9004 |
| WAGNER COMMUNITY LIBRARY |
2001 |
OR9004 |
OR9004 |
Note the change in the FSCSKEY from FY 2002 to FY 2003. This kind of change used to be common and reflected the fact that the impact of these kinds of changes on the longitudinal data was not considered. This kind of change has not occurred in several years...until the change noted above between FY 2004 and FY 2005 for this library. It is odd.
/* ALBANY */
if year = 1987 and FSCSKEY = 'OR0002' then newkey = 'OR0106';
/* ALOHA */
if year = 1987 and FSCSKEY = 'OR0003' then newkey = 'OR0117';
/* AMITY */
if year = 1987 and FSCSKEY = 'OR0004' then newkey = 'OR0002';
/* ARLINGTON */
if year = 1987 and FSCSKEY = 'OR0005' then newkey = 'OR0013';
/* ASTORIA */
if year = 1987 and FSCSKEY = 'OR0006' then newkey = 'OR0023';
/* ATHENA */
if year = 1987 and FSCSKEY = 'OR0007' then newkey = 'OR0035';
/* BAKER */
if year = 1987 and FSCSKEY = 'OR0008' then newkey = 'OR0046';
/* BANDON */
if year = 1987 and FSCSKEY = 'OR0009' then newkey = 'OR0058';
/* BANKS */
if year = 1987 and FSCSKEY = 'OR0010' then newkey = 'OR0138';
/* BEAVERTON */
if year = 1987 and FSCSKEY = 'OR0011' then newkey = 'OR0080';
/* BEND */
if year = 1987 and FSCSKEY = 'OR0012' then newkey = 'OR0091';
/* BOARDMAN */
if year = 1987 and FSCSKEY = 'OR0013' then newkey = 'OR0135';
if year = 1988 and FSCSKEY = 'OR0102' then newkey = 'OR0135';
if year = 1989 and FSCSKEY = 'OR0102' then newkey = 'OR0135';
if year = 1990 and FSCSKEY = 'OR0102' then newkey = 'OR0135';
if year = 1991 and FSCSKEY = 'OR0102' then newkey = 'OR0135';
if year = 1992 and FSCSKEY = 'OR0102' then newkey = 'OR0135';
/* BROOKINGS */
if year = 1987 and FSCSKEY = 'OR0014' then newkey = 'OR0107';
/* BROWNSVILLE */
if year = 1987 and FSCSKEY = 'OR0015' then newkey = 'OR0108';
/* BURNS */
if year = 1987 and FSCSKEY = 'OR0016' then newkey = 'OR0109';
/* CANBY */
if year = 1987 and FSCSKEY = 'OR0017' then newkey = 'OR0110';
/* CLATSKANIE */
if year = 1987 and FSCSKEY = 'OR0018' then newkey = 'OR0112';
/* CONDON */
if year = 1987 and FSCSKEY = 'OR0019' then newkey = 'OR0113';
/* COOS BAY (COOS COOP) */
if year = 1987 and FSCSKEY = 'OR0020' then newkey = 'OR0115';
/* COOS BAY (COOS BAY PL) */
if year = 1987 and FSCSKEY = 'OR0021' then newkey = 'OR0114';
/* COQUILLE */
if year = 1987 and FSCSKEY = 'OR0022' then newkey = 'OR0116';
/* CORNELIUS */
if year = 1987 and FSCSKEY = 'OR0023' then newkey = 'OR0118';
/* CORVALLIS */
if year = 1987 and FSCSKEY = 'OR0024' then newkey = 'OR0119';
/* COTTAGE GROVE */
if year = 1987 and FSCSKEY = 'OR0025' then newkey = 'OR0120';
/* COVE */
if year = 1987 and FSCSKEY = 'OR0026' then newkey = 'OR9975';
/* DALLAS */
if year = 1987 and FSCSKEY = 'OR0027' then newkey = 'OR0121';
/* DAYTON */
if year = 1987 and FSCSKEY = 'OR0028' then newkey = 'OR0122';
/* DUFUR */
if year = 1987 and FSCSKEY = 'OR0029' then newkey = 'OR0123';
/* ECHO */
if year = 1987 and FSCSKEY = 'OR0030' then newkey = 'OR0124';
/* ELGIN */
if year = 1987 and FSCSKEY = 'OR0031' then newkey = 'OR0125';
/* ENTERPRISE (WALLOWA CO.) */
if year = 1987 and FSCSKEY = 'OR0033' then newkey = 'OR0127';
if year = 1988 and FSCSKEY = 'OR0003' then newkey = 'OR0127';
/* ENTERPRISE (ENTERPRISE CITY) */
if year = 1987 and FSCSKEY = 'OR0032' then newkey = 'OR0132';
if year = 1988 and FSCSKEY = 'OR0126' then newkey = 'OR0132';
if year = 1989 and FSCSKEY = 'OR0126' then newkey = 'OR0132';
/* ESTACADA */
if year = 1987 and FSCSKEY = 'OR0034' then newkey = 'OR0004';
/* EUGENE (LANE CO) */
if year = 1987 and FSCSKEY = 'OR0035' then newkey = 'OR0006';
/* EUGENE (EUGENE PL) */
if year = 1987 and FSCSKEY = 'OR0036' then newkey = 'OR0005';
/* FALLS CITY */
if year = 1987 and FSCSKEY = 'OR0037' then newkey = 'OR0007';
/* FLORENCE */
if year = 1987 and FSCSKEY = 'OR0038' then newkey = 'OR0008';
/* FOREST GROVE */
if year = 1987 and FSCSKEY = 'OR0039' then newkey = 'OR0009';
/* FOSSIL */
if year = 1987 and FSCSKEY = 'OR0040' then newkey = 'OR0010';
/* GLADSTONE */
if year = 1987 and FSCSKEY = 'OR0041' then newkey = 'OR0011';
/* GOLD BEACH */
if year = 1987 and FSCSKEY = 'OR0042' then newkey = 'OR0012';
/* GRANTS PASS */
if year = 1987 and FSCSKEY = 'OR0043' then newkey = 'OR0014';
/* HARRISBURG */
if year = 1987 and FSCSKEY = 'OR0044' then newkey = 'OR0015';
/* HEPPNER */
if year = 1987 and FSCSKEY = 'OR0046' then newkey = 'OR0017';
/* HERMISTON */
if year = 1987 and FSCSKEY = 'OR0047' then newkey = 'OR0018';
/* HELIX */
if year = 1987 and FSCSKEY = 'OR0045' then newkey = 'OR0016';
/* HILLSBORO */
if year = 1987 and FSCSKEY = 'OR0048' then newkey = 'OR0019';
/* HOOD RIVER */
if year = 1987 and FSCSKEY = 'OR0049' then newkey = 'OR0020';
/* INDEPENDENCE */
if year = 1987 and FSCSKEY = 'OR0050' then newkey = 'OR0021';
/* IONE */
if year = 1987 and FSCSKEY = 'OR0051' then newkey = 'OR9976';
/* JEFFERSON */
if year = 1987 and FSCSKEY = 'OR0052' then newkey = 'OR0022';
/* JOHN DAY */
if year = 1987 and FSCSKEY = 'OR0053' then newkey = 'OR0024';
/* JOSEPH */
if year = 1987 and FSCSKEY = 'OR0054' then newkey = 'OR0025';
/* JUNCTION CITY */
if year = 1987 and FSCSKEY = 'OR0055' then newkey = 'OR0026';
/* KLAMATH FALLS */
if year = 1987 and FSCSKEY = 'OR0056' then newkey = 'OR0027';
/* LA GRANDE */
if year = 1987 and FSCSKEY = 'OR0057' then newkey = 'OR0028';
/* LAKE OSWEGO */
if year = 1987 and FSCSKEY = 'OR0058' then newkey = 'OR0029';
/* LAKESIDE */
if year = 1987 and FSCSKEY = 'OR0059' then newkey = 'OR0030';
/* LAKEVIEW */
if year = 1987 and FSCSKEY = 'OR0060' then newkey = 'OR0031';
/* LANGLOIS */
if year = 1987 and FSCSKEY = 'OR0061' then newkey = 'OR0032';
/* LEBANON */
if year = 1987 and FSCSKEY = 'OR0062' then newkey = 'OR0033';
/* LINCOLN CITY */
if year = 1987 and FSCSKEY = 'OR0063' then newkey = 'OR0034';
/* LYONS */
if year = 1987 and FSCSKEY = 'OR0064' then newkey = 'OR0036';
/* MADRAS */
if year = 1987 and FSCSKEY = 'OR0065' then newkey = 'OR0037';
/* MAUPIN */
if year = 1987 and FSCSKEY = 'OR0066' then newkey = 'OR0038';
/* MCMINNVILLE */
if year = 1987 and FSCSKEY = 'OR0067' then newkey = 'OR0039';
/* MEDFORD */
if year = 1987 and FSCSKEY = 'OR0068' then newkey = 'OR0041';
/* MILTON-FREEWATER */
if year = 1987 and FSCSKEY = 'OR0069' then newkey = 'OR0042';
/* MILWAUKIE */
if year = 1987 and FSCSKEY = 'OR0070' then newkey = 'OR0043';
/* MOLALLA */
if year = 1987 and FSCSKEY = 'OR0071' then newkey = 'OR0044';
/* MONMOUTH */
if year = 1987 and FSCSKEY = 'OR0072' then newkey = 'OR0045';
/* MT. ANGEL */
if year = 1987 and FSCSKEY = 'OR0073' then newkey = 'OR0047';
/* MYRTLE POINT (FLORA KM. LAIRD) */
if year = 1987 and FSCSKEY = 'OR0074' then newkey = 'OR0049';
/* NEWBERG */
if year = 1987 and FSCSKEY = 'OR0075' then newkey = 'OR0050';
/* NEWPORT */
if year = 1987 and FSCSKEY = 'OR0076' then newkey = 'OR0051';
/* NORTH BEND */
if year = 1987 and FSCSKEY = 'OR0077' then newkey = 'OR0052';
/* NYSSA */
if year = 1987 and FSCSKEY = 'OR0078' then newkey = 'OR0053';
/* OAKRIDGE */
if year = 1987 and FSCSKEY = 'OR0079' then newkey = 'OR0054';
/* ONTARIO */
if year = 1987 and FSCSKEY = 'OR0080' then newkey = 'OR0055';
/* OREGON CITY (OREGON CITY PL) */
if year = 1987 and FSCSKEY = 'OR0081' then newkey = 'OR0056';
/* OREGON CITY (CLACKAMAS CO L) */
if year = 1987 and FSCSKEY = 'OR0082' then newkey = 'OR0057';
/* PENDLETON */
if year = 1987 and FSCSKEY = 'OR0083' then newkey = 'OR0059';
/* PILOT ROCK */
if year = 1987 and FSCSKEY = 'OR0084' then newkey = 'OR0061';
/* PORT ORFORD */
if year = 1987 and FSCSKEY = 'OR0085' then newkey = 'OR0062';
/* PORTLAND (MULTNOMAH) */
if year = 1987 and FSCSKEY = 'OR0088' then newkey = 'OR0063';
/* PORTLAND (TOWN CENTER) */
if year = 1987 and FSCSKEY = 'OR0086' then newkey = 'OR0089';
/* PORTLAND (CEDAR MILL) */
if year = 1987 and FSCSKEY = 'OR0087' then newkey = 'OR0128';
if year = 1988 and FSCSKEY = 'OR0111' then newkey = 'OR0128';
/* POWERS */
if year = 1987 and FSCSKEY = 'OR0089' then newkey = 'OR0064';
/* PRINEVILLE */
if year = 1987 and FSCSKEY = 'OR0090' then newkey = 'OR0065';
/* RAINIER */
if year = 1987 and FSCSKEY = 'OR0091' then newkey = 'OR0066';
/* REDMOND */
if year = 1987 and FSCSKEY = 'OR0092' then newkey = 'OR0067';
if year = 1988 and FSCSKEY = 'OR0067' then newkey = 'OR0067';
if year = 1989 and FSCSKEY = 'OR0067' then newkey = 'OR0067';
/* ROSEBURG */
if year = 1987 and FSCSKEY = 'OR0093' then newkey = 'OR0068';
if year = 2002 and FSCSKEY = 'OR0068' then CITY = 'ROSEBURG';
/* SALEM (CHEMEKETA) */
if year = 1987 and FSCSKEY = 'OR0094' then newkey = 'OR0070';
/* SALEM (SALEM PL) */
if year = 1987 and FSCSKEY = 'OR0095' then newkey = 'OR0069';
/* SANDY */
if year = 1987 and FSCSKEY = 'OR0096' then newkey = 'OR0071';
/* SCAPPOOSE */
if year = 1987 and FSCSKEY = 'OR0097' then newkey = 'OR0072';
/* SCIO */
if year = 1987 and FSCSKEY = 'OR0098' then newkey = 'OR0073';
/* SEASIDE */
if year = 1987 and FSCSKEY = 'OR0099' then newkey = 'OR0074';
/* SHERIDAN */
if year = 1987 and FSCSKEY = 'OR0100' then newkey = 'OR0075';
/* SHERWOOD */
if year = 1987 and FSCSKEY = 'OR0101' then newkey = 'OR0133';
if year = 1988 and FSCSKEY = 'OR0076' then newkey = 'OR0133';
/* SILETZ */
if year = 1987 and FSCSKEY = 'OR0102' then newkey = 'OR0077';
/* SILVERTON */
if year = 1987 and FSCSKEY = 'OR0103' then newkey = 'OR0078';
/* SPRINGFIELD */
if year = 1987 and FSCSKEY = 'OR0104' then newkey = 'OR0079';
/* ST. HELENS */
if year = 1987 and FSCSKEY = 'OR0105' then newkey = 'OR0081';
/* STANFIELD */
if year = 1987 and FSCSKEY = 'OR0106' then newkey = 'OR0082';
/* STAYTON */
if year = 1987 and FSCSKEY = 'OR0107' then newkey = 'OR0083';
/* SWEET HOME */
if year = 1987 and FSCSKEY = 'OR0108' then newkey = 'OR0084';
/* THE DALLES */
if year = 1987 and FSCSKEY = 'OR0109' then newkey = 'OR0085';
/* TIGARD */
if year = 1987 and FSCSKEY = 'OR0110' then newkey = 'OR0086';
/* TILLAMOOK */
if year = 1987 and FSCSKEY = 'OR0111' then newkey = 'OR0087';
/* TOLEDO */
if year = 1987 and FSCSKEY = 'OR0112' then newkey = 'OR0088';
/* TUALATIN */
if year = 1987 and FSCSKEY = 'OR0113' then newkey = 'OR0090';
/* UMATILLA */
if year = 1987 and FSCSKEY = 'OR0114' then newkey = 'OR0092';
/* UNION */
if year = 1987 and FSCSKEY = 'OR0115' then newkey = 'OR0093';
/* VALE */
if year = 1987 and FSCSKEY = 'OR0116' then newkey = 'OR0094';
/* VENETA */
if year = 1987 and FSCSKEY = 'OR0117' then newkey = 'OR0095';
/* VERNONIA */
if year = 1987 and FSCSKEY = 'OR0118' then newkey = 'OR0096';
/* WALDPORT */
if year = 1987 and FSCSKEY = 'OR0119' then newkey = 'OR0097';
/* WALLOWA */
if year = 1987 and FSCSKEY = 'OR0120' then newkey = 'OR0098';
/* WEST LINN */
if year = 1987 and FSCSKEY = 'OR0121' then newkey = 'OR0099';
/* WESTON */
if year = 1987 and FSCSKEY = 'OR0122' then newkey = 'OR0100';
/* WILLAMINA */
if year = 1987 and FSCSKEY = 'OR0123' then newkey = 'OR0101';
/* WILSONVILLE */
if year = 1987 and FSCSKEY = 'OR0124' then newkey = 'OR0103';
/* WOODBURN */
if year = 1987 and FSCSKEY = 'OR0125' then newkey = 'OR0104';
/* YACHATS */
if year = 1987 and FSCSKEY = 'OR0126' then newkey = 'OR0105';
/*--------2005---------*/
/* WAGNER COMMUNITY LIBRARY */
if year = 2003 and FSCSKEY = 'OR9006' then newkey = 'OR9004';
if year = 2004 and FSCSKEY = 'OR9006' then newkey = 'OR9004';
November 22, 2022