Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatient Contains patient detailed information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPatient Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(184)NULL Valued by the user as a name. Format : First Name, Last Name.
IsDeletedtinyintNOT NULL Indicates if the row has been deleted or Patient has been Merged. Allowable Values: 0 - False, 1 - True(deleted)
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HPatient row
CreationTimesmalldatetimeNULL Date and Time when row was created.
InternalPatientIDvarchar(20)NOT NULL A running number whose format depends on ADT Preference
VIPIndicatorbitNULL Indicates if the patient is a VIP. Allowable Values: 0 - False(Not VIP), 1 - True(VIP patient)
PatientRegistrationDatedatetimeNOT NULL Date and time when patient was registered in the system.
Remarksvarchar(255)NULL Additional comments by user during patient registration.
InterpretTovarchar(50)NULL Valued by the user during patient registration.
Titlevarchar(64)NULL Title is a Data DictionaryItem(DDI)
FirstNamevarchar(30)NULL First Name of the Patient
MiddleNamevarchar(30)NULL Middle Name of the Patient
LastNamevarchar(60)NOT NULL Last Name of the Patient
GenerationQualifiervarchar(30)NULL Person generation. For example, Jr. or II. Valued by the user during patient registration.
IsMergedbitNULL Indicates if the patient is Merged. Allowable Values: 0 - Not Merged, 1 - Merged
Confidentialityvarchar(64)NULL Confidentiality is a DDI
AdvancedDirectiveonFilevarchar(64)NULL AdvancedDirectiveonFile is a DDI
HasImagesbitNULL Indicates if there is an image attached to the patient. Allowable Values: 0 - No, 1 - Yes
SubScriberNumbervarchar(75)NULL Not Used
RegistrationTypetinyintNULL RegistrationType :Registration(0) ModalityRegistration(1)
OrganDonorvarchar(64)NULL OrganDonor is a DDI.
MPINumbervarchar(20)NULL Master Patient Index Number
StreetAddressvarchar(255)NULL Street Address of Patient Permanent Home Address
POBoxNovarchar(50)NULL POBoxNo of Patient Permanent Home Address
Cityvarchar(64)NULL City of Patient Permanent Home Address
Countryvarchar(64)NULL Country Patient Permanent Home Address
DeathInformation_oidintNULL When patient is deceased, this field contains the objectid to HDeathInformation table.
PatientExtension_oidintNULL ObjectID of HExtendedPatient table
Initialvarchar(64)NULL Initial is a DDI.
LivingWillvarchar(64)NULL LivingWill is a DDI.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.
VeteranStatusvarchar(64)NULL VeteranStatus is a DDI.
LivingArrangementvarchar(64)NULL LivingArrangement is a DDI.
LivingDependencyvarchar(64)NULL Not used
IsPatientUnidentifiedsmallintNULL Indicated if the patient has been identified or Not. Allowable Values: 0 -identified, 1 - Unidentified, NULL - not valued
GestationalAgevarchar(15)NULL Gestational Age of a patient(in weeks).
PrefContactMethodvarchar(64)NULL Preferred Contact Method of a patient(E-mail, Phone etc.).
PrimaryLanguagevarchar(64)NULL Primary Language of a Patient.
MedHistoryConsentvarchar(64)NULL Patient consent to whether he/she agrees or not if a physician can review their Medication History. Valued by the user.
Allowable Values: Yes - Yes, No - No, Null - Not valued, space - Not valued.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates