Method, system and program product for conditionally controlling changes to key data fields in a project database

• US 9,805,318 B2
• Filed: 07/28/2006
• Issued: 10/31/2017
• Est. Priority Date: 07/28/2006
• Status: Active Grant

• Current Assignee: Kyndryl Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Ellis, Tanya J., Garrett, Andrew J., Hicks, Scott D., Martin, Jr., James A., Taylor, Philip J.
• Primary Examiner(s): Austin, Jamie
• Application Number:
  US11/460,695
• Publication Number:
  US 20080027775A1
• Time in Patent Office: 4,113 Days
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/06316 Sequencing of tasks or work
• CPC Class Codes: G06Q 10/06375 Prediction of business process outcome or impact based on a proposed change
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations

Abstract

A method, system and program product for performing one or more actions in response to a change made to a key data field in a project management application for managing a project. The method includes establishing one or more metrics to be monitored for a project, defining one or more actions for at least one key data field of a plurality of key data fields in the project management application, the one or more actions being defined in accordance with a level of control to be exercised and being triggered by one or more pre-specified conditions associated with the one or more metrics monitored for the project. The method further includes automatically performing at least one action of the one or more actions in response to a relative impact to the project caused by a change made to the at least one key data field.

Claims

1. A method of performing one or more pre-specified actions in response to a change made to a key data field in a project management application, said method comprising the steps of:

defining a plurality of key data fields in a project database for managing said project;

flagging, within the project database stored in computer-readable memory, a key data field of the plurality of key data fields, the flagging causing a change to data content of the key data field to automatically trigger one or more pre-specified actions performed by a project management computer system having a project management application loaded thereon for managing migration of a project, said project management application including a conditional controls component for automating performance of the one or more pre-specified actions in response to the change made to a key data field of a plurality of key data fields defined in said project management application at a particular time period corresponding to said change made in said project;

recording said change made to said key data field;

establishing one or more metrics to be monitored for the project, each of said one or more metrics having one or more pre-specified conditions that when met trigger performance of the one or more pre-specified actions, wherein said one or more metrics comprise;

time period for said project, percent of project budget expended for said project, percent of work completed for said project and specific milestones surpassed for said project;

monitoring, using said conditional controls component, the one or more metrics for said project;

defining, in said conditional controls component, one or more pre-specified actions for at least one key data field of said plurality of key data fields in said project management application for managing said project, said one or more pre-specified actions being defined in accordance with a level of control over changes that may be made to said at least one key data field of said plurality of key data fields to be exercised, wherein said level of control is selected from a plurality of progressively restrictive levels of control defining who is permitted to make changes to said at least one key data field of said plurality of key data fields;

performing, using said conditional controls component, at least one pre-specified action of said one or more pre-specified actions in response to a relative impact to said project caused by said change made to said at least one key data field, wherein said at least one pre-specified action performed corresponds to a respective level of control over changes that may be made to said at least one key data field of said plurality of key data fields to be exercised in response to said relative impact to said project depending at least in part on said time period corresponding to said change, and wherein said respective level of control to be exercised increases with time;

after achievement of a pre-established date and budget threshold value, triggering, by a change to a key data field, a pre-specified action comprising emailing a notification to members of a change review board, along with a set of financial consequences quantified in monetary or labor units caused by said change to the key data field, the notification requiring review a reply with an approval before proceeding with the change to the key data field;

sending a communication regarding said at least one pre-specified action of said one or more pre-specified actions performed; and

sending an invoice for the set of financial consequences.

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

determining one or more levels of control for said at least one key data field, wherein said level of control to be exercised is dictated by said one or more pre-specified conditions met for said one or more project progression metrics monitored.

3. The method according to claim 2, further comprising the steps of:

defining one or more activities for said project; and

establishing a schedule for said one or more activities for said project.

4. The method according to claim 3, wherein the level of control is based on at least one pre-specified condition, of said one or more pre-specified conditions, being met.

5. The method according to claim 1, wherein said one or more pre-specified actions comprise at least one of:

logging said change to said at least one key data field, preventing said change to said at least one key data field from being finalized based upon a field value of said at least one key data field, preventing said change to said at least one key data field from being finalized based upon a field value of another data field in said project management application, preventing said change to said at least one key data field, sending notification of said change to said at least one key data field to a distribution list of users, restricting access to change said at least one key data field to a list of approved users, requiring approval from one or more users prior to finalizing said change to said at least one key data field, determining an additional project cost to implement said change to said at least one key data field, sending an invoice for said additional project cost to a customer, and canceling one or more activities for said project.

15. The method according to claim 1, further comprising restricting access to change the at least one key data field to a list of approved users.

