Schedule of Changes to North Carolina newkeys


/* MARION           */
if year = 1987 and FSCSKEY = 'NC0043' then newkey = 'NC0044';

/* MARSHALL         */
if year = 1987 and FSCSKEY = 'NC0044' then newkey = 'NC0043';

/* CHINA GROVE      */
if year = 1987 and FSCSKEY = 'NC0072' then newkey = 'NC9975';

/* CLAYTON          */
if year = 1987 and FSCSKEY = 'NC0073' then newkey = 'NC0072';

/* DUNN             */
if year = 1987 and FSCSKEY = 'NC0074' then newkey = 'NC0073';

/* ENFIELD          */
if year = 1987 and FSCSKEY = 'NC0075' then newkey = 'NC0074';

/* FARMVILLE        */
if year = 1987 and FSCSKEY = 'NC0077' then newkey = 'NC0075';

/* FAITH            */
if year = 1987 and FSCSKEY = 'NC0076' then newkey = 'NC9976';

/* FOREST CITY      */
if year = 1987 and FSCSKEY = 'NC0078' then newkey = 'NC0076';

/* FOUNTAIN         */
if year = 1987 and FSCSKEY = 'NC0079' then newkey = 'NC0077';

/* FOUR OAKS        */
if year = 1987 and FSCSKEY = 'NC0080' then newkey = 'NC0078';

/* HICKORY          */
if year = 1987 and FSCSKEY = 'NC0082' then newkey = 'NC0079';

/* HIGH POINT       */
if year = 1987 and FSCSKEY = 'NC0083' then newkey = 'NC0080';

/* GRIFTON          */
if year = 1987 and FSCSKEY = 'NC0081' then newkey = 'NC9977';

/* KENLY            */
if year = 1987 and FSCSKEY = 'NC0084' then newkey = 'NC0081';

/* KINGS MOUNTAIN   */
if year = 1987 and FSCSKEY = 'NC0085' then newkey = 'NC0082';

/* MOORESVILLE      */
if year = 1987 and FSCSKEY = 'NC0087' then newkey = 'NC0083';

/* NASHVILLE        */
if year = 1987 and FSCSKEY = 'NC0088' then newkey = 'NC0102';
if year = 1988 and FSCSKEY = 'NC0084' then newkey = 'NC0102';
if year = 1989 and FSCSKEY = 'NC0084' then newkey = 'NC0102';

/* NORLINA          */
if year = 1987 and FSCSKEY = 'NC0089' then newkey = 'NC0085';

/* MIDDLESEX        */
if year = 1987 and FSCSKEY = 'NC0086' then newkey = 'NC9978';

/* PINEHURST        */
if year = 1987 and FSCSKEY = 'NC0090' then newkey = 'NC0086';

/* ROANOKE RAPIDS   */
if year = 1987 and FSCSKEY = 'NC0091' then newkey = 'NC0088';

/* RUTHERFORTON     */
if year = 1987 and FSCSKEY = 'NC0092' then newkey = 'NC0089';

/* SELMA (SELMA PUBLIC LIBRARY) */
if year = 1987 and FSCSKEY = 'NC0095' then newkey = 'NC0090';

/* SELMA (ATKINSON MEMORIAL)    */
if year = 1987 and FSCSKEY = 'NC0094' then newkey = 'NC0091';

/* SCOTLAND NECK    */
if year = 1987 and FSCSKEY = 'NC0093' then newkey = 'NC0092';

/* SOUTHERN PINES   */
if year = 1987 and FSCSKEY = 'NC0096' then newkey = 'NC0093';

/* SPENCER          */
if year = 1987 and FSCSKEY = 'NC0097' then newkey = 'NC0094';

/* SPINDALE         */
if year = 1987 and FSCSKEY = 'NC0098' then newkey = 'NC0095';

/* SPRING HOPE      */
if year = 1987 and FSCSKEY = 'NC0099' then newkey = 'NC0096';

/* WALLACE          */
if year = 1987 and FSCSKEY = 'NC0100' then newkey = 'NC0097';

/* WARRENTON (WARREN COUNTY COMMUNITY CENTER) */
if year = 1987 and FSCSKEY = 'NC0101' then newkey = 'NC0098';
if year = 1988 and FSCSKEY = 'NC0098' then newkey = 'NC0098';

/* WASHINGTON       */
if year = 1987 and FSCSKEY = 'NC0102' then newkey = 'NC0099';

/* WARRENTON (WARREN COUNTY MEMORIAL LIBRARY) */
if year = 1987 and FSCSKEY = 'NC0064' then newkey = 'NC0101';
if year = 1988 and FSCSKEY = 'NC0064' then newkey = 'NC0101';
if year = 1989 and FSCSKEY = 'NC0064' then newkey = 'NC0101';

/* WHITAKERS        */
if year = 1987 and FSCSKEY = 'NC0103' then newkey = 'NC9979';
if year = 1988 and FSCSKEY = 'NC0100' then newkey = 'NC9979';
if year = 1989 and FSCSKEY = 'NC0100' then newkey = 'NC9979';  

/*-------------------2007----------------------------------------------------*/                                                         
                                                                                                                                        
/* Is NC0103 Alamance County Public Libraries reporting first in FY 2007 the */                                                         
/* same as NC0005 Central North Carolina Regional Library which reported from*/                                                         
/* FY 1987 through FY 2006? Same street address. I believe not. CNCRL had 6  */                                                         
/* branches and ACPLs have 4. I think it is a different system after a       */                                                         
/* reorganization. I think NC0104 Chatham County Public Libraries is the rest*/                                                         
/* of it.                                                                    */                                                         
                                                                                                                                        
/* QUALLA BOUNDARY PUBLIC LIBRARY  */                                                                                                   
if year = 1987 and FSCSKEY = 'NC0104' then newkey = 'NC9980';                                                                           
                                                                                                                                        
/*-------------------2007----------------------------------------------------*/                                                         
                                                                                          

December 16, 2022