Archivelog

The Archivelog dataset contains data regarding actions performed in F2. ArchiveLog provides general information about actions in F2. See the ArchiveLogDetails dataset for more detailed information about each action.

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 internal F2 database ID of the action.

bigint identity

12058

69

ExecutedByPartyId

The internal F2 database ID of the acting user.

PartyRegistry

int

7613

1298

LogOnUserPartyId

The internal F2 database ID of the logged-in user if they acted on behalf of another user.

PartyRegistry

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

Specifies the action.

nvarchar

100

Create dossier

Approval process created

InternalCaseId

The internal F2 database ID of the case affected by the action.

Cases

bigint

5696

1279

InternalDossierId

The internal F2 database ID of the record affected by the action.

Dossiers

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

ArchiveLog action types

Actions in F2 are logged in ArchiveLog in the "operationTypeText" column. The table below provides an overview of the actions that are logged and what they correspond to in F2.

Use this overview to assess which action types to use and combine in order to create reports that are relevant for your organisation. The dataset can be combined in many ways, depending on the information you seek. For example, you can create reports about your approval processes with action types such as "Approval process created", "Approval process started", and "Approval process approved". You can also create reports about the efficiency of your approval processes, how often they are approved, returned, or cancelled.

Action type F2 action Additional information

"Document Seen"

The document was seen, either in its original format, in the preview, or as a PDF.

"Create Case"

A case was created.

"Change Case Properties"

The case metadata was edited.

Each edited metadata field is logged on a separate line.

The "Description" column shows the before and after values of the edited field. The column shows special information for changes to the "Status" and "External access" fields.

"Create Dossier"

A record was created.

Additional record information is available in the "Description" column.

"Change Dossier Properties"

The record metadata was edited.

Each edited metadata field is logged on a separate line. The "Description" column shows the before and after values of the edited field. The column shows special information for certain fields.

"ReJournalize"

A record was moved from one case to another.

"Add Party To Case"

A participant was added to the case.

The "Description" column shows the participant type and name.

"Remove Party From Case"

A participant was removed from the case.

The "Description" column shows the participant type and name.

"Add Party to Dossier"

A participant was added to the record.

The "Description" column shows the participant type and name.

"Remove Party From Dossier"

A participant was removed from the record.

The "Description" column shows the participant type and name.

"Document Moved"

The document was moved using drag and drop.

The "Description" column shows which records/cases the document was moved from and to.

"Document Copied"

The document was copied.

The "Description" column shows which records/cases the document was copied from and to.

"Document Deleted"

The document was deleted.

"Manual Pdf Uploaded"

A PDF was uploaded manually.

"Delete Dossier"

The record was deleted for everyone.

This action is logged when using the "Delete record for everyone" privilege, when deleting a case, or in connection with a cleanup task.

"Create New Dossier Version"

A new version of the record was created, or a previous version was restored.

"Send Dossier"

The record was sent.

A line in the log is created when the record receives a send date.

"Change Document Properties"

The document’s metadata has been edited, or the most recent author has changed.

The "Description" column shows the before and after values of the edited field or the before and after author’s name.

"Create New Document Version"

A new document version was created.

When a user has edited the document, it is possible to save it as a new document version.

"Document Created"

A new document was created.

"Create Endorsement"

A new annotation was created.

The first 50 characters of its contents appear in the "Description" column.

"Edit Endorsement"

The annotation was edited.

The first 50 characters of its contents appear in the "Description" column.

"Endorsement Seen"

The annotation was seen.

The first 50 characters of its contents appear in the "Description" column.

"Node Party Updated"

A participant associated with the case or record was edited.

The "Description" column shows the before and after value for the participant property that was edited.

"Keyword Added"

A keyword was added to the record or case.

The keyword appears in the "Description" column.

"Keyword Removed"

A keyword was removed from the record or case.

The keyword appears in the "Description" column.

"Archive Search"

A search was performed in the archive.

The search may be for cases, records, or in folders. Does not include searches related to private records, cleanup searches, case guide searches related to search templates, searches for related cases, searches for case and record participants as well as F2 Manager searches.

The "Description" column contains a textual representation of the search that was performed.

"Dossier Seen"

The record was seen.

This means that the record’s metadata was retrieved from the database.

"Dossier Status Changed"

The status of the record was changed, either from "In process" to "Completed" or vice versa.

The before and after values appear in the "Description" column.

"Dossier Archived Changed"

The record’s registration status was changed, i.e. the "Registered" box was ticked or unticked.

