A flexible, modifiable, and sophisticated rules processing engine includes a user interface through which customers may design and modify a wide range of rules. The customer may thereby setup rules that determine any action, template, or other resultant appropriate to or for their input data. Consequently, the customer may develop sophisticated processing patterns tailored to their own input data, without the time and expense associated with obtaining a custom solution from a software vendor.
|
1. A method, comprising:
displaying a policy configuration interface comprising a policy set belonging to a policy group;
associating the policy group with a determinant group comprising data items from customer data; and
associating each policy within the policy group with a priority value and a resultant specifier, and selecting a highest possible priority value by evaluating the determinant group against input customer data or system internal data to specify a policy selection.
15. A system comprising:
a memory system; and
one or more processing cores coupled to the memory system and that are each configured to:
display a policy configuration interface comprising a policy set belonging to a policy group;
associate the policy group with a determinant group comprising data items from customer data; and
associate each policy within the policy group with a priority value and a resultant specifier, and selecting a highest possible priority value by evaluating the determinant group against input customer data or system internal data to specify a policy selection.
8. A computer program product embodied on a non-transitory computer readable medium, comprising:
computer code for displaying a policy configuration interface comprising a policy set belonging to a policy group;
computer code for associating the policy group with a determinant group comprising data items from customer data; and
computer code for associating each policy within the policy group with a priority value and a resultant specifier, and selecting a highest possible priority value by evaluating the determinant group against input customer data or system internal data to specify a policy selection.
3. The method of
4. The method of
5. The method of
6. The method of
7. The method of
9. The computer program product of
10. The computer program product of
11. The computer program product of
12. The computer program product of
13. The computer program product of
14. The computer program product of
16. The system of
17. The system of
18. The system of
19. The system of
20. The system of
|
1. Technical Field
The present invention relates to configuring evaluation rules applied to data in a data processing system. In particular, the present invention relates to a policy configuration user interface for designing rules applied to customer data to determine a resultant action, data presentation template, or other consequent consistent with input customer data.
2. Background Information
The technologies supporting automated data processing of customer data, driven by strong market demand, have matured rapidly and become quite powerful in a relatively short time period. As a result, processing system hardware is now powerful enough and fast enough to execute complex calculations on large volumes of customer data for a multitude of purposes. However, the rapid advances in processing system hardware tend to outpace corresponding advances in software.
As one example, past approaches to processing customer data (e.g., preparing invoices) generally relied upon inflexible hardcoded processing steps. While the software might have captured the desired processing steps at the time the software was written, its hardcoded nature made the software inflexible, and in some cases, unsuitable for the customer at a later date. With such software, the customer could only initiate changes, if at all, through an expensive, time consuming re-programming process that required a software vendor programmer to modify the software by hand to suit customer specifications.
Even when a customer was willing to incur the expense and delay, the modified software still had drawbacks. As an example, with every custom software release came the need for individuals to track, understand, and support the software. Consequently, custom software increased the costs for the software vendor as well as the customer, and led to a general lack of standardization that hampered efficient production, delivery, and support of the software.
A need has long existed for addressing the problems noted above and other previously experienced.
Methods and systems consistent with the invention provide a flexible, modifiable, and sophisticated rules processing engine for processing input data. The rules processing engine may apply a wide range of rules against customer input data in order to determine any action, template, or other resultant appropriate to or for the input data. As a result, the customer may develop sophisticated processing patterns, through a user interface, for example, that are tailored to their own input data, without intervention from the software vendor.
In one method consistent with the invention, a data processing system interfaces an operator to policy configuration processing performed by the data processing system. The method includes displaying a policy configuration interface showing a policy set belonging to a policy group, and accepting a policy selection of a policy from the policy set. In addition, the method includes displaying a policy modification interface for the policy and accepting a policy modification directive through the policy modification interface for the policy. In response, the data processing system may then modify the policy in the policy group according to the policy modification.
A data processing system consistent with the invention includes a display, a memory, and a processor coupled to the memory. The memory holds a policy configuration user interface definition. The user interface definition specifies a policy configuration detail interface that includes a policy detail panel for displaying a policy set belonging to a policy group. The user interface definition may also include a policy configuration interface. The processor generates on the display a policy configuration interface according to the policy configuration interface definition.
The memory 104 stores data, for example the customer data 112, the internal data 114, and programs, for example the policy group evaluation program 116 and the policy configuration user interface definition 118. A ruleset user interface 120, described in more detail below, assists an operator to design policies for application to the customer data 112. The policy rule database 110 implements a data model for the rules engine, including, as examples, policy group definitions 122, policy definitions 124, and determinant definitions 126.
The elements illustrated in
Furthermore, although for discussion purposes specific components of the data processing system 100 will be described, methods, systems, and articles of manufacture consistent with the policy group rules engine may include additional or substitute different components. For example, the processor 102 may be a microprocessor, microcontroller, application specific integrated circuit (ASIC), discrete logic, or a combination of other types of circuits acting as explained below. Similarly, the memory 104 may be DRAM, SRAM, Flash or any other type of memory. The policy rule database 110 may be separately stored and managed, split into multiple databases, and generally logically and physically organized in many different ways. Furthermore, the policy rule database 110 may more generally represent data files searchable using techniques other than relational database queries, for example. The individual programs discussed below may be parts of a single program, separate programs, program libraries, or distributed across several memories and processors.
With regard to
Generally, however, a policy group may be established to process any data, including the system internal data 114. Thus, for example, the processing system 100 may make decisions concerning its own operation by applying a system policy group to the internal data 114. Such policy groups may determine, as examples, when to backup data, when to initiate system maintenance procedures, or any other system task appropriate to the data processing system 100.
For the discussion below, it is noted that the processor 102 generally operates under control of the policy group evaluation program 116. In other words, the processor 102 executes the instructions of the evaluation program 116 in order to proceed as noted below. In one implementation, the policy group evaluation program 116 is a Java™ program, although other programming languages may alternatively or additionally implement the evaluation program 116.
The policies 202 represent individual rules that are applied against the customer data 112. In the example shown in
The policy group 200 is associated with a determinant group 204. The determinant group 204 represents data items included in the customer data 112 and forms the basis for tests against the policies 202. As shown in
Each policy 202 may specify determinant values for zero or more determinants that characterize the policy group 200. For example, the Regular policy 210 includes a ‘REG’ determinant value for the Account Type determinant 218, a ‘REG’ determinant value for the Bill Request Type determinant 220, a ‘P’ determinant value for the Statement Type determinant 222, a ‘D’ determinant value for the Statement Summarization determinant 224, and a ‘BF’ determinant value for the Accounting Method determinant 226.
The determinant values may be one or more numeric, string, or other values. Examples are given next, and it is noted that the determinant values may vary according to any particular implementation desired. The determinant value for the Account Type determinant 218 may be ‘REG’ for a regular account. ‘MDU’ for a multiple dwelling unit account, or ‘SMA’ for a multiple delivery unit. The determinant value for the Bill Request Type determinant 220 may be ‘Final’ for a final billing statement, or ‘REG’ for a regular monthly billing statement. The determinant value for the Statement Type determinant 222 may be ‘P’ for a payable bill. ‘R’ for a reporting statement, or ‘I’ for an informational statement. The determinant value for the Statement Summarization determinant 224 may be ‘D’ for a detail billing statement, or ‘S’ for a summary billing statement. The determinant value for the Accounting Method determinant 226 may be ‘BF’ for a balance forward accounting method, or ‘Open’ for an open item accounting method.
In addition, each policy 202 may include a resultant specifier 208. For example, the Regular policy 210 includes the resultant specifier ‘25’ to indicate that billing template 25 should be used to bill the customer, if the Regular policy 210 evaluates to True. The resultant specifier 208 thereby indicates a resultant appropriate for the input data. The resultant specifier may take many forms, as examples, a data presentation template specifier (e.g., ‘25’), a processing action specifier (e.g., a function to call to process the customer data), or any other indicator of a resultant.
The resultant specifier may indicate a multi-valued resultant. Consequently, the resultant specifier may include two or more values consistent with the decision made by the policy. As one example, the resultant specifier may not only indicate a billing template for the customer, but may also indicate a special message to be printed as part of the bill. The resultant specifier may then take a multi-valued form (‘25’, ‘17’), for example, that would cause the processor 102 to print Message 17 (e.g., “Welcome, new customer.”) on a bill formatted according to Template 25.
When running bills for customer, the processor 102 selects the policy group 200 for application to the customer data. The processor 102 then evaluates the policies 202 until it finds a policy 202 that evaluates to True. By checking the value of the resultant specifier 208 in the policy that evaluated to True, the processor 102 identifies the resultant specifier (e.g., ‘25’) as indicative of the resultant (e.g., Template 25).
With regard to the example shown in
To that end, the processor 102 retrieves the customer data 112 for the customer currently being processed. Thus, starting with the Regular policy 210, the processor 102 determines if the customer data 112, as stored, indicates that the customer is set for ‘REG’ for the Account Type and ‘REG’ for the Bill Request Type and ‘P’ for the Statement Type and ‘D’ for Statement Summarization and ‘BF’ for Accounting Method. If so, the Regular policy 210 evaluates to True, and the processor 102 identifies the resultant specifier ‘25’ as indicative of the resultant appropriate (e.g., billing template 25) for the customer data.
If the Regular policy 210 evaluates to False, the processor 102 retrieves the next highest priority policy for evaluation. In this example, the processor 102 would next apply the Frequent policy 212 to the customer data, then the Policy A policy 214 to the customer data. Note that a policy 202 may specify a multiple determinate values for any single determinant. For example, the Policy A policy 214 specifies that the determinant values ‘MDU’ and ‘SMA’ for the Account Type determinant 218. In one implementation, the processor 102 may interpret multiple determinant values for a single determinant as a disjunctive determinant value. In doing so, the processor 102 tests whether the customer data for Account Type matches ‘MDU’ OR ‘SMA’. The Policy A policy 214 therefore evaluates to True when the customer data matches: ((AccountType=‘MDU’ OR AccountType=‘SMA’) AND BillRequestType=‘REG” AND StatementType=‘P’ AND StatementSummarization=‘D’ & AccountingMethod=‘Open’).
Finally, if none of the prior policies 202 evaluated to True, the processor 102 would apply the Default policy 216. The Default policy has the lowest priority and, like the other policies 202, includes a resultant specifier, in this case ‘1’. However, in one implementation, the Default policy always evaluates to True, so that the processor 102 may always determine a resultant for the customer data. To that end, the Default policy specifies an always True setting (in this case, an absence of a determinant value) for all of the determinants 204. As a result, the processor 102 interprets the Default policy 216 to match the customer data for each determinant, thereby rendering the Default policy 216 True in all cases.
In general, the policy rule database 110 may store policy group definitions for many decision tasks. As examples, the policy rule database 110 may include a policy group definition for determining how to handle a delinquent account, or how to process a refund. Each policy group may have its own determinant group and constituent policies.
An exemplary implementation of an Oracle™ database data model in the policy rule database 110 is presented below. The tables show how the policy groups, determinants, and other data may be defined and maintained in the policy rule database 110. Other implementations are also suitable, however, and may vary substantially from system to system.
Note that the Version fields shown below may be used in conjunction with concurrent access to the database. When a record is read, the version number is returned. Before changes are made to the record, the system may ensure that the version number is the same. If the version number is different, the system may re-read the record with locking enabled. Upon updating the record, the Version field may be incremented.
TABLE 1
OPERAND_GROUP_DEFINITION
Col. Seq
Column
Nulls
Type
10
OPERAND_GROUP_DEFINITION_ID
NOT NULL
NUMBER (18)
20
OPERAND_TYPE_ID
NOT NULL
NUMBER (18)
25
OPERAND_GROUP_ID
NOT NULL
NUMBER (18)
30
POLICY_GROUP_DEFINITION_ID
NULL
NUMBER (18)
40
CREATED_BY
NOT NULL
VARCHAR2 (30)
50
CREATED_TS
NOT NULL
TIMESTAMP ( )
55
VERSION
NULL
NUMBER (10)
60
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
70
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
80
IS_REQUIRED
NULL
NUMBER (1)
90
IS_SINGLED_VALUED
NULL
NUMBER (1)
Primary Key
Name
Column
OPGPDF_PK
OPERAND_GROUP_DEFINITION_ID
Foreign Keys
OPGPDF_POLGDF_FK01
POLICY_GROUP_DEFINITION_ID references
POLICY_GROUP_DEFINITION.POLICY_GROUP_DEFINITION_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
The OPERAND_GROUP_DEFINITION table defines how determinants or resultants are grouped for presentation on the user interface 120. For example, if the Policy Group Definition groups House Number and Street Name (two separate determinants) together for display and evaluation, a Group named ‘Street Address’ may be created and attached to the two determinants.
The OPERAND_GROUP_DEFINITION_ID field may provide a unique identifier for the Operand Group Definition. The OPERAND_TYPE_ID field may provide a code indicating whether this Operand Group Definition describes a Determinant or a Result. The OPERAND_GROUP_ID field may provide a code identifying the specific operand group, such as ‘Street Address’.
The POLICY_GROUP_DEFINITION_ID field may provide an identifier of a policy group definition. The CREATED_BY field may provide the ID of the user or application that created this record. The CREATED_TS field may provide the date/time that this record was created. The VERSION field may provide a sequential number used to identify historical changes to a particular bill request type configuration.
The LAST_MODIFIED_BY field may provide an identifier of an Application or User which last modified the bill request type configuration row. The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified. The IS_REQUIRED field may indicate whether or not this operand group is set up when a policy is established. The IS_SINGLED_VALUED field may indicate whether or not this operand group may be used multiple times when setting up a policy. Using the same result multiple times allows the customer to create an “and” condition between groups of the same type.
TABLE 2
POLICY_GROUP_DEFINITION
Col. Seq
Column
Nulls
Type
10
POLICY_GROUP_DEFINITION_ID
NOT NULL
NUMBER (18)
20
POLICY_GROUP_TYPE_ID
NOT NULL
NUMBER (18)
60
CREATED_BY
NOT NULL
VARCHAR2 (30)
65
CREATED_TS
NOT NULL
TIMESTAMP ( )
80
VERSION
NULL
NUMBER (10)
90
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
100
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
Primary Key
Name
Column
POLGDF_PK
POLICY_GROUP_DEFINITION_ID
The POLICY_GROUP_DEFINITION table contains the information that defines a particular set of policies. The POLICY_GROUP_DEFINITION table may establish, through an associated POLICY_OPERAND_DEFINITION table, the determinants and results that may be used to develop a policy within the given policy group. In one implementation, all customers may share the same Policy Group Definitions.
The POLICY_GROUP_DEFINITION_ID field may provide a unique identifier for the Policy Group Definition. The POLICY_GROUP_TYPE_ID field may provide a unique identifier for the Policy Group Type. The CREATED_BY field may provide the ID of the user or batch process that created the record.
The CREATED_TS field may provide the date the record was created by the application. The VERSION field may provide a sequential number used to identify historical changes to a particular bill request type configuration. The LAST_MODIFIED_BY field may provide an ID of the Application or User which last modified the bill request type configuration row. The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified.
TABLE 3
POLICY_OPERAND
Col. Seq
Column
Nulls
Type
10
POLICY_OPERAND_ID
NOT NULL
NUMBER (18)
11
RETAILER_POLICY_ID
NULL
NUMBER (18)
12
OPERAND_TYPE_ID
NOT NULL
NUMBER (18)
15
OPERAND_ID
NOT NULL
NUMBER (18)
40
OPERAND_DATA_TYPE_ID
NOT NULL
NUMBER (18)
50
CREATED_BY
NOT NULL
VARCHAR2 (30)
60
CREATED_TS
NOT NULL
TIMESTAMP ( )
61
VERSION
NULL
NUMBER (10)
63
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
66
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
86
POLICY_OPERAND_GROUP_ID
NULL
NUMBER (18)
100
DSP_ORDER_SEQ_NUMBER
NOT NULL
NUMBER (10)
Primary Key
Name
Column
POLOPR_PK
POLICY_OPERAND_ID
Foreign Keys
POLOPR_POPGRP_FK01
POLICY_OPERAND_GROUP_ID references
POLICY_OPERAND_GROUP.POLICY_OPERAND_GROUP_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
No
Delete Rule:
Restricted
POLOPR_RETPOL_FK01
RETAILER_POLICY_ID references RETAILER_POLICY.RETAILER_POLICY_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
The POLICY_OPERAND table defines a single determinant or result for the customer's policy. If the same operand is participating both singly and in a group, it may have two retailer policy operand instances to separately define the values associated with the operand in each of its roles.
The POLICY_OPERAND_ID field may provide a unique identifier for the retailer policy operand. The RETAILER_POLICY_ID field may provide a unique ID for the policy. The OPERAND_TYPE_ID field may provide a code that indicates whether this Policy Operand Definition describes a Determinant or a Result.
The OPERAND_ID field may provide a code that identifies the specific result field, such as ‘Account Balance’. The OPERAND_DATA_TYPE_ID field may provide a code that identifies the data type of the result field, such as ‘String’. The CREATED_BY field may provide the ID of the user that created this record.
The CREATED_TS field may provide the date/time that this record was created. The VERSION field may provide a sequential number that identifies historical changes to a particular bill request type configuration. The LAST_MODIFIED_BY field may provide an ID of the Application or User which last modified the bill request type configuration row.
The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified. The POLICY_OPERAND_GROUP_ID field may provide a unique identifier for the retailer policy operand group. The DSP_ORDER_SEQ_NUMBER field may provide the order in which this item will be displayed.
TABLE 4
POLICY_OPERAND_DEFINITION
Col. Seq
Column
Nulls
Type
10
POLICY_OPERAND_DEFINITION_ID
NOT NULL
NUMBER (18)
20
OPERAND_TYPE_ID
NOT NULL
NUMBER (18)
30
OPERAND_ID
NOT NULL
NUMBER (18)
40
OPERAND_DATA_TYPE_ID
NOT NULL
NUMBER (18)
50
POLICY_GROUP_DEFINITION_ID
NULL
NUMBER (18)
60
VALID_OPERATOR_ID_LIST
NOT NULL
VARCHAR2 (200)
70
CREATED_BY
NOT NULL
VARCHAR2 (30)
80
CREATED_TS
NOT NULL
TIMESTAMP ( )
90
VERSION
NULL
NUMBER (10)
100
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
110
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
130
OPERAND_GROUP_DEFINITION_ID
NULL
NUMBER (18)
140
OPERAND_DATA_TYPE_CATEGORY_ID
NULL
NUMBER (18)
150
IS_REQUIRED
NULL
NUMBER (1)
160
IS_SINGLED_VALUED
NULL
NUMBER (1)
170
OPERAND_SIZE
NULL
NUMBER (10)
Primary Key
Name
Column
POLOPD_PK
POLICY_OPERAND_DEFINITION_ID
Foreign Keys
POLOPD_OPGPDF_FK01
OPERAND_GROUP_DEFINITION_ID references
OPERAND_GROUP_DEFINITION.OPERAND_GROUP_DEFINITION_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
No
Delete Rule:
Restricted
POLOPD_POLGDF_FK01
POLICY_GROUP_DEFINITION_ID references
POLICY_GROUP_DEFINITION.POLICY_GROUP_DEFINITION_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
Index Summary
Name Seq.
Column Index
Type
POLOPD_UK01_INDX
5 POLICY_GROUP_DEFINITION_ID
UNIQUE
POLOPD_UK01_INDX
10 OPERAND_ID
UNIQUE
The POLICY_OPERAND_DEFINITION table defines the determinants and results that may be used when creating a policy for a given policy group. Each determinant definition may reference a list of one or more valid operators to be used with that determinant. Each resultant definition may reference the “=” operator.
The POLICY_OPERAND_DEFINITION_ID field may provide a unique number referencing a particular determinant or result definition. The OPERAND_TYPE_ID field may provide a code used to indicate whether this Policy Operand Definition describes a Determinant or a Result. The OPERAND_ID field may provide a code that identifies the specific result field, such as ‘Account Balance’.
The OPERAND_DATA_TYPE_ID field may provide a code that identifies the data type of the result field, such as ‘String’. The POLICY_GROUP_DEFINITION_ID may provide a unique number that references, in one implementation, one and only one Policy Group Definition. The VALID_OPERATOR_ID_LIST may provide a comma delimited list of Operator IDs referencing the Operators (e.g., “=”, “<”, “>”, and other operators) that are valid for the operand.
The CREATED_BY field may provide the ID of the user that created this record. The CREATED_TS field may provide the date/time that this record was created. The VERSION field may provide a sequential number used to identify historical changes to a particular bill request type configuration. The LAST_MODIFIED_BY field may provide an ID of the Application or User which last modified the bill request type configuration row.
The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified. The OPERAND_GROUP_DEFINITION_ID field may provide a unique identifier for the Operand Group Definition. The OPERAND_DATA_TYPE_CATEGORY_ID field may provide a code that may be used to provide a list of valid values for this result for viewing and validating through the user interface 120.
The IS_REQUIRED field may indicate whether or not the operand is required. The IS_SINGLED_VALUED field may provide a flag indicating whether the result consists of one or multiple values. The OPERAND_SIZE field may provide a field length of either the “RESULT” or “DETERMINANT” operand.
TABLE 5
POLICY_OPERAND_DSP_ORDER
Col. Seq
Column
Nulls
Type
10
POLICY_OPERAND_DSP_ORDER_ID
NOT NULL
NUMBER (18)
15
POLICY_GROUP_DEFINITION_ID
NULL
NUMBER (18)
20
OPERAND_TYPE_ID
NOT NULL
NUMBER (18)
20
SEQUENCE_NUMBER
NOT NULL
NUMBER (10)
30
POLICY_OPERAND_DEFINITION_ID
NOT NULL
NUMBER (18)
40
OPERAND_GROUP_DEFINITION_ID
NULL
NUMBER (18)
50
CREATED_BY
NOT NULL
VARCHAR2 (30)
60
CREATED_TS
NOT NULL
TIMESTAMP ( )
61
VERSION
NULL
NUMBER (10)
63
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
66
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
Primary Key
Name
Column
OPDODR_PK
POLICY_OPERAND_DSP_ORDER_ID
Foreign Keys
OPDODR_OPGPDF_FK01
OPERAND_GROUP_DEFINITION_ID references
OPERAND_GROUP_DEFINITION.OPERAND_GROUP_DEFINITION_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
No
Delete Rule:
Restricted
OPDODR_POLGDF_FK01
POLICY_GROUP_DEFINITION_ID references
POLICY_GROUP_DEFINITION.POLICY_GROUP_DEFINITION_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
OPDODR_POLOPD_FK01
POLICY_OPERAND_DEFINITION_ID references
POLICY_OPERAND_DEFINITION.POLICY_OPERAND_DEFINITION_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
The Policy Operand Display Order data object may be used by the user interface 120 to determine what order results or determinants will appear on the display 108. When a group is defined, the operand ID may define the sequence of an operand within the group.
The POLICY_OPERAND_DSP_ORDER_ID field may provide a unique identifier for the Policy Operand Display Order item. The POLICY_GROUP_DEFINITION_ID field may provide a unique identifier for the Policy Group Definition. The OPERAND_TYPE_ID field may provide a code that indicates whether this Operand Display Order item describes a Determinant or a Result.
The SEQUENCE_NUMBER field may provide the order in which this operand will be displayed, for example in the user interface 120. The POLICY_OPERAND_DEFINITION_ID field may provide a unique identifier for the policy operand to be displayed (by itself or within a group). The OPERAND_GROUP_DEFINITION_ID field, when this item represents a group, may provide a unique identifier for the group. When the item not a group, this field may be 0.
The CREATED_BY field may provide the ID of the user that created this record. The CREATED_TS field may provide the date/time that this record was created. The VERSION field may provide a sequential number that identifies historical changes to a particular bill request type configuration.
The LAST_MODIFIED_BY field may provide an ID of the Application or User which last modified the bill request type configuration row. The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified.
TABLE 6
POLICY_OPERAND_GROUP
Col. Seq
Column
Nulls
Type
5
POLICY_OPERAND_GROUP_ID
NOT NULL
NUMBER (18)
10
OPERAND_TYPE_ID
NOT NULL
NUMBER (18)
12
OPERAND_GROUP_ID
NOT NULL
NUMBER (18)
13
RETAILER_POLICY_ID
NULL
NUMBER (18)
42
CREATED_BY
NOT NULL
VARCHAR2 (30)
43
CREATED_TS
NOT NULL
TIMESTAMP ( )
53
VERSION
NOTNULL
NUMBER (10)
90
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
100
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
Primary Key
Name
Column
POPGRP_PK
POLICY_OPERAND_GROUP_ID
Foreign Keys
POPGRP_RETPOL_FK01
RETAILER_POLICY_ID references RETAILER_POLICY.RETAILER_POLICY_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
The POLICY_OPERAND_GROUP table defines a determinant or resultant group of operands that may be evaluated together.
The POLICY_OPERAND_GROUP_ID field may provide a unique identifier for the retailer policy operand group. The OPERAND_TYPE_ID field may provide a code that indicates whether this Operand Group Definition describes a Determinant or a Result. The OPERAND_GROUP_ID field may provide a code that identifies the specific operand group, such as ‘Street Address’.
The RETAILER_POLICY_ID field may provide a unique ID for the policy. The CREATED_BY field may provide the ID of the user or process that created the record. The CREATED_TS field may provide the date the record was created.
Multiple organizations (e.g., multiple retailers) may setup policy groups within the same database. For example, Alpha cable company and Beta cable company may establish independent statement template policy groups. Each policy group may then represent the preferred rules for each company. The retailer identifier may identify the retailer that owns or that is associated with any particular policy or policy group.
The VERSION field may provide a version number of the row. When the row is modified, the version number may be incremented. The LAST_MODIFIED_BY field may provide the Application or User which last modified the bill request type configuration row. The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified.
TABLE 7
POLICY_OPERAND_VALUE
Col. Seq
Column
Nulls
Type
5
POLICY_OPERAND_VALUE_ID
NOT NULL
NUMBER (18)
10
POLICY_OPERAND_ID
NULL
NUMBER (18)
20
OPERAND_TYPE_ID
NOT NULL
NUMBER (18)
25
OPERATOR_ID
NOT NULL
NUMBER (18)
30
MINIMUM_VALUE
NOT NULL
VARCHAR2 (240)
50
CREATED BY
NOT NULL
VARCHAR2 (30)
60
CREATED_TS
NOT NULL
TIMESTAMP ( )
61
VERSION
NULL
NUMBER (10)
63
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
66
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
76
MAXIMUM_VALUE
NULL
VARCHAR2 (240)
Primary Key
Name
Column
POLOPV_PK
POLICY_OPERAND_VALUE_ID
Foreign Keys
POLOPV_POLOPR_FK01
POLICY_OPERAND_ID references POLICY_OPERAND.POLICY_OPERAND_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
Policy Operand Value is a table that encapsulates the operators and values for a determinant or result. For a determinant, the operator represents how this field may be evaluated against input data (equals, not equals, greater than, and so forth), while the values indicate the comparison value(s). For a result, the operator may be ‘equals’, and the minimum value may contain the value to return should this policy evaluate to true.
The POLICY_OPERAND_VALUE_ID field may provide a unique number referencing a particular determinant or result definition. The POLICY_OPERAND_ID field may provide a unique identifier for the retailer policy operand. The OPERAND_TYPE_ID field may provide a code used to indicate whether this Operand Group Definition describes a Determinant or a Result.
The OPERATOR_ID field may provide a unique identifier of an operator that may be used with that particular operand value. The MINIMUM_VALUE field may provide the low end value of the range or the actual value if no maximum value is specified in the row. The CREATED_BY field may provide the ID of the user that created this record.
The CREATED_TS field may provide the date and time that this record was created. The VERSION field may provide a sequential number used to identify historical changes to a particular bill request type configuration. The LAST_MODIFIED_BY field may provide the Application or User which last modified the bill request type configuration row.
The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified. The MAXIMUM_VALUE field may provide the high end value of the range.
TABLE 8
RETAILER_POLICY
Col. Seq
Column
Nulls
Type
5
RETAILER_POLICY_ID
NOT NULL
NUMBER (18)
12
POLICY_NAME
NOT NULL
VARCHAR2 (50)
15
BEGIN_DT
NOT NULL
DATE
25
PRIORITY
NOT NULL
NUMBER (10)
40
RETAILER_POLICY_GROUP_ID
NULL
NUMBER (18)
42
CREATED_BY
NOT NULL
VARCHAR2 (30)
43
CREATED_TS
NOT NULL
TIMESTAMP ( )
53
VERSION
NULL
NUMBER (10)
90
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
100
LAST_MODIFIED_TS
NULL
TIMESTAMP 0
110
END_DT
NULL
DATE
Primary Key
Name
Column
RETPOL_PK
RETAILER_POLICY_ID
Foreign Keys
POLICY_POLGRP_FK01
RETAILER_POLICY_GROUP_ID references
RETAILER_POLICY_GROUP.RETAILER_POLICY_GROUP_ID
Transferable?
Yes
Update Rule:
Restricted
Mandatory?
Yes
Delete Rule:
Restricted
Index Summary
Name
Seq.
Column
Index Type
POLICY_UK01_INDX
5
RETAILER_POLICY_GROUP_ID
UNIQUE
POLICY_UK01_INDX
10
PRIORITY
UNIQUE
The RETAILER_POLICY table defines an individual policy that has been defined for a specific retailer and the given policy group type. The policy with the lowest priority (highest number) may be considered the default policy. The table includes two lists: 1) all results returned by the policy and 2) all determinants defined for the policy.
The RETAILER_POLICY_ID field may provide a unique ID for the policy. The POLICY_NAME field may provide the name of the policy. The BEGIN_DT field may provide the date that this will be in effect. The PRIORITY field may provide a priority indicating in what order policies will be evaluated. For example, the highest priority (lowest number) may be evaluated first.
The RETAILER_POLICY_GROUP_ID field may provide a unique id for the policy group. The CREATED_BY field may provide the ID of the user or process that created the record. The CREATED_TS field may provide the date the record was created.
The VERSION field may provide a version number of the row. When the row is modified, the version number may be incremented. The LAST_MODIFIED_BY field may provide the Application or User which last modified the bill request type configuration row. The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified. The END_DT field may provide the date after which the policy will no longer be in effect.
TABLE 9
RETAILER_POLICY_GROUP
Col. Seq
Column
Nulls
Type
5
RETAILER_POLICY_GROUP_ID
NOT NULL
NUMBER (18)
15
VERSION
NOT NULL
NUMBER (10)
25
POLICY_GROUP_TYPE
NOT NULL
NUMBER (18)
35
RETAILER_ID
NOT NULL
NUMBER (18)
42
CREATED_BY
NOT NULL
VARCHAR2 (30)
43
CREATED_TS
NOT NULL
TIMESTAMP ( )
90
LAST_MODIFIED_BY
NULL
VARCHAR2 (30)
100
LAST_MODIFIED_TS
NULL
TIMESTAMP ( )
Primary Key
Name
Column
POLGRP_PK
RETAILER_POLICY_GROUP_ID
Index Summary
Name
Seq.
Column
Index Type
POLGRP_SK01_INDX
5
RETAILER_ID
NOT UNIQUE
The RETAILER_POLICY_GROUP table may be stored at the retailer level to act as a cross-reference to the POLICY_GROUP_DEFINITION table. It may include a list of policies created for the retailer using the given policy group definition as a template.
The RETAILER_POLICY_GROUP_ID field may provide a unique ID for the policy group. The VERSION field may provide a version number of the row. When the row is modified, the version number may be incremented. The POLICY_GROUP_TYPE field may provide a unique identifier for the Policy Group Type.
The RETAILER_ID field may provide a unique identifier for the retailer. The CREATED_BY field may provide the ID of the user or process that created the record. The CREATED_TS field may provide the date the record was created. The LAST_MODIFIED_BY field may provide the Application or User which last modified the bill request type configuration row. The LAST_MODIFIED_TS field may provide the date and time that the bill request type configuration row was last modified.
With regard next to
In
Note also that in one implementation, a policy operand table 322 includes a policy identifier field 324 and an operand identifier field 326. As explained above, an operand may represent either a determinant or a resultant. Consequently, any given operand specified in the operand table 322 may be linked back to a policy through the policy identifier field 324.
Values for the operand may be retained by the policy operand value table 328. The value table 328 includes a value identifier field 330 and an operand identifier field 332. The value table 328 also includes, as examples, value fields 334 and 336 for storing operand values. Any given operand value may be linked back to its operand table 322 through the operand identifier field 332.
The operand group table 338 provides a mechanism through which operands are grouped together for a policy. The operand group table 338 includes an operand group identifier 340. The operand group table 338 is interlinked with the policy table 316 and the policy operand table 322 through the operand group identifier 342 and the policy identifier 344.
In a similar manner,
More specifically, the diagram 400 shows a policy group table 414, an operand group table 416, an operand table 418, and an operand display order table 420. The database tables 414-418 may establish the policy groups, operands, and operand definitions that the customers may employ for forming their own policies through the database tables shown in
Turning briefly to
The processing system 100 stores a group identifier for a policy group in the group identifier field 314 and links policies to the policy group (Act 1210). In that regard, the processing system may store the same group identifier in the policy table 316 for the policies that belong to the policy group indicated by the group identifier.
Similarly, to associate operands with policies, the processing system 100 may first store a policy identifier in the policy identifier field 320 in the policy table 320 (Act 1212). The same policy identifier may then be stored in the policy identifier field 324 for each operand belonging to that policy (Act 1214).
In order to assign a value to an operand, the processing system 100 employs the operand value table 328. For example, the processing system 100 first associate an operand value record with an operand by storing an operand identifier in the identifier field 326 and in the identifier field 332. The processing system 100 may then store values in the value fields 334 and 336 to set the operand value.
Turning next to
The evaluation program 116 applies each policy rule in a policy group according to its priority values. In doing so, the evaluation program 116 applies the policy determinant values for policies in the policy group against the input data (Act 504). When no prior policy evaluate to True, the evaluation program may apply a default policy in the policy group (Act 506).
By applying the policy rules against the input data, the evaluation program 116 identifies a resultant according to which policy evaluates to True (Act 508). The data processing system 100 may then take the appropriate action or present data according to the resultant, for example, by preparing a customer invoice according to a determined template format.
The discussion below focuses on several exemplary aspects of the user interface 120. In general, the user interface 120 may be implemented in many manners. Where specific examples are given for buttons, drop down lists, and other controls, it is noted that other control elements may be substituted instead. Accordingly, the user interface 120 may employ radio buttons, drop down lists, selection boxes, text entry fields, scroll bars, drop down menus, selection buttons, toggle buttons, or any other type of user interface element for implementing the features explained below.
The policy configuration user interface definition 118 includes text and graphical element positioning, size, and characteristic data that dictates how each element in each interface appears on the screen. Thus, for example, the interface definition 118 may specify a position, size, label, and length for a text entry field, several buttons, and a checkbox control. Similarly, the interface definition 118 may specify the realization of an interface element. As an example, the realization of an interface element may be a drop down list, radio button, text entry field, or another identifier of the form and function of the interface element.
The maintenance interface 600 includes a save icon 606 and a retailer tree view 608. The retailer tree view 608 includes a node for each retailer supported by the application. The node 610 represents Acme Cable company, for example. The retailer tree view 608 also includes list expanders 612, and retailer information entries 614. The save icon 606 is an operator selectable icon that directs the processing system 100 to save all changes made to any of the operator adjustable features described below.
The retailer tree view 608, through the list expanders 612, allows an operator to select any retailer supported by the statement preparation system. As shown
The operator may select any of the retailer information entries 614, for example by clicking the mouse cursor or through keyboard input. By doing so, the ruleset user interface 120 will present the operator with additional interface screens through which the operator may modify the policies present in the associated policy group. In the example discussed below, it is assumed that the operator has selected the minimum bill threshold information entry 616. However, the user interface 120 may respond in a similar manner regardless of the information entry selected.
As shown in
The detail panel 702 further includes a set of modification buttons. The modification buttons include an “Add” button 816 and a “Modify” button 818. The modification buttons further include a “Priorities” button 820 and a “Copy” button 822.
As shown in
The statement preparation system processes the policies 804 in order of priority 806. In doing so, the statement preparation system ensures that each policy is in effect by checking the policy begin date 812 and the policy end date 814. When no previous policy evaluated to True, the Default policy determines whether to print a bill. In this example, the Default policy specifies that a bill will not be printed.
The operator may modify the policy group 802. As examples, the operator may add a policy, modify an existing policy, or change a policy priority. To that end, the user interface 120 responds to the modification buttons 816-822 as explained below.
As shown in
The configuration interface 900 further includes a determinant selector 914 and a determinant value selector 916. An operator selector 918 is also present for selecting an operator (e.g., “=”, “<”, “>”, “< >”, “<=”, or another operator). The selectors 914-918 may be implemented, for example, as drop down boxes that the processing system 100 populates with values appropriate for each determinant, as determined by the data model discussed above.
The configuration interface 900 also includes a determinant panel 920. The determinant panel 920 lists determinants 922 that may be modified through the selectors 914-918, and that have currently been assigned a value 924. Additionally, the configuration interface 900 includes the following configuration buttons: Add 926, Remove 928, OK 930, Clear 932, and Cancel 934.
With reference back to
Accordingly, the operator may then enter a policy name in the name field 902, and at their discretion, set the minimum bill amount in the bill amount field 904 and provide values for the Account Type and Delivery Method determinants through the selectors 914-918. With regard to the determinants set through the selectors 914-918, the Add button 926 directs the processing system 100 to add the determinant value to the policy, and to display the determinant and its value in the determinant panel 920. Similarly, the Remove button 928 directs the processing system 100 to remove the determinate value from the policy, and to remove the determinant and its value from the determinant panel 920.
The operator may then enter a begin date in the begin date field 906, either by typing the date into the field, or selecting a date through the calendar icon 910. Similarly, the operator may enter an end date in the end date field 906, either by typing the date into the field, or selecting an end date through the calendar icon 912.
When the operator is finished adding the new policy, the operator may press the OK button 930 to direct the processing system 100 to accept and save the new policy. The processing system 100 responsively updates the policy rule database 110 to add the new policy to the policy group. The operator may click on the Clear button 932 to remove all the values previously added to the new policy. Similarly, the operator may click on the Cancel button 934 to return to the configuration detail interface 700 without adding a new policy to the policy group.
Again with reference to
The processing system 100 responds in a similar manner when the operator clicks the Copy button 822. More specifically, the processing system 100 populates the configuration interface 900 with values copied from the currently selected policy in the detail panel 702. The operator may then enter a new name for the policy and proceed as explained above to set values for the new policy.
The user interface 120 additionally supports modification of policy priorities. To that end, when the operator selects the Priorities button 820, the user interface 120 presents the priority configuration interface 1000 shown in
The policy detail panel 1002 displays each policy in the minimum bill threshold policy group, including its priority 806. The adjustment panel 1004 includes a priority increase control 1006 and a priority decrease control 1008. The command buttons include an OK button 1010, a Reset button 1012, and a Cancel button 1014.
The priority configuration interface 1000 may initially display the policies in ascending priority order. In one implementation, the Default policy has the lowest priority (highest priority number). In order to reprioritize a policy, the operator first selects the policy in the detail panel 1002. The configuration interface 1000 responsively highlights the selected policy, in this example the Minimal policy 1010.
Subsequently, the operator may use the controls 1006 and 1008 to increase or decrease the policy priority as desired. The processing system 100 may automatically re-prioritize other policies affected by the change. For example, as shown in
When the operator is satisfied with the policy priorities, the operator may click the OK button 1010. In response, the processing system 100 saves the new priorities and returns the operator to the detail interface 700. In response to the Reset button 1012, the processing system 100 will return all priorities to the values they had when the priority configuration interface 1000 was first displayed. The Cancel button 1014 returns the operator to the detail interface 700 without saving any changes.
The processing system 100 then accepts a policy selection of a policy from the policy set and a policy modification directive (Act 1104). For example, the policy selection may be a mouse click on an individual policy, or keyboard input to highlight an individual policy. Similarly, the policy modification directive may be a mouse click or keyboard input to select one of the configuration buttons 816-822.
Accordingly, when the operator has selected the Priorities button 820, the processing system 100 displays the policy priority configuration interface 1000 (Act 1106). The configuration interface 1000 includes, as examples, the detail panel 1002, the adjustment panel 1004 with the priority increase control 1006 and priority decrease control 1008, and the command buttons including the OK button 1010. Reset button 1012, and Cancel button 1014.
As explained above, the processing system 100 accepts a policy priority modification directive for a selected policy. The modification directive may be a mouse or keyboard activation of the increase control 1006 or the decrease control 1008, as examples. The processing system 100 responsively updates the policy priorities in the policy group (Act 1108).
As another alternative modification directive, the operator may choose to Add or Copy a policy. In response, the processing system 100 displays a policy configuration interface 900, including the selectors 914-918 (Act 1110). The configuration interface 900 may also include, as examples, the begin date field 906, the end date field 908, and the policy name field 902 (Act 1112). In general, the configuration interface 900 displays one or more characteristics of the policy that the operator may modify and a user interface input element (e.g., the text field 904) for accepting input with regard to that characteristic.
If the operator selected the Copy button 822, then the processing system 100 will copy the selected policy characteristics into the input fields of the configuration interface 900 (Act 1114). The operator may then change only the fields desired, while the rest remain unchanged. Alternatively, if the operator selected the Add button 816, then the processing system may instead display the configuration interface 900 blanked out, ready for new input.
In either case, the processing system 100, through then configuration interface 900, accepts priority modification directives from the operator (Act 1116). As examples, the processing system 100 may accept text input for the policy name, date input for the begin date and end date, and drop down list selections for the policy determinant values. The processing system 100 updates the policy accordingly so that it is ready the next time it is applied to customer or internal data.
The rules processing system explained above thereby provides an extensible sophisticated rules processing engine for customer or internal data. Each customer may conveniently tailor the engine to apply a wide range of policies against their input data. Consequently, the customer may develop and modify over time sophisticated processing patterns, without the time and expense associated with obtaining a custom solution from a software vendor.
It is therefore intended that the foregoing detailed description be regarded as illustrative rather than limiting, and that it be understood that it is the following claims, including all equivalents, that are intended to define the spirit and scope of this invention.
Campbell, Maxine, Irby, Cindy, Verego, Greg
Patent | Priority | Assignee | Title |
Patent | Priority | Assignee | Title |
6466932, | Aug 14 1998 | Microsoft Technology Licensing, LLC | System and method for implementing group policy |
6766319, | Oct 31 2000 | Method and apparatus for gathering and evaluating information | |
6880005, | Mar 31 2000 | Hewlett Packard Enterprise Development LP | Managing policy rules in a network |
6941465, | Jul 26 1999 | Microsoft Technology Licensing, LLC | Method of enforcing a policy on a computer network |
6950818, | Aug 14 1998 | Microsoft Technology Licensing, LLC | System and method for implementing group policy |
7055098, | Feb 19 1999 | Lucent Technologies Inc. | Dynamic display of data item evaluation |
7069259, | Jun 28 2002 | Microsoft Technology Licensing, LLC | Multi-attribute specification of preferences about people, priorities and privacy for guiding messaging and communications |
7082492, | Aug 10 2002 | Cisco Technology, Inc. | Associative memory entries with force no-hit and priority indications of particular use in implementing policy maps in communication devices |
7310613, | Apr 05 2001 | British Telecommunications public limited company; AT&T Corporation | Data management system |
7433944, | Dec 07 2001 | Hitachi, Ltd. | Network, server, and storage policy server |
7477600, | Feb 12 2002 | Cisco Technology, Inc. | Method and apparatus for configuring network elements to support real time applications based on meta-templates |
7523483, | May 12 2003 | BLUE YONDER GROUP, INC | Determining a policy parameter for an entity of a supply chain |
20030023587, | |||
20030107590, | |||
20030115545, | |||
20040230829, | |||
20070203756, |
Executed on | Assignor | Assignee | Conveyance | Frame | Reel | Doc |
Sep 21 2014 | VEREGO, GREG | Amdocs Software Systems Limited | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 035888 | /0022 | |
Oct 01 2014 | IRBY, CINDY | Amdocs Software Systems Limited | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 035888 | /0022 | |
Oct 07 2014 | CAMPBELL, MAXINE | Amdocs Software Systems Limited | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 035888 | /0022 | |
Oct 15 2014 | Amdocs Software Systems Limited | (assignment on the face of the patent) | / | |||
Jul 18 2016 | Amdocs Software Systems Limited | AMDOCS DEVELOPMENT LIMITED | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 039695 | /0965 | |
Jul 18 2016 | Amdocs Software Systems Limited | Amdocs Software Systems Limited | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 039695 | /0965 |
Date | Maintenance Fee Events |
Sep 03 2019 | M1551: Payment of Maintenance Fee, 4th Year, Large Entity. |
Sep 05 2023 | M1552: Payment of Maintenance Fee, 8th Year, Large Entity. |
Date | Maintenance Schedule |
Mar 15 2019 | 4 years fee payment window open |
Sep 15 2019 | 6 months grace period start (w surcharge) |
Mar 15 2020 | patent expiry (for year 4) |
Mar 15 2022 | 2 years to revive unintentionally abandoned end. (for year 4) |
Mar 15 2023 | 8 years fee payment window open |
Sep 15 2023 | 6 months grace period start (w surcharge) |
Mar 15 2024 | patent expiry (for year 8) |
Mar 15 2026 | 2 years to revive unintentionally abandoned end. (for year 8) |
Mar 15 2027 | 12 years fee payment window open |
Sep 15 2027 | 6 months grace period start (w surcharge) |
Mar 15 2028 | patent expiry (for year 12) |
Mar 15 2030 | 2 years to revive unintentionally abandoned end. (for year 12) |