This page (revision-25) was last changed on 26-Nov-2021 10:22 by jaiken

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
25 26-Nov-2021 10:22 4 KB jaiken to previous
24 26-Nov-2021 10:22 4 KB jaiken to previous | to last
23 26-Nov-2021 10:22 4 KB JMyers to previous | to last
22 26-Nov-2021 10:22 4 KB JMyers to previous | to last
21 26-Nov-2021 10:22 4 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
IMTD
IMTD

Version management

Difference between version and

At line 1 changed one line
!!!MAINTAIN TABLE DETAILS
MAINTAIN TABLE DETAILS
At line 4 added 2 lines
You may access this feature through the Screens/Forms menu:
Application Administration > System Structures > Maintain Table Details
At line 5 changed one line
%%warning Most of the information on this screen has been supplied and should not be altered.%%
Most of the information on this screen has been supplied by High LineMcKesson and should not be altered.
At line 7 changed 4 lines
* Disable Logging
* Retained Periods
* Period Type
* Purge Date
X Disable Logging
X Retained Periods
X Period Type
X Purge Date
At line 12 changed 45 lines
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|MPD_ID]:This field displays the product the table is associated with.
;[Table Alias|TABLE_ALIAS]:This field provides the abbreviated table identifier.
;[Table|TABLE_NAME]:This field identifies the table being defined.
;[Description|DESCRIPTION]:A short description of the table is provided in this field.
\\ \\
----
!!Table Details tab
;[Notes Not Allowed|NOTES_NOT_ALLOWED]: This field, set by the system, identifies if notes are permitted to be attached to the table.
;[User Fields Not Allowed|USER_FIELDS_NOT_ALLOWED]: This field, set by the system, identifies if [User Defined Fields|IMUF] are permitted on the table.
;[Logging Not Allowed|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|HISTORICAL_TABLE]: This optional toggle indicates that the table contains [date-sensitive|DATE SENSITIVE] information.
;[Disable Logging|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.
;[Maximum Note Size|MAX_NOTE_SIZE]: This field identifies the maximum note size allowed on the table. If the table allows notes to be defined, the note may be up to 2000 characters unless otherwise noted.
;[Subject Area|SUBJECT_AREA]: This is a lexicon based field which specifies if the table's subject is in reference to a person, user or position.
;[Maintained By|MFN_ID]: This is the function normally used to maintain the data in this table. It is the driving table for the Drill Downs.
;[Master|MTD_ID]: This is the table that is the Master of this table.
\\
The following three fields are used by [UMHP] to purge historical data:
;[Retained Periods|RETAINED_PERIODS]: This field allows the Administrator to state how many 'periods' to retain. Periods is determined by the value selected in [Period Type|PERIOD_TYPE] below.
;[Period Type|PERIOD_TYPE]: This field allows the Administrator to specify the type of time to retain for Historical purposes. This is used when the [UMHP] is run to purge the historical data.
;[Purge Date|PURGE_DATE]: This is a date field which allows the Administrator to specify a specific date in which all historical data prior to this date will be purged. Purge Date will take precedence IF all three fields are filled in. Thus if you have it set to normally delete rows that are older then 5 years BUT for a special run want to delete all rows prior to a specific date, you can.
\\
;[Clear Table Cache|ACT_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|ACT_CLEAR_ALL_TABLE_CACHES]: 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|FUNCTION_NAME]:The name of the function that uses the table.
;[Usage|FUNCTION_USAGE]: This field indicates if the function was predefined by the application or if the function was created by the client.
;[Join Clause|JOIN_CLAUSE]:This field indicates the clause that will join two or more tables or views.
;[Where Clause|WHERE_CLAUSE_CODE]:This field indicates if a where clause was added to the table's usage in the form definition.
;[Usage|FORM_TABLE_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|CREATE_ALLOWED]/[Retrieve|RETRIEVE_ALLOWED]/[Update|UPDATE_ALLOWED]/[Delete Allowed|DELETE_ALLOWED]:These fields indicate the security access defined at the function's level.
----
![Notes|Edit:Internal.IMTD]
[{InsertPage page='Internal.IMTD' default='Click to create a new notes page'}]
‘Maintain Lexicons’ Usage and Examples Table Alias
This field provides the abbrieviated table identifier.
Table
This field identifies the table being defined.
Product
This field displays the product the table is associated with.
Description
A short description of the table is provided in this field.
Notes Not Allowed User Fields Not Allowed Logging Not Allowed Historical Table Disable Logging Table is Cached Maximum Note Size Subject Area Retained Periods Period Type Purge Date Function Clear Table Cache Clear All Cached Tables
This page (revision-25) was last changed on 26-Nov-2021 10:22 by jaikenTop