The before and after values appear in the "Description" column.

"Access group added"

A user/unit/security group was added to the access restriction of the record/case.

The name of the added user/unit/security group appears in the "Description" column.

"Access group removed"

A user/unit/security group was removed from the access restriction of a record/case.

The name of the user/unit/security group that was removed appears in the "Description" column.

"Create Requisition"

A request was created (F2 version 4.2 or earlier).

The request number appears in the "Description" column. It contains the first 50 characters of the request description.

"Edit Requisition"

A request was edited (F2 version 4.2 or earlier).

The request number appears in the "Description" column. It contains the first 50 characters of the request description.

"Requisition Seen"

The request was seen (F2 version 4.2 or earlier).

The request number appears in the "Description" column. It contains the first 50 characters of the request description.

"Create Dossier from Mail"

A record was created based on an email.

This is usually internal emails created in the system, such as an email created in another authority or a notification email sent when an administrator changes a user’s settings.

"Extension Data Created"

Extension data has was created for the case or record.

Only logged only the first time extension data is created. Subsequent data creation is registered as edits (see next row).

"Extension Data Updated"

The extension data was edited.

The before and after values appear in the "Description" column.

"Create Dossier from Folder"

A record was created based on a file imported from a folder.

"Create Dossier from Scanner"

Import of an email from a known scanner IP address.

"Resend Dossier"

The record was resent due to an error in the original delivery.

"Requisition deadline edited"

The request deadline was edited (F2 version 4.2 or earlier).

The new and previous deadlines appear in the "Description" column.

"Create new requisition"

