Cases
The Cases dataset contains data regarding cases.
Importing to a BI database
Cases are continuously changed. This makes it necessary to ensure during periodic runs that the latest changes are included and that obsolete data is deleted.
You should do the following when importing to a BI database:
-
Delete rows related to changed cases in the existing table. Case IDs for the changed cases can be found in the latest version of the table.
-
Import the latest version of the table to the BI database.
Column overview
The following table describes the columns available in the dataset. The table includes the following information about each column:
-
Dataset name: The column’s name in the dataset.
-
Description: Describes the column’s content and function.
-
Reference to other dataset: Specifies references to other datasets, if any.
-
Format: Specifies the format of the returned values.
-
Length: Specifies the length of the returned values, if any.
-
Examples: Examples of returned values.
| Dataset name | Description | Reference to other dataset | Format | Length | Examples |
|---|---|---|---|---|---|
InternalCaseid |
The internal database ID of the case. |
bigint |
12058 69 |
||
Deleted |
Time and date of case deletion, if relevant. |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
F2CaseNumber |
The F2 case number of the case. |
nvarchar |
256 |
2017 - 69 2021 - 378 |
|
ClosedByUserInternal PartyId |
The ID of the user who marked the case as "Complete". |
int |
69 4896 |
||
ClosedDate |
The time and date of when the case was marked as "Complete". |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
CprCvrNumber |
The CPR or CVR number of a case. |
nvarchar |
12 |
012345-6789 12345678 |
|
ExternalId |
The external ID of the case. |
nvarchar |
1024 |
159868 68794 |
|
Keywords |
The keywords of the case. |
nvarchar |
400 |
Recruitment Quality Assurance |
|
Deadline |
The case deadline. |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
CreatedDate |
The time and date of when the case was created. |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
JournalPlanEnumItemId |
The ID of the file plan on the case. |
int |
96833 2663 |
||
ActionCodeNames |
A comma-separated list of action codes on the case. |
nvarchar |
400 |
Organisation, Control Application |
|
DisposalCodeEnum ItemId |
The ID of the disposal code on the case. |
int |
7633 1365 |
||
Status |
The status of the case. |
varchar |
11 |
In progress Closed |
|
ProgressCodeId |
The ID of the progress code on the case. |
nvarchar |
256 |
Awaits approval In hearing |
|
PreviousCaseNumber |
Any previous case number of the case. |
nvarchar |
256 |
12/23587 20/78646 |
|
Title |
The title of the case. |
nvarchar |
256 |
Reporting - Templates Grant application case regarding XYZ |
|
CreatedByInternal PartyId |
The ID of the user who created the case. |
int |
12 6963 |
||
SecurityGroups |
The access restriction of the case. |
Nvarchar |
4000 |
SG: Team leaders IT Office |