To my knowledge, the PeopleSoft catalog has no way of providing descriptions for its object type and object ID fields. So, I have created these two custom views. They are handy for joining to tables like PSPROJECTITEM.
View of Object Types
Fields
SQL:
SELECT 00, ‘Records’ FROM PS_INSTALLATION UNION
SELECT 01, ‘Indexes’ FROM PS_INSTALLATION UNION
SELECT 02, ‘Fields’ FROM PS_INSTALLATION UNION
SELECT 03, ‘Field Formats’ FROM PS_INSTALLATION UNION
SELECT 04, ‘Translate Values’ FROM PS_INSTALLATION UNION
SELECT 05, ‘Pages’ FROM PS_INSTALLATION UNION
SELECT 06, ‘Menus’ FROM PS_INSTALLATION UNION
SELECT 07, ‘Components’ FROM PS_INSTALLATION UNION
SELECT 08, ‘Record People Code’ FROM PS_INSTALLATION UNION
SELECT 09, ‘Menu People Code’ FROM PS_INSTALLATION UNION
SELECT 10, ‘Queries’ FROM PS_INSTALLATION UNION
SELECT 11, ‘Tree Structures’ FROM PS_INSTALLATION UNION
SELECT 14, ‘Colors’ FROM PS_INSTALLATION UNION
SELECT 15, ‘Styles’ FROM PS_INSTALLATION UNION
SELECT 17, ‘Business Processes’ FROM PS_INSTALLATION UNION
SELECT 18, ‘Activities’ FROM PS_INSTALLATION UNION
SELECT 19, ‘Role’ FROM PS_INSTALLATION UNION
SELECT 20, ‘Process Definitions’ FROM PS_INSTALLATION UNION
SELECT 21, ‘Server Definitions’ FROM PS_INSTALLATION UNION
SELECT 22, ‘Process Type Definitions’ FROM PS_INSTALLATION UNION
SELECT 23, ‘Job Definitions’ FROM PS_INSTALLATION UNION
SELECT 24, ‘Recurrence Definitions’ FROM PS_INSTALLATION UNION
SELECT 25, ‘Message Catalog Message’ FROM PS_INSTALLATION UNION
SELECT 29, ‘Business Interlink’ FROM PS_INSTALLATION UNION
SELECT 30, ‘SQL’ FROM PS_INSTALLATION UNION
SELECT 31, ‘File Layout Definitions’ FROM PS_INSTALLATION UNION
SELECT 32, ‘Component Interfaces’ FROM PS_INSTALLATION UNION
SELECT 33, ‘Application Engine Programs’ FROM PS_INSTALLATION UNION
SELECT 34, ‘Application Engine Sections’ FROM PS_INSTALLATION UNION
SELECT 35, ‘Message Nodes’ FROM PS_INSTALLATION UNION
SELECT 36, ‘Message Channels’ FROM PS_INSTALLATION UNION
SELECT 37, ‘Messages’ FROM PS_INSTALLATION UNION
SELECT 38, ‘Approval Rule Sets’ FROM PS_INSTALLATION UNION
SELECT 39, ‘Message People Code’ FROM PS_INSTALLATION UNION
SELECT 40, ‘Subscription People Code’ FROM PS_INSTALLATION UNION
SELECT 42, ‘Comp Interface People Code’ FROM PS_INSTALLATION UNION
SELECT 43, ‘Application Engine People Co’ FROM PS_INSTALLATION UNION
SELECT 44, ‘Page People Code’ FROM PS_INSTALLATION UNION
SELECT 45, ‘Page Field People Code’ FROM PS_INSTALLATION UNION
SELECT 46, ‘Component People Code’ FROM PS_INSTALLATION UNION
SELECT 47, ‘Component Record People Code’ FROM PS_INSTALLATION UNION
SELECT 48, ‘Component Rec Fld People Code’ FROM PS_INSTALLATION UNION
SELECT 49, ‘Images’ FROM PS_INSTALLATION UNION
SELECT 50, ‘Style Sheets’ FROM PS_INSTALLATION UNION
SELECT 51, ‘HTML’ FROM PS_INSTALLATION UNION
SELECT 53, ‘Permission Lists’ FROM PS_INSTALLATION UNION
SELECT 54, ‘Portal Registry Definitions’ FROM PS_INSTALLATION UNION
SELECT 55, ‘Portal Registry Structures’ FROM PS_INSTALLATION UNION
SELECT 56, ‘URL Definitions’ FROM PS_INSTALLATION UNION
SELECT 57, ‘Application Packages’ FROM PS_INSTALLATION UNION
SELECT 58, ‘Application Package People C’ FROM PS_INSTALLATION UNION
SELECT 59, ‘Portal Registry User Homepag’ FROM PS_INSTALLATION UNION
SELECT 60, ‘Analytic Types’ FROM PS_INSTALLATION UNION
SELECT 61, ‘Archive Templates’ FROM PS_INSTALLATION UNION
SELECT 62, ‘XS LT’ FROM PS_INSTALLATION UNION
SELECT 63, ‘Portal Registry User Favorit’ FROM PS_INSTALLATION UNION
SELECT 64, ‘Mobile Pages’ FROM PS_INSTALLATION UNION
SELECT 65, ‘Relationships’ FROM PS_INSTALLATION UNION
SELECT 66, ‘CI Property People Code’ FROM PS_INSTALLATION UNION
SELECT 67, ‘Optimization Models’ FROM PS_INSTALLATION UNION
SELECT 68, ‘File References’ FROM PS_INSTALLATION UNION
SELECT 69, ‘File Type Codes’ FROM PS_INSTALLATION UNION
SELECT 70, ‘Archive Object Definitions’ FROM PS_INSTALLATION UNION
SELECT 71, ‘Archive Templates( Type2)’ FROM PS_INSTALLATION UNION
SELECT 72, ‘Diagnostic Plug- Ins’ FROM PS_INSTALLATION UNION
SELECT 73, ‘Analytic Models’ FROM PS_INSTALLATION UNION
SELECT 75, ‘Java Portlet User Preference’ FROM PS_INSTALLATION UNION
SELECT 76, ‘WSRP Remote Producers’ FROM PS_INSTALLATION UNION
SELECT 77, ‘WSRP Remote Portlets’ FROM PS_INSTALLATION UNION
SELECT 78, ‘WSRP Cloned Portlet Handles’ FROM PS_INSTALLATION
View of Object IDs
This view may not be complete, but it attempts to map the OBJECTID1, 2, 3, … field to the OBJECTTYPE field.
Fields:
- OBJECTTYPE
- DESCR
- OBJECTID
SQL:
SELECT 0,’Records’,1 FROM PS_INSTALLATION UNION
SELECT 2,’Fields’,6 FROM PS_INSTALLATION UNION
SELECT 3,’Field Formats’,23 FROM PS_INSTALLATION UNION
SELECT 5,’Pages’,9 FROM PS_INSTALLATION UNION
SELECT 6,’Menus’,3 FROM PS_INSTALLATION UNION
SELECT 11,’Tree Structures’,37 FROM PS_INSTALLATION UNION
SELECT 15,’Styles’,35 FROM PS_INSTALLATION UNION
SELECT 17,’Business Processes’,7 FROM PS_INSTALLATION UNION
SELECT 18,’Activities’,18 FROM PS_INSTALLATION UNION
SELECT 19,’Role’,32 FROM PS_INSTALLATION UNION
SELECT 21,’Server Definitions’,33 FROM PS_INSTALLATION UNION
SELECT 23,’Job Definitions’,27 FROM PS_INSTALLATION UNION
SELECT 24,’Recurrence Definitions’,31 FROM PS_INSTALLATION UNION
SELECT 29,’Business Interlink’,64 FROM PS_INSTALLATION UNION
SELECT 31,’File Layout Definitions’,71 FROM PS_INSTALLATION UNION
SELECT 32,’Component Interfaces’,74 FROM PS_INSTALLATION UNION
SELECT 33,’Application Engine Programs’,66 FROM PS_INSTALLATION UNION
SELECT 35,’Message Nodes’,62 FROM PS_INSTALLATION UNION
SELECT 36,’Message Channels’,61 FROM PS_INSTALLATION UNION
SELECT 37,’Messages’,60 FROM PS_INSTALLATION UNION
SELECT 50,’Style Sheets’,94 FROM PS_INSTALLATION UNION
SELECT 53,’Permission Lists’,89 FROM PS_INSTALLATION UNION
SELECT 54,’Portal Registry Definitions’,98 FROM PS_INSTALLATION UNION
SELECT 56,’URL Definitions’,103 FROM PS_INSTALLATION UNION
SELECT 60,’Analytic Types’,109 FROM PS_INSTALLATION UNION
SELECT 64,’Mobile Pages’,111 FROM PS_INSTALLATION UNION
SELECT 69,’File Type Codes’,122 FROM PS_INSTALLATION UNION
SELECT 73,’Analytic Models’,12 FROM PS_INSTALLATION
store as (tablespace ' || tempName || ')';
end loop;
select count(*) into segmentCount from dba_segments
where tablespace_name = tblName;
dbms_output.put_line('Now ' || segmentCount || ' segments');
execute immediate 'alter tablespace ' || tblName || ' offline';
execute immediate 'drop tablespace ' || tblName;
execute immediate 'alter tablespace ' || tempName || ' rename to ' || tblName;
dbms_output.put_line('Renaming ' || tempName || ' to ' || tblName);
dbms_pipe.pack_message('cmd /c del e:\oradata\HCM90\' || tblName || '.DBF');
osOutput := dbms_pipe.send_message('HOST_PIPE');
dbms_output.put_line('Deleted e:\oradata\HCM90\' || tblName || '.DBF -- ' || osOutput);
end;
