|Publication number||US8185455 B2|
|Application number||US 11/241,763|
|Publication date||May 22, 2012|
|Filing date||Sep 30, 2005|
|Priority date||Sep 30, 2005|
|Also published as||US20070088639|
|Publication number||11241763, 241763, US 8185455 B2, US 8185455B2, US-B2-8185455, US8185455 B2, US8185455B2|
|Inventors||Euly LeGro, Gideon Juve, Kin Chan, Jorge Pastoral, Jr., Robert Rich, Kelly Stephenson, Jack Fine, Michael L. Peterson|
|Original Assignee||At&T Intellectual Property I, L.P.|
|Export Citation||BiBTeX, EndNote, RefMan|
|Patent Citations (17), Classifications (8), Legal Events (2)|
|External Links: USPTO, USPTO Assignment, Espacenet|
The present disclosure relates to methods and systems for auditing telecommunication billing data.
Telecommunication billing data is audited to ensure that telecommunication use has been accurately billed. U.S. Patent Application Publication Nos. 2002/0082991 A1 and 2004/0153382 A1 disclose various methods and systems for auditing telecommunication billing data.
The present disclosure is pointed out with particularity in the appended claims. However, other features are described in the following detailed description in conjunction with the accompanying drawings in which:
Disclosed herein are embodiments of a tool to create billing audit rules to analyze complex circuit structures to find errors and discrepancies. Incorrect circuit attributes created in a billing database may be caused by insufficient edit checks when processing and posting account service order activities or embedded base charges, for example.
The tool has a rule-construction user interface for users to interactively and dynamically construct billing audit rules. The rule-construction user interface may comprise particular drop-down menus that facilitate interactive construction of potentially-complex billing audit rules. Further, the rule-construction user interface enables identification of particular access service groups (ASGs), circuits, sub-circuits (e.g. legs), Universal Service Order Codes (USOCs), values and billing charges when constructing the billing audit rules. Still further, the rule-construction user interface assists in pinpointing errors by enabling the creation of rules that compare a value on a circuit with either another value on the circuit or a user-entered value. Yet still further, the rule-construction user interface supports a mileage calculation, coordinate comparisons, pattern matching, NCI code analysis, and keyed list substitutions.
The tool enables testing of a billing audit rule by running it against a data file of embedded account attributes. If acceptable results are returned, a run with the billing audit rule is baselined or the user can baseline the rule without baselining the test run results. Testing a billing audit rule may include running one or two versions of the same set of rules to detect and eliminate false positives. The billing audit rules can be stored and reused for testing and baselining purposes.
Based on the billing audit rules, extracted embedded-base billing data for existing telecommunication circuits are examined for proper billing attributes. Exceptions to the billing audit rules, which may represent instances of misbilling, are identified and reported. The tool enables work flow management of the exceptions between multiple access service centers (ASCs).
The tool also provides automated reporting of revenue impacts from the rule exceptions. The identified exceptions can be used in revenue assurance and revenue recovery applications.
Thus, the tool provides an automated method of building business rules via a requirements discovery process that allows for an audit of circuit billing rules and attributes. Further, the tool may provide user administration functions and an interactive generic capability to set rule parameters on a chunk of data by using character patterns. The application is portable to any billing system where an embedded data source can be established for account, circuit or circuit-leg-level validation. For example, the application may be used in an industry market carrier access billing platform, a retail billing platform, and other billing platforms.
In general, each audit rule comprises one or more conditions. Each condition may be constructed using one or more of a condition part, a left-hand side clause, an operator and a right-hand side clause.
The rule-construction user interface 10 further comprises a level drop-down menu 22 and a value drop-down menu 24 for users to construct the left-hand side clause of the rule condition. The level drop-down menu 22 includes an Access Service Group (ASG) option, an ASG Universal Service Order Code (USOC) option, a circuit option, a circuit USOC option, a circuit leg option and a circuit leg USOC option. The value drop-down menu 24 displays user-selectable options that depend on which option in the level drop-down menu 22 has been user-selected.
If the ASG option is selected from the level drop-down menu 22, then the value drop-down menu 24 includes a field identifier (FID) option and an FID quantity option.
If the circuit option is selected from the level drop-down menu 22, then the value drop-down menu 24 includes a circuit ID option, a billing account number (BAN) option, an access customer name abbreviation (ACNA) option, a class of service option, a common language facility (CLF) option, a common language location identifier (CLLI) option, a common language circuit identification serial number format (CLS) option, an Inter-Office Code (IOC) option, a network channel (NC) code option, a network channel interface (NCI) code option, an FID option, and an FID quantity option.
If the circuit leg option is selected from the level drop-down menu 22, then the value drop-down menu 24 includes a circuit location (CKL) option, a circuit location telephone company wire center (CKLT) option, a connecting facility assignment (CFA) option, an exchange company indicator (EC) option, a local serving office wire center CLLI code (LSOC) option, a vertical-horizontal (V-H) coordinates option, a point of interface (POI) option, an FID option, an FID quantity option, and an NCI code quantity option.
If either the ASG USOC option, the circuit USOC option or the circuit leg USOC option is selected from the level drop-down menu 22, then the value drop-down menu 24 includes a USOC option, a USOC quantity option, a USOC any-rate option, a USOC billed-rate option, a USOC fixed-rate option, a USOC variable-rate option, a USOC FID option, and a USOC FID quantity option.
The rule-construction user interface 10 further comprises at least one input box 26 that is presented to the user based on which options have been user-selected in the level drop-down menu 22 and the value drop-down menu 24. The at least one input box 26 may comprise up to three input boxes to receive any combination of a USOC input value, an FID input value and a product input value. The specific combination of input boxes presented for each possible level/value option combination is shown is
The rule-construction user interface 10 may further comprise a leg drop-down menu (not illustrated) if either the circuit leg option or the circuit leg USOC option is user-selected from the level drop-down menu 22. The leg drop-down menu includes an any-leg option, a leg option, a CKL option, a CKLT option, a last-leg option, a last-CKL option and a last-CKLT option. Based on which option is user-selected from the leg drop-down menu 22, the rule construction user interface 10 may further comprise a leg number input box (not illustrated). The leg number input box is presented if either the leg option, the CKL option, the CKLT option, the last CKL option or the last CKLT option is user-selected.
Referring back to
The options presented in the operator drop-down menu 30 are based on which options have been user-selected in the level drop-down menu 22 and the value drop-down menu 24. The options can be characterized as being either normal options or numeric options.
Based on which option is user-selected in the operator drop-down menu 30, the rule-construction user interface 10 may further comprise one or more drop-down menus and/or one or more input boxes 32 for constructing a right-hand side clause of the rule condition. Logic for providing the right-hand side user interface elements are also shown in
If the “exists” option is user-selected from the operator drop-down menu 30, then no right-hand side user interface is included in the rule-construction user interface 10.
If the “in” option is user-selected from the operator drop-down menu 30, then the right-hand side user interface comprises an input box. The input box is receptive to a user input of a comma-separated or other delimiter-separated list with regular expression matching and list replacement. A single character replacement may be represented by a first symbol such as “*”. A replacement of zero or more characters may be represented by a second symbol such as “˜”. A replacement of one or more characters may be represented by a third symbol such as “^”.
If the “equals” option is user-selected from the operator drop-down menu 30, then the right-hand side user interface is the same as the left-hand side user interface. In this case, the right-hand side user interface enables the creation of a rule condition that compares a value on a circuit with another value on the circuit.
If either the “less-than” option or the “greater-than” option is user-selected from the operator drop-down menu 30, then the right-hand side user interface comprises an input box. The input box is receptive to a user input of a numeric value.
If the “in-range” option is user-selected from the operator drop-down menu 30, then the right-hand side user interface comprises an input box. The input box is receptive to a user input of a lower value and an upper value, separated by a comma or another delimiter, to define the range.
If the “equals-mileage” option is user-selected from the operator drop-down menu 30, then the right-hand side user interface comprises two input boxes. A first input box is receptive to a user input of a first leg value, and a second input box is receptive to a user input of a second leg value. The “equals-mileage” option is used to create a rule condition based on a mileage calculation.
Inputs made by the various menus and input boxes of the rule-construction user interface 10 are concatenated to construct a rule condition. Referring back to
Referring back to
A test user interface 42 allows any of the audit rules in the database 40 to be tested. The test user interface 42 comprises a rule menu 44 of the audit rules stored in the database 40. The rule menu 44 is receptive to user selections of which audit rule(s) are to be tested.
The test user interface 42 comprises a data set menu 46 of a plurality of telecommunication billing data sets 50. The data set menu 46 is to receive a user selection of which telecommunication data set(s) is to be examined based on the user-selected audit rule(s).
The telecommunication billing data sets 50 may be produced by an extraction process from a main embedded-base master file. The extracted feed is loaded into and stored by a database that provides the telecommunication billing data sets 50. The extraction process assists in running the billing audit rules against very large files.
Referring back to
In general, the audit component 60 performs the audit based on a user selection of one or more audit rules/versions from the rule menu 44 and a user selection of a telecommunication billing data set from the data set menu 46.
Using the results user interface 64, the user can identify and select which version of the audit rule 14 is most accurate in detecting particular exceptions of interest. The exceptions displayed by the results user interface 64 are reviewed by the user to find a version that detects all desired exceptions, but does not produce false positives.
If some exceptions are not detected and/or some false positives are produced, the user can refine the best version (or any version) of the audit rule 14 using the rule-construction user interface 10. One or more subsequent audit tests can be performed until a version of the audit rule 14 has been constructed to produce the desired results.
Referring back to
The users may send any of the exceptions 62 for further validation or for completion to one or more other users. For instance, a user at a first ASC may send one or more exceptions to another user at a second ASC. Communication between users at ASCs may be performed using a mail-exchange server 76.
For example, an exception initially worked in a billing ASC 78 may be sent for completion to a provisioning ASC 80 because the exception needs a correcting service order. Another example is an exception initially worked in the provisioning ASC 80 being sent to the billing ASC 78 because the exception needs an adjustment to be created by the billing ASC 78.
The user interface 74 enables users to enter information associated with each exception such as a root cause, causing service order information, action taken, and comments/notes. A supervisory-level tool user can categorize or group like exceptions for assignment to an exception validator-owner. The exception validator-owner can use the user interface 74 to enter appropriate information for each exception as assigned to the user. The supervisory-level user can re-assign exceptions amongst groups of exception validator-owners for workload balancing.
Service orders and/or adjustments created to correct an exception determined to be a true positive or a misbilling are entered and stored in the tool. The tool processes this information to extract mechanically the associated revenues for each correcting action. The revenues that are extracted can include a Monthly Recurring Charge (MRC) which will enable annualized revenue reporting, Other Charges and Credit (OCC) for back billing, and Adjustments. The extracted revenues are stored in the tool for management reporting. A mechanized revenue tracking component can perform these acts.
The herein-disclosed features performed by the tool may be directed by one or more computer processors. In accordance with various embodiments, the features described herein may be implemented as one or more software programs running on the one or more computer processors. Dedicated hardware implementations including, but not limited to, application specific integrated circuits, programmable logic arrays and other hardware devices can likewise be constructed to implement the methods described herein. Furthermore, alternative software implementations including, but not limited to, distributed processing or component/object distributed processing, parallel processing, or virtual machine processing can also be constructed to implement the features disclosed herein.
It is noted that software that implements the disclosed methods may optionally be stored on a tangible storage medium, such as: a magnetic medium, such as a disk or tape; a magneto-optical or optical medium, such as a disk; or a solid state medium, such as a memory card or other package that houses one or more read-only (non-volatile) memories, random access memories, or other re-writable (volatile) memories. The software may also utilize a signal containing computer instructions. A digital file attachment to e-mail or other self-contained information archive or set of archives is considered a distribution medium equivalent to a tangible storage medium. Accordingly, the disclosure is considered to include a tangible storage medium or distribution medium as listed herein, and other equivalents and successor media, in which the software implementations herein may be stored.
In a networked deployment, the computer system may operate in the capacity of a server or as a client user computer in a server-client user network environment, or as a peer computer system in a peer-to-peer (or distributed) network environment. The computer system 900 can also be implemented as or incorporated into various devices, such as a personal computer (PC), a tablet PC, a set-top box (STB), a personal digital assistant (PDA), a mobile device, a palmtop computer, a laptop computer, a desktop computer, a communications device, a wireless telephone, a land-line telephone, a control system, a camera, a scanner, a facsimile machine, a printer, a pager, a personal trusted device, a web appliance, a network router, switch or bridge, or any other machine capable of executing a set of instructions (sequential or otherwise) that specify actions to be taken by that machine. In a particular embodiment, the computer system 900 can be implemented using electronic devices that provide voice, video or data communication. Further, while a single computer system 900 is illustrated, the term “system” shall also be taken to include any collection of systems or sub-systems that individually or jointly execute a set, or multiple sets, of instructions to perform one or more computer functions.
As illustrated in
In a particular embodiment, as depicted in
In an alternative embodiment, dedicated hardware implementations, such as application specific integrated circuits, programmable logic arrays and other hardware devices, can be constructed to implement one or more of the methods described herein. Applications that may include the apparatus and systems of various embodiments can broadly include a variety of electronic and computer systems. One or more embodiments described herein may implement functions using two or more specific interconnected hardware modules or devices with related control and data signals that can be communicated between and through the modules, or as portions of an application-specific integrated circuit. Accordingly, the present system encompasses software, firmware, and hardware implementations.
In accordance with various embodiments of the present disclosure, the methods described herein may be implemented by software programs executable by a computer system. Further, in an exemplary, non-limited embodiment, implementations can include distributed processing, component/object distributed processing, and parallel processing. Alternatively, virtual computer system processing can be constructed to implement one or more of the methods or functionality as described herein.
The present disclosure contemplates a computer-readable medium that includes instructions 924 or receives and executes instructions 924 responsive to a propagated signal, so that a device connected to a network 926 can communicate voice, video or data over the network 926. Further, the instructions 924 may be transmitted or received over the network 926 via the network interface device 920.
While the computer-readable medium is shown to be a single medium, the term “computer-readable medium” includes a single medium or multiple media, such as a centralized or distributed database, and/or associated caches and servers that store one or more sets of instructions. The term “computer-readable medium” shall also include any medium that is capable of storing, encoding or carrying a set of instructions for execution by a processor or that cause a computer system to perform any one or more of the methods or operations disclosed herein.
In a particular non-limiting, exemplary embodiment, the computer-readable medium can include a solid-state memory such as a memory card or other package that houses one or more non-volatile read-only memories. Further, the computer-readable medium can be a random access memory or other volatile re-writable memory. Additionally, the computer-readable medium can include a magneto-optical or optical medium, such as a disk or tapes or other storage device to capture carrier wave signals such as a signal communicated over a transmission medium. A digital file attachment to an e-mail or other self-contained information archive or set of archives may be considered a distribution medium that is equivalent to a tangible storage medium. Accordingly, the disclosure is considered to include any one or more of a computer-readable medium or a distribution medium and other equivalents and successor media, in which data or instructions may be stored.
Although the present specification describes components and functions that may be implemented in particular embodiments with reference to particular standards and protocols, the invention is not limited to such standards and protocols. For example, standards for Internet and other packet switched network transmission (e.g., TCP/IP, UDP/IP, HTML, HTTP) represent examples of the state of the art. Such standards are periodically superseded by faster or more efficient equivalents having essentially the same functions. Accordingly, replacement standards and protocols having the same or similar functions as those disclosed herein are considered equivalents thereof.
The illustrations of the embodiments described herein are intended to provide a general understanding of the structure of the various embodiments. The illustrations are not intended to serve as a complete description of all of the elements and features of apparatus and systems that utilize the structures or methods described herein. Many other embodiments may be apparent to those of skill in the art upon reviewing the disclosure. Other embodiments may be utilized and derived from the disclosure, such that structural and logical substitutions and changes may be made without departing from the scope of the disclosure. Additionally, the illustrations are merely representational and may not be drawn to scale. Certain proportions within the illustrations may be exaggerated, while other proportions may be minimized. Accordingly, the disclosure and the figures are to be regarded as illustrative rather than restrictive.
One or more embodiments of the disclosure may be referred to herein, individually and/or collectively, by the term “invention” merely for convenience and without intending to voluntarily limit the scope of this application to any particular invention or inventive concept. Moreover, although specific embodiments have been illustrated and described herein, it should be appreciated that any subsequent arrangement designed to achieve the same or similar purpose may be substituted for the specific embodiments shown. This disclosure is intended to cover any and all subsequent adaptations or variations of various embodiments. Combinations of the above embodiments, and other embodiments not specifically described herein, will be apparent to those of skill in the art upon reviewing the description.
The Abstract of the Disclosure is provided to comply with 37 C.F.R. §1.72(b) and is submitted with the understanding that it will not be used to interpret or limit the scope or meaning of the claims. In addition, in the foregoing Detailed Description, various features may be grouped together or described in a single embodiment for the purpose of streamlining the disclosure. This disclosure is not to be interpreted as reflecting an intention that the claimed embodiments require more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive subject matter may be directed to less than all of the features of any of the disclosed embodiments. Thus, the following claims are incorporated into the Detailed Description, with each claim standing on its own as defining separately claimed subject matter.
The above disclosed subject matter is to be considered illustrative, and not restrictive, and the appended claims are intended to cover all such modifications, enhancements, and other embodiments which fall within the true spirit and scope of the present invention. Thus, to the maximum extent allowed by law, the scope of the present invention is to be determined by the broadest permissible interpretation of the following claims and their equivalents, and shall not be restricted or limited by the foregoing detailed description.
|Cited Patent||Filing date||Publication date||Applicant||Title|
|US5504840 *||Jun 19, 1992||Apr 2, 1996||Hitachi, Ltd.||Knowledge acquisition support system and method in an expert system|
|US5530861 *||Nov 28, 1994||Jun 25, 1996||Hewlett-Packard Company||Process enaction and tool integration via a task oriented paradigm|
|US5689668 *||Sep 23, 1996||Nov 18, 1997||International Business Machines Corporation||Dynamic hierarchical selection menu|
|US5758031 *||Nov 9, 1993||May 26, 1998||Omron Corporation||Rule generating apparatus and method|
|US6625499 *||Jan 5, 2001||Sep 23, 2003||Mitel Knowledge Corporation||Tabular range editing mechanism|
|US6678669 *||Aug 14, 1997||Jan 13, 2004||Adeza Biomedical Corporation||Method for selecting medical and biochemical diagnostic tests using neural network-related applications|
|US6687335 *||Mar 31, 1998||Feb 3, 2004||Southwestern Bell Telephone Company||User interface and system to facilitate telephone circuit maintenance and testing|
|US6772135 *||Nov 21, 2001||Aug 3, 2004||Capital One Financial Corporation||Systems and methods for monitoring an application processor|
|US6934696 *||Sep 15, 2000||Aug 23, 2005||Bently Nevada, Llc||Custom rule system and method for expert systems|
|US7085360 *||Apr 21, 2003||Aug 1, 2006||Cingular Wireless, Llc||System and method for auditing billing records in a telecommunications system|
|US7139369 *||Aug 29, 2002||Nov 21, 2006||Sbc Properties, L.P.||Interface and method of designing an interface|
|US7581194 *||Apr 28, 2006||Aug 25, 2009||Microsoft Corporation||Enhanced on-object context menus|
|US7627891 *||Feb 13, 2004||Dec 1, 2009||Preventsys, Inc.||Network audit and policy assurance system|
|US7725728 *||Mar 23, 2005||May 25, 2010||Business Objects Data Integration, Inc.||Apparatus and method for dynamically auditing data migration to produce metadata|
|US20040153382 *||Jan 31, 2003||Aug 5, 2004||Richard Boccuzzi||System and method for determining discrepancies in a communications system|
|US20050080821 *||Jul 21, 2004||Apr 14, 2005||Breil Peter D.||System and method for managing collections accounts|
|US20070180490 *||Jul 1, 2004||Aug 2, 2007||Renzi Silvio J||System and method for policy management|
|U.S. Classification||705/34, 717/124, 379/114.04, 706/50|
|International Classification||G07F19/00, H04M15/00|
|Dec 23, 2005||AS||Assignment|
Owner name: SBC KNOWLEDGE VENTURES, L.P., NEVADA
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:LEGRO, EULY;JUVE, GIDEON;CHAN, KIN;AND OTHERS;REEL/FRAME:017143/0173
Effective date: 20051215
|Oct 27, 2015||FPAY||Fee payment|
Year of fee payment: 4