R-APDRP Part A IT Implementation

Dated: 27.01.2015

R-APDRP Part A - IT Systems

• SAP ISU System• For new connection and disconnection, metering,

billing and collection, plant and asset management.• SAP CRM System

• For customer relationship management.• SAP BI System

• For energy audit and other MIS reports.• MDAS System

• For AMR of Feeder, DT and Consumer meters.• GIS System

• For network planning of Distribution System.

R-APDRP (Part A) - Modules

• The following modules have been implemented:• Metering, Billing & Collection (MBC)• Meter Data Acquisition (MDAS)• Energy Audit • Customer Service

• New Connection• Disconnection & Dismantling

• Customer Relationship Management• Complaint Handling

• GIS based customer Indexing and asset mapping • GIS based integrated network analysis module • Centralized Customer Care Services • Asset Management • Maintenance Management• Web Self Service & User Portal

Metering, Billing, Collection (MBC) Module• All activities related to Metering, Billing & Collection to be

carried out through the SAP system• Benefits

• In house billing• No advices to be prepared manually• Online monitoring of all billing & revenue related activities• Online record of all service orders and jobs done by field/revenue

staff• Online history of consumption & payments of all consumers• Online billing related complaints’ handling/redressal• Online availability of various reports for management returns

MBC Related Reports

Master Ledger Report

Assessment Summary

Detail of Assessment

Key Exceptions with age analysis

Consumption Variation Reports

High Revenue Bill (above 1 Lakh)

CG/Board Offices Report

BPL & Weaker Section Report

Difference between SAP & SBM Bill Amount Report

SBM Billing Report

Negative Amount Billing Report

MMC Bills

Board Employees Report

Tariff wise Report

Requirements from DS Org. for MBC • Daily uploading of SBM • Timely completion of all service orders• Daily clearing of outsorted/implausible bills• Daily monitoring of progress of spot billing to ensure 100% recording

of readings timely• Correction of bills if any, should be carried out by reversal of

bills/invoices in the system and not by any sundry charges/allowances postings

• To ensure matching of GIS consumers and billed consumers to avoid any unbilled consumer which shall lead to loss of revenue

• Legacy payment data to be supplied on time to the migration team• To propagate payment of bills through e-payment and reduce rush

on the cash counters• To guide consumers to avail of free SMS alerts regarding billing &

payments• To guide consumers to avail of free e-mail alerts regarding billing &

payments

Customer Service (CS) Module• All activities related to Customer Services (walk-in) to be

carried out through the SAP system• Benefits

• All consumer billing/supply related activities namely:• New Connection• Disconnection/Reconnection• Change of Name• Change of Connected Load• Device (Meter/Metering Equipment)

removal/replacement/installation/shifting• Single Window system 100 KW to 500 KW (to be available

after 26.01.2015)• AP & PL related new connection orders available (other

orders to be available from 10.02.2015)

Benefits (Contd..)• Site Investigation reports for :

• Interchange of Connection• Category Dispute• PSPCL Initiated• Category change Lower to Higher• Category change Higher to Lower• Wiring in Dangerous Condition• Contract Demand Change• Sanction Load Change• Amalgamation of Meter• Meter Number Mismatch• Change MRU

Benefits (Contd..)• Miscellaneous Service Orders

• Security Related• Correction of Name• Correction of Address• Hiring of Pole/Pole Rent• Peak Load Exemption• Installation of DG/TG Set• Shifting of Installation• Re-Installation• Change of Industry• Weekly OFF• Meter Seal Terminal/Seal Replacement • Checking of Capacitor• Disconnection Not done• Wrong Disconnection• Updation of Fact• Permission for Cogeneration• Temporary Supply Extension• Refund of Service Connection Charges

CS Related Reports

New Connection

Pending/completed order status reports with provision for SLA monitoring and compensation to consumer for delay

Output

Order Status AbbreviationsABNR Abnormality Found

ANFD Abnormality Not Found

APPR Approval Required

APRV Approved

ASNR Assessment Not Required

AUDB Auto debit

CHIR Chief Engg rejected

CIRA Circle Approved

CIRR Circle Rejected

CPDU Bill Payment Due

DELL Delayed due to Labour

DELM Delayed due to Material

DELP Delayed due to permit

DERR Device Replacement Required

DIVA Division Approved

DIVR Division Rejected

DNPD Demand Note Payment Due

DRDN Device Removal Done

DWDR Disc. With Device Removal Req.

DWOR Disc. Without Device Removal R

EDPD Earnest Money Payment Due

EPAY Earnest Money Payment Done

FAOR Final Assessment Req

IWRC IWR/Form4/EMB/LMB Complete

MBIL Manual Bill Created

