Resolve

No.

Issue

Remarks from the Board

1

8496 ledger accounts do not have corresponding CMR. Some are

The board had investigated the issue, true that there are about 8324 unbilled customers as on now. Until new the new revenue module is in place, where ever no transactions are found, the new software shall take first bill generation from the date of connection. The invalid consumer CANs to filter and maintain separate log.

Status

2

3

4

recent accounts and first bill has not yet been issued. Some of the others have never been billed possibly due to incorrect Address. These are also entries for ‘00000000’ & ‘99999999’ which are not valid CAN numbers (some have Balances) 8445 CANs (in consumer master) do not have any entries in the ledger.

a) SWC legacy application has a record of approximately 3 lakh CANs and revenue application has 6.25 lakhs. Merging the two resulted in 619180 b) SWC users have reported some duplicate records after the merging c) Since SWC and revenue applications have been independent of each other, several contradictions and duplicates exists, in the new system, these two applications are integrated and therefore, these contradictions /duplicates are rejected by the data integrity constraints. Connection Date on Certain CANs does not Match

5

Meter Reader master data does not match with the field. Specifically, the meter codes collected during the training of Meter Readers do not match with those in the meter reader Master

6

Meter Average KL for CANs with meters in Repair condition does not match with Revenue application’s download file

We request the Co-options to join these cans with CANDELS table to know exact status( where the hidden, duplicate, linked and other status of the consumer are maintained) a) 275349 swc files are linked to RBS tables. b) & c) these records are to be joined with CANDELs table and report to HMWSSB

The Disconnection and Reconnections dates are to be looked into – to get latest connection dates Field meter codes written in the questionnaire being examined, certain codes are wrongly written by the MRs themselves. Actual MR Codes of 185 employees is herewith enclosed. Remaining if any,will be given shortly The meter reading for repair condition wherever available are maintained in the revenue oracle tables. However, it has

meager impact on over all repair condition billing. The co options shall take available information from revenue tables. 7

Number of residential Units does not match for several cans,

12

Meter Reader assignment to CANs does not match with existing system’s download files

Regarding these differences we have contacted the our Software Consultant.- he had explained that the information is available in oracle and DBF are both are same. However, he said he will look in this matter. The table names/ are correct meter reader assignments shall be informed shortly.