Cases
Data on cases can be divided into two categories: Metadata on the case itself and data on the authority’s case processing. The columns related to cases also describe records' relation to cases.
Case metadata
Case metadata include everything from the case metadata fields such as "External ID" and "File plan" to other metadata such as the number of records attached to a given case or which case number a case had when it was imported from another system.
Column name | Description | Value type |
---|---|---|
Count |
Number of records attached to a case. |
Number |
No. of binned records |
Number of records previously attached to the case and now in the bin. |
Number |
No. of inactive record |
Old record versions associated with the case. When a record is moved to a new case, a new version of the record is created. |
Number |
No. of deleted records |
Number of records previously attached to the case and now deleted. |
Number |
External ID |
The value specified in the "External ID" metadata field. |
String |
Action code |
The value specified in the "Action code" metadata field. |
String |
File plan |
The value specified in the "File plan" metadata field. |
String |
Disposal code |
The value specified in the "Disposal code" metadata field. |
String |
Orig. case number |
If a case has been imported from another system, the case ID from the original system is listed. |
Number |
Case completed |
Date and time when the case last changed status to "Completed". |
Date |
Case completed by |
Name of the user who last completed the case. |
String |
Case created |
Date and time when the record was created. |
Date |
Case created by |
Name of the user who created the case. |
String |
Access limitation on case |
All users, units, teams, and security groups specified in the "Access restriction" metadata field. |
String |
Case responsible |
The user or unit specified in the "Responsible" metadata field. |
String |
Unit responsible for case |
The unit or the unit associated with the user that is specified in the "Responsible" metadata field. |
String |
SSN/CVR No of case |
The value specified in the "SSN/CVR No" metadata field. |
String |
Case keyword |
The keyword(s) specified in the "Keyword" metadata field. |
String |
Case deadline |
The date specified in the "Deadline" metadata field at midnight. |
Date |
Case internal ID |
The unique value that serves as the case’s ID in the database. |
Number |
Case participants |
The case participant(s) specified in the "Case participants" metadata field. |
String |
Case status |
The value specified in the "Status" metadata field. |
String |
Case suppl. units |
Units specified in the "Suppl. case mgr." metadata field. |
String |
Case suppl. case mgr. |
Names of users specified in the "Suppl. case mgr." metadata field. |
String |
Case guide type |
Name of the active case guide on the case. |
String |
Case folder |
Name of the case folder in which a record is placed. |
String |
Case No |
The unique ID number in the authority’s archive for a case with which another element in F2 is associated, or for the case itself as seen at the top of the case window. |
Number |
Case title |
The full case title displayed at the top of the case window and in the "Title" metadata field. |
String |
Progress code |
The name of the progress code. |
String |
Progress code is current |
Indicates whether the selected progress code at the time of extract is assigned to a given case. |
Boolean |
Progress code ID |
The progress code’s unique ID. |
Number |
Previous case No. |
The case number specified in the "Previous case No." metadata field. |
Number |
Case processing
Column name | Description | Value type |
---|---|---|
Record deadline adherence |
Indicates whether the record was completed before the record deadline. |
Boolean |
Processing deadline adherence |
Indicates whether the deadline for case processing has been met. |
Boolean |
Processing deadline, duration |
Duration of case processing from start to deadline in full days. |
Number |
Processing deadline, excess |
Number of whole days the case processing has exceeded the deadline. |
Number |
Processing time |
The actual case processing time in minutes. |
Number |
Processing time in days |
The actual case processing time in days. |
Number |
Days to record deadline |
Number of days within office hours until the record deadline. |
Number |
Minutes to record deadline |
Number of minutes until record deadline. |
Number |
Months since case completion |
Number of whole months since the case changed status to "Completed". |
Number |
Case was completed |
Indicates whether a case changed status to "Completed" within the selected period. |
Boolean |
Case was processed |
Indicates whether a case had the "In progress" status during part or all of the selected period. |
Boolean |
Case was created |
Indicates whether a case was created within the selected period. |
Boolean |
End record, other keywords |
Any additional keywords on the case’s end record. |
String |
End record, letter date |
The "Letter date" value of the case’s end record. |
Date |
End record, first keyword |
The first keyword specified on the case’s end record. This may constitute the end record’s type in the case processing. |
String |
End record, ID |
The "Record ID" value for the case’s end record. |
Number |
End record, quarter |
The year and quarter when the case processing was completed as inferred from the end record. |
Date |
End record, month |
The year and month when the case processing was completed as inferred from the end record. |
Date |
End record, title |
The "Title" value of the case’s end record. |
String |
End record, year |
The year when the case processing was completed as inferred from the end record. |
Date |
End date |
Date and time when the case processing was completed as inferred from the case’s end record. |
Date |
Start record, other keywords |
Any additional keywords on the case’s start record. |
String |
Start record, letter date |
The "Letter date" value of the case’s start record. |
Date |
Start record, first keyword |
The first keyword specified on the case’s start record. This may constitute the start record’s type in the case processing. |
String |
Start record, ID |
The "Record ID" value for the case’s start record. |
Number |
Start record, quarter |
The year and quarter when the case processing was started as inferred from the start record. |
Date |
Start record, month |
The year and month when the case processing was started as inferred from the start record. |
Date |
Start record, title |
The "Title" value of the case’s start record. |
String |
Start record, year |
The year when the case processing was started as inferred from the start record. |
Date |
Start date |
Date and time when the case processing was started as inferred from the case’s start record. |
Date |
Duration |
The total duration in minutes that a progress code has been active on a given case. |
Number |