# SYSTEMDATACONTAINERS: Data Dictionary Datacontainer Active data containers. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `dcr` - Label: Datacontainer This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMDATACONTAINERS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ALIAS` | `varchar2(240)` | Alias | ☐ | Alias of the data container. | | `CONSUMPTION_LAST_CALL` | `number` | | ☐ | Number of calls or credits the platform charged for its last answer. | | `DAILY_LIMIT` | `number` | | ☐ | Number of calls allowed per day. | | `DAILY_REMAINING` | `number` | | ☐ | Number of calls left of the current day. | | `DAILY_RESET_DATE_UTC` | `datetime` | | ☐ | Moment at which the number of calls allowed per day is replenished. | | `DAILY_USED` | `number` | | ☐ | Number of calls spent of the current day. | | `HOURLY_LIMIT` | `number` | | ☐ | Number of calls allowed per hour. | | `HOURLY_REMAINING` | `number` | | ☐ | Number of calls left of the current hour. | | `HOURLY_RESET_DATE_UTC` | `datetime` | | ☐ | Moment at which the number of calls allowed per hour is replenished. | | `ID` | `varchar2(4000)` | ID | ☐ | Data container ID. | | `IS_DEFAULT_FLAG` | `char` | Is Default? | ☑ | Is the default provider? | | `IS_SERVICE_PROVIDER_FLAG` | `char` | Is Service Provider? | ☑ | Is the provider a service provider? | | `LAST_MEASUREMENT_UTC` | `datetime` | | ☐ | Moment the platform last stated its rate limit, without which the figures beside it can not be read. | | `MINUTELY_LIMIT` | `number` | | ☐ | Number of calls allowed per minute. | | `MINUTELY_REMAINING` | `number` | | ☐ | Number of calls left of the current minute. | | `MINUTELY_RESET_DATE_UTC` | `datetime` | | ☐ | Moment at which the number of calls allowed per minute is replenished. | | `PARTITIONS_COUNT` | `int32` | Number of Partitions | ☐ | Number of partitions. | | `PARTITIONS_SELECTED_COUNT` | `int32` | Number of Selected Partitions | ☐ | Number of selected partitions. | | `PROVIDER_DATABASE_POOL_DESCRIPTION` | `varchar2(240)` | Provider Database Pool Description | ☐ | Pool description of the database. | | `PROVIDER_DATABASE_PRICING_TIER` | `varchar2(240)` | Provider Database Pricing Tier | ☐ | Pricing tier of the database. | | `PROVIDER_DATABASE_SERVICE_TIER` | `varchar2(240)` | Provider Database Service Tier | ☐ | Service tier of the database. | | `PROVIDER_DATABASE_VERSION_NUMBER` | `varchar2(240)` | Provider Database Version Number | ☐ | Version number of the database. | | `PROVIDER_DATABASE_VERSION` | `varchar2(240)` | Provider Database Version | ☐ | Version text of the database. | | `PROVIDER_DESCRIPTION` | `varchar2(16000)` | Provider Description | ☐ | Description of the provider. | | `PROVIDER_INSTANCE_UID` | `guid` | Provider Instance UID | ☑ | Unique ID of the provider instance. | | `PROVIDER_NAME` | `varchar2(240)` | Provider Name | ☑ | Name of the provider. | | `PROVIDER_SHORT_NAME` | `varchar2(240)` | Provider Short Name | ☑ | Short name of the provider. | | `SECONDLY_LIMIT` | `number` | | ☐ | Number of calls allowed per second. | | `SECONDLY_REMAINING` | `number` | | ☐ | Number of calls left of the current second. | | `SECONDLY_RESET_DATE_UTC` | `datetime` | | ☐ | Moment at which the number of calls allowed per second is replenished. | | `SESSION_TIME_UTC_OFFSET_SECONDS` | `int32` | UTC Session Time Offset (sec) | ☑ | UTC session offset (seconds). | | `UI_LANGUAGE_CODE` | `varchar2(30)` | UI Language Code | ☐ | User interface language code. | | `USER_COMPANY_ADDRESS_LINE_1` | `varchar2(240)` | User Company Address Line 1 | ☐ | Address line 1 of the company of the user. | | `USER_COMPANY_ADDRESS_LINE_2` | `varchar2(240)` | User Company Address Line 2 | ☐ | Address line 2 of the company of the user. | | `USER_COMPANY_ADDRESS_LINE_3` | `varchar2(240)` | User Company Address Line 2 | ☐ | Address line 3 of the company of the user. | | `USER_COMPANY_BIC` | `varchar2(4000)` | Company BIC | ☐ | BIC of the company of the user. | | `USER_COMPANY_CITY` | `varchar2(240)` | User Company City | ☐ | City of the company of the user. | | `USER_COMPANY_COC_NUMBER` | `varchar2(240)` | User Company CoC Number | ☐ | CoC number of the company of the user. | | `USER_COMPANY_COUNTRY` | `varchar2(4000)` | | ☐ | Country of the company of the user. | | `USER_COMPANY_CURRENCY_CODE` | `varchar2(240)` | | ☐ | Currency code of the company of the user. | | `USER_COMPANY_DATE_ESTABLISHED` | `date` | User Company Established | ☐ | Date established of the company of the user. | | `USER_COMPANY_EMAIL_ADDRESS` | `varchar2(240)` | User Company Email Address | ☐ | Email address of the company of the user. | | `USER_COMPANY_EMPLOYEES` | `int32` | User Company Employees | ☐ | Number of employees of the company of the user. | | `USER_COMPANY_GLN_NUMBER` | `varchar2(240)` | | ☐ | GLN number of the company of the user. | | `USER_COMPANY_IBAN` | `varchar2(4000)` | Company IBAN | ☐ | IBAN of the company of the user. | | `USER_COMPANY_ID` | `varchar2(4000)` | User Company ID | ☐ | Unique ID of the company of the user. | | `USER_COMPANY_LEGAL_STRUCTURE` | `varchar2(240)` | User Company Legal Structure | ☐ | Legal structure of the company of the user. | | `USER_COMPANY_NAME` | `varchar2(4000)` | User Company Name | ☐ | Name of the company of the user. | | `USER_COMPANY_PAYPAL_IDENTIFIER` | `varchar2(240)` | User Company PayPal Identifier | ☐ | PayPal identifier of the company of the user. | | `USER_COMPANY_PHONE` | `varchar2(4000)` | User Company Phone | ☐ | Phone of the company of the user. | | `USER_COMPANY_POSTAL_CODE` | `varchar2(4000)` | | ☐ | ZIP-code of the company of the user. | | `USER_COMPANY_RSIN_NUMBER` | `varchar2(240)` | User Company RSIN Number | ☐ | RSIN number of the company of the user. | | `USER_COMPANY_SIRET_NUMBER` | `varchar2(240)` | User Company SIRET Number | ☐ | SIRET number of the company of the user. | | `USER_COMPANY_STATE` | `varchar2(4000)` | | ☐ | State of the company of the user. | | `USER_COMPANY_TRADENAMES` | `varchar2(240)` | User Company Tradenames | ☐ | Tradenames of the company of the user. | | `USER_COMPANY_VAT_NUMBER` | `varchar2(240)` | User Company VAT Number | ☐ | VAT number of the company of the user. | | `USER_COMPANY_WAGE_TAX_NUMBER` | `varchar2(240)` | | ☐ | Wage tax number of the company of the user. | | `USER_COMPANY_WEB_SITE` | `varchar2(4000)` | User Company Website | ☐ | Web site of the company of the user. | | `USER_EMAIL_ADDRESS` | `varchar2(240)` | User Email Address | ☐ | User email address. | | `USER_FIRST_NAME` | `varchar2(240)` | User First Name | ☐ | User first name. | | `USER_GENDER` | `varchar2(30)` | User Gender | ☐ | User gender. | | `USER_ID` | `varchar2(240)` | User ID | ☐ | User ID. | | `USER_LANGUAGE_CODE` | `varchar2(240)` | User Language Code | ☐ | User language code. | | `USER_LANGUAGE` | `varchar2(240)` | User Language | ☐ | User language. | | `USER_LAST_LOGON` | `datetime` | User Last Logon | ☐ | User last logon. | | `USER_LAST_NAME` | `varchar2(240)` | User Last Name | ☐ | User last name. | | `USER_LINKED_IN_ACCOUNT` | `varchar2(240)` | User LinkedIn Account | ☐ | User LinkedIn account URL. | | `USER_LOG_ON_CODE` | `varchar2(240)` | User Log On Code | ☐ | User log on code. | | `USER_MIDDLE_NAME` | `varchar2(240)` | User Middle Name | ☐ | User middle name. | | `USER_MOBILE_NUMBER` | `varchar2(240)` | User Mobile Number | ☐ | User mobile number. | | `USER_NAME_AND_COMPANY` | `varchar2(240)` | User Name and Company | ☐ | User name and company name. | | `USER_NAME` | `varchar2(240)` | User Name | ☐ | User name. | | `USER_NATIONALITY` | `varchar2(240)` | User Nationality | ☐ | User nationality. | | `USER_PHONE_NUMBER` | `varchar2(240)` | User Phone Number | ☐ | User phone number. | | `USER_PICTURE_BLOB` | `blob` | User Picture (BLOB) | ☐ | User picture as BLOB. | | `USER_PICTURE_MIME_TYPE` | `varchar2(240)` | User Picture MIME Type | ☐ | User picture MIME type. | | `USER_PICTURE_URL` | `varchar2(4000)` | User Picture (URL) | ☐ | User picture URL. | | `USER_SKYPE_ACCOUNT` | `varchar2(240)` | User Skype Account | ☐ | User Skype account. | | `USER_TITLE` | `varchar2(240)` | User Title | ☐ | User titlet. | | `USER_TWITTER_ACCOUNT` | `varchar2(240)` | User Twitter Account | ☐ | User Twitter account. | | `USER_WEBSITE_URL` | `varchar2(240)` | User Website | ☐ | User website URL. |