|
|
RA Challenges
Operational Areas
Network
Mediation
Postpaid
Prepaid
Fraud
Interconnect/ Roaming
Collections/ Dunning
GRAPA Library
RA
Standards
Whitepapers
Webinars
Books
Useful Links
RA Academy Website
GRAPA Website
|
|
 |
|
Mediation Assurance
Mediation is the starting point and the hub of all revenue
assurance operations. Through this one system passes almost 100%
of the revenue related information produced by a telecom. For
this reason, Mediation is usually the starting point and major
focus of most revenue assurance operations.
Conceptually, the mission of the mediation
system is simple and straightforward and can be summarized by by
the acronym FFESC which stands for:
 | Format - the CDRs into a readable form for
downstream systems |
 | Filter - remove CDRs that are not needed by
downstream systems |
 | Error - remove and mark CDRs that are in
error for future review |
 | Suspend - put into a suspense file all
records that may be able to be processed later |
 | Consolidate - assemble the different pieces
of a call into a single transaction record |

Revenue assurance activities usually start
with the mediation area and almost any revenue assurance
investigation will involve a review of what the mediation system
has to say. For this reason, revenue assurance expertise in the
mediation area is critical.
Mediation assurance activities are concerned
most with the following:
 | Validate that the mediation system is
functioning the way it is supposed to |
 | Validate that the mediation system has been
given the right requirements |
 | Validate that the reference tables that the
mediation system is using are correct, accurate and up to date |

Our Case Study reviews include the following
areas:
-
Mediation Requirements Review and Validation
Case Study
-
Mediation
Reference Table Reconciliation Case Study
-
Mediation Integrity
Verification Case Study
|

|
|
Mediation Requirements Review and
Validation Case Study
The mediation system is the
busiest system operating within the telecom environment. Each day,
hundreds of millions of CDRs are processed and forwarded to the
billing, interconnect, roaming, fraud, data warehouse and other
critical operational systems. Each of these systems submits an
extensive and complex set of requirements to the mediation
operational team specifying which records to format, filter or
forward.
Unfortunately, in the hectic
world that is modern telecommunications, the process of
submitting and changing these requirements is often handled in a
highly informal and unstructured manner. In many cases, a
requirements change will be requested via a phone call, and
input directly into the mediation system without any intervening
documentation whatsoever.
The result is an environment
where no one is really sure, authoritatively what precisely the
requirements are that mediation should be following.
In many cases, significant
leakage can be identified through the simple process of
formalizing and rectifying misunderstandings between groups.
The basic steps in the process are simple and
straightforward.
- First, all formal target
system specifications being used by the mediation group as
control documentation is reviewed
- Second, interviews are established with each of the target
systems operational support groups
- Each of these groups is interviewed, and a formal,
comprehensive understanding of what is expected out of the
mediation system is documented
- The results of the interviews are compared with the formal
specifications being utilized by the mediation group, and any
inconsistencies are resolved.
Projects of this kind have
yielded significant leakage reduction in the past, and the fact
that it is:
 | Low cost |
 | Puts a minimum burden on
the target systems support staff |
means that it is usually the
first step in any mediation assurance effort.
back to top |

|
Mediation Reference Table
Reconciliation Case Study
In a very real sense, a mediation system is nothing more than a
record processing engine. It reads records in, categorizes them,
reformats them and then writes them out.
There are two ways that mediation
systems keep track of all of the different rules, conversions
and conditions that it has to keep track of:
 |
Hard coded business rules
|
 |
Parameter tables
|
The only way to check up on the
way that the hard-coded business rules are working is to either
review the code, or run tests and samples to see how it
performs.
Checking on parameter tables is
much easier. In this case it is possible to gain copies of each
of the reference tables and run programs that compare their
contents against the "master tables" that hold the officially
correct values.
back to top
|

|
Mediation Integrity Verification
Case Studies
After the mediation requirements and reference table information
are verified, the last level of assurance to be conducted is the
verification of the mediation system operations themselves.
Verifying the integrity of the
mediation systems operation can best be described as a
painstaking and tedious undertaking. There are several
approaches that we have developed over time, these include:
 |
Spot check verification of
specific phone calls, customer activities or switch activities
|
 |
Systematic verification of
classes of records based upon different categorization criteria
|
 |
Generation of random sample based
checks in order to assure the overall integrity of mediation
system operations
|
 |
Comprehensive validation of the
overall population of CDRs processed for a given period of time
|
 |
Creation of CDR Data Warehouses
that make it possible to perform extensive checks into system
integrity on demand
|
 |
Establishment of automated
integrity check systems
|
back to top
|

|
|
Revenue Assurance Library
|
|