6. A system for conditionally controlling a change made to a key data field in a project management application, comprising:

a memory medium comprising program instructions;

a bus coupled to the memory medium; and

a processor, for executing the program instructions, coupled to a project management application via the bus that when executing the program instructions causes the system to;

defining a plurality of key data fields in a project database for managing said project;

flag, within the project database stored in computer-readable memory, a key data field of the plurality of key data fields, the flag causing a change to data content of the key data field to automatically trigger one or more pre-specified actions in said project management application at a particular time period corresponding to when said change is made,

record said change made to said key data field;

establish one or more metrics to be monitored pertaining to progress of the project, each of said one or more metrics having one or more pre-specified conditions that when met trigger performance of the one or more pre-specified actions, wherein said one or more metrics comprise;

time period for said project, percent of project budget expended for said project, percent of work completed for said project and specific milestones surpassed for said project;

monitor, by a conditional controls component, the one or more metrics;

define, in said conditional controls component, one or more pre-specified actions for at least one key data field of said plurality of key data fields in said project management application for managing said project, said one or more pre-specified actions being defined in accordance with a level of control over changes that may be made to said at least one key data field of said plurality of key data fields to be exercised, wherein said level of control is selected from a plurality of progressively restrictive levels of control defining who is permitted to make changes to said at least one key data field of said plurality of key data fields;

perform, using said conditional controls component, at least one pre-specified action of said one or more pre-specified actions in response to a relative impact to said project caused by said change made to said at least one key data field, wherein said at least one pre-specified action performed corresponds to a respective level of control over changes that may be made to said at least one key data field of said plurality of key data fields to be exercised in response to said relative impact to said project depending at least in part on said time period corresponding to said change, and wherein said respective level of control to be exercised increases with time;

each of said one or more pre-specified conditions having an associated level of control over changes that may be made to said key data field in said project management application and one or more pre-specified actions to be taken when a pre-specified condition is met, depending at least in part on said time period corresponding to said change, such that an increasing level of control over time over changes that may be made to said key data field in said project management application is exercised when performing said at least one pre-specified action in response to said change made to said key data field as said project progresses, wherein said associated level of control is selected from a plurality of progressively restrictive levels of control over changes that may be made to said key data field in said project management application each of the plurality of progressively restrictive levels of control defining who is permitted to make changes to said key data field in said project management application;

after achievement of a pre-established date and budget threshold value, triggering, by a change to a key data field, a pre-specified action, by the computer system, comprising emailing a notification to members of a change review board, along with a set of financial consequences quantified in monetary or labor units caused by said change to the key data field, the notification requiring review a reply with an approval before proceeding with the change to the key data field;

send a communication regarding said at least one pre-specified action of said one or more pre-specified actions performed; and

sending an invoice for the set of financial consequences.

7. The system according to claim 6, wherein the level of control is based on at least one pre-specified condition, of said one or more pre-specified, conditions being met.

8. The system according to claim 7, wherein said at least one pre-specified action comprise at least one of:

logging said change to said key data field, preventing said change to said key data field from being finalized based upon a field value of said key data field, preventing said change to said key data field from being finalized based upon a field value of another data field in said project management application, preventing said change to said key data field, sending notification of said change to a distribution list of users, restricting access to change said key data field to a list of approved users, requiring approval from one or more users prior to finalizing said change, determining an additional project cost to implement said change, sending an invoice for said additional project costs to a customer, and canceling one or more activities for said project.

9. A computer program product for implementing one or more pre-specified actions in response to a change made to a key data field in a project management application for a project, said computer program product comprising:

a non-transitory computer readable storage medium;

program instructions to define a plurality of key data fields in a project database for managing said project;

program instructions to flag, within the project database stored in computer-readable memory, a key data field of the plurality of key data fields, the flag causing a change to data content of the key data field to automatically trigger one or more pre-specified actions;

program instructions to record said change made to said key data field;

program instructions to establish one or more metrics to be monitored for the project, each of said one or more metrics having one or more pre-specified conditions that when met trigger performance of the one or more pre-specified actions, wherein said one or more metrics comprise;

time period for said project, percent of project budget expended for said project, percent of work completed for said project and specific milestones surpassed for said project;

program instructions to define the one or more pre-specified actions to be performed for the key data field of a plurality of key data fields, each of said one or more pre-specified actions corresponding to a level of control selected from a plurality of progressively restrictive levels of control over changes that may be made to said key data field of a plurality of key data fields to be exercised in response to a change made to said key data field of said plurality of key data fields at a particular time period corresponding to said change made in said project, wherein said level of control of the plurality of progressively restrictive levels of control over changes that may be made to said key data field of a plurality of key data fields defines who is permitted to make changes to said key data field of a plurality of key data fields;

