Presentation on

1
Presentation on
Total Revenue Management (TRM)
2
Total Revenue Management
SCOPE

• LOGIN / SECURITY
• MASTER ENTRY
• BILLING
• PAYMENT
• JOURNAL ENTRY (JE)
• SEARCH / QUERY TOOL
• MIS REPORTS

3
TRM Login / Security
Data Entry Operator
Clerk (Ledger / Counter)
Admin
A.O
A.E.E
User - Rights Verification
Database
4
TRM Master Entry

• New Consumer Entry
• Consumer Changes
• Account (Meter) Status Changes
• Master Data Changes

5
TRM Billing

• Upload and Download (SBM)
• Manual Bill Generation
• Trivectory Bill Generation

6
TRM Payment

• Manual Payment Entry
• Counter Payments
• Export master info
• Import Counter Payment
• SBM Payments
• Create master data
• Create header file
• Import Payments

7
TRM Journal Entry (JE)

• Journal Entry
• Cheque bounce
• Wrong account
• Other payments
• Meter reading
• Correct account
• Sluggish
• Deposit adjustment
• Cheque bounce
• Back billing charges
• Audit short claim
• Meter test charges
• Disconn and recon fee

8
TRM Search / Query Tool

• Consumer Search (View)
• Ad-hoc Query

9
TRM MIS Reports

• JSP Reports

10
TRM Database Design
P R O F I L E S
V I E W S
P A C K A G E S
I N D E X E S
C O N S T R A I N T S
P H Y S I C A L D A T A B A S E
B A C K E N D T R A C K E R
11
TRM Development Tools
DATABASE ORACLE 9i APPLICATION VB 6
REPORTS MIS Reports
12
TOTAL REVENUE MANAGEMENT
THANK U