DT412 Data item

The creation, modification, and deletion of data items in data tables of the Q1B and Q2B schemas must only be carried out by PLANTA. DT400 presents an exception as it can also contain customer-individual DIs.

Caution

• If system customizing changes are made to data tables or data items (e.g. new data items created, data item parameters changed), the menu item Tools → Restart PLANTA service must be executed to make the changes visible.
  • Note: If you click on the menu item, all open client connections (sessions) are closed. New client connections are not possible during restart. Changes to I-texts, e.g. changes to the DI designation or adjustments to value ranges (including the VR type), present an exception.
  • Before restarting the service, the target directory must be deleted so that it can be created again when the service is restarted to ensure that the POJO classes it contains, which are responsible for the metadata of the data dictionary, are generated anew.

DI000242 Index

Here, the index number is specified for data items which belong to a unique index.

Examples

• Project ID in the Project data table
  • Project ID in the Task data table
  • Project ID in the Project text data table contains the index number of the Index from the Project data table.
• Usually, Index is used to automatically fill IDs that do not exist as data fields themselves.
  • In DT463 Task, Project occurs twice. Once as a path to DT461 Project and once as part of the task number. In both data items, Index = 461 is entered. In a module which has Project and Task areas, none of both project data items must exist as a data field in the task area, because both project data items in the task record are automatically filled with the content of Project from the corresponding project record via the index.
• Another aspect of Index is that it scans N:1 relations "reversely".
  • Usually, one project is specified and all of its corresponding tasks are found.
  • Conversely, this N:1 relation between Project and Task can also be used to find the corresponding project when specifying a task. To do so, index 461 Project must be specified in the Project DI of DT463 Task.

Warning

• Incorrect use will result in unpredictable results.

DI000238 DI

ID of the data item. Automatically incrementing number.which is formed from the license number and an incrementing counter.

DI002058 Data item

Name of the data item (incarnation)

DI001591 Name

Name of the data item

DI000239 DT

Data table of the data items

DI023581 Data table

Name of the data table

DI041035 DI Python ID

Identifier of a data item. It is used in connection with Python to identify the data item.

Notes

• Names must be usable as Python literals. They must not contain any special characters, umlauts, spaces, etc.
• The DI Python ID must be unique in the data table.
  • It can be overwritten in the DF Python ID in the data field.
• The Python IDs of standard IDs are allocated by PLANTA.
• Individual Python IDs must start with an L and the license number.
  • Example: L011_request
• The Python IDs of standard data items must not be changed.

DI027351 DB Schema

In this data field, the database schema to which a data table belongs is displayed.

DI000215 SQL ID

Here, the SQL column names of the (real) data items, as they are defined in the database, are stored.

Notes

• SQL ID must be unique. Exception: parallel DIs with SQL = 2 or 4
• Via the Set column name button, the SQL ID can be set automatically.
• Reserved key words of the used DBMS must not be used as an SQL ID.

DI040835 Fetch exit DI

In this data field you can enter the ID of the fetch exit data item corresponding to the DI.

DI040836 Incarnation DI

• In this data field, the ID number of the corresponding ID field can be stored for incarnation DIs. It is automatically set during automatic creation of incarnations.
• For DIs with only one incarnation, the DI number of the corresponding incarnation can be stored here.

DI040837 Data item for adjustment source

In this field, you can store the data source for adjustment between two tables.

Example

• When creating a status report, the data fields of DT823 Status report are adjusted with those of DT461 Project. For this purpose, the corresponding data source is stored in the data items of DT823. In the Planned effort field, e.g., the ID number of the Planned effort DI from DT461 is stored.

DI000275 Virtual

This parameter determines whether the data item is a real or a virtual data item.

Values

• : Real data item which appears in the database.
• : Virtual data item which does not appear in the database but is determined during runtime by the means of data, e.g. by a value range.

Note

• Virtual data items have no DB pos.

DI000241 DB pos.

Thie field is required for sorting purposes. For real data items it must not be blank.

Details

