FVV told Rico that in order to minimize human errors in encoding Load Center and Pole Numbers, we should input them during creation of the customer account, and not when the meter has been installed already.
Makes sense, but it will require A LOT of changes in the system -- in the program and in the reports -- not to mention the shift in encoding practice...
Initially, I mentioned that we should just transfer the fields from the meter page/table to the consumer master page/table, but we will not be able to track the pole and LC histories. So now I'm thinking of transferring the 2 fields to a NEW table, while Rico suggests that we just get them transferred to the consumer_connection table, which I think will take up more server disk space than necessary, as it will entail recording of the 2 fields every time there's a Reco and Disco for a customer where there's no change in LC and Pole.
Update, Apr. 29, 2008:
I've decided to create a separate table, despite it having similar (redundant) fields like modified_by, created_modified, current_status...
Why? Because there are times when the Eng'g. Dept. has to replace rotten poles and there may be METERS that will have to be removed and subsequently put back. We will have no individual job orders per customer then.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment