Collection system database architecture

• US 20030187826A1
• Filed: 11/12/2002
• Published: 10/02/2003
• Est. Priority Date: 03/28/2002
• Status: Abandoned Application

• Current Assignee: Ontario Systems, LLC
• Original Assignee: Ontario Corporation
• Inventors: Read, Doug, Couch, Ken, Kennedy, Amy
• Application Number:
  US10/292,794
• Publication Number:
  US 20030187826A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/288 Entity relationship models
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A data model for an automated collection system. In an embodiment of the data model of the present invention represent an account is represented by a record in a first data structure, one or more accountholders each is represented by a record in a second data structure, and a third data structure is provided to contain records representing the connection or relationship between the accountholder and the account.

Claims

1. A method of implementing a debt collection process using a computer having a memory, the method comprising the steps of:

providing a first data structure in said memory, said first data structure comprising an account record, said account record comprising information about a debt;

providing a second data structure in said memory, said second data structure comprising at least one accountholder record, each said at least one accountholder record comprising information about a debtor that may be obligated to pay said debt;

providing a third data structure in said memory; and

processing said account information to create, in said third data structure, an account management record, said account management record comprising information related to said account record.

2. The method of claim 1, further comprising the step of:

processing said accountholder information and said account information to link said accountholder information to said account information in said third data structure, said third data structure thereafter comprising relationship data about one or more relationships between said account record and said at least one accountholder records.

3. The method of claim 2, wherein said processing step comprises the step of:

creating, in said third data structure, an account/accountholder record, said account/accountholder record comprising information related to said account record and one of said at least one accountholder records.

4. The method of claim 1, wherein said debt is a healthcare debt for which a healthcare insurance payer may be obligated to pay pursuant to a healthcare insurance plan, and wherein said second data structure comprises at least one accountholder record comprising information about said healthcare insurance payer, the method further comprising the steps of:

providing a fourth data structure in said memory, said fourth data structure comprising at least one healthcare insurance plan record comprising information about said healthcare insurance plan; and

processing said healthcare insurance plan information, said accountholder information about said healthcare insurance payer, and said account information to link said healthcare insurance plan information, said accountholder information about said healthcare insurance payer, and said account information in said third data structure, said third data structure thereafter comprising relationship data about one or more relationships between said account record, said at least one accountholder record comprising information about said healthcare insurance payer, and said at least one healthcare insurance plan record.

5. The method of claim 4, wherein said processing step comprises the step of:

creating, in said third data structure, a healthcare insurance claim record, said healthcare insurance claim record comprising information related to said account record, one of said at least one accountholder record comprising information about said healthcare insurance payer, and one of said at least one healthcare insurance plan records.

6. The method of claim 1, further comprising the steps of:

providing a fourth data structure in said memory, said fourth data structure comprising at least one legal case record, each said at least one legal case record comprising information about a collection lawsuit initiated for the purpose of collecting said debt, wherein at least one of said at least one accountholders is identified as a defendant in said collection lawsuit; and

processing said collection lawsuit information, said accountholder information, and said account information to link said collection lawsuit information, said accountholder information, and said account information in said third data structure, said third data structure thereafter comprising relationship data about one or more relationships between said account record, said at least one accountholder records, and said at least one legal case records.

7. The method of claim 6, wherein said processing step comprises the step of:

creating, in said third data structure, a legal case work record, said legal case work record comprising information related to said account record, one of said at least one accountholder records, and one of said at least one legal case records.

8. The method of claim 1, further comprising the step of:

assigning an account management workflow to said account management record, said account management workflow comprising information pertaining to at least one account management workflow phase, wherein each said at least one account management workflow phase is reflective of a possible step in said debt collection process, and wherein said account management workflow phase comprises an account management workflow phase variable that is capable of being assigned a value, said value assigned to said account management workflow phase variable being indicative of one of said at least one account management workflow phases.

9. The method of claim 8, where said account management record comprises a first work record, the method further comprising the step of:

creating a second work record in said third data structure, said second work record being created upon said account management workflow phase variable being assigned a value that is equal to a predetermined value.

10. The method of claim 8, where said account management record comprises a first work record, the method further comprising the step of:

deleting a second work record in said third data structure, said second work record being deleted upon said account management workflow phase variable being assigned a value that is equal to a predetermined value.

11. The method of claim 8, where said account management record comprises a first work record, the method further comprising the steps of:

providing a second work record in said third data structure, said second work record comprising data; and

changing said data of said second work record upon said account management workflow phase variable being assigned a value that is equal to a predetermined value.

12. The method of claim 1, wherein said third data structure comprises a plurality of work records, the method further comprising the steps of:

assigning a work record workflow to one of said plurality of work records, said work record workflow comprising information pertaining to at least one work record workflow phase, wherein each said at least one work record workflow phase is reflective of a possible step in said debt collection process, and wherein said work record workflow phase comprises a phase variable that is capable of being assigned a value, said value assigned to said phase variable being indicative of one of said at least one work record workflow phases; and

recording an event in said third data structure, wherein said recordation automatically changes the value of said phase variable.

13. The method of claim 1, wherein said third data structure comprises a plurality of work records, the method further comprising the steps of:

assigning a first work record workflow to a first of said plurality of work records, said first work record workflow comprising information pertaining to at least one first work record workflow phase, wherein each said at least one first work record workflow phase is reflective of a possible step in said debt collection process, and wherein said first work record workflow phase comprises a first work record workflow phase variable that is capable of being assigned a value, said value assigned to said first work record workflow phase variable being indicative of one of said at least one first work record workflow phases;

assigning a second work record workflow to a second of said plurality of work records, said second work record workflow comprising information pertaining to at least one second work record workflow phase, wherein each said at least one second work record workflow phase is reflective of a possible step in said debt collection process, and wherein said second work record workflow phase comprises a second work record workflow phase variable that is capable of being assigned a value, said value assigned to said second work record workflow phase variable being indicative of one of said at least one second work record workflow phases; and

changing said value of said first work record workflow phase variable, wherein said change in said value of said first work record workflow phase variable automatically causes a change in said value of said second work record workflow phase variable.

14. The method of claim 1, wherein said third data structure comprises a plurality of work records, the method further comprising the steps of:

assigning a work record workflow to one of said plurality of work records, said work record workflow comprising information pertaining to at least one work record workflow phase, wherein each said at least one work record workflow phase is reflective of a possible step in said debt collection process, and wherein said work record workflow phase comprises a phase variable that is capable of being assigned a value, said value assigned to said phase variable being indicative of one of said at least one work record workflow phases; and

changing said value of said phase variable, wherein said change in said phase variable value causes an action to be performed.

15. The method of claim 1, wherein said third data structure comprises a plurality of work records, the method further comprising the steps of:

assigning a work record workflow to one of said plurality of work records, said work record workflow comprising information pertaining to at least one work record workflow phase, wherein each said at least one work record workflow phase is reflective of a possible step in said debt collection process, and wherein said work record workflow phase comprises a phase variable that is capable of being assigned a value, said value assigned to said phase variable being indicative of one of said at least one work record workflow phases; and

changing said value of said phase variable, wherein said change in said phase variable value causes an action to be scheduled for future performance.

16. The method of claim 1, further comprising the step of:

recording an event in said third data structure, wherein said recordation automatically causes the creation of a work record.

17. The method of claim 1, further comprising the step of:

recording an event in said third data structure, wherein said recordation automatically causes an action to be performed.

18. The method of claim 1, further comprising the step of:

recording an event in said third data structure, wherein said recordation automatically causes an action to be scheduled for future performance.

19. An automated collection system comprising:

a computer having a memory;

a first data structure resident on said memory comprising account information about a debt;

a second data structure resident on said memory comprising accountholder information about at least one debtor that may be obligated to pay said debt;

a third data structure resident on said memory; and

processing structure capable of creating, in third data structure, an account management record, said account management record comprising information related to said account information.

20. The automated collection system of claim 19, further comprising:

processing structure capable of creating, in said third data structure, an account/accountholder record, said account/accountholder record comprising information about a relationship between said account information and said accountholder information about one of said debtors.

21. The automated collection system of claim 19, wherein said debt comprises a healthcare debt, and wherein at least one of said at least one debtors is a healthcare insurance payer that is obligated to pay said healthcare debt pursuant to a healthcare insurance plan, said system further comprising:

a fourth data structure resident on said memory, said fourth data structure comprising at least one healthcare insurance plan record comprising information about said healthcare insurance plan; and

processing structure capable of creating, in said third data structure, a healthcare insurance claim record, said healthcare insurance claim record comprising information about a relationship between said account information, accountholder information about one of said healthcare insurance payers, and said healthcare insurance plan information.

22. The automated collection system of claim 19, further comprising:

a fourth data structure resident in said memory, said fourth data structure comprising at least one legal case record, each said at least one legal case record comprising information about a collection lawsuit initiated for the purpose of collecting said debt, wherein at least one of said at least one debtors is identified as a defendant in said collection lawsuit; and

processing structure capable of creating, in said third data structure, a legal case work record, said legal case work record comprising information about a relationship between said account information, said accountholder information about one of said debtors, and said collection lawsuit information about one said collection lawsuit.