• When creating new real data items (virtual is deactivated), it is reasonable to allocate the DB pos. in ascending manner.
• Virtual data items (virtual is activated) have no DB pos.

Notes

• Occupied DB positions may not be used.
• Within compound table IDs which consist of several data items, the distance between the allocated DB pos. must correspond to the DB length.
  • Example DT462
    • ID from DI001049 to DI001092
    • DI001049 does not possess DB pos. = 19 and DB length = 18.
    • The next DI in the data table (here DI001080) may therefore only begin at DB pos. = 37.

DI041365 Column type

Type of the data item in the database (spelled out). It determines DB type, DF type, and PPMS type of the data item which are automatically set in the selection of the column type.

DI000254 DB length

Database length of the data item. It depends on DB type (Column type).

Values

Note

• For data items with class = 15 (I-text), the DB length can be extended to a maximum of 80 at any time. The space technically required for this purpose is always 4, regardless of the value contained in DB length.

DI000246 DF length

Possible input length in the data field which corresponds to the selected data item.

Details

• In alpha numeric data items: length of the input field in number of characters, the DB length as a maximum

Notes

• When defining the DF length, the format must be considered.
• It is possible to write in a field via Python entries that are longer than the defined DF length. However, when you click on them for the first time, they are truncated to match the permitted length.

DI000253 DB type

Type of the data item in the database in the PLANTA syntax (as a code for column type)

Note

• The DB type is set automatically when you select the column type.

Values

DI000244 DF type

Type of the data field which corresponds to the data item

Note

• The DF type is set automatically when you select the column type.

Values

• A: alpha numeric character string
  • The following suffixed letters serve to further specify the type properties:
    • L: set left aligned
    • R: set right aligned
    • G: convert to upper case
    • M: e-mail address
    • P: phone number 1
  • Order: ALG
• I: UUID field
• N: Number
• C: currency
• D: date
  • Stored internally as the number of days since 01/01/70.
