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:
|
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 |