NameDescriptionTypeAdditional information
ID

integer

None.

FirstName

string

None.

LastName

string

None.

MiddleName

string

None.

Gender

string

None.

DOB

date

None.

ImagePath

string

None.

SignarurePath

string

None.

Nationality

integer

None.

PrefferedLanguage

string

None.

CountryOfBirth

integer

None.

ContactNo

string

None.

Address

string

None.

ClientPreviousAddress

string

None.

FirstOvernight

date

None.

FlatNo

string

None.

AdmissionDate

date

None.

ClientsAdmissionNote

string

None.

NHS_Number

string

None.

NI_Bumber

string

None.

RIO_Number

string

None.

EyeColor

integer

None.

HairColor

integer

None.

HairLength

integer

None.

MaleOnly

integer

None.

Denture

boolean

None.

Spectacle

boolean

None.

Build

integer

None.

NextOfKin

string

None.

Allergy

string

None.

Admission

string

None.

ArchiveAccount

boolean

None.

SexOffenderRegister

boolean

None.

IsActive

boolean

None.

IsDeleted

boolean

None.

LastReportCheckDate

date

None.

CreatedDate

date

None.

UpdatedDate

date

None.

UpdatedBy

integer

None.

CreatedBy

integer

None.

GPName

string

None.

GPContactNo

string

None.

PsychiatristName

string

None.

IsSmoker

boolean

None.

DietaryRequirement

string

None.

DrugSensitivityIssue

string

None.

ReviewDate

date

None.

MHProfessionalName

string

None.

MHProfessionalNo

string

None.

InActiveDate

date

None.

EPJSDescription

string

None.

MosaicDescription

string

None.

MedicationAllergy

string

None.

FoodAllergy

string

None.

ReferralPathway

integer

None.

GPAddress

string

None.

Client_ActionPlan_Intervations

Collection of Client_ActionPlan_Intervations

None.

Client_Alcohol_And_Drug

Collection of Client_Alcohol_And_Drug

None.

Client_Assessment_Info

Collection of Client_Assessment_Info

None.

Client_Basic_Demographic

Collection of Client_Basic_Demographic

None.

Client_Care_Settings

Collection of Client_Care_Settings

None.

Client_CSP

Collection of Client_CSP

None.

Client_Daily_Report

Collection of Client_Daily_Report

None.

Client_Declared_Funeral_Arrangements

Collection of Client_Declared_Funeral_Arrangements

None.

Client_Personality_Prior_Illness

Collection of Client_Personality_Prior_Illness

None.

ParamMaster

ParamMaster

None.

ParamMaster1

ParamMaster

None.

ParamMaster2

ParamMaster

None.

ParamMaster3

ParamMaster

None.

ParamMaster4

ParamMaster

None.

ParamMaster5

ParamMaster

None.

ParamMaster6

ParamMaster

None.

Client_Due_Report

Collection of Client_Due_Report

None.

Client_Family_and_Household_Composition

Collection of Client_Family_and_Household_Composition

None.

Client_Family_History

Collection of Client_Family_History

None.

Client_Forensic_History

Collection of Client_Forensic_History

None.

Client_Form

Collection of Client_Form

None.

Client_Form_Mapping

Collection of Client_Form_Mapping

None.

Client_HealthCare_Solicitor

Collection of Client_HealthCare_Solicitor

None.

Client_Internal_Transfer

Collection of Client_Internal_Transfer

None.

Client_MDT_Contacts

Collection of Client_MDT_Contacts

None.

Client_MDT_Info

Collection of Client_MDT_Info

None.

Client_Medical_History

Collection of Client_Medical_History

None.

Client_Medication

Collection of Client_Medication

None.

Client_MedicationDetail

Collection of Client_MedicationDetail

None.

Client_Mental_Health_State

Collection of Client_Mental_Health_State

None.

Client_Personal_History

Collection of Client_Personal_History

None.

Client_Previous_History

Collection of Client_Previous_History

None.

Client_Psychiatric_History

Collection of Client_Psychiatric_History

None.

Client_Referral_Info

Collection of Client_Referral_Info

None.

Client_Risk_Assessment_Info

Collection of Client_Risk_Assessment_Info

None.

Client_Risk_Chronology

Collection of Client_Risk_Chronology

None.

Client_Session_Detail

Collection of Client_Session_Detail

None.

Client_Social_Situation

Collection of Client_Social_Situation

None.

Client_Staff_Mapping

Collection of Client_Staff_Mapping

None.

ClientAllergies

Collection of ClientAllergy

None.

ClientMessages

Collection of ClientMessage

None.

ClientMessages1

Collection of ClientMessage

None.

ClientTasks

Collection of ClientTask

None.

NotificationDetails

Collection of NotificationDetail

None.

Project_Client_Details

Collection of Project_Client_Details

None.

Project_Medication_Orders

Collection of Project_Medication_Orders

None.