Factset · Schema

TableField

FinancialFinancial DataInvestment AnalyticsMarket DataPortfolio AnalyticsResearch

Properties

Name Type Description
id string Unique identifier for a combination of table and data field
dataItemId string Unique identifier for the data item
name string Name of the data field
dataType string Data type of the data field
position integer Column position of the data field within the table
isPrimaryKey boolean Flag indicating if the data field is a primary key.
nullable boolean Flag indicating if a data field is nullable
hasCodeDependency boolean Flag indicating if the field's value is determined by a code value in its row. The monetary, splitAffected and unitFactor fields for that value will also be inherited from the code.
monetary boolean Flag indicating if the data field contained in this TableField is monetary. If true, this field can have exchange rates applied to convert to other currencies
splitAffected boolean Flag indicating if the data field contained in this TableField can be affected by splits
unitFactor string Factor to indicate what units that the data field is displayed in. If null, the field does not need to have a factor applied to obtain the real value
description string A description of the data field within the context of its table
View JSON Schema on GitHub

JSON Schema

factset-content-feeds-data-dictionary-table-field-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "TableField",
  "type": "object",
  "properties": {
    "id": {
      "type": "string",
      "description": "Unique identifier for a combination of table and data field"
    },
    "dataItemId": {
      "type": "string",
      "description": "Unique identifier for the data item"
    },
    "name": {
      "type": "string",
      "description": "Name of the data field"
    },
    "dataType": {
      "type": "string",
      "description": "Data type of the data field"
    },
    "position": {
      "type": "integer",
      "description": "Column position of the data field within the table"
    },
    "isPrimaryKey": {
      "type": "boolean",
      "description": "Flag indicating if the data field is a primary key."
    },
    "nullable": {
      "type": "boolean",
      "description": "Flag indicating if a data field is nullable"
    },
    "hasCodeDependency": {
      "type": "boolean",
      "description": "Flag indicating if the field's value is determined by a code value in its row. The monetary, splitAffected and unitFactor fields for that value will also be inherited from the code."
    },
    "monetary": {
      "type": "boolean",
      "description": "Flag indicating if the data field contained in this TableField is monetary. If true, this field can have exchange rates applied to convert to other currencies"
    },
    "splitAffected": {
      "type": "boolean",
      "description": "Flag indicating if the data field contained in this TableField can be affected by splits"
    },
    "unitFactor": {
      "type": "string",
      "description": "Factor to indicate what units that the data field is displayed in. If null, the field does not need to have a factor applied to obtain the real value"
    },
    "description": {
      "type": "string",
      "description": "A description of the data field within the context of its table"
    }
  }
}