MAINTAIN TABLE DETAILS#
The Maintain Table Details (IMTD) screen is used to view supplied information. Most of the information on this screen has been supplied and should not be altered. Some values that are user changeable are:
- Disable Logging
- Retained Periods
- Period Type
- Purge Date
The definition data for the Maintain Table Details screen is stored in the P2K_AM_TABLE_DETAILS, P2K_AM_DATA_ACCESS_OBJECTS and P2K_AM_FORM_TABLE_USAGES tables.
- Product
- This field displays the product the table is associated with.
- Table Alias
- This field provides the abbreviated table identifier.
- Table
- This field identifies the table being defined.
- Description
- A short description of the table is provided in this field.
Table Details tab#
- Notes Not Allowed
- This field, set by the system, identifies if notes are permitted to be attached to the table.
- User Fields Not Allowed
- This field, set by the system, identifies if User Defined Fields are permitted on the table.
- Logging Not Allowed
- This field, set by the system, indicates if logging is even permitted on this field/table. Some tables do not make sense to log, due to their volatility or transactional nature.
- Historical Table
- This optional toggle indicates that the table contains date-sensitive information.
- Disable Logging
- DISABLE_LOGGING is an optional toggle field. When checked, the field or table that it pertains to will no longer be logged for audit purposes.
- Table is Cached
- This is a toggle which indicates if the data within the table is 'cached', in other words is the data stored in a temporary storage area or is it accessed directly from the database. Caching tables improves the query performance of the application.
- Clear Table Cache
- If necessary the user may clear the table's data from the cache. This may be necessary if changes to the data within the table are not refreshing for the users.
- Clear All Cached Tables
- This action button will clear data from ALL of the cached tables, not just the one selected in the find block.
Form Usage tab#
This tab displays any function that utilizes the specified table as a data source.- Function
- The name of the function that uses the table.
- Usage
- This field indicates if the function was predefined by the application or if the function was created by the client.
- Where Clause
- This field indicates if a where clause was added to the table's usage in the form definition.
- Usage
- This field identifies if the form's usage of the table has been predefined by the application or if it was added by a client.
- Create/Retrieve/Update/Delete Allowed
- These fields indicate the security access defined at the function's level.
