DossierParties
The DossierParties dataset contains data regarding record participants.
Importing to a BI database
Record participants can continuously change on records. For example, the participant responsible for the record 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 Dossiers dataset, which contains general data about records, governs changes in the DossierParties dataset. Changes in Dossiers thus mean that there may also be changes in DossierParties (also see Diagram over "Entity Relationship").
You should do the following when importing to a BI database:
-
Delete rows related to changed records in the existing DossierParties table. Record IDs for the changed records can be found in the latest version of the Dossiers table.
-
Import the latest versions of the Dossiers and DossierParties 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 |
---|---|---|---|---|---|
InternalDossier PartyId |
The internal database ID of the record participant. |
bigint identity |
8 986635 |
||
InternalDossierId |
The internal database ID of the record. |
bigint |
5112 2065 |
||
InternalPartyId |
The internal database ID of the participant. |
int |
6345 3975 |
||
PartyType |
The participant type of the participant. |
varchar |
20 |
CaseWorker ResponsibleUnit |