Data Type for Attributes

Data Types for Attributes
Data Type	Description
Date	Can be in any of the supported Date formats. The attribute data type cannot be changed from Date to String.
Timestamp	Timestamp format allows you to select the date, time, and time zone together. You can add the Timestamp data type for a single value, multivalue, and relationship attributes. TIBCO MDM supports the following Timestamp formats: YYYY-MM-DD hh:mm:ss.SYYYY-MM-DD hh:mm:ss.S AM/PMYYYY-MM-DD hh:mm:ss.S zYYYY-MM-DD hh:mm:ss.S z AM/PM For more information about these formats and their usage, see Creating a User. You can also use the Timestamp data type in a rulebase. The date is converted to timestamp with 00 time before performing the operations. You can assign a timestamp to a date variable or an attribute, it results in truncation of the time portion. Similarly, you can assign a timestamp variable or attribute to a date variable, the date is converted to timestamp with 00 time. For more information, see TIBCO MDM Studio Rulebase Designer User Guide.
Integer	Can have a maximum scale of 10 and value must be less than 2147483648.
Decimal	The number can be represented as (p,s) where p is the precision and s is the scale and then describe everything with respect to precision and scale. Can have a maximum scale of 7 and a maximum precision of 30. The non-fractional part can be 23. The decimal value defined for the decimal type attribute for a repository gets rounded up. For example, when you create a record with a decimal attribute value as 60001111444466668888999.7832521.
String	The default length of a string attribute is determined by configuration, and unless changed, it is 256 characters (minimum). If zero is specified, default is assumed. The maximum characters limit is based on the database type that you have configured. For more information, see the "Configuration for String Data Type" section in TIBCO MDM Installation and Configuration Guide.
File	The default length of a File attribute is determined by configuration, and unless changed, it is 256 characters.
Amount	This can have a maximum scale of 7 and a maximum precision of 30.
Boolean	The boolean attribute can take `True` and `False` values. The values can be in a mixed case. For example, `true`, `TRUE`, or `True` and `false`, `FALSE`, or `False`. It can have a maximum length of five characters.
Custom Decimal	The number can be represented as (p,s) where p is the precision and s is the scale and then describe everything with respect to precision and scale. Use Custom Decimal if you need to store decimals that have more than eight digits in the fractional part. Can have a maximum scale of 29 and a maximum precision of 30. The non-fractional part of the number can have a maximum of 29 digits. However, this works only if your database supports the fractional part of a decimal to be over eight decimal places. The default values are: scale(12) + decimal point (1) + integer part (18) = 31 (maximum length)
Long	Long is a primitive data type that maps to Java Long. The behavior is similar to the Integer data type. The maximum length is 19.
URL	URL is a derived data type based on the String data type. The behavior is similar to the String data type, except for the following: Length: The default length is 256 and the maximum length is based on the database type that you have configured. The Length cannot be zero (0) or more than the maximum length. UI Representation: The URL view is a hyperlink. If you click the link, the URL opens in another tab.
For information about customizing the data types, see TIBCO® MDM Customization Guide.

Date

Can be in any of the supported Date formats.

The attribute data type cannot be changed from Date to String.

Timestamp

Timestamp format allows you to select the date, time, and time zone together. You can add the Timestamp data type for a single value, multivalue, and relationship attributes. TIBCO MDM supports the following Timestamp formats:

YYYY-MM-DD hh:mm:ss.SYYYY-MM-DD hh:mm:ss.S AM/PMYYYY-MM-DD hh:mm:ss.S zYYYY-MM-DD hh:mm:ss.S z AM/PM

For more information about these formats and their usage, see Creating a User.

You can also use the Timestamp data type in a rulebase. The date is converted to timestamp with 00 time before performing the operations.

You can assign a timestamp to a date variable or an attribute, it results in truncation of the time portion.
Similarly, you can assign a timestamp variable or attribute to a date variable, the date is converted to timestamp with 00 time.
For more information, see TIBCO MDM Studio Rulebase Designer User Guide.

Integer

Can have a maximum scale of 10 and value must be less than 2147483648.

Decimal

The number can be represented as (p,s) where p is the precision and s is the scale and then describe everything with respect to precision and scale. Can have a maximum scale of 7 and a maximum precision of 30. The non-fractional part can be 23.

The decimal value defined for the decimal type attribute for a repository gets rounded up. For example, when you create a record with a decimal attribute value as 60001111444466668888999.7832521.

String

The default length of a string attribute is determined by configuration, and unless changed, it is 256 characters (minimum). If zero is specified, default is assumed.

The maximum characters limit is based on the database type that you have configured. For more information, see the "Configuration for String Data Type" section in TIBCO MDM Installation and Configuration Guide.

File

The default length of a File attribute is determined by configuration, and unless changed, it is 256 characters.

Amount

This can have a maximum scale of 7 and a maximum precision of 30.

Boolean

The boolean attribute can take True and False values. The values can be in a mixed case. For example, true, TRUE, or True and false, FALSE, or False.

It can have a maximum length of five characters.

Custom Decimal

The number can be represented as (p,s) where p is the precision and s is the scale and then describe everything with respect to precision and scale. Use Custom Decimal if you need to store decimals that have more than eight digits in the fractional part. Can have a maximum scale of 29 and a maximum precision of 30. The non-fractional part of the number can have a maximum of 29 digits. However, this works only if your database supports the fractional part of a decimal to be over eight decimal places.

The default values are:

scale(12) + decimal point (1) + integer part (18) = 31 (maximum length)

Long

Long is a primitive data type that maps to Java Long. The behavior is similar to the Integer data type. The maximum length is 19.

URL

URL is a derived data type based on the String data type. The behavior is similar to the String data type, except for the following:

Length: The default length is 256 and the maximum length is based on the database type that you have configured. The Length cannot be zero (0) or more than the maximum length.
UI Representation: The URL view is a hyperlink. If you click the link, the URL opens in another tab.

For information about customizing the data types, see TIBCO® MDM Customization Guide.