PublicNotice file from Water Supply Inventory
Number of Records In File: 3227
Number of Data Fields In File: 21
Data That Is Stored Within This File
Comments = Note
Note = Note
WSID = Water Supply Identification Number
TypeOfNoticeIfForViolation = Type of Notice If For A Violation Code
TypeOfNoticeIfNotForViolation = Type Of Notice If Not For Violation (0=No Entry,1= Boil Water,2=Chemical Detection,3=Do Not Drink)
DateNoticeIssued = Date Notice Issued
ViolationIdentifier = Violation Identifier (if public notice is for a violation)
BeginningOfCompliancePeriod = Beginning Of Compliance Period (format MM/YY)
DateNoticeDue = Date Notice Due
RadioTVNotice = Public Notice was Made via Radio TV (if field is 1, this was method)
DailyNewsPaperNotice = Public Notice was Made via Daily News Paper (if field is 1, this was method)
WeeklyNewsPaperNotice = Public Notice was Made via Weekly Newspaper (if field is 1, this was method)
MailDeliveryNotice = Public Notice was Made via Mail Delivery(if field is 1, this was method)
HandDeliveryNotice = Public Notice was Made via Hand Delivery(if field is 1, this was method)
DateReminderLetterSent = Date Reminder Letter Sent
DateOfAction = Date of Action
DOE = Date of Entry of Record
UOE = User Who Entered Record
DOC = Date of Change Of Record
UOC = User Who Changed Record
PublicNoticeRecordNumber = Public Notice Record Number
Related Files and Return To Hyperlinks
INVENTRY To Relate information between files, find records where WSID here = WSID there
PublicNoticeStateActions To Relate information between files, find records where ViolationIdentifier here = PublicNoticeRecordNumber there
Violations To Relate information between files, find records where ViolationIdentifier here = Identifier there
VViolationType To Relate information between files, find records where TypeOfNoticeIfForViolation here = Type there
Return To Index
Return To Compact List of All Files/All Variables