Archivelog
The Archivelog dataset contains data regarding actions taken in F2.
Importing to a BI database
The dataset is a log, which means there are no retroactive changes to the data. Periodic runs will continuously add new data to the table.
Column overview
The following table describes the columns available in the dataset. The table includes the following information about each column:
-
Dataset name: The column’s name in the dataset.
-
Description: Describes the column’s content and function.
-
Reference to other dataset: Specifies references to other datasets, if any.
-
Format: Specifies the format of the returned values.
-
Length: Specifies the length of the returned values, if any.
-
Examples: Examples of returned values.
| Dataset name | Description | Reference to other dataset | Format | Length | Examples |
|---|---|---|---|---|---|
Id |
The ID of the action. |
bigint identity |
12058 69 |
||
ExecutedByPartyId |
The ID of the acting user. |
int |
7613 1298 |
||
LogOnUserPartyId |
The ID of the logged-in user if they acted on behalf of another user. |
int |
7613 1298 |
||
eventTime |
The time and date of the action. |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
operationTypeText |
The action as text. |
nvarchar |
100 |
Create dossier Approval process created |
|
InternalCaseId |
The internal database ID of the case affected by the action. |
bigint |
5696 1279 |
||
InternalDossierId |
The internal database ID of the record affected by the action. |
bigint |
2079 3987 |
||
PartyName |
The name of the participant affected by the action, e.g. who was updated or added to a case. |
nvarchar |
512 |
Admin Hugo Hugosen |
|
PartyType |
The type of the participant affected by the action, e.g. who was updated or added to a case. |
int |
15 3 |
||
description |
An optional description of the action. |
nvarchar |
2048 |
Approved on step: 1 - next step: Finalised 310.004 |