Records

Below is a description of the columns that extract data about record metadata. This includes everything from data in the record’s metadata fields to other visible metadata such as the record’s version and derived data, i.e. whether the record was completed before its deadline. As a rule the value that appears on the active version of the record is displayed.

Column name Description Value type

Access

The value specified in the "Access" metadata field.

String

Sender

The user, unit, or external participant specified in the "From" metadata field. If the record has been sent as an email, it will correspond to the sender.

String

Record - version

Number of the current record version.

Number

Record completed

Date and time when the record last changed status to "Completed".

Date

Record completed by

Name of the user who last completed the record.

String

Record last updated

Date and time when the record was last updated. The time specifies when the changes were saved.

Date

Record created

Date and time specified in the "Created date" metadata field.

Date

Record created by

Name of the user who created the record specified in the "Created date" metadata field.

String

Access limitation on record

All users, units, teams, and security groups specified in the "Access restricted to" metadata field.

String

Record responsible

The user or unit specified in the "Responsible" metadata field.

String

Unit responsible for record

The unit or the unit associated with the user that is specified in the "Responsible" metadata field.

String

SSN/CVR No of record

The value specified in the "SSN/CVR No" metadata field.

String

Record keyword

The keyword(s) specified in the "Keyword" metadata field.

String

Record deadline

The date specified in the "Deadline" metadata field at midnight.

Date

Record internal ID

The unique value that serves as the record’s ID in the database.

Number

Record participants

The participant(s) specified in the "Record participants" metadata field.

String

Record status

The value specified in the "Status" metadata field.

String

Record suppl. units

Units specified in the "Suppl. case mgr." metadata field.

String

Record suppl. case mgr.

Names of users specified in the "Suppl. case mgr." metadata field.

String

Record format

A detailed specification of the record’s delivery type.

String

Record ID

The record’s unique ID number in the authority’s archive displayed at the top of the record window.

Number

Record ID, record reply

The unique ID number of the record in the authority’s archive to which this record is a reply.

Number

Record ID, forwarded record

The unique ID number of the record in the authority’s archive of which this record is a forwarded version.

Number

Record number

The record’s unique ID number on the case specified in the "Record No" metadata field, which is automatically assigned during registration.

Number

Record title

The full record title displayed at the top of the record window and in the "Title" metadata field.

String

Record title, record reply

The title of the record to which this record is a reply.

String

Record title, forwarded record

The full title of the record of which this record is a forwarded version.

String

Record type

The value specified in the "Record type" metadata field.

String

Archive area

The record’s location in F2’s general archive areas:

  • "Archive"

  • "My private records"

  • "Library"

  • "My deleted records"

String

Bcc

The participant(s) specified in the "Bcc" metadata field, if any.

String

Request

Indicates whether there is at least one request on the record.

Boolean

Letter date

Date and time specified in the "Letter date" metadata field.

Date

Cc

The participant(s) specified in the "Cc" metadata field, if any.

String

Document locked

Indicates whether documents on the record (including the record document) are locked for editing. Visually this is indicated by the "Lock documents" menu item.

Boolean

External access

The value specified in the "External access" metadata field.

String

Email received

Date and time specified in the "Received date" metadata field.

Date

Email sent

Date and time when the record was sent as an email. This typically corresponds to the "Letter date" metadata field.

Date

Email title

The title of the record at the time it was sent as an email.

String

Remind Date

Date and time specified in the "Remind date" metadata field.

Date

Registered

Indicates whether the "Registered" checkbox is ticked.

Boolean

Binned on

Date and time when the record was moved to the "My deleted records" archive area.

Date

Recipient

The user, unit, or external participant specified in the "To" metadata field. If the record was sent as an email, it will correspond to the recipient.

String

Inherited access restriction

All users, units, teams, and security groups specified in the "Case access restricted to" metadata field.

String

Original file path

Path of the file that was used as the basis for a record, if the record was imported via document import from a server.

String

Annotations

Indicates whether there is at least one annotation on the record.

Boolean

Case help

Indicates whether the "Case help" menu item is ticked.

Boolean

Secure email

Indicates whether the email was sent securely.

Boolean