program instructions to establish one or more metrics to be monitored for said project, each of said one or more metrics having one or more pre-specified conditions, such that said change made to said key data field that meets a pre-specified condition triggers implementation of said one or more pre-specified actions, wherein said one or more metrics comprise;

time period for said project, percent of project budget expended for said project, percent of work completed for said project and specific milestones surpassed for said project;

program instructions to implement at least one pre-specified action of said one or more pre-specified actions defined based on said pre-specified condition that is met and corresponding to said level of control over changes that may be made to said key data field of a plurality of key data fields to be exercised in response to said change made to said key data field depending at least in part on said time period corresponding to said change, wherein said respective level of control over changes that may be made to said key data field of a plurality of key data fields to be exercised increases with time;

after achievement of a pre-established date and budget threshold value, triggering, by a change to a key data field, a pre-specified action comprising a notification e-mailed to members of a change review board, along with a set of financial consequences quantified in monetary or labor units caused by said change to the key data field, the notification requiring review a reply with an approval before proceeding with the change to the key data field; and

wherein said instructions are stored on said non-transitory computer readable storage medium;

send a communication regarding said at least one pre-specified action of said one or more pre-specified actions performed; and

program instructions to send an invoice for the set of financial consequences.

10. The computer program product according to claim 9, wherein said second program instructions include instructions to monitor whether or not said one or more pre-specified conditions associated with said one or more metrics have been met in order to trigger performance of said at least one pre-specified action in response to said change made to said key data field.

11. The computer program product according to claim 10, wherein said level of control is dictated by said pre-specified condition met for said one or more metrics monitored.

12. The computer program product according to claim 11, wherein the level of control is based on at least one pre-specified condition, of said one or more pre-specified conditions, being met.

13. The computer program product according to claim 9, wherein said one or more pre-specified actions comprise at least one of:

logging said change to said data field, preventing said change to said data field from being finalized based upon a field value of said data field, preventing said change to said data field from being finalized based upon a field value of another data field in said project management application, preventing said change to said at least one key data field, sending notification of said change to a distribution list of users, restricting access to change said data field to a list of approved users, requiring approval from one or more users prior to finalizing said change, determining an additional project cost to implement said change, sending an invoice for said additional project costs to a customer, and canceling one or more activities for said project.

14. A process for deploying a computing infrastructure comprising integrating computer-readable code into a computing system, wherein said code in combination with said computing system is capable of performing one or more pre-specified actions in response to a change made to a key data field in a project management application, said process comprising:

defining a plurality of key data fields in a project database for managing said project;

flagging, within the project database stored in computer-readable memory, a key data field of the plurality of key data fields, the flagging causing a change to data content of the key data field to automatically trigger one or more pre-specified actions;

recording said change made to said key data field;

establishing one or more metrics to be monitored for a project, each of said one or more metrics having one or more pre-specified conditions that when met trigger performance of the one or more pre-specified actions, wherein said one or more metrics comprise;

time period for said project, percent of project budget expended for said project, percent of work completed for said project and specific milestones surpassed for said project;

identifying one or more levels of control over changes that may be made to said key data field in the project management application to be exercised for a key data field of a plurality of key data fields based on a relative impact to said project caused by a change made to said key data field at a particular time period corresponding to said change made to said key data field for said project, wherein said one or more levels of control over changes that may be made to said key data field in a project management application is selected from a plurality of progressively restrictive levels of control, each of the plurality of progressively restrictive levels of control determines who is permitted to make changes to said key data field in a project management application;

establishing said one or more pre-specified actions to be performed in response to said change made to said key data field of said plurality of key data fields;

performing at least one action of said one or more pre-specified actions corresponding to a level of control of said one or more levels of control over changes that may be made to said key data field in a project management application to be exercised and triggered based on at least one pre-specified condition, of said one or more pre-specified conditions, being met, wherein said at least one action is performed in response to said change made to said key data field depending at least in part on said time period corresponding to said change made to said key data field, and wherein said respective level of control over changes that may be made to said key data field in a project management application to be exercised increases with time such that after achievement of a pre-established date and budget threshold value, a change to a key data field triggers a pre-specified action comprising a notification e-mailed to members of a change review board, along with a set of financial consequences quantified in monetary or labor units caused by said change to the key data field, the notification requiring review a reply with an approval before proceeding with the change to the key data field;

sending a communication regarding said at least one action of said one or more pre-specified actions performed; and

sending an invoice for the set of financial consequences.