Data Cache Data Model
dc_event_log: Events |
Name: dc_event_log
An action by the software and is typically used to aid analysis of what happened when.
Catalog: Cache
Schema: Invantive
Alias: deg
Primary Keys: deg_id
Label: Events
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
dcr_id |
decimal |
Datacontainer ID |
☐ |
Reference to a data container. |
dcr_label |
string(240) |
Datacontainer 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 |
Partitie ID |
☐ |
Reference to a partition. |
ptn_label |
string(240) |
Partitie Label |
☐ |
Reference to a partition. |
tbe_id |
decimal |
Tabel ID |
☐ |
Reference to a table. |
tbe_label |
string(240) |
Tabel Label |
☐ |
Reference to a table. |
tpn_id |
decimal |
Tabelpartitieversie ID |
☐ |
Reference to a table partition version. |
tpn_label |
string(240) |
Tabelpartitieversie Label |
☐ |
Reference to a table partition version. |
tpt_id |
decimal |
Tabelpartitie ID |
☐ |
Reference to a table partition. |
tpt_label |
string(240) |
Tabelpartitie Label |
☐ |
Reference to a table partition. |
26-06-2020 06:4820.1.99-BETA+2846