A request was created (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Edit new requisition"

The details of a request were edited (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Delete new requisition"

The request was deleted (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"See new requisition"

The request was seen (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Requisition Deadline Changed"

The request deadline was changed after the request was accepted (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number and the new and old deadlines appear in the "Description" column.

If the deadline is edited before the request is accepted, it is logged as an "Edit new requisition" action (three rows above).

"Requisition Sent"

The request was sent (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number and recipient appear in the "Description" column.

"Requisition Distributed"

The request has been forwarded (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number and the new recipient appear in the "Description" column.

"Requisition Retracted"

The request was cancelled (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Requisition Executed"

The request was executed manually (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Requisition Assessed"

The request was finalised or evaluated (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Approval process created"

An approval was created on the record.

"Approval process design updated"

An approval process was edited.

This includes all actions performed from the "Edit approval process" dialogue.

"Approval process started"

An approval process was started.

"Approval process approved"

The approval was approved on an approval step.

The approval step and the next step (or completed) appear in the "Description" column.

"Approval process returned"

The approval was returned to a previous step.

The step and recommended action appear in the "Description" column.

"Approval process resumed"

The approval process was resumed.

Step for resumption and recommended action appear in the "Description" column.

"Approval process retracted"

The approval was withdrawn.

The "Description" column shows which step the approval had reached.

"Copy dossier to case"

The record was copied to another case.

The number of the case to which the record was copied and the record ID of the original record appear in the "Description" column.

"Requisition answer created"

An answer record for a request was created or selected.

The request number appears in the "Description" column.

"External requisition received"

A record (copy) was created upon receipt of a group request from another authority on the same installation.

The request number appears in the "Description" column.

"Requisition received in external authority"

A group request was received from another authority on the same installation.

The request number appears in the "Description" column.

"Requisition synchronization received"

A group request was updated in the recipient authority after the request was edited in the sender authority.

The request number appears in the "Description" column.

"Requisition answer from external received"

An answer record to a group request was received from another authority on the same installation.

The request number appears in the "Description" column.

"Requisition answer from external added"

An answer record was associated with a group request.

The request number appears in the "Description" column.

"Requisition answer sent"

An answer to the request was sent (F2 version 4.3 or later).

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Requisition info mail created"

An info mail regarding the request was created.

This may be an internal, external, or group request. The request number appears in the "Description" column.

"External requisition created"

A group request was created.

The request number appears in the "Description" column.

"RequisitionAnswerSentFromExternalAdded"

An answer record from a group request was received.

The request number appears in the "Description" column.

"Approval process cancelled"

An approval process was cancelled.

"Approval process uncancelled"

A cancelled approval process was resumed.

"Approval process deleted"

An approval process was deleted.

"Folder addet to case"

A case folder was created.

The folder’s name appears in the "Description" column.

"Rename case folder"

A case folder was renamed.

The old and new names of the folder appear in the "Description" column.

"Delete case folder"

The case folder was deleted.

The folder’s name appears in the "Description" column. If the deleted case folder contained sub-folders, these are logged separately.

"Move case folder"

The case folder was moved.

The case folder’s name and previous location appear in the "Description" column.

"QualityStamp created"

A quality stamp was added to the case.

"QualityStamp description changed"

The quality stamp description was edited.

"QualityStamp deleted"

The quality stamp was deleted.

"Note created"

A note was created on a record or case.

The first 50 characters of the note’s contents appear in the "Description" column.

"Note deleted"

A note was deleted from a record or case.

The first 50 characters of the note’s contents appear in the "Description" column.

"Requisition receiver assessed"

The request was evaluated by the recipient.

This may be an internal, external, or group request. The request number appears in the "Description" column.

"Requisition receiver changed"

The request recipient was changed.

The request number and the old and new recipients appear in the "Description" column.

"Requisition answer removed"

An answer record was removed from the request.

The answer record’s record ID and the request number appear in the "Description" column.

"Dossier associated as requisition answer"

An answer record was associated with the request, both upon creation and selection of an answer record.

The request number appears in the "Description" column.

"Approval process seen"

The approval was seen by a copy recipient.

The approval step and approver appear in the "Description" column.

"Malware quarantined"

The antivirus service quarantined a document after detecting malware or a virus.

The document title and threat name (if available) appear in the "Description" column.

"Timeregistration created"

A time registration was manually created.

"Timeregistration edited"

The time registration was edited.

A line is created in ArchiveLogDetails for each edit. Edits are logged collectively in ArchiveLog.

"Timeregistration deleted"

The time registration was deleted.

Classification, date, start time, and end time appear in the "Description" column.

"Distributed requisition updated"

The external request was updated.

The request number and action appear in the "Description" column.

Possible Actions:

  • ReceiverAccess

  • Accept

  • Execute

  • AnswerCreated

  • Answered

  • AnswerRemoved

  • AcceptUpdated

  • Assessed

  • ForcedChangeDeadline

  • Retracted.

"Distributed requisition operation invalid"

An error occurred during validation of the external request.

The error message appears in the "Description" column.

"Distributed requisition operation failed"

A critical error occurred while handling the external request.

The error message appears in the "Description" column.

"Distributed requisition received"

An external request was received from another F2 installation.

The request number appears in the "Description" column.

"Dossier read for unit"

The record was marked as read in the unit’s inbox.

The unit’s name appears in the "Description" column.

"Dossier unread for unit"

The record was marked as unread in the unit’s inbox.

The unit’s name appears in the "Description" column.

"Added task guide to case"

A case guide was added to the case.

The title of the case guide appears in the "Description" column.

"Deleted task guide from case"

The case guide was removed from the case, either because the case guide was changed or because the case was deleted by a cleanup task.

The title of the case guide appears in the "Description" column.

"Changed task completion status"

The status of a task in a case guide changed from not completed to completed (or vice versa).

The task’s title and new status appear in the "Description" column.

"Created simple note"

A note was created on a task in the case guide.

The task’s title and note text appear in the "Description" column.

"Updated simple note"

The contents of a note in the case guide was edited.

The task’s title and the before and after versions of the note text appear in the "Description" column.

"Updated task guide group active"

The "active" value of a group in the case guide was edited.

The group’s name and the before and after value for "active" appear in the "Description" column.

"Assigned dossier to task"

The record was selected for a task in the case guide.

The task’s title and the record’s node ID and title appear in the "Description" column.

"Unassigned dossier from task"

The record has been removed from a task in the case guide.

The task’s title and the record’s node ID and title appear in the "Description" column.

"Approval process overruled"

The approval was taken over (an approver was either replaced or removed, or a step was removed).

The action and the before and after values appear in the "Description" column.

"Requisition internal deadline changed"

The request’s internal deadline was updated (F2 version 4.3 or later).

This may be an internal, external, or group request. The old and new deadlines and the request number appear in the "Description" column.

"Executed task"

A task in the case guide was completed.

The task’s title appears in the "Description" column.

"Executed task action"

An action in a task in the case guide was completed.

The task’s title, the action name, and the case guide ID appear in the "Description" column.

"New PDF for public disclosure dossier item created"

A new PDF of a record element in an FOI request was been created.

The document name appears in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"New public disclosure created"

A new FOI request was created.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Dossier added to public disclosure"

The record was added to the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Dossier removed from public disclosure"

The record was removed from the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Comment to public disclosure dossier added"

A comment was added to a record on an FOI request.

The comment appears in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure dossier excluded"

A record was excluded from the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure document excluded"

A document was excluded from the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure requisition excluded"

A request was excluded from the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure endorsement excluded"

An annotation was excluded from an FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure dossier included"

An excluded record was re-included in the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure document included"

An excluded document was re-included in the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure requisition included"

An excluded request was re-included in the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure endorsement included"

An excluded annotation was re-included in the FOI request.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Comment to public disclosure document added"

A comment was added to a document in the FOI request.

The comment appears in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Comment to public disclosure requisition added"

A comment was added to a request in the FOI request.

The comment appears in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Comment to public disclosure endorsement added"

A comment was added to an annotation in the FOI request.

The comment appears in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure finalized"

The FOI request was completed.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure content settings saved"

Content setup options for the FOI request were saved.

Case number and case title appear in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Public disclosure PDF created"

A PDF of the FOI request report was created.

The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"PublicDisclosureCopied"

The FOI request was copied.

The case number and case title of the case to which it was copied appear in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"PublicDisclosureImported"

The FOI request was imported.

The case number and case title for the case from which it was imported are shown in the "Description" column. The log registers actions in the modules "FOI Request" and "FOI Request, Advanced" in the same way.

"Dossier manually removed from outbook"

The record was manually removed from the inbox.

The context menu option "Remove from inbox". The user’s name appears in the "Description" column.

"Executed Ruby debug script"

A Ruby script was executed in debug mode.

Context and task title appear in the "Description" column.

"Case Seen"

The case was seen.

This means that the record’s metadata was retrieved from the database.

"Extension record updated"

The case information was updated in the case guide.

This means that fields in the case guide were saved. The field and its before and after values appear in the "Description" column.

"Extension row added"

A row was added to a list field in the case guide.

The list name appears in the "Description" column.

"Extension row updated"

A row in a list field in the case guide was changed.

The list name and before and after values appear in the "Description" column.

"Extension row deleted"

A row in a list field in the case guide was deleted.

The list name and position appear in the "Description" column.

"Unit flag changed for dossier"

The unit flag on the record was changed.

The before and after values appear in the "Description" column.

"Unit deadline changed for dossier"

The unit deadline on the record was changed.

The before and after values appear in the "Description" column.

"Task guide script administrator action"

A user with the "Case guide script administrator" privilege performed an action in the "Case guide scripts" dialogue in a case guide.

"Task guide script started"

Automation in the case guide was started.

The script name for the automation appears in the "Description" column.

"Task guide script failed"

Automation in the case guide failed.

The script name for the automation appears in the "Description" column.

"Task guide script completed"

Automation in the case guide was completed.

The script name for the automation appears in the "Description" column.

"Task guide script step error ignored"

Automation in the case guide continued after a failed action.

This occurs if the script is set up to ignore a certain error type. The script name for the automation appears in the "Description" column.

"Extension list deleted"

All rows in a list field in the case guide were deleted.

The list name appears in the "Description" column.

"Case import finished"

A case import was completed.

"Dossier import finished"

A record import was completed.

"Approval secretariat action"

The secretariat/gatekeeper has performed an action on the approval.

The before and after values appear in the "Description" column.

"Requisition rejected"

The request was rejected.

The request number appears in the "Description" column.

"Requisition execution comment saved"

A request execution comment was saved.

The request number appears in the "Description" column.

"Requisition executor set"

A request executor was added.

The request number appears in the "Description" column.

"Forced cancelling editing document"

A user’s editing of a document was forcefully cancelled.

The document’s title appears in the "Description" column.

"Forced cancelling editing dossier"

A user’s editing of a record was forcefully cancelled.

The record’s title appears in the "Description" column.

"Recalled sent dossier"

A record sent through output manager was recalled.

"Extension record created"

All case guide fields were created.

"Extension record deleted"

All case guide fields were deleted.

"Task guide changed"

The case’s case guide was changed.

The new case guide’s case guide key appears in the "Description" column.

"Dossier added to unit inbox"

The record was added to the unit’s inbox.

The unit’s name appears in the "Description" column.

"Dossier removed from unit inbox"

The record was removed from the unit’s inbox.

The unit’s name appears in the "Description" column.

"Dossier added to unit desktop"

The record was added to the unit’s desktop.

The unit’s name appears in the "Description" column.

"Dossier removed from unit desktop"

The record was removed from the unit’s desktop.

The unit’s name appears in the "Description" column.