Please enable JavaScript to view this site.

Manual Invantive Data Cache

Navigation: Catalog: Cache > Schemas > Schema: Invantive > Tables

dc_data_containers: Data Containers

Scroll Comments Prev Top Next More

Name: dc_data_containers

Bundle of one or more partitions with data in tables associated with a physical source.

Catalog: Cache

Schema: Invantive

Alias: dcr

Primary Keys: dcr_id

Label: Data Containers

Table Columns

Name

Data Type

Label

Required

Documentation

dcr_created_at

string(60)

Created in

The code of the function in the modules table from within which the user created the record. This value will never change after creation of the record.

dcr_created_by

string(60)

Created by

Who created the record.

dcr_date_created

datetime

Created at

The system time in UTC at which the record was created. This value will never change after creation of the record.

dcr_date_modified

datetime

Updated at

The system time in UTC at which the record was last updated. This value will change for every mutation of the record.

dcr_description

string(5)

Description

Description.

dcr_fragment_code

string(5)

Table Name Fragment Code

Random sequence of characters used to compose the name of the facts table with.

dcr_id

decimal

ID

Unique identifier.

dcr_modified_at

string(60)

Updated in

The code of the function in the modules table from within which the user last updated the record. This value will change for every mutation of the record.

dcr_modified_by

string(60)

Updated by

The name of the user in the users table whom last updated the record. This value will change for every update of the record.

dcr_name

string(240)

Name

Name of the data container.

dcr_orig_system_group

string(240)

Original System Group

Reference for identifying the group of records on the system from which it originated. It is commonly used to group records for later validation in an application control.

dcr_orig_system_reference

string(240)

Original System Reference

Reference for identifying the record on the system from which it originated.

dcr_session_created

string(240)

Session Created

The ID of the session which created the record. This value will not change after insert.

dcr_session_modified

string(240)

Session Updated

The ID of the session which last updated the record.

dcr_transaction_created

string(240)

Transaction Created

The ID of the transaction which created the record.

dcr_transaction_modified

string(240)

Transaction Updated

The ID of the transaction which last updated the record.

 

17-06-2019 12:0717.33.37-BETA+2162