• U Time
• Y: yes/no
• P: Relationship type for links (SS, SF, FS, FF)
• O: object protection
  • Stored in the database as a number
  • Displayed on the GUI as a three digit character string:
    • r: reading of the record allowed
    • w: writing (modification) allowed
    • d: deletion permitted
    • r, w, and d may only occur once
    • the order is arbitrary
    • Only values which are to take effect must be specified (e.g. rw for read + write
    • the spelling used under LINUX, with "-" for not in effect is allowed (e.g. rw- for read + write)
• W: calculation method in DT467

DI003141 PPMS type

Note

• The PPMS type is set automatically when you select the column type.

Values

• A: alpha numeric character string
  • The following suffixed letters serve to further specify the type properties:
    • L: set left aligned
    • R: set right aligned
    • G: convert to upper case
    • M: e-mail address
    • P: phone number 1
  • Order: ALG
• B: binary (only internal)
• BL: BLOB continuous text
• BLOB: binary large object
• C: currency
• CLOB: character large object
• D: Date
• IT: text
• ITG: text, large
• L: relationship
• N2: Number without DP up to 4 digits
• N4: Number without DP up to 9 digits
• N8: Number with DP
• O: object protection
• D: date
• UUID: Universally Unique Identifier
• W: calculation method in DT467
• Y: yes/no

DI001990 VR type

Value range type

There are three groups of value range types:

• Px: check for input fields
• Cx: Calculation for input/output fields (however, mostly output fields)
• PY: python value range

Details

• Customizing of value ranges

DI027352 Value range

Here, the formula for the data item value range is entered/displayed

Details

• Customizing of value ranges
• Python value range functions
• Python api

DI000252 EXIT

ID of the data item exit

Note

• Exits are created, edited, and deleted in the Exits module.

Details

• Customizing of exits

DI000248 Summarization type

Summarization type of the data item The value is used as a default preset for the respective data field if the data field does not possess any summarization type. If a deviating value is entered in the data field, this value takes effect, except 5 Never summarize, always calculate (see below).

Values

• 0: No summarization (for DFs "Summarization type" from DI)
• 1: Sum
• 2: Maximum
• 3: Minimum
• 4: Average
• 5: never summarize, always calculate

Note

• The Never summarize, always calculate summarization type on a data item prevents any summarization and does not allow deviating summarization types in the data field. For fields with relative values, e.g. percentage specifications, summarization does not make sense. The Never summarize, always calculate summarization type on the data item provides the customizer with a means to prohibit this effectively.
• If, e.g., no summarization type has been stored in a grouped area, the following default summarization types are used.
  • Alpha numeric fields: Maximum
  • Numeric fields: Sum
  • Date fields: Maximum
  • The values of the checkbox fields are not summarized, the checkboxes are always displayed as deactivated

DI001701 Symbol ID

ID of the data item symbol

Example

• DIs with DB type = N, T, U, Y, A, AL, or ALG receive font symbols.
• DIs which are bars receive bar symbols.

Notes

• The symbol defined here
  • overwrites possible symbol definitions in the skin (DT030, Symb. symbol, Output field symbol and Hyperlink Hyperlink
  • is overridden by the symbol in the data field itself (DT411, Symbol ID parameter).

DI002033 Symbol

Preview of the symbol which is defined for the selected data item via the symbol ID parameter

DI000257 Format ID

ID of the format for the date or number or currency which is saved in the selected data item

Notes

• This format
  • overrides a deviating format which has possibly been specified at other levels:
    • at skin level: the formats specified in the Date format, Currency format, or Number format parameters
    • at user level: the formats specified in the Date format, Currency format, or Number format parameters
  • and can itself be overridden by the possibly existing deviating format at data field level of the respective data field (Format ID parameter).
    • Exception: projection value Here the format on the data field has no effect.

DI002075 Format

Preview of the format which has been specified for the selected data field in the Format ID parameter.

DI001700 Class

Values

• 0: Data
• 1: Date bar
• 2: Histogram Bar
• 3: Time Scale
  • For these two DIs you have to specify the following:
    • Type: T

    • Format: 2 = day, 3 = CW, 4 = month, 5 = quarter, 6 = year

    • Length: output length of the values, e.g. 8 for day
• 4: Incarnation
• 5: RGB color output
• 8: Linkage
• 9: Data items which do not represent values in the database and which cannot be attributed to any real data table. Such data items are, e.g. required as components for complex objects or for fields in print areas.
• 10: Area frame dominance symbol
• 11: Projection value
• 12: Histogram Scale
• 13: OLE Objects
• 15: I-text
• 16: Hyperlink/documents
• 17: Variable object (continuous text)
• 18: Date contr. exchange rate (only for fields with type C)
• 19: CLOB

DI000967 Status

Serves as a selection criterion for the DI ranges of the customizer

Values

• 0: Status unknown, visible in the Data Dictionary
• 1: Normal data items, visible in the Data Dictionary
• 2: Complex data items, visible in the Data Dictionary
• 3: free criterion
• 4: free criterion
• 5: free criterion
• 6: Object protection, techn. IDs
• 7: PLANTA internal
• 8: Reserve data item, not active
• 9: designated for deletion

DI000151 UF DF

Use frequency of a data field Shows how often the data item is used as a data field in data areas.

Note

• A link is stored on the field via which you can view the use of the data item in the Data Areas module.

DI000152 UF DDI

Frequency of use determined data item. This shows how often the data item appears in data areas as a determining data item (DDI).

Note

• A link is stored on the field via which you can view the use of the data item in the Data Areas module.

DI001561 UF UDI

Frequency of use subordinate data item-. Shows how often the data item is used as a Subordinate data item in DI structures.

Note

• A link is stored on the field via which you can view the use of the data item in the Data Items module.

DI057664 UF traffic light

Use frequency of traffic lights. Shows how often the data item is used as a traffic light in data areas.

Note

• A link is stored on the field via which you can view the use of the data item in the Data Areas module.

DI026678 Multiline

This parameter controls whether line breaks are possible in the data field which corresponds to the data item.

DI001165 DI note

Controls the display of the notes in the Data Field Information.

Values

• 1: standard only
• 2: standard and individual
• 3: individual only

DI002461 SQL

Information on the generation of SQL schema files

Values

• 0: Data item appears in the generated schema file
• 1: Data item has the specification NOT NULL in the schema
• 2: Data item does not appear in the generated schema file since it is a parallel relation data item.
  • Notes
    • Parallel DIs can differ in the data item parameter configuration. For this purpose, the SQL ID of the parallel data items must be identical.
    • DIs with SQL = 2 are required since relations can only be defined via Ident of DI, and Ident up to DI.
• 4: Data item does not appear in the generated schema file since it is a parallel DB pos. data item.
  • Parallel DIs can differ in the data item parameter configuration. For this purpose, the DB pos. and the SQL ID of the parallel data items must be identical. Parallel DIs are no longer required from release 39 since relations can now intersect in their DIs.
• Values 0, 1, 2, 4 are combined dually.

Note

• In case a date field in the SQL parameter is marked as NOT ZERO, all ZERO values in date fields are treated as if their default value was 0 (which equates to 1/1/1970).

DI026799 SQL default value

Standard value of the data item for the SQL database

Caution! This value is currently not unloaded during schema export.

DI028175 Scheduling

DI066579 Data item configuration

The parameter serves to configure the tooltip modules

Details

• If a tooltip module is entered here, it is displayed in all modules in which the data item is used.
• The tooltip module entered here can be overwritten by a deviating entry in the Data field configuration field at data field level.

DI060111 Activated

Defines whether a data item is (de)activated. Data items which are to be deleted can be deactivated in a first step, e.g. for tests, and then be deleted permanently in a second step. For this purpose, a schema update file is generated which can be run manually upon requirement to delete the DI.

Values

• : The DI is activated.
• : The DI is deactivated. This means that the DI does not exist in the data dictionary of the server.

  • If a deactivated DI is used in a module, it is still displayed in Customizing.

    • If a module is started with a deactivated DI, the behavior differs depending on the DI:
      • If it is a real DI ( Virtual = ), the IE: FATAL ERROR: get_dip: DI 123456 not found error message is displayed.
      • If it is a virtual DI ( Virtual = ), the DI is not loaded, i.e. it is not displayed.

Notes

• If a DI is deactivated, it is displayed grayed-out in the Data Dictionary and in the listbox on the DI field in the Data Areas module.
• If a schema (060096 Activated = ) or a data table (060097Aktiviert = ) is deactivated, all contained DIs are automatically deactivated, i.e., the data table or schema settings overwrite the setting of the DI.

• As soon as the value in one of the three parameters mentioned (DI060111, DI060096 or DI060097) is changed and saved, a script is created in the working directory and a message is output at the same time: Due to your changes to DT412, your database must be adjusted. Please select the appropriate ./22*.sql file (depending on the database system) and run the content on your database.

  • The message is only displayed once in the same session, i.e. only when the DI060111 or DI060097 or DI060096 is changed for the first time.
  • After changes to DI060111, DI060096 or DI060097, the system customizing must be updated (e.g. via the corresponding menu item in the Tools menu).

DI062333 HTML template for value range

Stores a template (written in HTML) which enables the syntax highlighting in Python code

DI063233 Historization

The parameter determines whether the selected data item is to be historized or not.

Note

• The parameter only takes effect if the Historization parameter is activated as well.
• Historization is always done record wise. I.e. if changes are made to a DI with activated Historization parameter, an entry for the entire record is created in the history data table. If changes are made to a DI with deactivated Historization parameter, no entry is created in the history data table.

DI001867 Created by

When a record is created, the ID (code) of the logged-on user is automatically entered in this field. The creating user is also the owner of a record.

DI000407 Created on

Upon creation of a record, the time of creation is automatically entered here.

DI001868 Changed by

When a record is modified, the ID (code) of the logged-on user is automatically entered in this field.

DI000408 Changed on

Upon creation of a record, the time of creation is automatically entered here.

DI001869 Owner license

DI003037 Date of currency conversion