PartyRegistry

The PartyRegistry dataset contains data regarding participants in the participant register.

Importing to a BI database

Participant data can change continuously. 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:

  1. Delete rows related to changed participants in the existing table. Participant IDs for the changed participants can be found in the latest version of the table.

  2. 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

InternalPartyId

The internal database ID of the participant.

int

6345

3695

PartyRegisterType

The type of participant in the participant register.

varchar

4

User

Department

Active

Whether the participant is active.

0 = Deactivated

1 = Active

int

0

1

Navn

The name of the participant.

nvarchar

510

Admin

Robert Robertson

Email

The email address of the participant.

nvarchar

200

CPR_CVRNumber

The CPR or CVR number of the participant.

nvarchar

24

0123456789

12345678

CVR_PNumber

The P number of the participant.

int

7652

2345

ExternalPartyId

The external ID of the participant.

int

12

96

ParentPartyId

The ID of the participant register node in which the participant is placed.

PartyRegistry

int

7531

1863

Adress1

Address line 1 of the participant.

nvarchar

200

17 Street

Flat A

Adress2

Address line 2 of the participant.

nvarchar

200

17 Street

50 Valley Hill

PostalCode

The postal code of the participant.

nvarchar

40

ZZ99 9ZZ

City

The city of the participant.

nvarchar

200

Hilltown

Cityburg

CountryCode

The country code of the participant.

nvarchar

20

DK

UK

Phone

The phone number of the participant.

nvarchar

50

45 12 34 45

+45 12 34 56 78

PhoneLocalNumber

The local phone number of the participant.

nvarchar

10

45 12 34 45

+45 12 34 56 78

MobilePhoneLocal

The mobile phone number of the participant.

nvarchar

50

45 12 34 45

+45 12 34 56 78

Telefax

The telefax number of the participant.

nvarchar

50

45 12 34 45

+45 12 34 56 78

ContactPerson

The point of contact for the participant.

nvarchar

256

Admin

Robert Robertson

HomePage

The website of the participant.

nvarchar

100

www.website.uk

www.homepage.com