Adding a New High-Level Key


Concept


Steps:

  1. A high-level key is a unique piece of data that is specific to only one record in the database table(s). For example, an Employee ID is unique to just that employee, regardless of other employee details, such as last name, address, and date of hire.

    Step 1
  2. Sometimes it is not feasible to use one specific key to identify a row of system data. For these circumstances, PeopleSoft also accommodates a multi-part key. In the table below, there are five separate rows of data for Employee KC0032. The high-level key for this table is the Employee ID.

    Step 2
  3. However, with this key alone, there is no distinction between Amanda Agnew, Brian Avery, Harris Smythe, Lynda Penrose, or Sean Jones. If you queried the database by Employee ID alone, you would receive all five of the data rows above.

     

    You can use a multi-part key to help you with these types of queries. Using both the Employee ID and the Contact Name fields to access the data, you are ensured to receive the correct information.

    Step 3
  4. To enter a new high-level key into the database, use the Add action type. For example, your organization has entered all current employees into the PeopleSoft database. This enables updates to personal information and employee status changes.

     

    When a new employee is hired by the organization, you must create a new high-level key, and add the employee to the database. Otherwise, a database record will not be available. This key becomes the unique identifier, or Employee ID, and is used to access this employee's record.

    Step 4
  5. The file cabinet graphic below represents a PeopleSoft database in your organization. The cabinet contains all your company's employee information.

     

    To ensure that you retrieve the correct file folder from the file cabinet, each is labeled with an Employee ID. The Employee ID is considered a high-level key. In other words, it uniquely identifies one employee file from another.

    Step 5
  6. You may want to access Susan Jones' personnel file. However, there may be three people named Susan Jones within the company. How do you know which Susan Jones file to access?

     

    If you were simply to open the file cabinet, it would take some time to find the correct file folder. However, by uniquely identifying data with a high-level key, PeopleSoft can determine an exact match to a particular piece of data within the system. This makes data retrieval much more efficient and accurate.

    Step 6
  7. To add a high-level key to the database, you need to determine exactly what you want to add and where it is located within PeopleSoft.

     

    For this example, your institution has added a new building, the Warren Science Library. You need to add the Building ID and corresponding building information to the database.

     

    Click the Building Table link.

    Step 7
  8. Click the Add a New Value tab.

    Step 8
  9. The key field is Building. See what happens if you enter an ID that already exists.

     

    Enter the desired information into the Building field. Enter

     a valid value
     e.g.
     "WARR"
    .

    Step 9
  10. Click the Add button.

    Step 10
  11. A message appears telling you that this value already exists. You can either modify this one or specify a new value.

     

    Click in the Building field.

    Step 11
  12. Enter the desired information into the Building field. Enter

     a valid value
     e.g.
     "WARRL"
    .

    Step 12
  13. Click the Add button.

    Step 13
  14. The Building Table page is displayed. You need to enter all required information before you can save the page.

     

    Enter the desired information into the Description field. Enter

     a valid value
     e.g.
     "Warren Science Library"
    .

    Step 14
  15. Click in the Short Desc field.

    Step 15
  16. Enter the desired information into the Short Desc field. Enter

     a valid value
     e.g.
     "WSL"
    .

    Step 16
  17. All the required information has been added, and you can now save the page.

     

    Click the Save button.

    Step 17
  18. With the Add action, once a page has been saved and data has been committed to the database, you can continue to add additional high-level keys. Perhaps there is another new building that needs to be added.

     

    You can easily continue by clicking the Add button on this page.

     

    Click the Add button.

    Step 18
  19. The system returned you to the Add a New Value page for the component. Once a high-level key has been added and committed to the database, it can only be accessed using the available action types assigned to that component.

    Step 19

You have successfully added an new high-level key to the database.

Table of Contents  Start Topic