DT412 Data item
The creation, modification, and deletion of data items in data tables of the Q1B and Q2B schemas may only be carried out by PLANTA. The only exception is data table DT400, which can contain custom DIs as well.
Caution
- If system customizing changes are made to data tables or data items (e.g. new data items are created, data item parameters are changed), the Tools → Restart PLANTA service menu item must be executed in order to make the changes visible.
- Note: If you click on the menu item, all open client connections (sessions) are closed. During restart, new client connections are not possible. This does not apply to changes made to I-texts, e.g. changes to the DI name or adjustment of value ranges (also of the VR type).
- Before restarting the service, the target directory must be deleted so it can be created anew upon server restart in order to make sure that the POJO classes contained in it, which are responsible for the meta data 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.
- Example DT462
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.
Values | DB type | DF type | PPMS type | Additional |
---|---|---|---|---|
Alpha (alphanumeric) | X | AL | AL | |
Alpha (alpha alphanumeric), e-mail | X | AM | AM | |
Alpha (alpha alphanumeric), large | X | ALG | ALG | |
Alpha (alpha numeric), phone number | X | AP | AP | |
Bar | - | Class = 1 | ||
Links | N2 | P | L | |
Clob (continuous text) | X | AL | CLOB | Class = 19, DB length = 3000, DF length = 3000 |
Currency | N8 | C | C | |
Date | N4 | T | D | DB length = 4, DF length = 8, Standard value SQL = to_date('01.01.70','DD.MM.RR') |
HL: File in the DB | X | AL | HL | Class = 16 |
HL: Local file | X | AL | HL | Class = 16 |
HL: Linked file | X | AL | HL | Class = 16 |
I-text | X | AL | IT | Class = 15 |
I-text, large | X | AL | ITG | Class = 15 |
Incarnations, bars, projections | ||||
yes/no | N2 | Y | Y | DB length = 2, DF length = 1, Standard value SQL = 0 |
Object protection for rwd output | N2 | O | O | Status = 6, DB length = 2, DF length = 4 |
Time | N4 | U | T | |
UUID | ID | I | UUID | |
Number with DP | N8 | N | N8 | |
Number without DP up to 4 digits | N2 | N | N2 | |
Number without DP up to 9 digits | N4 | N | N4 | |
Image | B | A | BLOB | Class = 20, DB length = 2, 000246 DF length = 2 |
DI000254 DB length
Database length of the data item. It depends on DB type (Column type).
Values
Column type | DB type | DB length | Preset |
---|---|---|---|
Alpha (alphanumeric) | X | Length (even number) | |
Alpha (alpha alphanumeric), e-mail | X | Length (even number) | |
Alpha (alpha alphanumeric), large | X | Length (even number) | |
Alpha (alpha numeric), phone number | X | Length (even number) | |
Links | N2 | 2 | |
Clob (continuous text) | X | Length (even number) | 3000 |
Currency | N8 | 8 | |
Date | N4 | 4 | 4 |
Hyperlink | X | Length (even number) | |
Incarnations, bars | - | 0 | |
I-text | X | Length (even number) <80 | |
I-text, large | X | Length (even number) <80 | |
yes/no | N2 | 2 | 2 |
Object protection for rwd output | N2 | 2 | 2 |
Time | N4 | 4 | |
Number with DP | N8 | 8 | |
Number without DP up to 4 digits | N2 | 2 | |
Number without DP up to 9 digits | N4 | 4 | |
UUID | ID | 16 | Unique code; cf. UUID |
Image | B | 2 |
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
DB type | DF type | Additional |
---|---|---|
N2 | P | |
N2 | Y | |
N2 | O | |
N2 | N | DF length = 1.0 up to 4.0 |
N4 | T | |
N4 | N | DF length = 5.0 up to 9.0 |
N4 | U | |
N8 | N | DF length = with decimal places |
N8 | C | |
X | AL | |
X | ALG | |
X | AM | |
X | AP | |
ID | I | |
B | A |
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
- The following suffixed letters serve to further specify the type properties:
- 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
- The following suffixed letters serve to further specify the type properties:
- 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
DI027352 Value range
Here, the formula for the data item value range is entered/displayed
Details
DI000252 EXIT
ID of the data item exit
Note
- Exits are created, edited, and deleted in the Exits module.
Details
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).
See also: Create, Edit, Delete Symbols |
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.
- overrides a deviating format which has possibly been specified at other levels:
See also: Create, Edit, Delete Formats |
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
- For these two DIs you have to specify the following:
- 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.
- Notes
- 4: Data item does not appear in the generated schema file since it is a parallel DB pos. data item.
- 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 will still be displayed in the customizing.
- If a module is started with a deactivated DI, the behavior will differ according to the DI.
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 is changed and saved in one of the three parameters mentioned (DI060111, DI060096, or DI060097), a script is created in the work directory and a message is displayed 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 will only be displayed once in a session, i.e. only upon the first change made to DI060111 or DI060097 or DI060096.
- After making changes to DI060111, DI060096, or DI060097, the System Customizing must be updated (e.g. via the respective 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
When a record is created, 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
When a record is created, the time of creation is automatically entered here.