Storing and depicting organizations that are subject to dynamic event driven restructuring

Abstract

The present invention discloses a solution for storing and depicting complex non-contiguous organizations that are subject to situation-based restructuring. Different views for organization charts of the organization can be generated, where the generated organization charts are collapsed to a minimal view which automatically hides at least a portion of the organization positions in accordance with a desired view. For example, a view showing only filled positions will hide unfilled positions, collapsing intermediate nodes of a shown hierarchy so that child nodes of a hidden node are directly connected to the parent node of the hidden node. A set of indexed database tables can be used to efficiently store details of the organization. The indexed tables can store positions, assignment, and position reporting details in separate 3NF tables. The solution can be integrated to a commercial off-the-shelf command management system and/or to a commercial off-the-shelf front-end charting application.

1 - 20 . (canceled) 
     
     
         21 . A computer-implemented method for charting an organization, comprising:
 identifying a set of database tables for an organization structure;   receiving, from a user, a user request for a graphical organization chart that includes at least one user-selected option;   querying the set of database tables using the at least one user-selection option to generate an organization object;   converting the organization object into the graphical organization chart;   dynamically changing the organization chart in responses to a change in the set of indexed tables; and   presenting, in response to the user request, the graphical organization chart.   
     
     
         22 . The method of  claim 21 , wherein
 the set of database tables includes:
 a position table including a unique record for each position within an organization structure, 
 a position reporting table including a unique record for each relationship among the positions, 
 a resource table including a unique record for each resource capable of occupying one of the positions, and 
 an assignment table includes a unique record for each resource/position assignment; 
   
     
     
         23 . The method of  claim 21 , wherein
 the user request specifies a specific view for the organization chart that is one of:
 a full view showing filled and unfilled positions, and 
 a filled view showing only positions that are filled. 
   
     
     
         24 . The method of  claim 21 , wherein
 a position of the organization structure is hidden within the graphical organization chart based upon a sensitivity attribute of the position and based upon a security level of the user.   
     
     
         25 . The method of  claim 21 , wherein
 the set of database tables are in third normal form (3NF),   the set of database tables store historical information regarding positions and assignments, and   the set of database tables are integrated to an incident command system.   
     
     
         26 . The method of  claim 25 , wherein
 the integrating adds dynamic organization charting capabilities consistent with a non-contiguous organization structure that changes based upon situational factors managed by the incident command system.   
     
     
         27 . The method of  claim 25 , wherein
 the incident command system is configured to
 determine an incident event, and 
 automatically alter, responsive to the incident event, at least one structure of the set of database tables and content stored in records contained in the set of database tables. 
   
     
     
         28 . A computer hardware system configured to chart an organization, comprising:
 a hardware processor configured to initiate the following executable operations:
 identifying a set of database tables for an organization structure; 
 receiving, from a user, a user request for a graphical organization chart that includes at least one user-selected option; 
 querying the set of database tables using the at least one user-selection option to generate an organization object; 
 converting the organization object into the graphical organization chart; 
 dynamically changing the organization chart in responses to a change in the set of indexed tables; and 
 presenting, in response to the user request, the graphical organization chart. 
   
     
     
         29 . The system of  claim 28 , wherein
 the set of database tables includes:
 a position table including a unique record for each position within an organization structure, 
 a position reporting table including a unique record for each relationship among the positions, 
 a resource table including a unique record for each resource capable of occupying one of the positions, and 
 an assignment table includes a unique record for each resource/position assignment; 
   
     
     
         30 . The system of  claim 28 , wherein
 the user request specifies a specific view for the organization chart that is one of:
 a full view showing filled and unfilled positions, and 
 a filled view showing only positions that are filled. 
   
     
     
         31 . The system of  claim 28 , wherein
 a position of the organization structure is hidden within the graphical organization chart based upon a sensitivity attribute of the position and based upon a security level of the user.   
     
     
         32 . The system of  claim 28 , wherein
 the set of database tables are in third normal form (3NF),   the set of database tables store historical information regarding positions and assignments, and   the set of database tables are integrated to an incident command system.   
     
     
         33 . The system of  claim 32 , wherein
 the integrating adds dynamic organization charting capabilities consistent with a non-contiguous organization structure that changes based upon situational factors managed by the incident command system.   
     
     
         34 . The system of  claim 32 , wherein
 the incident command system is configured to
 determine an incident event, and 
 automatically alter, responsive to the incident event, at least one structure of the set of database tables and content stored in records contained in the set of database tables. 
   
     
     
         35 . A computer program product, comprising:
 a hardware storage device having program code stored therein,   the program code, which when executed by a computer hardware system, causes the computer hardware system to perform:
 identifying a set of database tables for an organization structure; 
 receiving, from a user, a user request for a graphical organization chart that includes at least one user-selected option; 
 querying the set of database tables using the at least one user-selection option to generate an organization object; 
 converting the organization object into the graphical organization chart; 
 dynamically changing the organization chart in responses to a change in the set of indexed tables; and 
 presenting, in response to the user request, the graphical organization chart. 
   
     
     
         36 . The computer program product of  claim 35 , wherein
 the set of database tables includes:
 a position table including a unique record for each position within an organization structure, 
 a position reporting table including a unique record for each relationship among the positions, 
 a resource table including a unique record for each resource capable of occupying one of the positions, and 
 an assignment table includes a unique record for each resource/position assignment; 
   
     
     
         37 . The computer program product of  claim 35 , wherein
 the user request specifies a specific view for the organization chart that is one of:
 a full view showing filled and unfilled positions, and 
 a filled view showing only positions that are filled. 
   
     
     
         38 . The computer program product of  claim 35 , wherein
 a position of the organization structure is hidden within the graphical organization chart based upon a sensitivity attribute of the position and based upon a security level of the user.   
     
     
         39 . The computer program product of  claim 35 , wherein
 the set of database tables are in third normal form (3NF),   the set of database tables store historical information regarding positions and assignments, and   the set of database tables are integrated to an incident command system.   
     
     
         40 . The computer program product of  claim 39 , wherein
 the integrating adds dynamic organization charting capabilities consistent with a non-contiguous organization structure that changes based upon situational factors managed by the incident command system.