Domains

Domains define common information about data such as data type, length, alignment, valid ranges, display format, and capitalization rules.

Domains insure consistent data types for fields and variables. Domains can be linked to table fields, form fields, and program variables.

The following table shows some domains of the tc (Common) package.

Domains for tc package
DomainDescriptionType
dateDateUTC Date/Time
emnoEmployee NumberString
relcReconciliation ElementString
reopReorder PointLong
rntpRun TypeEnumerated
rutmRun Time in MinutesDouble

 

The following figure shows the details of the tc emno (Employee Number) domain.

Domain properties Example

Domain properties Example

Domains of type Enumerated or Set have constants with language-dependent descriptions. Each constant has three characteristics:

  • Numeric value that is stored in the database
  • Constant Name that the programmer can use
  • Constant Description that provides the description of the option to the user, in the language of the user

For example: the tc styp (Schedule type) domain has the following constants:

ConstantConstant NameDescription
1not.applicableNot Applicable
2pullPull Schedule
3pushPush Schedule

 

To create domains

You can create domains in the Domains (ttadv4500m000) session.

See To create a data model.