adding ruwanego's changes for adding the 'isParent' column