myPeopleSoft

PeopleSoft Community Network

Bonita Northington's Likes

June 2013

How to read DataSelection and DataSequencing… I am building a report which will print DataSelection and Data Sequencing for all the reports.This information is stored in Central Objects.Can anybody tell me in which table it is stored. Discussion How to read DataSelection and DataSequencing… 6 Likes

May 2013

Talent Summary

video Talent Summary 32 Likes Record Keys and Field Attributes SQL !! SELECT r.recname, r.fieldname, l.longname, l.shortname, decode(f.fieldtype, 0, 'Character', 1, 'Long Character', 2, 'Number', 3, 'Signed Number', 4, 'Date', 5, 'Time', 6, 'Date Time', 8, 'Image', 9,… Discussion Record Keys and Field Attributes SQL !! 2 Likes Get high level list of peoplesoft Customisat… SELECT *FROM(SELECT DECODE(recdescr,' ',''''||recname||'''',recdescr),recname ,rcount,'Select '''||DECODE(recdescr,' ',recname,recdescr)||''''||DECODE(rcount,4,','' ''')||REPLACE(rtrim(MAX(SYS_CONNEC… Discussion Get high level list of peoplesoft Customisat… 5 Likes