---
title: "JSONRECORDTYPECOLUMNS (Data Dictionary)"
description: "JSON Record Type Columns"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.JSONRECORDTYPECOLUMNS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.JSONRECORDTYPECOLUMNS
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# JSONRECORDTYPECOLUMNS: Data Dictionary JSON Record Type Columns

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Label: JSON Record Type Columns

The columns of the JSON record types of the products, one row per property of every type as its specification describes it.

Can only retrieve data.

## Table Columns

The columns of the table `JSONRECORDTYPECOLUMNS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CLR_PROPERTY` | `varchar2(240)` | Property | [ ] |  | Name of the .NET property, when it differs from the JSON name. |
| `CLR_TYPE` | `varchar2(240)` | Type | [ ] |  | Full name of the .NET type of the property. |
| `DESCRIPTION` | `clob` | Description | [ ] |  | What the value holds, as written in the specification. |
| `ENUM_VALUES` | `varchar2(4000)` | Enum Values | [ ] |  | The members of an enumeration as written, separated by commas; empty for other values. |
| `EXAMPLE` | `varchar2(1024)` | Example | [ ] |  | An example value, as text. |
| `ID` | `number` | ID | [x] |  | Sequence number of the column over all record types. |
| `JSON_FORMAT` | `varchar2(60)` | JSON Format | [ ] |  | OpenAPI format of the value, such as date-time, uuid or int64, when the type alone does not say it. |
| `JSON_TYPE` | `varchar2(60)` | JSON Type | [x] |  | OpenAPI type of the value: string, integer, number, boolean, array or object. |
| `LABEL` | `varchar2(240)` | Label | [ ] |  | Label of the column, as a user interface shows it. |
| `NAME` | `varchar2(240)` | Name | [x] |  | Name of the column, which is the JSON name of the property. |
| `NULLABLE` | `boolean` | Nullable | [x] |  | Whether the value may be absent or null. |
| `POSITION` | `number` | Position | [x] |  | Position of the column, counted from 1 in the order the serializer writes the properties. |
| `RECORD_TYPE` | `varchar2(240)` | Record Type | [x] |  | Full name of the .NET type whose instances are the records. |
| `TABLE_NAME` | `varchar2(240)` | Table Name | [x] |  | Name of the table the files are read as by the Big Data JSON driver. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `JSONRECORDTYPECOLUMNS_RECORD_TYPE_JSONRECORDTYPES_fk` | `RECORD_TYPE` | [JSONRECORDTYPES](DataDictionary.Invantive.JSONRECORDTYPES)`.RECORD_TYPE` | Key |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Data Dictionary](/en/release-notes/drivers?driver=data-dictionary)

