Understanding Keys


Concept

During this topic we will identify and explain (data) keys.


Steps:

  1. Click the Workforce Administration button.

    Step 1
  2. Click the Personal Information menu.

    Step 2
  3. Click the Modify a Person menu.

    Step 3
  4. A field or a combination of fields uniquely identifies every row in a table in CONNECT database.  For example, a Person ID uniquely identifies each row in the Personal Information table.

    Step 4

  5. 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 5

  6. 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 absence history for your employees, you must specify or search for the data by using the Person ID.

    Step 6

  7. 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 employee by using one or a combination of the keys displayed on this page.

    Step 7

  8. Click the Home link.

    Step 8
  9. Click the Sign out link.

    Step 9

You have completed reviewing the Understanding Keys topic.

Table of Contents  Start Topic