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.