Configuring systems for generating business transaction reports using processing relationships among entities of an organization
First Claim
1. A method performed in a financial service organization (FSO) computer system, wherein an FSO comprises a plurality of FSO entities, wherein each of the FSO entities performs one or more transactions, wherein each transaction comprises data, wherein the FSO computer system comprises a model of the FSO stored in a database, the model:
- comprising the FSO entities configured in a tree structure, wherein the tree structure comprises one or more branches, wherein each of the tree branches comprises one or more FSO entities of the FSO entities, and wherein at least one of the FSO entities on at least one of the tree branches reports to a first one of the FSO entities higher on the tree branch, the method comprising;
a) accessing a transaction from a database of a plurality of transactions;
b) reading a processing relationship object associated with the accessed transaction from a database, wherein the processing relationship object describes a location of one or more processing parameter values for the accessed transaction;
c) reading one or more processing parameter values associated with the transaction described in the processing relationship object;
d) transferring the one or more processing parameter values to a report record;
e) reading a report data definition from the database of a plurality of transactions from a), wherein the report data definition describes a location of data in the accessed transaction;
f) transferring the data to the report;
repeating a) through f) until each of the plurality of transactions has been accessed and the associated processing parameters placed in a report record, wherein one report record is created for each transaction, and wherein each of the report records are stored in a report record file;
sorting report records such that report records comprising FSO identifying processing parameter values of the one or more FSO entities below other FSO entities on the tree branch appear in the sorted report record file before report records associated with FSO entities that are higher on the tree branch;
g) identifying a current report record and reading the current report record from the sorted report record file;
h) identifying the FSO associated with the current report record, wherein the identified FSO is designated as the current FSO entity;
i) writing data from the current report record to a summary report for the current FSO entity;
j) reading a next report record of the sorted report record;
k) comparing the FSO entity associated with the next report record to the current FSO entity;
l) writing data from the next report record to a summary report for the current FSO entity if the FSO entity of the next report is the same as the current FSO entity;
m) creating a new summary report in response to the FSO entity of the next report record not being equal to the current FSO entity; and
writing data from the current report record to a summary report for the FSO entity associated with the next report record;
n) designating the FSO entity associated with the next report record as the current FSO entity;
repeating g) through n) until all of the report records in the report record file have been read.
1 Assignment
0 Petitions
Accused Products
Abstract
Business data (including transactional data) may be gathered, stored, sorted, and/or collated into financial service organization (FSO) reports used by various entities of a FSO. A processing relationship configuration program may be used to create a processing relationship structure between various entities of the FSO. Processing relationship structure information may be stored on a database of an FSO. Nodes may be created and uniquely defined to represent FSO physical entities and/or FSO functions. A nodes structure may correspond to the processing relationship structure within an FSO. In some embodiments, an FSO application program, such as a report program, may be generated based on a defined processing relationship structure. The report records may be arranged in a particular sequence by one or more of the break key fields. Changes to the processing relationship structure may be automatically reflected in the reports generated by the report program.
153 Citations
39 Claims
-
1. A method performed in a financial service organization (FSO) computer system, wherein an FSO comprises a plurality of FSO entities, wherein each of the FSO entities performs one or more transactions, wherein each transaction comprises data, wherein the FSO computer system comprises a model of the FSO stored in a database, the model:
- comprising the FSO entities configured in a tree structure, wherein the tree structure comprises one or more branches, wherein each of the tree branches comprises one or more FSO entities of the FSO entities, and wherein at least one of the FSO entities on at least one of the tree branches reports to a first one of the FSO entities higher on the tree branch, the method comprising;
a) accessing a transaction from a database of a plurality of transactions;
b) reading a processing relationship object associated with the accessed transaction from a database, wherein the processing relationship object describes a location of one or more processing parameter values for the accessed transaction;
c) reading one or more processing parameter values associated with the transaction described in the processing relationship object;
d) transferring the one or more processing parameter values to a report record;
e) reading a report data definition from the database of a plurality of transactions from a), wherein the report data definition describes a location of data in the accessed transaction;
f) transferring the data to the report;
repeating a) through f) until each of the plurality of transactions has been accessed and the associated processing parameters placed in a report record, wherein one report record is created for each transaction, and wherein each of the report records are stored in a report record file;
sorting report records such that report records comprising FSO identifying processing parameter values of the one or more FSO entities below other FSO entities on the tree branch appear in the sorted report record file before report records associated with FSO entities that are higher on the tree branch;
g) identifying a current report record and reading the current report record from the sorted report record file;
h) identifying the FSO associated with the current report record, wherein the identified FSO is designated as the current FSO entity;
i) writing data from the current report record to a summary report for the current FSO entity;
j) reading a next report record of the sorted report record;
k) comparing the FSO entity associated with the next report record to the current FSO entity;
l) writing data from the next report record to a summary report for the current FSO entity if the FSO entity of the next report is the same as the current FSO entity;
m) creating a new summary report in response to the FSO entity of the next report record not being equal to the current FSO entity; and
writing data from the current report record to a summary report for the FSO entity associated with the next report record;
n) designating the FSO entity associated with the next report record as the current FSO entity;
repeating g) through n) until all of the report records in the report record file have been read. - View Dependent Claims (2, 3, 4, 6, 7, 8, 9, 10, 11, 12, 13, 14)
- comprising the FSO entities configured in a tree structure, wherein the tree structure comprises one or more branches, wherein each of the tree branches comprises one or more FSO entities of the FSO entities, and wherein at least one of the FSO entities on at least one of the tree branches reports to a first one of the FSO entities higher on the tree branch, the method comprising;
-
5. The method of claim, wherein at least one of the processing parameter values is defined by a user of the FSO computer system.
-
15. A system for processing financial service organization (FSO) transactions, the system comprising:
-
a computer system, wherein the FSO comprises a plurality of FSO entities, wherein each of the FSO entities performs one or more transactions, wherein each transaction comprises data, wherein the FSO computer system comprises a model of the FSO stored in a database, the model comprising the FSO entities configured in a tree structure, wherein the tree structure comprises one or more branches, wherein each of the tree branches comprises one or more FSO entities of the FSO entities, and wherein at least one of the FSO entities on at least one of the tree branches reports to a first one of the FSO entities higher on the tree branch, a computer program, wherein the computer program is executable on the computer system to execute;
a) accessing a transaction from a database of a plurality of transactions;
b) reading a processing relationship object associated with the accessed transaction from a database, wherein the processing relationship object describes a location of one or more processing parameter values for the accessed transaction;
c) reading one or more processing parameter values associated with the transaction described in the processing relationship object;
d) transferring the one or more processing parameter values to a report record;
e) reading a report data definition from the database of a plurality of transactions from a), wherein the report data definition describes a location of data in the accessed transaction;
f) transferring the data to the report record;
repeating a) through f) until each of the plurality of transactions has been accessed and the associated processing parameters placed in a report record, wherein one report record is created for each transaction, and wherein each of the report records are stored in a report record file;
sorting report records such that report records comprising FSO identifying processing parameter values of the one or more FSO entities below other FSO entities on the tree branch appear in the sorted report record file before report records associated with FSO entities that are higher on the tree branch;
g) identifying a current report record and reading the current report record from the sorted report record file;
h) identifying the FSO associated with the current report record, wherein the identified FSO is designated as the current FSO entity, i) writing data from the current report record to a summary report for the current FSO entity;
j) reading a next report record of the sorted report record;
k) comparing the FSO entity associated with the next report record to the current FSO entity;
l) writing data from the next report record to a summary report for the current FSO entity if the FSO entity of the next report is the same as the current FSO entity, m) creating a new summary report in response to the FSO entity of the next report record not being equal to the current FSO entity; and
writing data from the current report record to a summary report for the FSO entity associated with the next report record;
n) designating the FSO entity associated with the next report record as the current FSO entity;
repeating g) through n) until all of the report records in the report record file have been read. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28)
-
-
29. A recordable medium comprising program instructions for a financial system organization (FSO), wherein a model of the FSO stored in a database, the model comprising the FSO entities configured in a tree structure, wherein the tree structure comprises one or more branches, wherein each tree branch comprises one or more FSO entities of the FSO entities, wherein the at least one of the FSO entities on at least one of the tree branches reports to a first one of the FSO entities higher on the tree branch, and wherein the FSO entities perform one or more transactions, wherein each of the transactions comprise data and wherein the program instructions are executable by the FSO computer system to implement:
-
a) accessing a transaction from a database of a plurality of transactions;
b) reading a processing relationship object associated with the accessed transaction from a database, wherein the processing relationship object describes a location of one or more processing parameter values for the accessed transaction;
c) reading one or more processing parameter values associated with the transaction described in the processing relationship object;
d) transferring the one or more processing parameter values to a report record;
e) reading a report data definition from the database of a plurality of transactions from a), wherein the report data definition describes a location of data in the accessed transaction;
f) transferring the data to the report record;
repeating a) through f) until each of the plurality of transactions has been accessed and the associated processing parameters placed in a report record, wherein one report record is created for each transaction, and wherein each of the report records are stored in a report record file;
sorting report records such that report records comprising FSO identifying processing parameter values of the one or more FSO entities below other FSO entities on the tree branch appear in the sorted report record file before report records associated with FSO entities that are higher on the tree branch;
g) identifying a current report record and reading the current report record from the sorted report record file;
h) identifying the FSO associated with the current report record, wherein the identified FSO is designated as the current FSO entity;
i) writing data from the current report record to a summary report for the current FSO entity;
j) reading a next report record of the sorted report record;
k) comparing the FSO entity associated with the next report record to the current FSO entity;
l) writing data from the next report record to a summary report for the current FSO entity if the FSO entity of the next report is the same as the current FSO entity;
m) creating a new summary report in response to the FSO entity of the next report record not being equal to the current FSO entity, and writing data from the current report record to a summary report for the FSO entity associated with the next report record, n) designating the FSO entity associated with the next report record as the current FSO entity;
repeating g) through n) until all of the report records in the report record file have been read. - View Dependent Claims (30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
Specification