Appendix A -- Data Listings of Files used in Fuzzy Match


SOURCE LISTING
FILE REF = PRTFUZZ AND FILE TYPES = CSV

  -------------------------- FILEREF=PRTFUZZ --------------------------

OBS      SRCCODE

	1    	MASTER.CSV
	2    	STDADDR.CSV
	3    	STDBUSN.CSV
	4    	STDNAME.CSV
	5   	TRANSACT.CSV




MEMBER = MASTER.CSV

OBS                                        SRCCODE

1     Charles Patridge,172 Monce Road,Burlington,CT,06013
2     James Goodnight,SAS Campus Drive,Cary,NC,27513
3     Betty Angell,SAS Campus Drive,Cary,NC,27513




MEMBER = STDADDR.CSV

OBS    SRCCODE

          1    Avenues,Ave        
          2    Avenue,Ave         
          3    Ave,_              
          4    Boulevard,Blvd     
          5    Blvd,_             
          6    Circle,Cir         
          7    Cir ,_             
          8    Crossing,Xing      
          9    Xing,_             
         10    Drawer,Box         
         11    Draw ,Box          
         12    Box,_              
         13    Drive,Dr           
         14    Dr,_               
         15    East,E             
         16    East,_             
         17    Floor,Fl           
         18    Floor,_            
         19    Fort,Ft            
         20    Ft,_               
         21    Heights,Hgt        
         22    Height,Hgt         
         23    Hgt,_              
         24    Highway,Hwy        
         25    Hwy,_              
         26    Lane,Ln            
         27    Ln,_               
         28    North,N            
         29    North,_            
         30    Park,Pk            
         31    Pk,_               
         32    Post Office Box,Box
         33    P O Box,Box        
         34    PO Box,Box         
         35    POBox,Box          
         36    Box,_              
         37    Pointe,Pt          
         38    Point,Pt           
         39    Pt,_               
         40    Road,Rd            
         41    Rd,_               
         42    Route,Rt           
         43    Rt,_               
         44    South,S            
         45    S,_                
         46    Square,Sq          
         47    Square,_           
         48    Street,St          
         49    Street,_           
         50    Terrace,Tr         
         51    Tr,_               
         52    Turnpike,Tpk       
         53    Tpk,_              
         54    West,W             
         55    West,_             



MEMBER = STDBUSN.CSV

OBS    SRCCODE

           1    Agency,Agy       
           2    Business,Busn    
           3    Casualty,Cslty   
           4    Company,Co       
           5    Co,_             
           6    Corporate,Corp   
           7    Corporated,Corp  
           8    Enterprise,Entpze
           9    Enterprize,Entpze
          10    Incorp ,Inc      
          11    Incorporated,Inc 
          12    Insurance,Ins    
          13    Limited,Ltd      
          14    Ltd,_            
          15    Management,Mgmt  
          16    Managing,Mgmt    
          17    Manufacture,Mfg  
          18    Manufacturing,Mfg
          19    Office,Ofce      






MEMBER = STDNAME.CSV

OBS    SRCCODE

1    Charles,Chas 
             2    Charlie,Chas 
             3    Charley,Chas 
             4    Chuck,Chas   
             5    Richard,Dick 
             6    Rick,Dick    
             7    Rickie,Dick  
             8    Rickey,Dick  
             9    Ricky,Dick   
            10    Rich ,Dick   
            11    James,Jim    
            12    Jame ,Jim    
            13    Jimmie,Jim   
            14    Jimmy,Jim    
            15    Jamie,Jim    
            16    Elizabeth,Liz
            17    Betty,Liz    
            18    Beth,Liz     
            19    William,Bill 
            20    Will ,Bill   
            21    Willy,Bill   
            22    Willie,Bill  
            23    Billy,Bill   
            24    Billie,Bill  






MEMBER = TRANSACT.CSV


OBS    SRCCODE

 1    C  Patridge,172 Monce Road,Burlington,Connecticut,06013
 2    Partridge Charlie,Monce Road Box 172,Lake Garda Area,CT.,06035    
 3    Richard Gibson,123 George Washington Turnpike,Burlington,CT.,06013
 4    Jim Good Night,1 SAS Circle,Cary,NC,27513                         
 5    Good-Knight James,SAS Campus Drive,Cary,NC,27513                  
 6    Angell Elizabeth,SAS Campus Drive,Cary,NC,27513                   
 7    Charles Todd,176 Monce Road,Burlington,CT.,06013                  
 8    David Congdon,168 Monce Road,Burlington,CT.,06013                 
 9    Alice Smith,123 George Washington Turnpike,Burlington,CT.,06085   
10    William Smythe,675 G. Washington Tpke,Burlington,CT.,06013        



