Append BOA Reserved Columns to Tables Automatically

BOA reserved columns are (required fields are indicated by an *):

• boaStatus*
• AddedOn*
• AddedBy*
• AddedVia*
• ChangedBy*
• ChangedOn*
• ChangedVia*
• LockedOn
• LockedBy
• boaLockType

When the Designer clicks the Append Columns icon on the Page toolbar of the Data Sources page’s Vertical View, the required reserved columns are appended to all of the tables that do not already have them in the database.

Any time a table is added to the data source, click the Append Columns icon to add the reserved columns to the new table.

A Designer can also add these columns manually.

NOTE: LockedOn and LockedBy must be added manually where appropriate. Add these columns for any table where multiple users may be editing the same page at the same time to prevent multiple users from editing the same record at the same time. The boaLockType column is not required, but it is recommended as it stores relevant information.

With the exception of boaStatus, the appended columns should not display on the page so should not be added to the view.

NOTE: If the columns exist on the table, they display in the Information pane below the Navigation pane when a user hovers the mouse cursor over a row’s edit pencil icon. This allows the Designer to exclude the columns from the view, but still display the column's values on the page.