Data Type Best Practices
Attribute Types can be assigned the following data types:
When determining the attribute type, it is best to choose the right type from the beginning as there is no mechanism to migrate to different data types after they are in use.
The attribute type 'Number' can be problematic if it is not the most appropriate for the values that will be stored. Sometimes the 'Number' type can cause issues when using Excel for Attribute Updates, or in Reporting.
'Number' should be used when something is being measured (i.e. length, miles, percentage, count of stuff). If a attribute needs to have any kind of 'contains', 'equals any', or similar search functionality, then 'String' should be used. If it is a unique identifier like an Agreement Number, 'String' is the most appropriate type to use.
If you have any questions or technical difficulties, you can reach out to disupport@thomsonreuters.com
Comments
0 comments
Please sign in to leave a comment.