SQL to get the PeopleSoft Compare Report
SELECT projectname, objecttype, DECODE(objecttype, '0', 'Record', '1', 'Index', '2', 'Field', '3', 'Field Format', '4', 'Translate Value', '5', 'Page', '6', 'Menu', '7', 'Component', '8', 'Record PeopleCode', '9', 'Menu PeopleCode', '10', 'Query', '11', 'Tree Structure', '12', 'Tree', '13', 'Access Group', '14', 'Color', '15', 'Style', '16', 'Business Process Map', '17', 'Business Process', '18', 'Activity', '19', 'Role', '20', 'Process Definition', '21', 'Process Server Definition', '22', 'Process Type Definition', '23', 'Process Job Definition', '24', 'Process Recur...