Skip to content

Instantly share code, notes, and snippets.

@dlprice
dlprice / ProjectView.sql
Created February 21, 2012 17:50
PeopleSoft Project View
select
case PI.OBJECTTYPE
when 0 then 'Records'
when 1 then 'Indexes'
when 2 then 'Fields'
when 3 then 'Field Formats'
when 4 then 'Translate Values'
when 5 then 'Pages'
when 6 then 'Menus'
when 7 then 'Components'