NEW New Order

PAAK PAO Acknowledged

PACR Posting of Actual Cost Require

PAFS Assigned to Field Staff

PAOR Provisional Assessment Req

PBAR Bill Amendment Required

PCAT Category Change Required

PCFR CF Rejection

PCFR Customer Feedback req.

PCFS Customer feedback satisfied

PCON Change Of Name Required

PCTF Site Visit Required

PDIC Meter Installation Completed

PDIN Meter Installation Required

PDNC Demand Notice Cancellation

PDRR Device Replacement Required

PESR Estimate Preparation Required

PFNR Customer Feedback not req.

PFNS Customer feedback not satisfie

PFRD Falult Rectified

PLTS Letter To Be Sent

PMIC Meter Replacement Completed

PMIN Meter Relacement Required

PMRD Off Cycle Meter Reading Req

PNSC Cust Appointment Scheduled

PNSC Customer Appointment Scheduled

PPAY Demand Note Payment Accepted

PPAY Payment Accepted

PPAY D.N Payment Accepted

PRFR Refund Required

PRFS Reassigned to Field staff

PRNS Test Report Not Submitted

PSIC Site Installtion Completed

PSIR Site Insatllation Required

PSVC Site Visit Complete

PSVR Meter Shifting Required

PTFR TF Rejection

PTNR Permit Not Required

PTRC Test Results To Be Uploaded

PTRS Test Report Submitted

PTRT Permit Returned

PTWG Permit granted

PTWN Permit rejected

PTWR Permit Required

PWEX Order Completed

PWJC Job Incomplete

PWNE Order Cancelled

SDNA Security Not Applicable

SDOA SDO Approved

SDOR SDO Rejected

SDPD Security Deposit Payment Due

SDTD Security Deposit Transferred

SPAY Security Payment Done

STAT Statutory Work

STEA Store XEN Approved

STER Store XEN Rejected

STIV Site Investigation Req

STRA Store Incharge Approved

STRR Store Incharge Rejected

TFAR TF Done/Approval for TF Req.

TFER TF Ok/Estimate Posting Req.

TFOK TF Ok

TFRE Technical Feasibility Required

TMBR Time barred

ZTMD TMD Created

Active Consumers Report

Output

New connection report with SLA monitoring

     

BI REPORT FOR NEW CONNECTION         

               

               

                       

                       

                       

                       

Table                      

False False False False False False False

False False False Date : 01.12.2014 To 31.12.2014

False False False False                  

TownNew Connection pending from previous preriod

New Connection applied in current period

Total New Connection pending for release

Total connection released in current period

Connection yet to be released

Connection released within SERC Time Limit

Connection released beyond SERC Time Limit

% of connection released within SERC Time Limit

% of connection released beyond SERC Time Limit

Connections released by system

% Connection within SERC Limit - Prev Month

Dhuri   52 52   52            

Faridkot 223 163 386 64 322 42 22 65.6 34.4 64 86.6

Gidderbaha 213 87 300 68 232 65 3 95.6 4.4 68 93.1

Gurdaspur 407 170 577 38 539 35 3 92.1 7.9 38 98.2

Jalalabad 11 55 66 21 45 20 1 95.2 4.8 21  

Kharar 272 279 551 6 545 5 1 83.3 16.7 6  

Malout 79 277 356 179 177 176 3 98.3 1.7 179 99.3

Nakodar   5 5   5            

Nangal 62 48 110 28 82 14 14 50.0 50.0 28 95.8

Nawanshahar 2 37 39 29 10 29 0 100.0 0.0 29 97.8

Patti 186 73 259 41 218 21 20 51.2 48.8 41 94.3

Ropar 62 54 116 67 49 56 11 83.6 16.4 67 87.0

Sirhind 18 27 45 31 14 30 1 96.8 3.2 31  

Sunam   26 26   26            

Zira 20 53 73 16 57 16 0 100.0 0.0 16  

Overall Result 1,555 1,406 2,961 588 2,373 509 79 86.6 13.4 588 94.6

Other Services

Customer Relationship Module (CRM) • All activities related to Customer

complaints etc. to be carried out through the SAP system

• Benefits• Supply Complaints• Billing Complaints• Meter Complaints• Viewing account information

(billing/payment etc)

CRM SCREEN

Requirements from DS Org. for CS• All orders after field activities should be closed in SAP on daily

basis otherwise monthly report to PFC shall not be accurate• Clearance of all pending orders for a particular officer/official

(ID) in case of transfer/change of charge etc.• Cancellation of any order issued inadvertently or not requiring

any action• Immediate revoking of the access rights of transferred

officers/officials • Passwords must not be shared/delegated

