Navigation to this function
This evaluation lists all static and dynamic characteristics in a portal, with all relevant information relating to this characteristic and the info area and form in which they are arranged. A traffic light provides information on the maintenance status of each line and the next steps required.
List
This group contains properties that relate to lists or enumerations in the data model cache. It includes properties that represent collections of elements or structured lists.| Property | Description |
| Traffic light | The traffic light column gives a colored indication of the status of the stored data. See the associated notes for further information |
| Note | The note in this column gives you further information on the displayed traffic light color. Follow the instructions to be able to change red and yellow traffic lights in particular. |
| Form (with link to configuration) | Form (with link to configuration) |
| DB table name | This table name uniquely identifies a database table in the system. It is used for internal processes and data management. The correct specification is important in order to access the correct data and ensure consistency in the data model. |
| DB Field name | This field shows the internal database name of the selected field. It is used to uniquely identify and reference fields within the data model and is particularly relevant for administrators and advanced users when analyzing data and reporting. |
| Area (with link to configuration) | Area (with link to configuration) |
| Feature (with link to configuration) | Feature (with link to configuration) |
| Characteristic definition (with link to text) | Characteristic definition (with link to text) |
| Form definition (with link to text) | Form definition (with link to text) |
| Support article link | Display of the link to the support article |
| Area definition (with link to text) | Area definition (with link to text) |
| Menu path | This menu path shows the hierarchical structure and position of an item in the system's navigation menu. It helps users to identify the exact location of an item in the menu tree and makes it easier to navigate to specific functions or areas of the application. |
| ProductOwner | This field shows the product owner who is responsible for the corresponding data model. The product owner plays a central role in the administration and further development of the data model and serves as a contact person for technical questions. |
| Table or view type | Indication of whether it is table or view |
| Namespace | The namespace groups related data models and enables logical structuring. It helps with the organization and management of data models by creating a hierarchical division and improving clarity. |
| SystemName | This entry shows the unique name of the system or application to which the data model cache refers. It is used to clearly identify and differentiate between different systems within the global system data and enables efficient management and assignment of the cached data models. |
| SystemName table | Only the part of the system name that comes from the table |
| Area System name | This system name uniquely identifies the area within the data model. It is used to distinguish between different areas of the system and enables precise assignment of data records to specific functional areas. |
| SystemName column | Only the part of the system name that comes from the column/characteristic |
| Form definition Number of words | This field shows the number of words in the form definition. It is used to quickly assess the scope and complexity of the form description without having to open the full text. |
| Characteristic definition Number of words | This field shows the number of words in the definition of a feature. It is used to quickly assess the scope and level of detail of the feature description without having to read the full text. |
| Type | This type categorizes the feature within the data model. It helps to structure and filter the characteristics so that you can quickly find the relevant information and analyze the data model efficiently. |
| Data type | This data type specifies what type of information is stored in this field of the data model. It determines which values are permitted and how the data is processed internally. The correct selection of the data type is important for data integrity and processing in the system. |
| DB Data type | Data type in the database |
| Length | This column shows the maximum length of a character field in the data model. It helps you to understand the permitted number of characters for certain data fields and to recognize input restrictions. |
| Dimension | This field shows the measure or dimension of a characteristic. It is used to precisely describe and quantify properties in the stored data models and enables detailed analysis and comparability of the data records. |
| Unit | This field shows the unit of measurement of the associated characteristic. It is used for precise quantification and makes it easier to interpret the characteristic values in the data model cache. |
| Mandatory field | This field indicates whether it is a mandatory field that must be completed. Mandatory fields ensure that all necessary information for the data model cache is recorded and are crucial for the completeness and consistency of the data. |
| Type filter | This type filter allows you to restrict the display of data records in the data model cache according to specific types. By entering specific filter criteria, you can select and display the information that is relevant to you. |
| Activated | This field shows whether the data model cache is active and ready for use. An activated cache enables faster access to frequently used data models and improves system performance. |
| Visible | This checkbox controls the visibility of the data model cache entry in the user interface. If activated, the entry is displayed in relevant lists and views, otherwise it remains hidden from users. |
| Canceled? | This field indicates whether the data model has been marked as obsolete or no longer supported. It helps users to distinguish between current and possibly obsolete models and provides information about the status of the data in the system. |
| Namespace deletion date | Namespace deletion date |
| Namespace discontinued Comment | Namespace discontinued Comment |
| Deletion date table | Deletion date table |
| Table discontinued Comment | Table discontinued Comment |
| Deletion date range | Deletion date range |
| Area discontinued Comment | Area discontinued Comment |
| Deletion date column | Deletion date column |
| Column discontinued Comment | Column discontinued Comment |
| Control type | This value specifies the type of control used to display and edit the data model cache. It determines how users can interact with the stored information and influences the visual appearance and functionality of the element in the user interface. |
| Sequence | This number determines the order in which items are displayed in the list. It enables a user-defined sorting of the entries, regardless of other attributes such as name or date. You can customize the display order according to your needs by adjusting these values. |
| Sequence range | This number determines the order in which areas are displayed in lists. It enables user-defined sorting of the areas, regardless of other criteria such as name or creation date. |
| Sequence field in area | Defines the display order of the field within a specific area of the user interface. This positioning determines the order in which the fields are presented to the user, which ensures an intuitive and logical display of information. |
| Order in list | Specifies the (column) order/position in which the field is displayed in the list view. |
More columns
This group contains additional technical and functional attributes of the data model cache that are not assigned to any other category. They supplement the main features with further relevant information.| Property | Description |
| Primary key Table Namespace SystemName | Display of the primary key table namespace SystemName |
| Primary key Table SystemName | System name of the primary key table for the foreign key |
| Area Type | This Type area classifies the type of data model and enables quick categorization and filtering. It helps to organize and efficiently find relevant data structures in the system. |
| IsPrimaryKey | Indicates whether this column is used as the primary key for the table in the data model cache. A primary key is used to uniquely identify a data set and is of central importance for the integrity and structure of the data model. |
| Primary key Column number | This number uniquely identifies the column that serves as the primary key for the data model. It is crucial for the correct linking and integrity of the data in the system. |
| Primary key Columns Number | Number of columns involved in the primary key. Should always be 1. |
| Primary key DB Table name | Database Table name of the primary key table for the foreign key |
| Number of foreign keys for the same target table | Specification of the number of foreign keys for the same target table |
| UniqueType | This value specifies the specific type of unique identifier for the data model. It is used to distinguish between different types of identifiers within the data model cache and enables precise allocation and management of the stored information. |
| UniqueIndex Name | This unique name identifies the UniqueIndex within the data model. It is used to refer to the index and ensure its uniqueness. Correct naming is important for the integrity and consistency of the data model. |
| UniqueIndex Column number | This number indicates the position of a column within a unique index. It is important for the structure and performance of the data model, as it defines the order of the columns in the index and therefore has an influence on queries and data integrity. |
| IsAlwaysUpdate | This checkbox determines whether the data model should be automatically reloaded each time the cache is updated. Activate this option to ensure that the latest data is always used. |
| DbSize | This number indicates the size of the cached data model in the database. It helps to estimate the memory requirements and optimize the performance of the caching mechanism for data models in the system. |
| DbNumericPrecision | This field shows the numerical precision of a database number. It specifies the maximum number of digits that can be used for the value, including digits before and after the decimal point. This information is important for the exact representation and processing of numerical values in the system. |
| DbNumericScale | This field specifies the number of decimal places for numeric data types in the database schema. It is important for the precise representation and processing of decimal numbers in the corresponding data fields of the model. |
| Regular expression | Display of the regular expression |
| Regular expression Description (German) | Display of the regular expression Description |
| Default value | Display the default value from the database, or the function from the database that returns the default value. |
| Available Data: Number of Values | Displays the number of data values actually present in a data model cache. This metric provides insight into the completeness and scope of the data available for analyses and reports. |
| Available Data Length (Typical) | Displays the typical length of the data in this data column. This value helps estimate storage requirements and optimize the data structure. |
| Existing Data Length Max | Displays the maximum length of the data in this column of the data model. This information helps you assess storage requirements and optimize the data structure. |
German texts
This group contains characteristics for German text content in the data model cache. It includes properties such as names, descriptions and other textual elements in German.| Property | Description |
| Text Table Tooltip (German) | Text table tooltip (German) with link to the text table |
| Text Feature Tooltip (German) | Text feature tooltip (German) with link to text table |
| Text area Tooltip (german) | Text area tooltip (German) with link to text table |
| Text Table Label (German, with link to text) | Text table label (German) with link to text table |
| Text area Label (German, with link to text) | Text area Label (German) with link to text table |
| Text feature label (German, with link to text) | Text feature label (German) with link to text table |
English texts
This group includes attributes that represent English-language text content or translations. It is used to manage and analyze attributes with English text values in the data model cache.| Property | Description |
| Form EN | This field contains the English text for the associated form or user interface. It is used for multilingual display and enables the consistent display of designations and labels in English for international users. |
| Area EN | This field contains the English name of the area for the data model. It is used for multilingual display and enables the correct display and use of the area name in English-language user interfaces and reports. |
| Feature EN | This field contains the English name of the feature for the data model. It is used for the multilingual display and use of the feature in English-language user interfaces and reports. The correct translation is important for consistent international use of the system. |
| Form definition EN | This field contains the English-language definition of the form for the data model. It describes the structure and layout of the form in English and is used for the display and processing of forms in English-language user interfaces. |
| Area definition EN | This field contains the English definition and description of a specific data model section. It is used to provide English-speaking users with a clear understanding of the structure and purpose of the respective data model section. |
| Characteristic definition EN | This field contains the English definition of a feature in the data model. It describes the properties and purpose of the feature for international users and enables a uniform interpretation of the data in English-speaking contexts. |
| Form definition EN Number of words | This field shows the number of words in the English form definition. It is used to estimate the scope and complexity of the description, which can be helpful for translations and adaptations. |
| Characteristic definition EN Number of words | This field shows the number of words in the English definition of a feature. It is used to quickly assess the scope and level of detail of the English-language feature description without having to read the full text. |
| Regular expression Description | Display of the regular expression description |