Peoplecode array functions


  • What is PeopleSoft built on?
  • Perl | Arrays (push, pop, shift, unshift)
  • How to Use Split Function Peoplesoft in Peoplecode
  • Function – Separate Filename from File Path
  • PeopleCode functions All/None on a Array Object
  • PeopleSoft Interview Questions And Answers For Experienced
  • What is PeopleSoft built on?

    Output Window — Deals about the output generated by using project development or up gradation. How is data stored, retrieved, manipulated and processed in People soft applications? A PeopleSoft is a table-based system and it contains three major sets of tables, 1. System catalog tables; it stores physical attributes of tables and views. Sys, Columns, Sys tables 2. People Tools tables; it contains information that you define using People Tools e.

    Application Data Tables; Store the actual data users enter and access through People Soft application windows and pages. Define a Field, Field attributes, and Field properties? A Fields are basic building blocks in People soft and can be used in application when they are added to at least one record. Fields are globally defined. The common filed attributes are: 1. Data type 2. Field name 3. Long name 4. Short name 5. Formatting 6. Help context number 7. Fields are: 2.

    Reusable components and can be shared across multiple record definitions 3. A change to the Field properties affects all the records that include the field. Explain briefly about record properties? A KEY: The record knows a field, which uniquely identifies each row, as a key. We will search and retrieve data from the database according to the key field. This will not allow duplicate and null values.

    It is a primary key It allows multiple keys Maximum keys allowed in a record is 15 It should be placed at the top of the record definition. Duplicate Order Key: 1.

    It provides a way of ordering data in the table when the duplicate values are allowed. It will create index for the column. However the index can be disabled. Alternate Search key: 1. Due to alternate search key the system becomes slow, because database index will be created when SQL creates the tables, so it will consume the disk space.

    It allows duplicate values. Descending order key: It is used to retrieve data in the form of or C-B-A and normally it is used in Effective date. How many types of securities are available in People soft? A There are 6 types of securities: 1.

    Network security 3. Operator security 4. Object security 5. Tree level security 6. Query security row level security Types of Menus? Standard menu: It appears in the menu bar of a PeopleSoft application.

    Popup menu: Allows the user to navigate related information in other areas of application by right clicking on a page or component. What is the difference between Key and alternate search Key? A KEY-It is the primary key of the record. Can be used as search key or need not be. Alternate search key-it is used for searching purposes. Can update only future rows. Correction — can view and update history, current and future rows.

    What types of audits are supported by people soft? In case of record level audit what is the structure of table? A We have field level audit and record level audit. What are Table Edits? What conditions are required to establish parent child relationship between two records?

    What are the advantages with that? A Conditions are: 1 The child record should have all the key fields of parent record and at least one more key field other than the key fields of parent record. Advantages are: 1 To have referential integrity. Can you place Sub page into Grid? If yes How? A Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid.

    When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.

    PeopleSoft Interview Questions on Peoplecode Can you hide a primary page in a component? A No we cannot hide the primary page of a component. What is an Expert Entry? A Expert entry enables a user to change from interactive to deferred mode at runtime for appropriate transactions What is Auto Update? What is Record Group? Which records can be included into a record group? A Record group consists of records with similar functionality. To setup a record in record group we should enter a set control field value in record properties How can you improve the security and usability of a Prompt table edit.?

    A Prompt table view What are the different ways to setup row level security? A We can setup row-level security using a SQL view that joins the data table with an authorization table. And by having Query search for data using a query security record definition. The query security record definition adds a security check to the search.

    How does PeopleSoft use views? Which are online functions? A People soft uses views for search records, summary pages, prompt views, reports Search records and summary pages are online functions. Why do PeopleSoft often use views as search records? A Search views are used for three main reasons. How can a component have more than one search record? Give a situation. A You might want to reuse the same component multiple times with different search records.

    You can accomplish this by overriding the component search record at runtime when the component is opened from a menu item without creating separate copies of the component.

    The component override is temporary and occurs only when the component is opened from the menu item in which the override is set.

    It does not change the component definition. What is PIA and what are its components? A It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. In database server we have system tables, peopletools tables and application tables.

    Differentiate Field edit and Save edit? A In Field edit for each field change, a transition to the application server to the database is taken place. In Saveedit for all the fields , only one transition to the application server to the Database is taken place. What are think time functions? A Think-time functions suspend processing either until the user has taken some action such as clicking a button in a message box , or until an external process has run to completion.

    Perl | Arrays (push, pop, shift, unshift)

    System variables and User defined variables. Scope Component Local Q Can update only future rows. Correction: can view and update history, current and future rows.

    If Yes How? Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid. What Is An Expert Entry? Expert entry enables a user to change from interactive to deferred mode at runtime for appropriate tractions Q We have field level audit and record level audit.

    Primary permission list is used for mass change and definition security purposes. Search views are used for three main reasons. Adding criteria to the search dialogue page Providing row level security Implementing search page processing Q SqlExec me it bypasses the component buffer and it is directly contacts database to retrieve data.

    But it retrieves the data row by row and not possible for bulk insert. But in the case of Create SQL we can able insert the data in bulk. To give access to the records that are to be used in query, we have create a new query security tree and add the records which we want to give the access and then assign a access group to the tree.

    After that we have to add that query tree and query access group to the permission list. Returns U — for Update mode Q Conditions are: The child record should have all the key fields of parent record and at least one more key field other than the key fields of parent record. We should mention the parent record in the record properties of child record. Advantages are: No need to enter information again and again Q Give A Situation?

    You might want to reuse the same component multiple times with different search records. You can accomplish this by overriding the component search record at run-time when the component is opened from a menu item without creating separate copies of the component.

    The component override is temporary, and occurs only when the component is opened from the menu item in which the override is set. It does not change the component definition. What Are Think Time Functions? Think-time functions suspend processing either until the user has taken some action such as clicking a button in a message box , or until an external process has run to completion.

    No we can not hide the primary page of a component. If the component had only one page then by making this page also invisible we wont have any component existing so we are not allowed to hide the primary page.

    KEY-It is the primary key of the record. Can be used as search key or need not be. Alternate search key-it is used for searching purposes.

    Component buffer contains all the data of the active component. Data buffer contains the data other than the data in the component buffer Data of other records Search for:.

    How to Use Split Function Peoplesoft in Peoplecode

    Function – Separate Filename from File Path

    You might want to reuse the same component multiple times with different search records. You can accomplish this by overriding the component search record at run-time when the component is opened from a menu item without creating separate copies of the component. The component override is temporary, and occurs only when the component is opened from the menu item in which the override is set.

    It does not change the component definition. What Are Think Time Functions? Think-time functions suspend processing either until the user has taken some action such as clicking a button in a message boxor until an external process has run to completion.

    No we can not hide the primary page of a component. If the component had only one page then by making this page also invisible we wont have any component existing so we are not allowed to hide the primary page.

    KEY-It is the primary key of the record. Can be used as search key or need not be.

    PeopleCode functions All/None on a Array Object

    Alternate search key-it is used for searching purposes. Component buffer contains all the data of the active component. Which are the Think-Time functions in PeopleSoft? Think-time functions suspend processing either until the user has taken some action such as clicking a button in a message box or until an external process has run to completion for example, a remote process.

    Which event is triggered when we click a button on a page in PeopleSoft? PeopleCode programs started by button are placed in the FieldChange event.

    PeopleSoft Interview Questions And Answers For Experienced

    In which events, we should not write any error or warning? An error or warning in these events causes a runtime error that forces cancellation of the component. Which function is used to force Save on a page? Now, notice that the third item is the array is also a b, a duplicate item. What happens when we encounter this duplicate item on our third time through the loop?

    Instead, we simply loop around and repeat this process with the fourth item in the array. In order to reconfigure arrItems we first need to redimension the array; that is, we need to reset arrItems so that it will hold only as many items as we have in the Dictionary.

    Count — 1 Note. The first item in an array is always given the index number 0; that means that, in an array with 5 items, the last item will have an index number of 4 the total number of items minus 1. Thus we take total number of items and subtract 1; that gives us the index number that will be assigned to the last item in the array.

    Now all we have to do is fill each of those 5 spots. Is that going to be hard? No, not really.


    thoughts on “Peoplecode array functions

    Leave a Reply

    Your email address will not be published. Required fields are marked *