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

# JSONRECORDTYPES: Data Dictionary JSON Record Types

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Label: JSON Record Types

The JSON record types of the products - the types whose files describe themselves through an OpenAPI specification derived at run time - with the specification and the documentation page of each.

Can only retrieve data.

## Table Columns

The columns of the table `JSONRECORDTYPES` 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 |
|---|---|---|:---:|---|---|
| `ASSEMBLY_NAME` | `varchar2(240)` | Assembly Name | [x] |  | Name of the assembly which declares the type. |
| `ASSEMBLY_VERSION` | `varchar2(60)` | Assembly Version | [x] |  | Version of the assembly, as major.minor.build.revision. |
| `CONNECTION_STRING_EXAMPLE` | `varchar2(1024)` | String Example | [ ] |  | Connection string of the Big Data JSON driver which reads the files, with placeholders for the specification and the directory. |
| `DESCRIPTION` | `clob` | Description | [ ] |  | Description of the records and their files, as written in the specification. |
| `FILE_NAME_MASK` | `varchar2(1024)` | Name Mask | [ ] |  | Mask of the names of the files, as documented by the process which writes them; empty here, since the views describe the types. |
| `ID` | `number` | ID | [x] |  | Sequence number of the record type. |
| `LABEL_PLURAL` | `varchar2(240)` | Label Plural | [x] |  | Label of the records, as a user interface names the table. |
| `MARKDOWN_FILE_NAME` | `varchar2(240)` | Markdown File Name | [x] |  | Name of the documentation page of the type, one page per type. |
| `MARKDOWN_PAGE` | `clob` | Markdown Page | [x] |  | The documentation page of the type as Markdown for the product documentation, rendered from the specification. |
| `RECORD_TYPE` | `varchar2(240)` | Record Type | [x] |  | Full name of the .NET type whose instances are the records. |
| `SCHEMA_NAME` | `varchar2(240)` | Schema | [x] |  | Schema of the table the files are read as by the Big Data JSON driver. |
| `SPECIFICATION` | `clob` | Specification | [x] |  | The OpenAPI specification as JSON text, generated from the type by this process. |
| `SPECIFICATION_FILE_NAME` | `varchar2(240)` | Specification File Name | [x] |  | Name of the specification file as the products write it beside their files, without the version. |
| `SPECIFICATION_VERSION` | `varchar2(60)` | Specification Version | [x] |  | Version of the specification, as major.minor of the assembly. |
| `TABLE_NAME` | `varchar2(240)` | Table Name | [x] |  | Name of the table the files are read as by the Big Data JSON driver. |
| `TITLE` | `varchar2(240)` | Title | [x] |  | Title of the specification. |

## Referenced By

- [JSONRECORDTYPECOLUMNS](DataDictionary.Invantive.JSONRECORDTYPECOLUMNS) `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)

