Id

INT

Primary key, automatically generated

The id uniquely identifies one patient

DateCreated

DATETIME

The date and time on which the patient was created

DateUpdated

DATETIME

The date and time on which the patient was last updated

DateDeleted

DATETIME

The date and time on which the patient was logically deleted

CreatedBy

INT

Refers to the user that created the patient

UpdatedBy

INT

Refers to the user that was the last one to update the patient

DeletedBy

INT

Refers to the user that logically deleted the patient

NationalityCode

VARCHAR(20)

Refers to an organizational unit in the OrgUnit table that corresponds to a country.

CPRnr

VARCHAR(10)

Unique id for the patient (central person register id). Can be expanded to hold other types of identifiers.

BirthDate

DATETIME

The patients birth date

DeathDate

DATETIME

The patients death date

SexType

INT

The patients sex. Refers to the SexType table.

PreferredName

VARCHAR(50)

The patients preferred name

FirstName

VARCHAR(50)

The patients first name

LastName

VARCHAR(50)

The patients last name

Title

VARCHAR(50)

The patients title

Notes

TEXT

Notes about the patient

ProtectedAddress

BIT

Whether the patients address is protected

Location

VARCHAR(50)

The location part of the patients address.

Road

VARCHAR(30)

The road part of the patients address.

HouseNum

VARCHAR(20)

The house number part of the patients address.

ZipNum

int

For holding numeric zip codes. ZipCode text can be found in lookup table ZipCodeNumeric if it exists. If this is not the case the ZipText table is used for holding the zipcode text.

ZipString

VARCHAR(10)

For holding non numeric zip codes. ZipCode text can be stored in lookup table or in ZipText column.

ZipText

VARCHAR(50)

If no lookup table exists for finding text for ZipNum or ZipString, ZipText can be used for holding this text.

Country

varchar(50)

The full name of the patients country of origin

CountryCode

varchar(20)

A code referring to a row in the OrgUnit table holding the patients country of origin

TemporaryRoad

varchar(30)

The road part of the patients temporary address

TemporaryHouseNum

varchar(20)

The house number part of the patients temporary address

TemporaryZipNum

int

The numeric zip code part of the patients temporary address

TemporaryZipString

varchar(10)

The non numeric zip code part of the patients temporary address

TemporaryZipText

varchar(50)

The zip code text part of the patients temporary address

TemporaryCountry

varchar(50)

The patients temporary country of origin

TemporaryCountryCode

varchar(20)

Refers to row in OrgUnit holding the patients temporary country of origin

ProtectedContactInfo

bit

Whether the patients contatct info is protected

PhonePrivate

varchar(15)

The patients private phone number

PhoneJob

varchar(15)

The patients work phone number

MobilePrivate

varchar(15)

The patients private mobile phone number

MobileJob

varchar(15)

The patients work mobile phone number

FaxPrivate

varchar(15)

The patients private fax number

FaxJob

varchar(15)

The patients work fax number

EmailPrivate

varchar(50)

The patients private email address

EmailJob

varchar(50)

The patients work email address

ConsentDate

datetime

The date the patient gave consent that data about the patient can be used.

Password

varchar(40)

The patients password

PasswordEncrypted

varchar(80)

The patients encrypted password

PasswordChangeAtLogon

bit

Whether the patient should change the password at next logon

PasswordChangedDate

datetime

Date for last password change

OrgUnit_TYPE

varchar(20)

Part of patient address. Refers (together with OrgUnit_CODE) to a row in the OrgUnit table

OrgUnit_CODE

varchar(20)

Part of patient address. Refers (together with OrgUnit_TYPE) to a row in the OrgUnit table

OrgUnit2_TYPE

varchar(20)

NOT USED

OrgUnit2_CODE

varchar(20)

NOT USED

TemporaryOrgUnit_TYPE

varchar(20)

Part of patient temporary address. Refers (together with TemporaryOrgUnit_Code) to a row in the OrgUnit table

TemporaryOrgUnit_CODE

varchar(20)

Part of patient temporary address. Refers (together with TemporaryOrgUnit_Code) to a row in the OrgUnit table

MaritalStatus

int

The patients marital status

CoverageGroup

int

The patients coverage group

GPReferenceNumber

int

The patients general practitioner reference number

GPName

varchar(50)

The patients general practitioner name

GPPhone

varchar(15)

The phone number of the patients general practitioner

GPRoad

varchar(30)

The road part of the patients general practitioner address

GPHouseNum

varchar(20)

The house number part of the patients general practitioner address

GPZipNum

int

The numeric zip code part of the patients general practitioner address