Rolodex file from Water Supply Inventory

Number of Records In File: 11160
Number of Data Fields In File: 71

Data That Is Stored Within This File
Note  =  Note for this Person    
RolodexPIN  =      
FirstName  =  First Name    
MiddleInitial  =  Middle Initial    
LastName  =  Last Name    
DivisionThatOwnsRecord  =      
Title  =      
CompanyName  =      
WSOpID  =  Water Supply Operator ID    
Primary  =  Primary Contact Info    
PrimaryAddr1  =  PrimaryAddr1    
PrimaryAddr2  =  Primary Address 2    
PrimaryAddr3  =      
PrimaryAddr4  =      
PrimaryCity  =  Primary City    
PrimaryState  =      
PrimaryZip  =  Primary Zip Code    
PrimaryPhone  =  Primary Phone    
PrimaryPhoneExtension  =      
PrimaryFax  =  Primary FAX    
PrimaryEMail  =      
PrimaryCellPhone  =      
PrimaryPager  =      
Secondary  =      
SecondaryAddr1  =  Work Address 1    
SecondaryAddr2  =  Secondary Address 2    
SecondaryAddr3  =      
SecondaryAddr4  =      
SecondaryCity  =  City    
SecondaryState  =      
SecondaryZIP  =  Secondary Zip    
SecondaryPhone  =  Work Phone Number    
SecondaryPhoneExtension  =      
SecondaryFAX  =  Secondary FAX    
SecondaryEMail  =      
SecondaryCellPhone  =      
SecondaryPager  =      
WSOperatorRank  =  WS Operator Rank at Facility    
WSGPCertfctn  =  WS GrandParented Certification (Y/N)    
WSGPCertClass  =  GrandParented Certification Class    
WSGPExpDate  =  GrandParented Certification Expiration D    
WSFCertfctn  =  Full Certification (Y/N)    
WSFCertClass  =  Full Certification Class    
WSFExpDate  =  Full Certification Expire Date    
WSIssuedCert  =  Issued Certification (Y/N)    
WSOpStatus  =  OpStatus    
WellDrillerID  =      
WellDrillerLicenseExpirationDate  =      
WellDrillerStatus  =      
RecordStatus  =      
QualifyingIndividualWSPin  =      
QualifyingIndividualName  =      
QualifyingIndividualLicenseNumber  =      
DateDrillerCertificateSent  =      
WWSiteTechCertNumber  =      
WWSiteTechCertificationType  =      
WWSiteTechYearCertifiedTypeA  =      
WWSiteTechYearCertifiedTypeB  =      
WWSiteTechStatus  =      
WWSiteTechExpirationDate  =      
WWSiteTechLastRenewalDate  =      
WWSiteTechRenewalFeeReceivedDate  =      
WWSiteTechWantsToReceiveMailings  =      
WWSiteTechCountyCode  =      
DOE  =  Date of Entry    
UOE  =  User of Entry    
DOC  =  Date of Change    
UOC  =  User of Change    
Deleted  =      
WWOpCertificationNumber  =      
WWOpStatus  =      

Related Files and Return To Hyperlinks
 Enforcement To Relate information between files, find records where WellDrillerID here = WellDrillerID there
 EnfStat To Relate information between files, find records where WellDrillerID here = WellDrillerID there
 RolodexToWSID To Relate information between files, find records where RolodexPIN here = RolodexPIN there and LastName here = LastName there
 SRFNeeds To Relate information between files, find records where RolodexPIN here = WNPIN there
 Violations To Relate information between files, find records where WellDrillerID here = WellDrillerID there
 WellCompletionRepor To Relate information between files, find records where WellDrillerID here = DrillerLicenseNumber there
 WellMain To Relate information between files, find records where WellDrillerID here = DrillerLicenseNumber there
 WellTagsSent To Relate information between files, find records where WellDrillerID here = DrillerLicenseNumber there

 Return To Index
 Return To Compact List of All Files/All Variables