1. Development Guidelines for Application Design Guide
  2. Adding a Table

Adding a Table

Before adding a new table, determine whether an existing table contains the data items required by the application. If an existing table does not exist, you must add a new table.

When you add a new table, you must include these audit trail columns:

  • User ID (USER)

  • Program ID (PID)

  • Machine Key (MKEY)

  • Date Updated (UPMJ)

  • Time of Day (UPMT)