Understanding Action Types


Concept

During this topic we will review Action Types.


Steps:

  1. Imagine the file cabinet graphic below is a CONNECT database.  The file cabinet is filled with information categorized by folders.  When you use the Add action type, you create a new folder, such as file K0G001 below.

     

    Susan Jones has just been hired by your organization and has been assigned Employee ID K0G001.  This ID is now the high-level key used to differentiate Susan Jones from Arnold Jones, who is also employed within the company.

    Step 1

  2. Susan has now been hired and assigned a CONNECT Employee ID.  She has additional personal information to be added to her records.  To access her employee file, the action type of Update/Display is used.  As its name describes, the action Update/Display enables you to make updates to existing data or to display current data.

    Step 2

  3. Three years have passed since Susan was hired.  In that time, she has changed jobs, moved twice, and gotten married.  You can use the action type Update/Display All to view previously entered (historical) data, in addition to current accessible rows using Update/Display.

    Step 3

  4. It was recently discovered that an error was made when Susan transferred departments.  You can use the action type Correction to make adjustments to errors in the database.  The Correction action type is a powerful tool, and not all users have access to it because of the ability to delete or modify any row of data within the database.

    Step 4

  5. You use four action types to work with data in CONNECT.

     

    You use Add when a new high-level key is required to complete a transaction.

    Step 5

  6. Update/Display is used when retrieving or updating data on non-effective-dated database tables.  If the table is effective-dated, you can use this action to view current and future rows; modify future rows only; insert a new current row or future row.

    Step 6

  7. When you view data using Update/Display All, you will view current, future, and history rows of data.  This is helpful when you want to view historical data.

    Step 7

  8. Correction is the most powerful of all the actions.  You can use it to view, change, or insert rows of data, regardless of the effective date.

    Step 8

You have completed reviewing the Action Types topic.

Table of Contents  Start Topic