Field Change
22. Types of SQL objects used in peoplecode?
PeopleSoft HRMS
20. Which fields will be loaded into component buffer if a component is opened? i.e. if there are 10 fields in a record and only 3 fields are placed on the page then all the remaining fields will be available in the
component buffer or only those fields which are placed on the component?
a. All fields will be available in component buffer. For search record only those fields which are there in search dialog.
21. How to retrieve/assign a record field, which is not placed in the component?
Using Createsql n createrecord n sqlexec function .
The CreateSQL function create a SQL object from the SQL class and opens it on the given sqlstring and input values. That sql object can be used with array or with fetch stmt to access the value.
e.g.
&Sql1 = CreateSql("Select * from " | &TableName);
&AAny = CreateArrayAny();
While &Sql1.Fetch(&AAny)
/* Process the row in &AAny. */
...
End-While;
CreateRecord creates a standalone record definition and its component set of field objects. The specified record must have been defined previously, that is, it must have a record definition. However, if you are calling this function from PeopleCode associated with a page, the record does not have to be included on the current page
22. Types of SQL objects used in peoplecode?
a.
PeopleSoft HRMS
51 24. Name the objects used in peoplecode?
a. RowSet, Row, SQL, RecordSet
25. When can you attach PeopleCode with a push button? What are the events that are triggered with a push button action?
When a Push Button is tagged to a derived record peoplecode can be llinked to it.
recordfield field change event is triggered with a push button action.
PeopleSoft HRMS
HRMS
1.What are the Major changes in 7.5 and 8.8 PeopleTools.
2.HRMS Data flow.
3.Recruit WorkForce Dataflow.
4.What is SETID and Business Unit.
5.What is the use of Structured ID in Tree Manager.
6.Moment you Enter Business unit what are the other fields get defaulted 7. How do you build the Departmental Security
8 What is the Permission List and Role?
9.How do give the access to page
10. What is the primary permission List in HRMS 8.8
11.After Building the tree, which is the process you need to run.
12.what are the three steps to setting up the employee data security Security –
Row-Level Security
With row-level security, users can have access to a table without having access to all rows on that table. This type of security is typically applied to tables that hold sensitive data. For example, you might want users to be able to review personal data for employees in their own department, but not for people in other
departments. You would give everyone access to the PERSONAL_DATA table, but would enforce row-level security so that they could only see rows where the DEPTID matches their own.
SQR 20. What are the common SQC‘s used in Report 21. How many section are available in SQR 22. Which is the Required Section in SQR
23. What is difference between Begin-Report and Begin-Program.
24. Can you write Select statement in Begin-SQL Section 25. How do you call the procedure in SQR
26. What is the difference between Display and Show command 27. Can you print the result on one line using Display command.
28. What are the parameters required to connect the database using SQR 29. Can you tell us the SQR report execution flow using Process Scheduler.
30. What are the type of variable used in SQR
31. What is the difference between LET and MOVE command 32. What is the use of ON-BREAK.
33. What is the purpose of -F flag and –O flag
34. What is the difference between ASK and INPUT command.
35. What is Load-Lookup
36. What is the relevance of –ZIF and –ZIV flags 37. What prcsapi.sqc written
38. Can you override the setting in SQR
PeopleSoft HRMS
53 14. How to build the Record
15. What is the difference between Search key and Alt search key 16. What is the use of List box item in record field properties 17. What is the length of translate value
18. What is the different type of Record definition (7) SQL Table
19. What is the difference between Prompt table and Translate Table Prompt table :
Promt table is physical table that can be attach to certain field. Then we can select value for that field from that physical table.
Translate table :
The Translate Table is a prompt table, which is similar to an all-purpose data dictionary, to store values for fields that don’t need individual prompt tables of their own. As a general rule, store field values in the Translate Table if the field meets the following criteria:
Field type is Character.
Field length is 1 to 4 characters.
Field values consist of a relatively small, static set of values that are not maintained by the user.
No other fields relate to this field.
20. What is the derived record and what is the use of it
Select to define the record definition as a temporary workspace to use during online page processing. A derived or work record is not stored in the database, so you do not build it.
21. What is the concept of parent-child record
If any record has Parent record the specify parent record at record property- use tab.
The keys that you establish in a parent record definition determine which keys are required in child record definitions. The child must have the same keys as the parent, plus one or more keys that uniquely identify each row.
22. What is the use of Add Search Record in component properties 23. What is the difference between Sub page and Secondary page 24. Name the some page control
Application Engine
PeopleSoft HRMS
9. What is the use of state record 10. What is the use of Temporary record
11. What are the actions available in app engine in PS 8.8
12. What is the difference between 7.5 app engine debugger and 8.8 Debugger 13. What is the structure of an application engine program
14. What is the difference between Do select and Do When
15. Can you use Call App Engine in App engine Program Peoplecode 16. How do you Schedule the app Engine
17. what is the extension of state record.
Peoplecode
19. give the sequence in which the events are fired in application processor flow 20. What is the difference between Rowset and Standalone rowset
21. How many levels we can use on one page 22. What is component buffer
23. What is the use of workflow event
24. While creating the workflow what are the three objects used 25. What is the use of sub record
26. What is the difference between Save prechange and save postchange event 27. What is the difference between prebuild and postbuild event
28. What is page activate event does
29. Which event fire first Record field or Component record Field 30. Name of the objects used in people code
31. What is the difference between the 7.5 and 8.8 security aspects 32. How do you open the secondary page using the peoplecode 33. What is the use of effective data
34. How many rows SQLEXEC return 35. What does the Setcursorpos do
36. Have u debug the Peoplecode?? Explain it
37. What is the difference between Field change and Fieldedit event and which fire first 38.
Miscellaneous
8. What is the used of component Interface 9. What are the method available in CI 10. Can you define your own method 11. How do you connect PS using CI 12. What do mean by session object 13. What is the collection
14. What is the difference between Runtime plugin and design time plugin
PeopleSoft HRMS
55 What difference is there in AE75 and AE84?
What is the purpose of temperory record and state record?
What the events of components and when /why are they used?
Why use work records when we have variables?
What does session object signify in the CI?
What are the various append modes for a file?how will you append in the beginning?
What are the common sqc's? why are they used?
Written any SQR processess?
What is the difference between Do Select & a Do When?
In a Do Select when using a Restartable AE what care shoud be taken by the programme while writting the code?
Can work records be used in a Reselect?
Have you done debugging of an application Engine?
Can we make use of work records and sil make it restartable?
+++++++++++++++++++++++++++++++++++++++++++++++++
CHECK OUT MORE QUESTIONS INCLUDING ABOVE ONCE AND ALMST ALL ANSWERED..PLEASE BE CAREFUL
01. What difference is there in AE75 and AE84?
a. In 7.5 AE is the separate tool where in 8.4 it is a part of application designer i.e. Object.
b. In 8.4, you can associate peoplecode with Application engine.
c. In 8.4, you can access all application designer objects from Application Engine 02. What is the purpose of temporary record and state record?
a. Temporary record is generally used in processing of data on large volumes.
b. State record is like variables which contain only one row of data and used to pass values from one section to another section.
03. What the events of components and when /why are they used?
a. FieldEdit, FieldChange, SavePreChange, SavePostChange. These events are used to write component specific code.
04. Why use work records when we have variables?
a. Variables hold the values until the program ends or the component is changes where work record can hole multiple rows of data and it is available across all events.
b. Work records can also used to attach to PushButton and hyperlink or objects.
05. What does session object signify in the CI?
a. Session objects are used to connect CI with PS application. You can multiple session objects while connecting PS to third party application.
06. What are the various append modes for a file? How will you append in the beginning?
a. Never come across using FILES.
07. What are the common SQC's? Why are they used?
a. Setenv.sqc, setdec32.sqc, sqrtrans.sqc, prcsapi.sqc, prcsdef.sqc, reset.sqc, curdttim.sqc, datetime.sqc, number.sqc, readxlat.sqc, datemath.sqc.
08. Written any SQR processes?
a. Yes
09. What is the difference between Do Select & a Do When?
a. Do select is loop and Do when is like if condition.
PeopleSoft HRMS
10. In a Do Select when using a Restartable AE what care should be taken by the programmer while writing the code?
a. Use Re-Select type of Do select.
11. Can work records be used in a Reselect?
a. No.
12. Have you done debugging of an application Engine?
a. Yes.
13. Can we make use of work records and still make it restartable?
a. No.
14. What is Component Buffer?
a. Whatever data is fetched from database while populating component will kept in temporary memory of application server i.e. called as component buffer.
15. Use of SQLExec?
a. SQL Exec is used to perform DML operations but SELECT statement returns only one row.
16. What is dynamic view?
a. Dynamic view is temporary view created at run time dynamically for processing.
17. If you get an error in SQR log Inspite of you getting the report output; what type of error is it & why?
18. What is the difference between FieldChange and FieldEdit?
a. FieldEdit executes to validate new value in field where FieldChange does processing for new value entered.
19. What is Page Activate Event?
a. Page activate is fired every time the page is get focused.
20. How many scrolls can there be on a page?
a. Three
21. What is a prompt table?
a. Prompt table is to get valid data.
22. Actions in Application engine. Different types of application engines?
a. Actions- PeopleCode, Do when, Do select, Do While, Do Until, SQL, Call Section, XSLT, Message Log
b. Types - Standard, Upgrade, DEAMON, Transform, Import Utility.
23. Export & Import of data via AE? (Have u done it anywhere) a. No.
24. How to refer a field value in Scroll level three?
PeopleSoft HRMS
57 How many sections
which is the mandatory cna u write sqr using single section and which what is break?
can u have multiple heading in sqr 1 heading but 1 header section How to call diff processes or sqr from sqr.
==========================================================
===========
01. What difference is there in AE75 and AE84?
a. In 7.5 AE is the separate tool where in 8.4 it is a part of application designer i.e. Object.
b. In 8.4, you can associate peoplecode with Application engine.
c. In 8.4, you can access all application designer objects from Application Engine 02. What is the purpose of temporary record and state record?
a. Temporary record is generally used in processing of data on large volumes.
b. State record is like variables which contain only one row of data and used to pass values from one section to another section.
03. What the events of components and when /why are they used?
a. FieldEdit, FieldChange, SavePreChange, SavePostChange. These events are used to write component specific code.
04. Why use work records when we have variables?
a. Variables hold the values until the program ends or the component is changes where work record can hole multiple rows of data and it is available across all events.
b. Work records can also used to attach to PushButton and hyperlink or objects.
05. What does session object signify in the CI?
a. Session objects are used to connect CI with PS application. You can multiple session objects while connecting PS to third party application.
06. What are the various append modes for a file? How will you append in the beginning?
a. Never come across using FILES.
07. What are the common SQC‘s? Why are they used?
a. Setenv.sqc, setdec32.sqc, sqrtrans.sqc, prcsapi.sqc, prcsdef.sqc, reset.sqc, curdttim.sqc, datetime.sqc, number.sqc, readxlat.sqc, datemath.sqc.
08. Written any SQR processes?
a. Yes
09. What is the difference between Do Select & a Do When?
a. Do select is loop and Do when is like if condition.
10. In a Do Select when using a Restartable AE what care should be taken by the programmer while writing the code?
a. Use Re-Select type of Do select.
11. Can work records be used in a Reselect?
PeopleSoft HRMS
a. No.
12. Have you done debugging of an application Engine?
a. Yes.
13. Can we make use of work records and still make it restartable?
a. No.
14. What is Component Buffer?
a. Whatever data is fetched from database while populating component will kept in temporary memory of application server i.e. called as component buffer.
15. Use of SQLExec?
a. SQL Exec is used to perform DML operations but SELECT statement returns only one row.
16. What is dynamic view?
a. Dynamic view is temporary view created at run time dynamically for processing.
17. If you get an error in SQR log Inspite of you getting the report output; what type of error is it & why?
18. What is the difference between FieldChange and FieldEdit?
a. FieldEdit executes to validate new value in field where FieldChange does processing for new value entered.
19. What is Page Activate Event?
a. Page activate is fired every time the page is get focused.
20. How many scrolls can there be on a page?
a. Three
21. What is a prompt table?
a. Prompt table is to get valid data.
22. Actions in Application engine. Different types of application engines?
a. Actions- PeopleCode, Do when, Do select, Do While, Do Until, SQL, Call Section, XSLT, Message Log
b. Types - Standard, Upgrade, DEAMON, Transform, Import Utility.
23. Export & Import of data via AE? (Have u done it anywhere) a. No.
24. How to refer a field value in Scroll level three?
25. Name the joins used in SQL?
a. Inner Joins, Outer Joins, Self Join
26. How to open a secondary page through the PeopleCode? And how to refer the fields in the secondary page?
PeopleSoft HRMS
59 a. SearchInit, SearchSave, RowSelect, PreBuild, FieldDefault, FieldFormula, RowInit,
PostBuild, Activate
b. RowInsert, RowDelete, SaveEdit, SavePreChange, Workflow, SavePostChange, PrePopup, ItemSelected.
28. Field Length of Translate value?
a. Field Length – 4
29. Difference between prompt table and translate table?
a. Prompt table get the list from Physical table or view, which can be updated from front end.
b. Translate table lists the pre-defined values for that field.
30. Use of effective date?
a. To maintain present, past and history data.
31. Types of tables are allowed as a state records in AE.
a. SQL Table, Derived work record where name ending with AET.
32. Which fields will be loaded into component buffer if a component is opened? i.e. if there are 10 fields in a record and only 3 fields are placed on the page then all the
remaining fields will be available in the component buffer or only those fields which are placed on the component?
a. All fields will be available in component buffer. For search record only those fields which are there in search dialog.
33. How to retrieve/assign a record field, which is not placed in the component?
a. Record.RECORDNAME.FieldName.FieldValue 34. Types of SQL objects used in peoplecode?
a.
35. Difference between the 7.5 and 8.4 in security aspect?
a. Role is main layer added in 8.4
36. Name the objects used in peoplecode?
a. RowSet, Row, SQL, RecordSet