Understanding Keys 
- A field or a combination of fields
uniquely identifies every row in a table in your PeopleSoft database. For
example, an Employee ID
uniquely identifies each row in the
Personal Information table. [ go
]
- 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 the history of
the hot jobs that are posted in your organization, you must specify or search
for the jobs by using a Job
Requisition ID. [ go
]
- 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 the status of a
requisition by using one or a combination of the keys displayed on this
page. [ go
]
- 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. [ go
]
In summary, the fields that uniquely identify
your data are called keys.
[ Start
Topic ] | [ Return
to Table of Contents ]