Understanding Keys


Concept


Steps:

  1. A field or a combination of fields uniquely identifies every row in a table in your PeopleSoft database.  For example, a Person ID uniquely identifies each row in the Personal Information table.

    Step 1
  2. The fields that uniquely identify your data are called keys.  To display a page, you enter the search key(s) on the search page so that the system can retrieve the correct row of data.

     

    For example, if you want to review a summary of admissions for an organization, you specify or search for the data by using an Organization ID.

    Step 2
  3. A search record is the list of defined search keys that help you locate data.  The search keys are the fields you are prompted for on a search page.  For example, you can search for an organization by using one or a combination of the keys displayed on this page.

    Step 3
  4. Most transaction pages or components have search records associated with them.  If you select other pages that have a common search record, such as pages within a component or an associated link, you are not prompted to enter search criteria again.  You are prompted for new search keys only when you select a new page outside of a component with a different search record.

    Step 4

In summary, the fields that uniquely identify your data are called keys.

Table of Contents  Start Topic