WILDFIRES-YEAR TO DATE SUMMARY

1) EXPORT 'INCIDENTS_PT' FROM FMIS PROD
2) EXPORT 'V_INCIDENTS' FROM FMIS PROD
3) JOIN BY INCIDENT NUMBER
3) QUERY FOR 'WILDFIRE'  (INCIDENT_TYPE = 'Wildfire')
4) QUERY FOR 2010 ([CRE_DATE] >= #1/01/2010# AND [CRE_DATE] <= #12/31/2010#)




OBA-YEAR TO DATE SUMMARY

1) EXPORT 'SV_OPEN_BURN_REQUEST_PT' FROM FMIS PROD
2) QUERY FOR 2010 ([START_DATE] >= #1/01/2010# AND [START_DATE] <= #12/31/2010#)
3) QUERY FOR 'AUTHORIZED'  ([STATUS] = 'Authorized')