PSDDLDEFPARMS This table holds the storage structure of the tables for db platforms PSGATEWAY This table hold the gateway url. PSIDXDDLPARM This table holds the storage structure of the indexes for db platforms PSPROJECTITEM Project info PSRECDEFN This table holds the information of all the p...
PSPROJECTITEMtable stores objects inserted into your Application Designer project. Try it out: SELECT * FROM PSPROJECTITEM WHERE PROJECTNAME = 'Your_Project_name'; Portal Structure PSPRSMDEFNis a Portal Structure Definition table. A good example is to use this table to find portal path for a s...
Accounting entries are created to record accruals, payments, payment cancellations, manual closures, project activities in general ledger, and so forth (depending on the application). Accounting Entry Template A user-defined table that controls the use of system-generated accounting lines in the ...
Other Sources of Information In the planning phase of the implementation, take advantage of all PeopleSoft sources of information, including the installation guides, table-loading sequences, data models, and business process maps. A complete list of these resources appears in the preface of the ...
Having said that, my “GoTo” table for field reference in SQL is PSRECFIELDDB. This PeopleTools table has all the record fields broke out of the many layers of sub-records on PSRecDefn SELECT FIELDNAME FROM PSRECFIELDDB WHERE RECNAME = '[RECNAME]' ...
WHERE projectname = l_projectname; END; END; Conclusion The effect on my demo HCM8.9 system was to reduce the total number of temporary table instances from 5942 to 5106, a 14% reduction. However, when I tried this on an HCM9.0 system, I got a reduction of only 7%. This shows that...
2. Customer Item X-Reference Specify the code that the system uses to search and display cross-reference information using a customer's item number. Cross-references associate internal item numbers with customer item numbers. You set up items in the F4104 table and create the cross-reference ...
Function and Data Processing Controls Grid Scroll area .. PAGE介绍-各种Page Control实例 Image,需要指定其图象源 有Prompt Table的Edit Box 一般对应于有Translate Value的字段 需要放在一个Group Box中,并在Page Order上紧跟于Group Box之后 Sub Page 横线 特殊功能:将其后的Control都设置回Level 1 Tree控件 ...
1.ApplicationDesinger概述 ApplicationDesinger的初级功能 开发PeopleSoft的基本定义 FieldRecordPageComponentMenu SQL片断 HTML片断 管理PeopleSoft应用程序的开发过程 维护peoplesoft应用程序 4 ApplicationDesinger的中级功能 为简单的Component嵌入反映业务逻辑的代码 PeopleCodeProgram 开发Peoplesoft与其他应用系统的接口(非实时...
1.ApplicationDesinger概述 ApplicationDesinger的初级功能 开发PeopleSoft的基本定义 FieldRecordPageComponentMenu SQL片断 HTML片断 管理PeopleSoft应用程序的开发过程 维护peoplesoft应用程序 4 ApplicationDesinger的中级功能 为简单的Component嵌入反映业务逻辑的代码 PeopleCodeProgram 开发Peoplesoft与其他应用系统的接口(非实时...