CaseParties

The CaseParties dataset contains data regarding case participants.

Importing to a BI database

Case participants can continuously change on cases. For example, the participant responsible for the case can be changed, or external participants can be added or removed during case processing. This makes it necessary to ensure during periodic runs that the latest changes are included and that obsolete data is deleted. The Cases dataset, which contains general data about cases, governs changes in the CaseParties dataset. Changes in Cases thus mean that there may also be changes in CaseParties (also see Diagram over "Entity Relationship").

You should do the following when importing to a BI database:

Delete rows related to changed cases in the existing CaseParties table. Case IDs for the changed cases can be found in the latest version of the Cases table.
Import the latest versions of the Cases and CaseParties tables 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
InternalCasePartyId	The internal database ID of the case participant.		bigint		58 69
InternalCaseId	The internal database ID of the case.	Cases	bigint		5112 2065
InternalPartyId	The internal database ID of the participant.	PartyRegistry	int		6364 4975
PartyType	The participant type of the participant.		varchar	20	CaseWorker ResponsibleUnit
ParticipantType EnumTypeId	The value list item ID of the case participant’s type (e.g. "Father" in paternity cases).	EnumTypeItems	int		6364 4975

Dataset name

Description

Reference to other dataset

Format

Length

Examples

InternalCasePartyId

The internal database ID of the case participant.

bigint

InternalCaseId

The internal database ID of the case.

Cases

bigint

5112

2065

InternalPartyId

The internal database ID of the participant.

PartyRegistry

int

6364

4975

PartyType

The participant type of the participant.

varchar

CaseWorker

ResponsibleUnit

ParticipantType EnumTypeId

The value list item ID of the case participant’s type (e.g. "Father" in paternity cases).

EnumTypeItems

int

6364

4975