Meter Data Acquisition (MDAS)/ Energy Data Mgt (EDM) Module• All activities related to Energy Data Mgt/Energy Audit to be carried out

through the MDAS system• Benefits

• Data of LS consumers can be monitored online• Peak Load violations • Max. Demand violations• Monitoring of consumption data • Prevention of fraud due to wrong reading, leading to reduction in AT&C losses• Freedom from human intervention thereby achieving proper energy accounting• Reduction in effort of manpower as manual meter reading shall be eliminated for

these consumers• Anytime and anywhere access to reports of live feed of meter energy data on

handheld devices, laptops, desktops etc• AMR Data can be utilised for theft detection, Implementation of Regulatory

Measures

MDAS/EDM Related Reports

AT&C Loss Report

Bus Bar Loss reports

HT Loss reports

LT Loss Report

Load Change Report

Overloaded Transformers report

Unbalanced Transformers report

Contract Demand violation report

Area wise load growth report

Meter data statistical report

SAIDI/SAIFI related reports

Power Factor report

Requirements from DS Org. for MDAS/EDM• Ensuring timely installation of DT Meters so that modems can

be installed on the same• Replacement of HT consumer meters from non-DLMS to DLMS• Closing of MCOs in SAP immediately after completion of field

activity as the same has to be synced in the MDAS system to keep it robust

• Defective DT meters should be replaced immediately by issuing MCO in SAP

• Modems are part of metering equipment; the same should be returned to IT Org. In case of PDCO

• To ensure data of HT consumers in SAP is correct

Asset Mgt. (AM)/Plant Mtc. (PM)/GIS Updation• All activities related to estimate preparation, technical feasibility,

issue of material including meters/permit issuing etc. to be carried out through the system

• Benefits• Accounting of all assets• Online availability of stock position• Less human effort for management of stock• Real time Technical Feasibility • HT/LT network diagrams readily available online• Availability of SLDs of grids

AM/PM/GIS Related Reports

No. of DTs Feeder wise

DTs Sub Division Wise

Length of HT/LT lines

Summary of Assets in a Substation

Equipment Details

Consumer details Feeder wise/DT wise

DT wise Network and consumer Details

Capacity wise DT details in a Feeder

Consumer details based on Sanction load

Functional Location Structure

Asset List

List of Orders

JE wise Order Status

JE Wise Estimate wise cost - Period

JE Wise Estimate wise cost

Stock Card cum Material Document List (Store Document)

Warehouse Stock (Store document)

Stock Overview

SLD of Network

Requirements from DS Org. for AM/PM/GIS Updation• Usage of Plant Maintenance (PM) module at S/Divs., S/Stns. &

Stores so that the system is updated regularly• Assets Data (Pole & DTs) may be maintained and provided

which is required to be uploaded in server once GIS of the town is complete

• GIS updation (assets/consumers) to be carried out regularly in the system

• Technical feasibility should be carried out through the system only

• Issuing of meters/material from ME Lab/Store should be done through system only

• Estimate preparation to be carried out through system only• Accounting of assets to be carried out through the system • Permit issue/grant to be done through the system

Web Self Service (WSS) User Portal

• All online activities by consumers to be carried out through the WSS User portal

• Benefits• Online Bill Payment• Payment History (availability of receipts)• Bill History (downloading of bill)• Consumption History• Raise Request• Complaints • New Connection Registration

Requirements from DS Org. for WSS User Portal

• To make consumers aware regarding carrying out the activities through the User Portal

• Manuals uploaded may be perused• All Business Intelligence (BI) reports available on the portal

WSS PSPCL User Login URL

WSS PSPCL User Login Screen

Open PSPCL Website and click Pay Bill

Click Here

Click Quick Bill Pay to pay the bill

Click here

Enter CA number and Click “View Bill”

Enter CA NumberClick Here

Click Pay Bill to make the Payment

Click here

For Other Consumer Services Click “Consumer Services” on “Pay Bill” Page

Click here

Enter ID, Password to Login

For New User to create id, Password

Click Manage Account to Add CA no.

Click Here

Click Add Account

Click Here

Click New Account no, Enter CA no and Click Add Button

Once Account is added User can Pay Bill, View Bill, Check His Payment History using Tabs on L.H.S.

Bill History PageBill can be downloaded by clicking Bill Number

Payment History Page

Going Forward• Readiness of Sites for Customer Care Centres• Readiness of sites for installation of Bill Payment Machines• Helpdesk – 1015 (IP Phone) & 96461-19129 for registering of

complaints• The T & D losses report shall be generated from the system

and reviewed regularly by the management.• In case of any lapse, the T & D reports generated from the

system would be incorrect thereby providing wrong information

THANK YOU