摘要： This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel f... 阅读全文

摘要： PSOPRDEFN - UserIds created. PSCLASSDEFN - Permission List definition. PSROLEDEFN - Role Definition table PSAUTHITEM - Menus, Components and Pages attached to a permission list. PSROLEUSER - Contains ... 阅读全文

摘要： Change control is used in Application Designer to lock definitions and track history changes for each object. Change control can be activated through Application Designer using Tools > Change Control ... 阅读全文

摘要： The sql will identify duplicate objects in different application designer projects to eliminate duplicate work by developers. You will find the SQL very handy during the analysis phase of a peoplesoft... 阅读全文

摘要： In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file. Navigate to th... 阅读全文

摘要： This was kind of interesting to figure out. What I was going after is the following. I had a drop down box on a page that shows some Business Units. The values however need to be dynamic and change de... 阅读全文

摘要： decode(条件,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)该函数的含义如下：IF 条件=值1 THEN　　　　RETURN(翻译值1)ELSIF 条件=值2 THEN　　　　RETURN(翻译值2)　　　　......ELSIF 条件=值n THEN　　　　RETURN(翻译值n)ELSE　　　　RETURN(缺省值)END IF· 使用方法：1、比较大小sele... 阅读全文

摘要： The below function is to be used on a grid with multiple check boxes. Place the code behind a FieldChange event and users will have the option to Select or Deselect grid rows all at once. Fucntion s... 阅读全文

摘要： When you have a grid that is filled with data; data that you don't want. How do you clear it out and then fill it with the data set that you do want? Well, here are the simple steps to do just that. ... 阅读全文

摘要： Local File &MYFILE; Local Record &REC; Local array of string &ARRAY; Local string &FILE_DIRECTORY, &FileName; &FileName = "MY_FILE_NAME.txt"; &FILE_DIRTORY = "/MYDIRECTORY/" /*open file for reading*/... 阅读全文