-
PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record.Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables?
PSRECORDNAME
karam_amit
- Dec 6th, 2008
System Tables Will Have Convention as " PSREORDNAME" and Non System table will have as "PS_RECORDNAME"Where in the above both the cases the RECORDNAME is the name of the actual record.
priya
- Mar 21st, 2006
peoplesoft categorises tables into 3 types with naming convention assystem catalog tables start with sys like systables, syscolumns, sysindexespeopletools tables psrecdefn application tables ps_recname.
-
Difference between Save PreChanges and Save PostChanges w.r.t saveedit?
dharmendragohil
- Nov 20th, 2008
Save pre event is mainly use for checking validation and Save Post is mainly use for DML Statments like Insert and Update on the basis of validation.
priya
- Mar 21st, 2006
save edit validates data and gives messages or warnings.when no error/warnings exist then saveprechange fires. it helps by doing one last check before the save process. save post change...
-
Table set sharing and Set ID
What is Table set sharing and Set ID?What is the difference between Master table, Transaction table and Control table?
PeoplesoftSarada
- Nov 7th, 2008
Set ID is the highest level key in Peoplesoft. Its very important to understand the concepts of SET ids and table set sharing for the purpose of centralisation and decentralisation of data. Control ta...
-
Verbal Report
Would you rather write a report or give a verbal report? Why?
-
SQL injection what is it?
hemsiri
- Jul 15th, 2008
SQL injection is a technique that exploits a security vulnerability occurring in the database layer of an application. The vulnerability is present when user input is either incorrectly filtered for s...
-
What the main differences between versions of the foll.Peoplesoft CRM 8.8 and CRM 8.9? Peoplesoft HRMS 8.8 and HCM 8.9? Peoplesoft Finance 8.8 and 8.9?
kishorev1
- Jun 21st, 2008
Peoplesoft 8.9 came up with AAF (Active Analytics Framework), a powerful front end tool for workflow, which was absent in 8.8 crm (though 8.8 has workflow, its not that powerful) as 8.8In generic 8.9 ...
-
AE actions
What is the difference between dowhen and doselect?
sharathkedika
- Jun 15th, 2008
Sry ....DoWhen is some thig like IF statment. it is the first acation in execution order. if the query written in the Do When action returns any rows then the subsequent actions will be executed.In a simple way DoWhen is a conditional actionDoSelect is a looping action
sharathkedika
- Jun 15th, 2008
DoSelect : here we don't need to increase the counter. pointer to the next row in the selected data will be moved automatically.DoWhen: here we need to write the select query to skip the processed row.
-
Load look up in sqr, where did you use?
Ariraj S
- Sep 5th, 2005
The LOAD-LOOKUP command defines an array containing a set of keys and values and loads it into memory. The LOOKUP command looks up a key in the array and returns the associated value. In som...
-
Which of the following record is not found in database?
Derived work record
mitra
- Sep 22nd, 2005
Derived work record,dynamic view and sub record
-
Differences between role and operator class?
arunkumar061
- Apr 30th, 2008
role: it is nothing but group of doing same work.operator: it is adding a permission list to the user.
PeopleSoft Tech
- Aug 21st, 2006
Role contains the opertaor class. Operator class is basically a permission list and permission list are included a roles.
-
What is the difference between SaveEdit and FieldEdit?
nsivudu
- Mar 27th, 2008
Save Edit people code performs once the user tries to save the component. It is used to validate data before it is updated on the database.Field Edit People code is performed after a field has changed...
arundgati@yahoo.com
- Jun 21st, 2006
Field edit can be used to locally check the syntactial errrors made by end user( mostly). It can be used for conplex checking operations too but rarely.Save edit is used to check the logical existance...
-
Why temporary records are needed?
nsivudu
- Mar 27th, 2008
Temporary table can be used in application engine programs to support parallel processing and better performence
Ruchi Bhardwaj
- Aug 21st, 2006
AE programs run in batch mode so the multiple instances of the same program gets created and due to this the deadlock situation can come. To avoid this situation peoplesoft provides the concept of tem...
-
What is a state record?
nsivudu
- Mar 27th, 2008
The State record is used to pass variable information between the application engine sections
natarajcheedella
- Nov 8th, 2006
State Record is used to pass the values from sections to sections and actions to actions. State record is not a temporary record, it can be Sql record or derived work record. Mainly sql reco...
-
One-to-Many?
Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table.
-
What are the difference between AE and SQR?
Answered by Leah on 2005-05-09 12:39:03: AE are maintained with in PeopleSoft, with in Application Designer SQRs are a 3rd party software and not mainteinted with in PS, therefore need a separte upgrade process
nsivudu
- Mar 17th, 2008
Application Engine is used for batch processing where you have a large (or small) amount of data that needs to be processed with out user intervention. we can develop Application Engine with...
chinese nerd
- May 30th, 2006
In addition, AE has a restart ability, which is SQR does not have restart ability
-
What is the use of process profile?
(scenario based on process profile / process group)Server o/p path override , process he can access
cnd181
- Dec 18th, 2007
Process profile give information regarding server and destination along with the printer. It also provide option of viewing and updation of process by owner only , by all or by none.
-
-
Menu path provides path to?
Component
-
What is the difference in using SQL directly and calling SQL from Peoplecode in Application Engine?
surender_engg
- Dec 11th, 2007
Hey Priya, If you use SQL directly then it will go to database directly to fetch rows of data. But if u write SQL'S in peoplecode, den the trip will be from application server to databas...
-
Peoplesoft Interview Questions
Ans