Output field data types (Query Model) - 23.1

Spectrum Dataflow Designer Guide

Version: 23.1
Language: English
Product name: Spectrum Technology Platform
Title: Spectrum Dataflow Designer Guide
First publish date: 2007
Last updated: 2024-05-09
Published on: 2024-05-09T23:01:03.226155

Data Type	Description
bigdecimal	A numeric data type that supports 38 decimal points of precision. Use this data type for data that will be used in mathematical calculations requiring a high degree of precision, especially those involving financial data. The bigdecimal data type supports more precise calculations than the double data type. In custom queries, this data type is returned as string.
boolean	A logical type with two values: true and false.
date	A data type that contains a month, day, and year. For example, 2022-01-30 or January 30, 2022. You can specify a default date format in Management Console.
datetime	A data type that contains a month, day, year, and hours, minutes, and seconds. For example, 2022/01/30 6:15 PM.
double	A numeric data type that contains both negative and positive double precision numbers between 2^-1074 and (2-2^-52)×2¹⁰²³. In E notation, the range of values is 4.9E-324 to 1.7976931348623157E308. For information on E notation, see: http://en.wikipedia.org/wiki/Scientific_notation#E_notation
Dynamic Graph Fields	These fields include relationship and entities in Context Graph (corresponding to nodes and edges in graph theory). Entities—The individual entities that have the relationships you are identifying. If you choose this type of output field, you can change field names and determine which entities to include upon output. Note: If you create an output field this way, Query Model will auto-populate the schema for you. Relationships—The links between entities; the factor they share with other entities. If you choose this type of output field, you can change field names and determine which relationships to include upon output. Note: If you create an output field this way, Query Model will auto-populate the schema for you.
float	A numeric data type that contains both negative and positive single precision numbers between 2^-149 and (2-2²³)×2¹²⁷. In E notation, the range of values is 1.4E-45 to 3.4028235E38. For information on E notation, see: http://en.wikipedia.org/wiki/Scientific_notation#E_notation In custom queries, this data type is returned as double.
integer	A numeric data type that contains both negative and positive whole numbers between -2³¹ (-2,147,483,648) and 2³¹-1 (2,147,483,647). In custom queries, this data type is returned as long.
long	A numeric data type that contains both negative and positive whole numbers between -2⁶³ (-9,223,372,036,854,775,808) and 2⁶³-1 (9,223,372,036,854,775,807)
string	A sequence of characters.
time	A data type that contains the time of day. For example, 21:15:59 or 9:15:59 PM.If you want to add a field from your model, select Dynamic Model Fields and the tab will be populated with fields and properties from your model. The structure of this data is determined by whether you choose list output as well as the paths and names entered on Add Field dialog box.