Looks right!
From: Phillips, Tim
Sent: Wednesday, March 04, 2015 1:48 PM
To: Swanberg, Ned Subject: RE: LEOP Setting!
Ned, This definition for the calculated field logic seems right to me. What do you think?
6) LocalEmergencyOperationsPlanCheckbox
Is Municipality.LEOPByTown checked or unchecked
a) if the field is not checked, the municipality itself is responsible. Look at the value in the Municipality.LEOPDate field.
- if the current date is May 1st or later and LEOPDate is greater than March 1st of the current year then return Yes.
- if the current date is in January, February, March or April and LEOPDate is greater than March 1st of the previous year then return Yes.
- if none of the above conditions have been met, return No. b) if the field is checked, the municipality listed in Municipality.LHMPTownResponsible is responsible. Find the Municipality. record for that municipality and look at the value in the LEOPDate field. - if the current date is May 1st or later and LEOPDate is greater than March 1st of the current year then return Yes. - if the current date is in January, February, March or April and LEOPDate is greater than March 1st of the previous year then return Yes
- if none of the above conditions have been met, return No.
Tim
From: Phillips, Tim
Sent: Wednesday, March 04, 2015 1:11 PM
To: Swanberg, Ned Subject: RE: LEOP Setting!
Ned,
I was working on implementing your 2nd revision to the calculated field. I’m stopping to figure out if this latest email requires a 3rd revision.
When I’ve detangled that, I’ll email you a new revised description of the calculated field.
When you say it is good, I’ll try to implement it.
Tim
From: Swanberg, Ned
Sent: Wednesday, March 04, 2015 1:03 PM
To: Phillips, Tim Subject: RE: LEOP Setting!
Tim, Just to review the LEOP program
The plan is annual and needs to be updated “after Town Meeting”
The old plan is still valid through the end of April of next year.
On the other-hand if it actually comes in late…June… Oct …. It is valid when received.
So really….goes to “No” on 5/1 if it hasn’t been updated since Town Meeting (“3/1/current year”)
The problem is the current year calculation hence … Not “No” if Jan….April and LEOP date is after 3/1/Previous Year.
From: Swanberg, Ned
Sent: Wednesday, March 04, 2015 12:06 PM
To: Phillips, Tim Subject: RE: LEOP Setting!
They are all wrong.
The LEOP Check box shouldn’t go to “No” until after the town fails to update before May 1.
From: Phillips, Tim
Sent: Wednesday, March 04, 2015 12:00 PM
To: Swanberg, Ned Subject: RE: LEOP Setting!
Ned, Which municipality is wrong on this report? Tim
From: Swanberg, Ned
Sent: Wednesday, March 04, 2015 11:58 AM
To: Phillips, Tim Subject: RE: LEOP Setting!
Thanks Tim!
https://anrweb.vt.gov/DEC/FoFReports/DisplayERAFSummaryReport.aspx?SC=Addison&SMN=&SRPC=&SSA=N
and .pdf attached.
I’ll see if I can track down something new too!
From: Phillips, Tim
Sent: Wednesday, March 04, 2015 11:46 AM
To: Swanberg, Ned Subject: RE: LEOP Setting!
OK. Bump me up an example municipality that is incorrect so I have something to test the new code with, please. Tim
From: Swanberg, Ned
Sent: Wednesday, March 04, 2015 11:35 AM
o: Phillips, Tim Cc: Bell, Morgaine Subject: RE: LEOP Setting! Importance: High
I think this works better!
ALT 2
6) LocalEmergencyOperationsPlanCheckbox
Is Municipality.LEOPByTown checked or unchecked
a) if the field is not checked, the municipality itself is responsible. Look at the value in the Municipality.LEOPDate field.
- if the current date is May1st or later, then if the LEOPDate value is greater than March 1st of the current then return Yes. Otherwise, return No.
- if the current date is in January, February, March or April, then if the LEOPDate value is greater than March 1st of the previous year return a Yes. Otherwise, Return No.
From: Swanberg, Ned
Sent: Wednesday, March 04, 2015 11:13 AM
To: Phillips, Tim Cc: Bell, Morgaine Subject: LEOP Setting!
Importance: High
Hello Tim, Bit of a problem.
We had a declared disaster and tomorrow 3/5 DEMHS will take an “official” snapshot/pdf of the data on Flood Ready for the purposes of ERAF.
Unfortunately I seem to have screwed up the logic on the LEOPs.
As of today….apparently the LEOPs are showing up as “expired”. They shouldn’t expire until 5/1.
1. Can you fix the logic? Let me know if we need to talk this through. I made a possible logic fix to the a) section below but not for b) .
2. Let’s hold off on the database migration until at least Friday.
6) LocalEmergencyOperationsPlanCheckbox
Is Municipality.LEOPByTown checked or unchecked
a) if the field is not checked, the municipality itself is responsible. Look at the value in the Municipality.LEOPDate field.
- if the current date is March 1st or later, then if the LEOPDate value is greater than March 1st of the current year and less than May 1st of the current year, then return Yes. Otherwise, return No.
- if the current date is in January or February, then if the LEOPDate value is greater than March 1st of the previous year and less than May 1st of the current year return a Yes. Otherwise, Return No.
b) if the field has a value, the municipality listed in Municipality.LHMPTownResponsible is responsible. Find the Municipality. record for that municipality and look at the value in the LEOPDate field.
- if the current date is March 1st or later, then if the LEOPDate value is greater than March 1st of the current year and less than May1st of the current year, then return Yes. Otherwise, return No.
- if the current date is in January or February, then if the LEOPDate value is greater than March 1st of the previous year and less than May1st of the current year return a Yes. Otherwise, Return No.
ALT?
6) LocalEmergencyOperationsPlanCheckbox
Is Municipality.LEOPByTown checked or unchecked
a) if the field is not checked, the municipality itself is responsible. Look at the value in the Municipality.LEOPDate field.
- if the current date is April 30th or later, then if the LEOPDate value is greater than March 1st of the current year and less than May 1st of the current year, then return Yes. Otherwise, return No.
- if the current date is in January, February, March, April, then if the LEOPDate value is greater than March 1st of the previous year and less than May 1st of the current year return a Yes. Otherwise, Return No.
b) if the field has a value, the municipality listed in Municipality.LHMPTownResponsible is responsible. Find the Municipality. record for that municipality and look at the value in the LEOPDate field.
- if the current date is March 1st or later, then if the LEOPDate value is greater than March 1st of the current year and less than May1st of the current year, then return Yes. Otherwise, return No.
- if the current date is in January or February, then if the LEOPDate value is greater than March 1st of the previous year and less than May1st of the current year return a Yes. Otherwise, Return No.
Thank you!
Ned