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 14 changed one line
;[Product|PRODUCT_CODE]:This field displays the product the table is associated with.
;[Product|MPD_ID]:This field displays the product the table is associated with.
At line 22 changed one line
;[User Fields Not Allowed|USER_FIELDS_NOT_ALLOWED]: This field, set by the system, identifies if [User Defined Fields|USER DEFINED FIELD] are permitted on 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.
At line 25 removed one line
;[No Monitor Triggers|NO_MONITOR_TRIGGERS]:
At line 27 changed 7 lines
;[Table is Cached|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.
;[Maximum Note Size|MAX_NOTE_SIZE]:
;[Subject Area|SUBJECT_AREA]:
;[Retained Periods|RETAINED_PERIODS]:
;[Period Type|PERIOD_TYPE]:
;[Purge Date|PURGE_DATE]:
;[Function|FUNCTION_NAME]:
;[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.
\\
At line 43 changed one line
;[Join Clause|JOIN_CLAUSE]:
;[Join Clause|JOIN_CLAUSE]:This field indicates the clause that will join two or more tables or views.
At line 48 changed one line
[CLEANUP]
----
![Notes|Edit:Internal.IMTD]
[{InsertPage page='Internal.IMTD' default='Click to create a new notes page'}]
This page (revision-25) was last changed on 26-Nov-2021 10:22 by jaikenTop