Footprints Data Model

Table
Table Name Application Element
Table Definition The identity and name of an element in the application implementation. An element can be one of many types, and can contain other elements. Example Application Elements include: a screen, a form, a dialog box, a text box, the Home Page, an Architecture Component, the Item Status field, the system values of the Item Status field. The Application Element is not the full implementation of the element, but is a key and nametag for the element. In many cases, a well-known algorithm can be used to locate the correct Application Element from the Application Element implementation. In other cases, an association to the Application Element Id must be recorded as part of the implementation.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Application Element Id The automatically generated primary key of the app_ele table. LONG Yes
Application Element Namespace Id A Foreign Key to the Application Element Namespace table. LONG Yes
Application Element Name The name of the Application Element. VARCHAR(255) No
Is Internal Flag A boolean flag for indicating if the Application Element is defined internally by Engineering or by Partners or is defined by the customer. BOOLEAN Yes
Internal Id An alternate automatically generated key of the app_ele table. INTEGER No
Change Needs Review Date A date that indicates that there were changes made to the Application Element or its Strings or String Values that may need to be propogated to other Strings or String Values or even related Application Elements. This date value will be stored in the application element, and in the Audit Trail, and therefore application elements that have not been changed can be determined. At some point, the user may declare that all needed propogating changes were made, and this date can be cleared. DATE No
Application Element Type Id A Foreign Key to the Application Element Type table. INTEGER Yes
Internal Identifier Type Id A Foreign Key to the Internal Identifier Type table. INTEGER No