Changed Date

Date for the latest change

Creation Date

Date for the creation of the data model

Name

The name of the data model

Add Simple Model

Add a simple model

DB Access Type

inout – update/read from the database

in – update the database

out – read from database

none – create an empty data instance

ID

The ID of the simple model

Index

The sequence index

Key Index

The key index on the master table

Master Table

The name of the master table

Metadata ID

The metadata ID where the master table reside

Name

The name of the simple model

Result Type

single – only one record is read (typical for a detail)

multi – several records are read (typical for a browse)

Rows To Extract

The maximum number of rows to extract from the database

Add Master Table

Add a master table to the simple model. This option is only available when no master table has been selected for the simple model. 

Add Dependency

Add a dependency. This option is only available on a simple model that has other simple models “above” it.

Move Up

Move the simple model one step up.

Mode Down

Move the simple model one step down.

Reset Columns

Resets all columns in all the tables that belong to this simple model. Possible overridden values on the columns are overwritten by the default values of each column defined in the repository.

Remove

Remove the simple model.

Paste

A criterion has been copied in an earlier action, and it can be pasted here.

Generate Criteria

Generates criteria for this simple model. Based on information in the repository for the master table, the default criteria are generated automatically. This option is only available when a master table has been chosen for the simple model.

Add Criterion

Adds a non default criterion to the simple model. This option is only available when a master table has been chosen for the simple model.

Alias

The actual name of the table in the repository. This should actually be the Id property.

Constraint

Property for an imported table. The constraint tells which column in the imported table to map to

ID

The ID of the table. In the master table case ‘Alias’ and ‘ID’ is the same. In the imported table case it is used to give the imported table a unique identity. If the same table is imported several times from a master table but with different constraints, the id is the imported table name concatenated with the constraint on which the table is imported. The ‘Alias’ and the’ ID’ properties should switch in the future.

Imported From

Property for an imported table. Tells from which table this table is imported.

Metadata ID

The metadata ID in which this table reside

Work With Master

Launches a dialog where table columns can be selected together with what index to use. 

Add Imported Table

Add an imported table. This option is only available if the master table references other tables as imported tables. If it does, this option is available as long as there are tables to import i.e. if the master table only imports one table and that table has been chosen as an imported table, the option is no longer available.

Remove

Remove the master table.

Alias

The actual name of the table in the repository. This should actually be the ID property.

Constraint

Property for an imported table. The constraint tells which column in the imported table to map to

ID

The ID of the table. In the master table case Alias and ID is the same. In the imported table case it is used to give the imported table a unique identity. If the same table is imported several times from a master table but with different constraints, the ID is the imported table name concatenated with the constraint on which the table is imported. The Alias and the ID properties should switch in the future.

Imported From

Property for an imported table. Tells from which table this table is imported.

Join Type

Tells what kind of join to use

inner join – a common inner join

left outer join – same as outer join

Metadata ID

The metadata ID in which this table reside

Work With Table

Launches a dialog where table columns can be selected. 

Remove

Remove the master table.

Alias

Table name.

Column Label Long

A label describing the field.

Column Label Short

A label describing the field.

Data Type

Shows the numeric representation of the data type for the column.

Is Key

Tells if this column is a key or not in the table.

Max Key

Tells if this column is part of the desired number of keys to use in the query.

Metadata ID

The columns metadata ID.

Name

The name of the column.

Short Name

The short name of the column.

Simple Model ID

The ID of the simple model that this column belongs to.

Table

Table name

Virtual Column

The column from which a virtual field inherits its properties.

Virtual Metadata ID

The metadata ID from which a virtual field inherits its properties.

Virtual Table

The table from which a virtual field inherits its properties.

Remove

Remove the dependency.

Binder

A logical binder

and

or

Col1Type

The type of the left column

fld – a field in the database

var – a variable that can change its value, i.e. a previous simple model has been executed and a resulting field value from that model is mapped to this column.

fix – a fix value is set for the column

Col2Type

The type of the right column

fld – a field in the database

var – a variable that can change its value, i.e. a previous simple model has been executed and a resulting field value from that model is mapped to this column.

fix – a fix value is set for the column

Default Criterion

Yes – a default criterion generated based on information in the repository for the master table.

Override – to indicate that the default is changed manually

Identifier Left

The left identifier for this criterion. The identity is a dot ‘.’ separated concatenation of METADATAID.TABLE.COLUMN

Identifier Right

The right identifier for this criterion. It can be referenced from different parts of the runtime workspace environment.

Instance – the identifier references a column in a simple model within this data model.

MapData – the identifier references a variable in the map data.

SessionArea – the identifier references a variable in the session area.

Session – the identifier references a variable in the session.

DialogArea – the identifier references a variable in the dialog area.

Function – the identifier references current date or user ID

Key

Whether this criterion is generated over a key column.

true – column is key

false – column is not key

Name

Name of the criterion

Operator

The criterion operator.

=

!=

>=

> 

<=

< 

in

not in

asc

desc

Copy

Launches a dialog where table columns can be selected. 

Move Up

Moves the criterion one step up. 

Move Down

Moves the criterion one step down.

Remove

Remove the master table.

Dependency Reference

References a simple model that is earlier in the sequence relative to the simple model that this dependency belongs to. 

Type

The dependency has a type depending on what type of object it references. For now there is only one type – DataModel

Remove

Remove the dependency.