Case import
The "Case import" report type extracts data about cases in F2 that have been imported from another system.
The report type contains one default configuration that gives a broad overview of the case import in the recipient system.
The "Imported cases" default configuration
Use the "Imported cases" default configuration to create a list of cases in F2 that have been imported from another system and by whom.
The configuration contains neither filters nor fields to fill in.
| Column name | Description | Examples |
|---|---|---|
Date and time |
The full timestamp with year, month, day, hour, minute, and second. |
2023-11-14T12:40:29.597 2023-04-12T15:30:20.773 |
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. |
2024 - 48 2023 - 5 |
Case title |
The full case title displayed at the top of the case window and in the "Title" metadata field. |
Board meeting Section 20 question regarding data protection |
Name |
Name of the user who has performed an action. If the action was performed on behalf of another user, the name of the "on behalf of" user is specified. |
Holly Rogers Isaac Johnson |
Orig. case number |
If a case has been imported from another system, the case ID from the original system is listed. |
2019 - 135 2021 - 34 |
Other available columns
The following table covers columns that are accessible when configuring reports, but are not included in the default configurations.
| Column name | Description | Examples |
|---|---|---|
User ID |
The unique user ID of the user who has performed an action. If the action was performed on behalf of another user, the unique user ID of the "on behalf of" user is specified. |
107 124 |
Login user ID |
If a user has performed the action on behalf of another user, the unique user ID of the logged-in user is specified. |
107 124 |
Login name |
If a user has performed the action on behalf of another user, the name of the logged-in user is specified. |
Holly Rogers Isaac Johnson |
Action |
Name of the action that was performed. |
Case created Add participant to record |
Operation type |
The unique action ID |
2 22 |
Count |
Accumulates identical rows in the data extract and returns the total. |
249 |