ArchivelogDetails

The ArchivelogDetails dataset contains data regarding events that took place 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

12

96

archiveLogId

The ID of the action as logged in Archivelog.

Archivelog

bigint

73

64868

objecttype

The type of object affected by the action.

nvarchar

100

F2Dossier

NodeParty

attributename

The field of the object affected by the action.

nvarchar

2048

Title

AccessType

FROM

The value in the field prior to the action.

nvarchar

2000

InProgress

08-01-2021

FALSE

To

The value in the field after the action.

nvarchar

2000

Closed

17-01-2021

TRUE