CA2034600C - Method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services - Google Patents

Method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services

Info

Publication number
CA2034600C
CA2034600C CA002034600A CA2034600A CA2034600C CA 2034600 C CA2034600 C CA 2034600C CA 002034600 A CA002034600 A CA 002034600A CA 2034600 A CA2034600 A CA 2034600A CA 2034600 C CA2034600 C CA 2034600C
Authority
CA
Canada
Prior art keywords
user
billing
records
record
call
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Lifetime
Application number
CA002034600A
Other languages
French (fr)
Other versions
CA2034600A1 (en
Inventor
David M. Baum
Andrea E. Bradshaw
Christopher G. Mcclain
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Motorola Solutions Inc
Original Assignee
Motorola Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Motorola Inc filed Critical Motorola Inc
Publication of CA2034600A1 publication Critical patent/CA2034600A1/en
Application granted granted Critical
Publication of CA2034600C publication Critical patent/CA2034600C/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04W—WIRELESS COMMUNICATION NETWORKS
    • H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
    • H04W4/24—Accounting or billing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/04—Billing or invoicing
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/49—Connection to several service providers
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/51—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP for resellers, retailers or service providers
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/80—Rating or billing plans; Tariff determination aspects
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/80—Rating or billing plans; Tariff determination aspects
    • H04M15/8022—Determining tariff or charge band
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/80—Rating or billing plans; Tariff determination aspects
    • H04M15/8044—Least cost routing
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/80—Rating or billing plans; Tariff determination aspects
    • H04M15/8066—According to the number of recipients
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M15/00—Arrangements for metering, time-control or time indication ; Metering, charging or billing arrangements for voice wireline or wireless communications, e.g. VoIP
    • H04M15/80—Rating or billing plans; Tariff determination aspects
    • H04M15/8083—Rating or billing plans; Tariff determination aspects involving reduced rates or discounts, e.g. time-of-day reductions or volume discounts
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/01—Details of billing arrangements
    • H04M2215/0152—General billing plans, rate plans, e.g. charge rates, numbering plans, rate centers, customer accounts
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/01—Details of billing arrangements
    • H04M2215/0184—Details of billing arrangements involving reduced rates or discounts, e.g. time-of-day reductions, volume discounts, cell discounts, group billing, frequent calling destination(s) or user history list
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/20—Technology dependant metering
    • H04M2215/2026—Wireless network, e.g. GSM, PCS, TACS
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/32—Involving wireless systems
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/42—Least cost routing, i.e. provision for selecting the lowest cost tariff
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/46—Connection to several service providers
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/54—Resellers-retail or service providers billing, e.g. agreements with telephone service operator, activation, charging/recharging of accounts
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/74—Rating aspects, e.g. rating parameters or tariff determination apects
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/74—Rating aspects, e.g. rating parameters or tariff determination apects
    • H04M2215/7421—Determine tariff or charge band
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/74—Rating aspects, e.g. rating parameters or tariff determination apects
    • H04M2215/745—Least cost routing, e.g. Automatic or manual, call by call or by preselection
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M2215/00—Metering arrangements; Time controlling arrangements; Time indicating arrangements
    • H04M2215/74—Rating aspects, e.g. rating parameters or tariff determination apects
    • H04M2215/7478—According to the number of recipients

Abstract

A METHOD OF PROCESSING CELLULAR TELEPHONE CALL DETAIL DATA FOR BILLING MULTI-LINE CUSTOMERS FOR CELLULAR TELEPHONE SERVICES Abstract of the Disclosure A unique cellular telephone billing system (100) processes call detail records (102) of cellular telephone calls made by users of multi-line customers to produce invoices and reports. The call detail records (301 and 302) for each user of a multi-line customer include a unique key identification number (311 and 321) and may include an information format (401 and 402) having variable-length sub-fields (411-415 and 421-423). Call detail records (102) with key identification numbers are pooled into files (110) and then sorted for each multi-line customer by key identification number and corresponding information format to produce consolidated billing and usage information for all of the cellular telephones as well as individual invoices for each of user-employee of each multi-line customer.

Description

203~0~

A METHOD OF PROCESSING CELLUU~R TELEPHONE
CALL DETAIL DATA FOR BILLING MULTI-LINE CUSTOMERS
FOR CELLULAR TELEPHONE SERVICES

Background of the Invention The present invention is generally related to cellular telephone billing systems, and more particularly 10 to a method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services.
Cellular telephone billing systems currently accept cellular telephone call detail data on a periodic basis by 15 electronic transmission or on magnetic media from cellular telephone carriers, process the call detail data on the tapes, and typically generate monthly invoices for the user associated with each cellular telephone number.
For a multi-line customer owning a large number of 20 cellular telephones with associated cellular telephone numbers, a different monthly invoice (in varying formats) is typically generated for each of the cellular telephone numbers. As a result, it is very difficult for a multi-line customer to determine on a monthly basis ths 25 total bill for cellular telephone services provided to its users and many other criteria needed to efficiently and cost effectively make use of the cellular telephones it owns. Therefore, for the foregoing reasons, there is a need to provide on a regular basis consolidated cost and 30 usa~e information for the cellular telephones owned by a multi-line customer.

3k : ' , .. ~

203~60~
ObLçcts of the Invention Accordingly, it is an objeet of the present invention to provide an improved method for billing a 5 multi-line eustomer for eellular telephone services.
It is another objeet of the present invention to provide a unique method for billing multi-line customers for cellular telephone serviees, wherein each customer has a unique key identifieation number and one or more 10 users of each eustomer has an information format with variable-length fields for defining data management and reporting funetions.

Brj~f Description of the Drawings Figure 1 is a diagram of a eellular telephone billing system embodying the present invention.
Figure 2 is a flow diagram for proeessing call detail and eustomer detail files produced in the cellular 20 telephone billing system in Figure 1.
Figure 3 illustrates a eall detail reeord and a eustomer detail reeord for a key identifieation number and eorresponding information format.
Fi~ure 4 illustrates two information formats for 25 eorresponding key identifieation numbers.
Fi~ure 5 is a flow dia~ram of the proeess for produeing seleeted reports for a multi-line eustomer having a pre-assigned key identifieation number and pre-assign~d information format.

.

. ~ .. . . .
.. . , .
~,, - ,. . ..

20~60~
Q~iled Descrigtion of the er~f~r~bodiment Referring to Figure 1, there is illustrated a diagram of a cellular telephone billing system 100 5 embodying the present invention. Billing systsm 100 procass call detail reeords of cellular telephone calls made by cellular subscribers or users in various cellular systems operated by cellular carriers throughout the United States and/or other countries of the world. For 10 each cellular telephone call made by or to a user, at least one call detail record is created in the cellular system processing the call. Each such call detail record includes information relating to the call, including, but not limited to, the cellular telephone number, the 15 electronic serial number of the cellular telephone, the called telephone number, the time the call was placed, the time duration of the call, and other information depending on the cellular carrier processing the call. On a periodic basis, the call detail records accumulated by a 20 eellular earrier are proeessed to produce sellular telephone bills for eaeh user for which calls were processed.
A reseller of eellular serviees obtains cellular telephone numbers from carriers in a number of 25 different eities. The reseller provides telephone numbers direetly to a user and then bills the user typieally on a monthly basis for the telephone ealls made by the user. In order for the reseller to generate the monthly bills, billing system 100 is utilizad to process 30 on a periodie basis eall detail reeords from multiple earriers for eaeh user telephone number billed by the reseller.
For a multi-line eustomer whieh owns a number of eellular telephones operated by its user-employees, it is 35 desirable to reeeive eonsolidated billin~ and usa~e information for all of its eellular telephones as well as ...
, , ~ -, ,.

2~3a~
individual bills for each of its user-employees.
According to the present invention, a unique key identification number is associated with each multi-line customer. An information format with variable-length 5 fields is associated with one or more user-employees of a multi-line customer so that call detail records may be pooled and processed for providing consolidated biiling and usage information for all of its cellular telephones as well as individual bills for each of its user-10 employees. Illustrative call detail records 301 and 302including the key identification number and the information format are shown in Figure 3. As illustrated in Figure 4, the number and length of the sub-fields in the information formats 401 and 402 can be tailored to 15 the specific data management and reporting functions desired by the multi-line customer.
In the diagram of Figure 1, call detail data 102 is received from cellular carriers in many different cities or geo~raphical areas. The call detail data 102 from 20 each carrier may be received on magnetic tapes, cartrid~es, data sets or other suitable storage media, may be received electronically, and may be received in a number of different data formats. Next, at block 106, the call detail data 102 is batch processed on a periodic 25 basis to reformat, rate, add the user's key identification number and information format, and consolidate the new call detail data with the previous data, using tariff tables 104 and service profile file 105.
Next, at block 108, according to the present 30 invention, the previously collected call detail data from block 10B may be processed to select all records including a key identification number and create two data poolQ or files, called the call detail file 110 and the customer detail file 112. As illustrated in Figure 3, 35 records 302 in customer detail file contain customer related information, includin~, but not limited to, the , , . , ; ;, , . ~
. , . , : , "
,., . ,, ~.

20~60~

- 5 - CEoo10sR

billing account number 323, cellular telephone number 324, electronic serial number 325 of a cellular telephone, rate plan 326, features plan 327, air time charges 328, landline charges 329, feature charges 330.
5 roaming charges 331, and taxes 332. As illustrated in Figure 3, records 301 in call detail file contain information related to the calls placed by the cellular telephone, including, but not limited to, cellular telephone number 313, electronic serial number 314 of a 10 cellular telephone, the called telephone number 315, the date 316 the call was placed, the time 317 the call was placed, and the duration 318 of the call.
The cùstomer detail file 118 and call detail file 110 may be outputted on tapes or other suitable media or 15 may be transmitted electronically and are further processed at block 114. In the preferred embodiment, the processing of blocks 106 and 108 is performed using conventional billing software which has been modified to include the ability to associate key identification 20 numbers and information formats for all cellular telephone numbers of each multi-line customer. One source of such software is Cincinnati Bell Information Systems, Inc.
Online data entry at block 116, which utilizes 25 online front end processor 118 to produce an online data ently work file 120 which is transferred to block 108 where it is utilized to maintain service profile file 105, to provide and/or edit the unique key identification number and the information format for cellular 30 telephone numbers of a new multi-line customer and/or users, and to correct or provide additional call detail data.
Returning to block 108, the call detail records may be processed further to create user invoices, pre-35 selected management reports, and fiche data sets 122.

-., ,.: . . ;
.

~ .. .. . - -, ,. ........ ,. .... . ~, . ...
Referring next to Figure 2, there is illustrated a flow diagram for block 114 in Figure 1, where further processing of tapes containing the call detail file 110 and customsr detail file 112 is performed. Upon receipt 5 of new tapes containing the call detail and customer detail files 110 and 112, the tapes are processed at block 200 using a mainframe computer, such as an International Business Machines 3090, to produce internally formatted copies of the call detail file 210 10 and the customer detail file 212. Once copies 210 and 212 are made, tapes 110 and 112 are placed in a fire-proof vault for safe storage.
Next, at block 220, a file maintenance utility, such as the utility called "File-AlD" available from 15 COMPUWARE, is executed on the mainframe computer to produce subsequent generations of 221 and 222 of the call detail file 210 and customer detail file 212, respectively, in which the header and trailer records have been removed. Then, at block æs, a software 20 application program is executed on the mainframe computer to create, on the basis of the key iden~itication number for a selected multi-line customer, tapes 226 and 227 from abbreviated files 221 and 222, respectively, which contain selected data 25 relating to the users of that multi-line customer.
Next, at block 230, another software application program is executed on the mainframe computer for sorting the records in the abbreviated customer detail file 222 and computing the total values of the quantities 30 in certain data fields, such as, for example, the data fields for roaming charges, air-time charges, and landline charges to produce a sorted customer detail summary file 231. This software application program also incorporates into file 231 other selected 3~ information from the customer detail records from file 222, and replaces embedded market identifiers of the * Trade-mark .

,, ' :. ' . ' ' , ' : , , - 7 - CE00 1 osR

conventional billing software in file 222 with different market idsntifiers using a general usage table. Then, at block 232, another sofh~are application program is executed on the mainframe computer for deleting 5 records for cancelled users and for users with no account lev~l charges in file 231. Thereafter, the data is transferred from the mainframe computer to a personal computer 233 (sueh as an Intel 80X86 microproeessor based personal eomputer using MS-DOS
10 or PC-DOS operating system), using a commercially available file transfer program (such as the program ealled "SIM/XFER~ available from Simware, Inc.). The data is then transferred to a relational data base structure 235 (sueh as that provided by dBASE lll Plus 15 from Ashton Tate Corporation). Next, at block 236, data 235 iS sorted and totaled on the personal eomputer and reports 237 are printed using a report program generator (such as the program ealled "R & R Relational Report Writer'~ available from Coneentrie Data Systems, Inc.).
20 The report program generator 236 ineludes a process sueh that sorting is performed for eaeh multi-line customer using the key identifieation number and information format for that eustomer. Print images of some of the reports are uploaded from the relational 25 data base 235 to the mainframe eomputer using a file transfer program. The uploaded reports may then be transferred to individual mainframe aecounts 238 on another mainframe eomputer.
Referring next to Figure 4, there are illustrated 30 two information formats 401 and 402 for key identifieation numbers for multi-line eustomer A and multi-line eustomer B, respeetively. According to the present invention, the information format is a data field whieh can be sub-divided into a variable number of sub-35 fields eaeh having different lengths. In the preferredembodiment, the information format is a fifteen * Trade-mark : , . . . . .
character field with four sub-fields of variable lenqth.
Information format 401 has four sub-fields 411-414 having three characters.
Information format 402 has four sub-fields 5 421-424 having three, four, eight, and zero characters, respectively. For the sales organization of customer A, sub-fields 41 1, 412, 413 and 414 of information format 401 are associated with data fields for product, division, region and district, respectively. For the 10 service organization of customer B, sub-fields 421, 422 and 423 of information format 402 are associated with data fields for region, department, and employee number, respectively. Sub-field 424 is a zero length filler field.
As illustrated by information formats 401 and 402, the 15 sub-fields selected for a particular multi-line customer may be varied in length to suit that customer's specific needs.
The structure (sizing of sub-fields) of an information format is specific to a multi-line customer, 20 and therefore, is also specific to the associated key identification number. The data contained within the information format sub-field in call detail and customer detail records is specific to one or more users.
Referring next to Figure 5, there is illustrated a 25 flow diagram of the process for producing selected reports for a multi-line customer having a predetermined key identification number and one or more information formats (with same number of sub-fields but different information in each). The process is 30 entered at START block 502 and proceeds to block 504, where the predetermined key identification number and information format are associated with each cellular telephone number or user of a multi-line customer.
Next, at block 506, the call detail and customer detail 35 files are generated from the monthly billing pool. Also, a sequence number for the billing cycle is added to each A

. ,. .. ~ , , .
, i ;
s, . ;s ~ ~" - ~ -.

203~60~
- g - CE001 osR

reeord to identify that biliing cycle. Then, at block 508, the call detail and eustomer detail files are sorted in aceordanee with the predetermined key identifieation number and information format of the multi-line 5 eustomer.
Next, at bloek 510, a report type is seleeted for a number of different reports eaeh ineluding a set of data sub-fields from the eall detail and eustomer detail files.
Then, at bloek 512, a plurality of the sorted reeords are seleeted on the basis of the desired report type to create abbreviated summary reeords. Last, at bloek 514, a printed report is generated illustrating in graphie form the seleeted summary reeords. Thereafter, at bloek 516, a eheek is made to determine if another report type has been seleeted. If so, YES braneh is taken baek to block 508 to repeat bloek 508-514 for another report type. If another report type has not been seleeted, NO branch is taken form bloek 516 to bloek 518 to return to other tasks.
In summary, a unique billing system has been deseribed for billing multi-line eustomers for cellular telephone serviees, wherein eaeh user has a unique key identifieation number and may have an information format with variable-length and variable-eontent fields for defining data management and reporting funetions.
As a result, a eustomer owning a number of eellular telephones may be assigned a predetermined identifieation number and eorresponding information format for obtaining eonsolidated billing and usage information for all of its eellular telephones as well as individual bills for eaeh of its users.

., , ~ `,' .

' , . ' ' '' '

Claims (8)

Claims
1. A method of cellular radiotelephone user billing from a multiplicity of user records from one or more cellular systems gathered in a billing pool, said method comprising the steps of:
creating a key identification number for a group of users and an information format having at least one sub-field for at least one user of said group of users;
associating said key identification and said information format with each user record in the billing pool;
obtaining from the billing pool at least one call record and at least one call detail;
sorting said at least one call record and said at least one call detail in accordance with said key identification number and said information format;
selecting a plurality of user record types from the sorted call record and call detail to create an abbreviated summary record file; and presenting said abbreviated summary record file in human perceptible form.
2. The method according to claim 1, further including the step of creating a sequence number associated with a selected radiotelephone user.
3. The method according to claim 2, wherein said step of sorting further includes the step of sorting said at least one call record and said at least one call detail in accordance with said sequence number.
4. A cellular radiotelephone billing system for processing cellular radiotelephone call data including a multiplicity of user records from one or more cellular systems gathered in a billing pool for billing users , said system comprising:
means for creating a key identification number and an information format for a group of users;
means for associating said key identification and said information format with each user record in the billing pool;
means for obtaining from the billing pool at least one call record and at least one call detail;
means for sorting said at least one call record and said at least one call detail in accordance with said key identification number and said information format;
means for selecting a plurality of user record types to create an abbreviated summary record file; and means for presenting said abbreviated summary record file in human perceptible form.
5. A method of processing with computing means cellular radiotelephone user billing records from one or more market areas each corresponding to a different cellular system, each billing record associated with a user radiotelephone number, said method comprising the steps of:
adding to each user billing record for at least a pre-selected group of users, a key identification number and an information format having at least one sub-field associated with at least one user of said pre-selected group of users;
adding to each user billing record a billing cycle sequence number;
sorting the-user billing records by at least one key identification number to produce a consolidated file of user records for said at least one key identification number;
creating a user data file of records and a call detail data file of records from said consolidated file;
selecting information from the records in said user data file and/or call detail data file in accordance with said information format and producing summary records containing the selected information; and presenting said summary records in human perceptible form.
6. The method according to claim 5, wherein said step of adding further includes the step of adding to each user billing record a sequence number identifying the billing cycle.
7. The method according to claim 6, wherein said step of sorting further includes the step of sorting said user data file and said call detail data file in accordance with said sequence number.
8. A key account billing controller for use with a digital computer, the controller comprising:
a computer program storage medium having a computer program to be executed by the digital computer stored thereon, the computer program comprising:
first means for processing cellular radiotelephone call data including a multiplicity of user records from one or more cellular systems gathered in a billing pool for billing users and adding to each user billing record a key identification number and an information format having at least one sub-field associated with at least one user; and second means for sorting the user billing records by at least one key identification number to produce a file of user records for said at least one key identification number, selecting information from the user billing records in said file in accordance with said information format, producing summary records containing the selected information, and presenting said summary records in human perceptible form.
CA002034600A 1990-02-01 1991-01-18 Method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services Expired - Lifetime CA2034600C (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US07/473,787 US4979207A (en) 1990-02-01 1990-02-01 Method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services
US473,787 1990-02-01

Publications (2)

Publication Number Publication Date
CA2034600A1 CA2034600A1 (en) 1991-08-02
CA2034600C true CA2034600C (en) 1993-12-14

Family

ID=23880968

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002034600A Expired - Lifetime CA2034600C (en) 1990-02-01 1991-01-18 Method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services

Country Status (5)

Country Link
US (2) US4979207A (en)
CA (1) CA2034600C (en)
GB (1) GB2246051A (en)
IL (1) IL97016A (en)
MX (1) MX171385B (en)

Families Citing this family (142)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5301223A (en) * 1990-05-22 1994-04-05 Cellular Technical Services Company, Inc. Cellular telephone system with remote programming, voice responsive registration and real time billing
GB2245454B (en) * 1990-06-18 1994-03-23 Stc Plc Mobile communications
US5260987A (en) * 1990-06-18 1993-11-09 Northern Telecom Limited Mobile communications
GB9013605D0 (en) * 1990-06-18 1990-08-08 Stc Plc Mobile communications
DE4290261C2 (en) * 1991-02-04 1996-07-25 Motorola Inc Operation of radiotelephone with multifunctional keys
US5218632A (en) * 1991-10-16 1993-06-08 Telefonaktiebolaget L M Ericsson Flexible call detail recording system
WO1993012606A1 (en) * 1991-12-12 1993-06-24 Cellular Technical Services Company, Inc. Real-time information system for cellular telephones
US5333183A (en) * 1992-03-13 1994-07-26 Moscom Corporation Universal MDR data record collection and reporting system
US5339352A (en) * 1992-10-01 1994-08-16 Bell Atlantic Network Services, Inc. Directory assistance call completion via mobile systems
WO1994009439A1 (en) * 1992-10-22 1994-04-28 American Express Travel Related Services Company, Inc. Automated billing consolidation system and method
US5408519A (en) * 1993-01-19 1995-04-18 Teledebit, L.P. Telecommunications system having a local area network with concurrently processing nodes
NZ263225A (en) 1993-03-31 1998-01-26 British Telecomm Communication network call accounting
JP2905358B2 (en) * 1993-05-18 1999-06-14 富士通株式会社 Communication service system and switching system for implementing communication service
US6052447A (en) * 1993-05-28 2000-04-18 Sprint Communications Company L.P. Method and apparatus for aggregating customer information for a telecommunications system
US5553131A (en) * 1993-07-09 1996-09-03 Mountain International Corporation Providing the most cost-effective long-distance telephone service based on milage band rates
US5420914A (en) * 1994-02-28 1995-05-30 U S West Technologies, Inc. System and method for real time carrier selection
DE69503882T2 (en) * 1994-03-02 1998-12-17 British Telecomm METHOD FOR PRICE DETERMINATION IN A TELECOMMUNICATION SYSTEM
DE4414500A1 (en) * 1994-04-26 1995-11-02 Deutsche Telekom Mobil Method for determining subscribers in a mobile radio network with excessive traffic
US5873032A (en) 1994-04-28 1999-02-16 Metro One Telecommunications, Inc. Method and system for providing directory assistance services during attempt to complete customer or after call termination via an alphanumeric page
US7110520B1 (en) * 1994-04-28 2006-09-19 Metro One Telecommunications, Inc. Method and system for directory assistance services
US5978456A (en) * 1994-10-25 1999-11-02 Kokusai Denshin Denwa Co., Ltd. Charging unit price determination/information apparatus and communication system having charging unit price information function
NZ513722A (en) * 1994-12-02 2001-09-28 British Telecomm Communications terminal
TW288240B (en) * 1995-01-31 1996-10-11 Qualcomm Inc
US5659601A (en) * 1995-05-09 1997-08-19 Motorola, Inc. Method of selecting a cost effective service plan
US5907800A (en) * 1995-06-07 1999-05-25 Lightbridge, Inc. Apparatus for use in inhibiting telecommunication subscriber termination
EP0862840A4 (en) * 1995-06-28 2000-11-08 Mci Communications Corp Method and apparatus for improved call connectivity in an intelligent wireless network
CN1192310A (en) * 1995-07-27 1998-09-02 英国电讯有限公司 Billing for communications usage
GB9603582D0 (en) 1996-02-20 1996-04-17 Hewlett Packard Co Method of accessing service resource items that are for use in a telecommunications system
US6070076A (en) * 1995-12-22 2000-05-30 Ericsson Inc. Identification of mobile calls within a mobile telephone system
US5913163A (en) * 1996-03-14 1999-06-15 Telefonaktiebolaget Lm Ericsson Integrated local communication system
US5907603A (en) * 1996-05-17 1999-05-25 Alcatel Usa, Inc. Database-driven automatic message accounting system and method
US5924076A (en) * 1996-08-16 1999-07-13 Bell Atlantic Science & Technology Coin operated device collection scheduler
WO1998016075A2 (en) * 1996-10-09 1998-04-16 Alcatel Usa Sourcing, L.P. Call routing in a wireless telecommunications system
US6055430A (en) * 1996-10-09 2000-04-25 Alcatel Usa Sourcing, Inc. Call instance representation of a call for call management in a wireless telecommunications system
GB2320649B (en) * 1996-12-20 2001-07-11 Dsc Telecom Lp Call logging in a wireless telecommunication system
US6070150A (en) * 1996-10-18 2000-05-30 Microsoft Corporation Electronic bill presentment and payment system
US6968319B1 (en) 1996-10-18 2005-11-22 Microsoft Corporation Electronic bill presentment and payment system with bill dispute capabilities
US5974308A (en) * 1996-11-13 1999-10-26 Telefonaktiebolaget Lm Ericsson Selective broadcasting of charge rates
US6212377B1 (en) * 1996-11-27 2001-04-03 Ericsson Telefon Ab L M System and method of providing group wireless extension phone service in a radio telecommunications network
US6393275B1 (en) * 1996-12-27 2002-05-21 At&T Corp. Cellular extension service using single line and multiple cellular telephone sets
CA2281926A1 (en) * 1997-02-24 1998-08-27 Wildfire Communications, Inc. Method and apparatus for offering additional product functions to a user
US6173046B1 (en) 1997-02-27 2001-01-09 At&T Corp Customer group billing
US6058170A (en) * 1997-03-10 2000-05-02 At&T Corp Telephone billing with summary information
US5987108A (en) * 1997-03-19 1999-11-16 At&T Corp Telephone billing with customer-defined budgeting
US5844972A (en) * 1997-03-20 1998-12-01 At&T Corp. Customer profile based telephone card billing
US6026291A (en) * 1997-04-09 2000-02-15 Telefonaktiebolaget L M Ericsson Cellular system having programmable subscription capabilities
FI103626B (en) * 1997-04-16 1999-07-30 Nokia Telecommunications Oy Extraction of desired data from data stream
US5881138A (en) 1997-04-27 1999-03-09 Ameritech Corporation Method and system for detecting a change in at least one telecommunication service rate plan
US6498840B2 (en) * 1997-04-25 2002-12-24 Ameritech Corporation Method and system for generating a billing record
US5920613A (en) * 1997-04-25 1999-07-06 Ameritech Corporation Method and system for generating a billing record
US5915006A (en) * 1997-05-01 1999-06-22 At&T Corp. Telephone line aggregated billing
US5982864A (en) * 1997-05-01 1999-11-09 At& T Corp Telephone billing with customized billing information
US6125173A (en) * 1997-05-21 2000-09-26 At&T Corporation Customer profile based customized messaging
GB2313744B (en) * 1997-05-23 1998-04-15 Orange Personal Comm Serv Ltd Telecommunications
US6185413B1 (en) * 1997-06-17 2001-02-06 Siemens Aktiengesellschaft Mobile station having a cost-efficient call management method and system
US6967972B1 (en) 1997-07-31 2005-11-22 Cisco Technology, Inc. Universal protocol conversion
US6111893A (en) * 1997-07-31 2000-08-29 Cisco Technology, Inc. Universal protocol conversion
US6128603A (en) 1997-09-09 2000-10-03 Dent; Warren T. Consumer-based system and method for managing and paying electronic billing statements
EP1016263B1 (en) * 1997-09-15 2001-12-12 Swisscom Mobile AG Billing process and system in a telecommunication network
US6801763B2 (en) 1997-10-29 2004-10-05 Metro One Telecommunications, Inc. Technique for effectively communicating travel directions
US6317490B1 (en) * 1997-12-30 2001-11-13 Nortel Networks Limited Method and apparatus for real-time billing account query
AU2262099A (en) * 1998-02-16 1999-08-30 Swisscom Ag Identification card and billing process with an identification card
JP3204306B2 (en) * 1998-03-03 2001-09-04 日本電気株式会社 Optimal call path re-search device
US6256515B1 (en) 1998-04-29 2001-07-03 Metro One Telecommunications, Inc. Call management system for wireless telephones
US6304857B1 (en) 1998-06-08 2001-10-16 Microsoft Corporation Distributed electronic billing system with gateway interfacing biller and service center
US20020065772A1 (en) * 1998-06-08 2002-05-30 Saliba Bassam A. System, method and program for network user access
US20050187875A1 (en) * 1998-06-08 2005-08-25 Microsoft Corporation Parcel manager for distributed electronic billing system
US6144726A (en) * 1998-06-12 2000-11-07 Csg Systems, Inc. Telecommunications access cost management system
US6650632B1 (en) 1998-06-30 2003-11-18 Cisco Technology, Inc. Feature transparency in a telecommunications network
US6456986B1 (en) * 1998-07-29 2002-09-24 American Management Systems, Incorporated Decision network based event pricing system in a component based, object oriented convergent customer care and billing system
US6704563B1 (en) 1998-08-11 2004-03-09 Boston Communications Group, Inc. Systems and methods for prerating costs for a communication event
US6459779B2 (en) * 1998-09-04 2002-10-01 Ameritech Corporation System and method for creating a billing record with a called party's name
GB2342006B (en) * 1998-09-22 2000-11-08 Cellcom Ltd Apparatus for generating billing data
US7212522B1 (en) 1998-09-30 2007-05-01 Cisco Technology, Inc. Communicating voice over a packet-switching network
US6658022B1 (en) 1998-09-30 2003-12-02 Cisco Technology, Inc. Signaling protocol for controlling voice calls in a packet switching network
US6570869B1 (en) 1998-09-30 2003-05-27 Cisco Technology, Inc. Communicating voice over a packet-switching network
US6301471B1 (en) * 1998-11-02 2001-10-09 Openwave System Inc. Online churn reduction and loyalty system
US7187928B1 (en) 1998-11-24 2007-03-06 Boston Communications Group, Inc. Call delivery systems for roaming prepaid subscribers
US6298125B1 (en) * 1998-12-23 2001-10-02 At&T Corp. Frequency-based discount system for host-system within a communication network
GB2350019B (en) 1999-05-12 2003-09-03 Motorola Ireland Ltd System and method for billing in a radio telecommunications network
US6680952B1 (en) 1999-06-01 2004-01-20 Cisco Technology, Inc. Method and apparatus for backhaul of telecommunications signaling protocols over packet-switching networks
US7797193B1 (en) 1999-06-10 2010-09-14 Simplexity, Llc Systems and methods for distributing telecommunication services via a network
US7076447B1 (en) * 1999-06-10 2006-07-11 Inphonic, Inc. Systems and methods for aggregating buyers for the purchase of telecommunication services via a network
US6356628B1 (en) * 1999-07-16 2002-03-12 Insers Integrated Communications Method for performing call traffic pattern analysis
US6937575B1 (en) * 1999-07-16 2005-08-30 Insors Integrated Communications Method of providing intra-company two way voice communications over a data network
US6999944B1 (en) * 1999-08-19 2006-02-14 Sprint Communications Company L.P. Method and apparatus for authorizing and billing communications services using a bank card financial network
US7729944B1 (en) 1999-09-03 2010-06-01 Simplexity, Llc System and methods for buying and selling telecommunication services via a network
US7603311B1 (en) 1999-11-29 2009-10-13 Yadav-Ranjan Rani K Process and device for conducting electronic transactions
US7822683B2 (en) * 2000-01-21 2010-10-26 Microsoft Corporation System and method for secure third-party development and hosting within a financial services network
FI20000276A (en) * 2000-02-09 2001-08-10 Nokia Networks Oy Reports of reports produced by telephone exchange
US6885997B1 (en) * 2000-02-16 2005-04-26 Teligistics.Com Apparatus and method for comparing rate plans on a net-net basis
US7792745B2 (en) 2000-02-25 2010-09-07 Ipass Inc. Method and system to facilitate financial settlement of service access transactions between multiple parties
US20010034693A1 (en) * 2000-02-25 2001-10-25 Jay Farhat Method and system to broker a service access transaction
GB0011171D0 (en) * 2000-05-10 2000-06-28 Hewlett Packard Co Method and system for operating a communications infrastructure on a pre-payment basis
US7996310B1 (en) * 2000-07-19 2011-08-09 Globys, Inc. Electronic financial management and analysis system and related methods
US7072639B2 (en) * 2000-09-07 2006-07-04 Trag Wireless, Inc. System and method for determining optimal wireless communication service plans based on historical projection analysis
US6574465B2 (en) 2000-09-07 2003-06-03 Traq Wireless, Inc. System and method for determining optimal wireless communication service plans
US7664484B2 (en) * 2000-09-07 2010-02-16 Tangoe, Inc. Pooling groups of wireless communication users
US6681106B2 (en) 2000-09-07 2004-01-20 Traq Wireless, Inc. System and method for analyzing wireless communication records and for determining optimal wireless communication service plans
US7184749B2 (en) * 2000-09-07 2007-02-27 Traq Wireless, Inc. System and method for analyzing wireless communication data
US6813488B2 (en) 2000-09-07 2004-11-02 Traq Wireless, Inc. System and method for determining optimal wireless communication service plans based on spectrum licenses
US7761083B2 (en) * 2000-09-07 2010-07-20 William Marsh Providing a rebate to a user of a telecommunication plan
US20020154751A1 (en) * 2000-10-18 2002-10-24 Thompson Richard H. Method for managing wireless communication device use including optimizing rate and service plan selection
US7827097B2 (en) * 2000-10-19 2010-11-02 Peter K. Trzyna System for transferring an inbond communication to one of a plurality of credit-counseling agencies
DE10058064A1 (en) * 2000-11-23 2002-06-06 Viag Interkom Gmbh & Co Communication system and method for operating a communication system
US7412412B2 (en) * 2001-02-12 2008-08-12 Avotus Inc. Network reverse auction and spending analysis methods
US8380840B2 (en) * 2001-12-17 2013-02-19 Verizon Business Global Llc Method for recording events in an IP network
US7945592B2 (en) * 2001-03-20 2011-05-17 Verizon Business Global Llc XML based transaction detail records
US7406306B2 (en) * 2001-03-20 2008-07-29 Verizon Business Global Llc Method for billing in a telecommunications network
US20030078019A1 (en) * 2001-10-24 2003-04-24 Motorola, Inc. Method of brokering wireless services
US20030200135A1 (en) * 2002-04-19 2003-10-23 Wright Christine Ellen System and method for predicting and preventing customer churn
US6925160B1 (en) * 2002-08-21 2005-08-02 Mobilesense Technologies, Inc. System and method for managing cellular telephone accounts
US7486944B2 (en) * 2002-10-02 2009-02-03 The Bill Police Llc Method for managing wireless telecommunications bills
US20050246277A1 (en) * 2002-10-23 2005-11-03 Bloem Nicolaas C Transaction processing system
US7487140B2 (en) * 2002-12-17 2009-02-03 International Business Machines Corporation Method for executing a query having multiple distinct key columns
ES2262945T3 (en) * 2003-02-21 2006-12-01 Swisscom Mobile Ag PROCEDURE AND SYSTEM TO BLOCK AND UNLOCK A FINANCIAL ACCOUNT ASSOCIATED WITH A SIM CARD.
JP4629482B2 (en) * 2005-04-13 2011-02-09 大日本印刷株式会社 Mobile communication terminal, IC card, mobile communication system, program, and communication charge notification method
US20060246899A1 (en) 2005-04-28 2006-11-02 Research In Motion Limited System and method for providing network advertisement information via a network advertisement broker (NAB)
US8060084B2 (en) 2005-04-28 2011-11-15 Research In Motion Limited Network selection scheme using a roaming broker (RB)
US8428584B2 (en) 2005-07-01 2013-04-23 Research In Motion Limited System and method for accelerating network selection by a wireless user equipment (UE) device
EP1858278B1 (en) 2006-05-19 2013-05-15 Research In Motion Limited System and method for facilitating accelerated network selection in a radio network enviroment
US8010105B2 (en) 2006-05-19 2011-08-30 Research In Motion Limited System and method for facilitating accelerated network selection using a weighted network list
US20080172240A1 (en) * 2007-01-17 2008-07-17 Wolfgang Klotzki Method For Optimizing a Fee Tariff System For a User of a Telecommunication System
US8666849B2 (en) 2007-05-04 2014-03-04 Validas, Llc Computer implemented method for bill analysis over the internet
US7904354B2 (en) * 2007-05-04 2011-03-08 Validas, Llc Web based auto bill analysis method
US8150006B2 (en) * 2007-11-08 2012-04-03 At&T Intellectual Property I, L.P. Method and apparatus for performing call correlation across network elements
CA2677534C (en) * 2008-09-05 2019-03-05 Accenture Global Services Gmbh Tariff management test automation
AU2012241129B2 (en) * 2008-09-05 2015-07-02 Accenture Global Services Limited Tariff management test automation
US8566197B2 (en) 2009-01-21 2013-10-22 Truaxis, Inc. System and method for providing socially enabled rewards through a user financial instrument
US8600857B2 (en) 2009-01-21 2013-12-03 Truaxis, Inc. System and method for providing a savings opportunity in association with a financial account
US10504126B2 (en) 2009-01-21 2019-12-10 Truaxis, Llc System and method of obtaining merchant sales information for marketing or sales teams
US10594870B2 (en) 2009-01-21 2020-03-17 Truaxis, Llc System and method for matching a savings opportunity using census data
US20100185489A1 (en) * 2009-01-21 2010-07-22 Satyavolu Ramakrishna V Method for determining a personalized true cost of service offerings
US8238538B2 (en) 2009-05-28 2012-08-07 Comcast Cable Communications, Llc Stateful home phone service
US8958770B2 (en) * 2009-10-12 2015-02-17 At&T Mobility Ii Llc Dynamic usage inequity detection and/or remedy
US8346212B2 (en) 2010-04-08 2013-01-01 James Breitzman Resource and utilization management of telecommunication devices
US8738482B2 (en) * 2010-12-02 2014-05-27 Telefonica, S.A. Method for preparing an optimal alternative billing plan for mobile telephony users managed through a call center
US20150201437A1 (en) * 2014-01-13 2015-07-16 Vonage Network, Llc Systems and methods for reducing signaling in an internet protocol telephony system
US9787534B1 (en) 2015-01-15 2017-10-10 Amdocs Software Systems Limited System, method, and computer program for generating event tests associated with a testing project
KR20180004156A (en) 2015-05-07 2018-01-10 어펌드 네트웍스, 인크. METHOD AND SYSTEM FOR CREATING TELEPHONE DETAILS RECORD OF A BILLING SYSTEM
US10924520B2 (en) 2016-12-13 2021-02-16 Microsoft Technology Licensing, Llc Online charging mechanisms during OCS non-responsiveness
JP7132239B2 (en) 2016-12-13 2022-09-06 マイクロソフト テクノロジー ライセンシング，エルエルシー Machine-to-machine network optimization and online billing

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4640986A (en) * 1983-09-16 1987-02-03 Nec Corporation Mobile radio communication system

Also Published As

Publication number Publication date
IL97016A0 (en) 1992-03-29
US5027388A (en) 1991-06-25
GB2246051A (en) 1992-01-15
GB9102170D0 (en) 1991-03-20
MX171385B (en) 1993-10-21
IL97016A (en) 1994-02-27
US4979207A (en) 1990-12-18
CA2034600A1 (en) 1991-08-02

Similar Documents

Publication Publication Date Title
CA2034600C (en) Method of processing cellular telephone call detail data for billing multi-line customers for cellular telephone services
US5659601A (en) Method of selecting a cost effective service plan
US5325290A (en) Billing system with data indexing
US6173171B1 (en) Method and apparatus for generating billing data in a telecommunication system
US5551025A (en) Relational database system for storing different types of data
CN101216821B (en) Data acquisition system storage management method
US8059802B2 (en) Billing data interface for conferencing customers
US6876731B2 (en) System and method for managing CDR information
EP2357857B1 (en) Method and apparatus for generating phone bill
JPH10507329A (en) Apparatus and method for reproducing and reporting PBX data
JP2004070445A (en) Batch type billing method and system using distributed processing
CN101087203A (en) A statistical method of high magnitude of data
CN101141754A (en) Value-added service analysis and method thereof
CA2177967A1 (en) A method and device for extracting data from a group of data
CN111813866B (en) Improved block chain account book synchronization method
CN101431760B (en) Method and system for implementing business report
CA2043500C (en) Method of selecting the most cost effective cellular service plan provided by cellular telephone resellers to multi-line customers
CN109359132A (en) A kind of method of data processing, device and system
CN108428009A (en) A kind of channel distribution method and device
CN113570444A (en) Non-tax payment report processing method and query system based on non-tax payment book
Jukić et al. The use of call detail records and data mart dimensioning for telecommunication companies
US20020029198A1 (en) Flexible information and business logic software engine
EP1104632B1 (en) Method and system for the management of subscriber functions
Lane et al. Software Package Review
CN113807822A (en) Standing book management method and system for basic level management

Legal Events

Date Code Title Description
EEER Examination request
MKEX Expiry
MKEX Expiry

Effective date: 20110118