Data Cache Data Model

dcr_id

decimal

Data Container ID

☐

Reference to a data container.

dcr_label

string(240)

Data Container Label

☐

Reference to a data container.

deg_category_code

string(30)

Category Code

☐

Code of category uniquely typing this event.

deg_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.

deg_created_by

string(60)

Created by

☑

Who created the record.

deg_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.

deg_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.

deg_date_started

datetime

Start Date

☐

Date/time at which the action leading to this event started.

deg_free_field_1

string(240)

Free text column 1

☐

Unstructured information related to the event.

deg_free_field_2

string(240)

Free text column 2

☐

Unstructured information related to the event.

deg_free_field_3

string(240)

Free text column 3

☐

Unstructured information related to the event.

deg_free_field_4

string(240)

Free text column 4

☐

Unstructured information related to the event.

deg_free_field_5

string(240)

Free text column 5

☐

Unstructured information related to the event.

deg_id

decimal

ID

☑

Unique identifier.

deg_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.

deg_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.

deg_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.

deg_orig_system_reference

string(240)

Original System Reference

☐

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

deg_session_created

string(240)

Session Created

☑

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

deg_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

deg_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

deg_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.

deg_txt

string(240)

Text

☑

Text of message.

ptn_id

decimal

Partition ID

☐

Reference to a partition.

ptn_label

string(240)

Partition Label

☐

Reference to a partition.

tbe_id

decimal

Table ID

☐

Reference to a table.

tbe_label

string(240)

Table Label

☐

Reference to a table.

tpn_id

decimal

Table Partition Version ID

☐

Reference to a table partition version.

tpn_label

string(240)

Table Partition Version Label

☐

Reference to a table partition version.

tpt_id

decimal

Table Partition ID

☐

Reference to a table partition.

tpt_label

string(240)

Table Partition Label

☐

Reference to a table partition.