Run SQL output final 2024 water standby report.  Copy SQL result Paste into Excel file
 
 
 
Step 1
Total Assessment for ID-2

 
 
 
 
 
 
Step 2
Total Parcel Count for ID-2

 
 
 
 
 
Step 3
Calculate ID-1 Fee Amount. Multiply Prorated Acres Field by 10

 
 
 
 
Step 4
Total Parcel Count for ID-1

 
 
 
 
 
Step 5
Total Assessment for ID-1

 
 
 
Step 6
ID-1 Property Listing

 
 
 
 
Step 7
ID-2 Property Listing

 
 
 
 
Step 8
ID-1 Mailing List

 
 
 
Step 9
ID-2 Mailing List

 
 
 
 
 
 
Step 10
ID-1 Lien List

 
 
 
 
Step 11
ID-2 Lien List

 
 
 
 
 
 
Step 12
Unmatched parcels between COV_POD and current parcel layer (COV_STANDBY_AVAILABILITY)
