Table Field Authorizations (ttams4112m000)

Use this session to define Table Field Authorizations. Table Field Authorizations can be conditional (formerly known as Data Authorization). The session supports defining authorizations on all levels: Package, Module, Table Field and Company.

Field Information

Context

This field determines whether the role is an AMS role, a SEC role, or an EM role. In the latter case, the Central Enterprise Modeler Company, Project Model, Version and Optimization Phase fields determine the Enterprise Modeler context.

Note: You cannot manually specify SEC roles and EM roles.
Central Comp

For an EM role, this field indicates in which central Enterprise Modeler company the EM role is defined. For a SEC role, this field indicates in which authorization and security company the SEC role is defined.

Project Model

This field indicates to which Enterprise Modeler project model the Enterprise Modeler role applies. The field is only relevant if the context is EM.

Version

The Enterprise Modeler version in which the Enterprise Modeler role is defined. The field is only relevant if the context is EM.

Optimization Phase

The Enterprise Modeler optimization phase in which the Enterprise Modeler role is defined. The field is only relevant if the context is EM.

Role

The role code.

Changed

Indicates whether the role was changed. For example, when the role Description has changed, or when one or more authorizations have changed. The field indicates that the role must be converted to runtime.

Authorized Field

This field contains the Table Field code to which the authorization applies.

All Companies

This check box indicates whether the session authorization applies to all companies.

Company

The company to which the authorization applies.

Conditional

This check box indicates the table field authorization is conditional. When a table field authorization is conditional, a condition text must be specified

Sequence

A technical field used to make authorizations unique.

Authorization

The Authorization level.

Changed

This check box indicates whether the table field authorization is changed. The field indicates that the table field authorization must be converted to runtime.

Condition Text

If the Conditional check box is selected, this display field shows the condition text.

This field is maintained by the Text Editor.

Conditional expression

The conditional expression is a logical expression that returns True or False.

Enclose the expression by parenthesis: (expression)

The expression consists of operands and operators, where operands can also be an expression:

Expression = (Operand_A operator Operand_B)

Operand_A, Operand_B = constant (integer/float/string), table field or expression.

Operator = comparison operator or range operator

Range operators a and b refers to constant(integer/float/string) of the table field

This table shows the comparison operators you can use in the expression:

= Equal to (EQ)
<> Not equal to (NE)
!= Not equal to (NE)
> Greater than (GT)
< Less than (LT)
>= Greater than or equal to (GE)
<= Less than or equal to (LE)

This table shows the range definition:

[a..b] Range between a and b, including both a and b
[a..b> Range between a and b, including a and excluding b
<a..b] Range between a and b, excluding a and including b
<a..b> Range between a and b, excluding both a and b
in Exists in range
not in Does not exist in range

Note: string literals must be single quoted.

This table shows some examples:

(A != 9.0) True if A does not equal 9.0
(A <= “Davies”) True if A is less than or equal to “Davies”
(A in [3.4..8.10]) True if A is in range 3.4 to 8.10
(A in [3..8>) True if A is in range 3 to 8, excluding value 8 itself.

You can use commas to specify a list of values.

This table shows some examples:

(A in [a,b]) True if A is equal to a or b
(A in [a,b,e,f,z]) True if A is equal to a, b, e, f, or z
(A in [3..8,15,22]) True if A is in range 3 to 8, 15 or 22

You can logically combine conditional expressions into compound boolean (and, or) or arithmetic (+, -, *, /) expressions.

This table shows some examples:

(A in [3.4..8]) and (B > 2) True if A is in range 3.4 to 8 and B is greater than 2
(B in <”Brown”..”Miller”]) True if B is in range 'Brown' to 'Miller', excluding value 'Brown' itself
(((A <> 6) and (B >= 9)) or (C <= 7)) True in these two situations:
  • A is not equal to 6 and B is greater than or equal to 9
  • C is less than or equal to 7

To define null values in a condition, for example for datetime datatype, the NULL value is:

1970-01-01T00:00:00Z