NNEC Data Auditor
The NNEC Data Auditor is a set of programs that were created to verify data integrity within and between various systems at NNEC.
Abnormal Usage Report
This report shows abnormal usages. These are usage
that are reported as less than 0 kWh, or more than 400 kWh. This report will
show the net metering members, and the larger consumption users.
This report is run twice a day after the daily reads are loaded into the CIS.
The first run is to show what lwas loaded into CIS from the AMR system.
The second run is after some erratic reads,have been corrected by the "Fix Abnormal Reads.asp" script. |
Contents of "AbnormalUsageReport.bat."
:: The following are daily audit scripts that perform some data integrity checks.
::
"c:\program files\internet explorer\iexplore.exe" www.insidennec.com/NNECDAS/scheduledjobs/Abnormal Usage Report.asp?Mode=B
exit
|
Abnormal Usage Fix
This is a script that runs in an attempt to correct
erratic AMR reading by the TWACS AMR system.
It replaces any reads reported as "OK" by the AMR system, but that calculates a daily usage of less trhan 400 kWh or more than 400 kWh for any Rate 100 Account.
The script sends an email for each record modified in the CIS, so all actions are logged.
This is currently run at 12:55 PM, every day. |
Contents of "\\NNEC03\c\inetpub\wwwroot\nnecdas\batchfiles\FixAbnormalReads.bat."
:: FixAbnormalReads.bat
::
"c:\program files\internet explorer\iexplore.exe" http://www.insidennec.com/NNECDAS/ScheduledJobs/FixAbnormalReads.asp
exit
|
Blink Report
This report shows locations that had 2 or more blinks.
The blinks are reported by the TWACS AMR system, and transferred to the CIS along with the billing reads.
The blinks are stored in the BLPBLINK file in the Daffron CIS. |
This is a scheduled job on NNEC03,
"Blink Report" that runs "C:\Inetpub\wwwroot\NNECDAS\BatchFiles\Blink Report.bat" every day at 1:10 PM.
|
The blinks can also be viewed in the CIS, by pressing Shift-F6, while in Customer Inquiry.
|
CRC Disconnect List
This report shows locations that are disconnected.
It runs, via a scheduled job, at 4:30 and 5:00 PM by executing c:\inetpub\ComputerRoom\CRC\Disconects.bat file on \\NNEC03.
It also create 2 files.
The first file "c:\inetpub\wwwroot\computerroom\crc\crcdisc.txt" gets copied to "d:\CRC-CIC\disconnects\crcdisc.txt" for CRC.
The second file, c:\inetpub\wwwroot\computerroom\crc\NonPayForDisspatch.txt" gets copied to "m:\Milsoft\Billing\NonPayForDisspatch.txt" for Milsoft.
|
Daily kWh Total
This report shows the total kWh sold by day, based off of the AMR meter readings.
This data is obtained by adding all the daily usages, by type, after tthey are loaded into the CIS.
Those totals, are stored in a Access database "\\NNEC03\c\inetpub\wwwroot\database\Intranet.mdb" for tracking. |
This is a Windows scheduled job, "Daily Usage Summary Job" runs "C:\Inetpub\wwwroot\NNECDAS\BatchFiles\Daily Usage Summary.bat" every day at 12:57 PM. |
Contents of Daily Usage Summary.bat.
|
Sample Daily kWh Total eMail:
|
Daily Variance Report
This report shows locations that did not have usage in the past day, but had usage in the last billed month.
It is currently emailed each day to the VP of IT & Customer Service and the General Manager. The report is also viewable from the NNECDAS toolbar. |
Delinquent Report
This report is run just prior to each Board Meetinmg, to verify that no employees are delinquent. |
|
Devices With No Protective Devices in AMR Report
This report shows devices in the AMR system that do not have a protective device.
This report gets emailed to the computer room each week day morning. There is a scheduled job which attempts to correct these, based off of the "\\nnec03\c\inetpub\wwwroot\nnecdas\meter protective device_fromDB.asp" script that is run daily. |
DRU's in CIS Not In AMR Report
This report looks for DRU's that are in the CIS system, and are not in AMR.
This report gets emailed to the computrer room each week day morning. |
DRU's in AMR Not In CIS Report
This report looks for DRU's that are in the AMR system, but are not in the CIS system.
This report gets emailed to the computer room each week day morning. Hopefully there are none. |
DSIs in AMR not on CIS Report
This report looks for DSI's that are in the AMR system, and are not in CIS.
This report gets emailed to the computrer room each week day morning. |
DSIs in CIS not in AMR Report
This report looks for DSI's that are in the CIS system, but are not in AMR.
This report gets emailed to the computer room each week day morning. |
Incomplete 911 Address Report
This report shows accounts where the address is not a street address.
This report gets emailed to the computer room each week day morning. |
Inactive Locations with Usage Report
This report shows locations that are marjked
inactive in the CIS, but had usage. This could either be a tamper, or sometimes
a leaking boot.
This report gets emailed to the computer room each week day morning. |
Large Power Wrong Book Report
LP Accounts Report
MANS Hourly Report
This report shows accounts that are not set to
read hourly in the AMR system. Clicking on the "fix" link will auomatically
run a SQL in the AMR system to set the reads to hourly.
This report gets emailed to the computer room each week day morning. |
Meters in CIS not in AMR Report
This report shows meters that are in the CIS system, but are not in the AMR system.
This report gets emailed to the computrer room each week day morning. |
Meters with Cycle of 0 Report
This report shows the meters tin the TWACS AMR system that have a cycle of 0.
This report should always be blank because the read jobs in the TWACS system are by cycle.
A meter with a cycle of 0 will never be read by the AMR system.
|
Multiple Paths one Location Report
This is a report that shows devices in the TWACS
AMR system that are at the same location, but are reading or replying from different paths.
This is still unexplainable at this time. |
Outstanding Service Orders Report
This report shows the Open Service Orders that are in the CIS. They are grouped by type, and the color code reflects the number of service Orders open for that type.
This report gets emailed to the computer room each week day morning. |
Stat 6 Accounts with Credit Balance Report
This report shows Stat 6 accounts that have a credit balance.
This report gets emailed to the computer room each week day morning. |
Street Light Wrong Rate Report
This report shows accounts where the street light rate is incorrect.
This report gets emailed to the computer room each week day morning. |
Tax Counties Report
This report shows accounts where the tax district
may be invalid. This report gets emailed to the computer room each week day morning. |
Undiscoverable Meters Report
This report shows the meters that have been entered into the AMR system,
but for whatever reason, have not been discovered (Searched in).
This report gets emailed to the computrer room each week day morning.
|
Update Protective Devices in AMR
This is a script that updated the protective
device field in the AMR system, from the protective device table in the
"\\nnec03\wwwroot\database\nnecdas.mdb" database. This updates by location (premise ID)
to update any devices that have been changed (Meters, DSI's, DRU's, LCT's).
|