LCMASTER file from Water Supply Inventory

Number of Records In File: 747
Number of Data Fields In File: 27

Data That Is Stored Within This File
Notes  =  notes    
WSID  =  Water Supply Identification Number    
TrmtRecDue  =  Treatment Recommendation Due Date    
TrmtRecDone  =  Treatment Recommendation Done Date    
AdInfoRqDue  =  Additional Information Due Date    
AdInfoRqDone  =  Additional Information Required Done    
AddInfSuDue  =  Additional Information Submittal Due    
AddInfSuDone  =  Additional Information Submittal Done    
StTmtDetDue  =  State Treatment Determination Due    
StTmtDetDone  =  State Treatment Determination Done    
StTmtDetDoneToEPA  =  Report State Treatment Determintation Done To EPA At Next Chance (if field is 1, answer is yes)    
TrmtInstDue  =  Treatment Installation Due Date    
TrmtInstDone  =  Treatment Installation Done Date    
TrmtInstDoneToEPA  =  Report Treatment Installation Done to EPA At Next Chance (if field is 1, answer is yes)    
TrmtReqPb  =  Treatment Required for Lead    
DateFailPb  =  Date First Failed Lead    
TrmtReqdCu  =  Treatment Required Copper    
DateFailCu  =  Date First Failed Copper    
Deemed  =  Deemed (Y/N)    
DateDeemed  =  Date Deemed    
DeemedMileStoneReasonCode  =  Deemed Mile Stone Reason Code    
Done  =  Done (Y/N)    
DateDone  =  Date Done    
UnDone  =  Undone (Y/N)    
DateUnDone  =  Date Undone    
ConsecutiveNotIncludedInParent  =      
ConsecutiveIncludedInParent  =      

Related Files and Return To Hyperlinks
 INVENTRY To Relate information between files, find records where WSID here = WSID there
 LCPUBLED To Relate information between files, find records where WSID here = WSID there
 LCRESULTS To Relate information between files, find records where WSID here = WSID there

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