Abstract: Embodiments use a visual cue to identify a record with missing information among a plurality of hierarchical records. Each record includes a parent field and an associated records field. An entry in the parent field identifies a parent record of a given record. An entry in the associated records field identifies records that are associated with the record based on a criterion or one or more predetermined criteria. For a selected record, a first group of records are identified based on the parent field of the selected record. The entries in the associated records field of the selected record are then compared to the first group of records. A missing record missing an entry in the associated records field is identified among the first group of records. When the first record and the first group of hierarchical records are graphically represented on a target output medium, the missing record is represented using a visual cue.

Abstract: Embodiments use a graphical tree to illustrate hierarchical records including a child record having parent field(s) identifying a first parent record and a second parent record of the child record. The graphical tree is generated by determining a first position for the child record and a second position for the first parent record without considering the second parent record. Subsequently, a third position for the second parent record is determined at a same level as the second position. Once the positions are determined, a first shape, a second shape and a third shape are rendered at the first position, the second position and the third position, respectively. The graphical tree is then generated by visually connecting the first shape with the second shape and the third shape, thereby graphically illustrating the plurality of hierarchical records on a target output medium.