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