Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPerson Contains person information (can be patient, staff member, next of kin (NOK) to the patient, etc)
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPerson Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(90)NULL Not used
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. 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 HPerson row
CreationTimesmalldatetimeNULL Creation Date and Time of the row creation
SextinyintNULL Gender of the Person. Allowable Values: 0 - Male, 1 - Female, 3 - Unknown
Religionvarchar(64)NULL Religion is a Data DictionaryItem(DDI).
Nationalityvarchar(64)NULL Nationality is a DDI.
MotherMaidenNamevarchar(30)NULL Mother Maiden Name
MotherIdentifiervarchar(20)NULL Mother Identifier entered by user. It can be valued to SSN.
Racevarchar(255)NULL Race is a DDI item where Item Type Code is "Person.Race"
MaritalStatusvarchar(64)NULL Marital Status is a DDI item entered by client. As an example Item Type Code can be "Person.MaritalStatus"
PagerNovarchar(30)NULL Person Pager Number entered by user.
MobilePhoneNovarchar(30)NULL Person Mobile Phone Number entered by user.
BirthDatedatetimeNULL Birth Date of the Person
MobileCountryCodevarchar(6)NULL Country Code for the Mobile Phone Number
MobileAreaCodevarchar(6)NULL Area Code for the Mobile Phone Number
PagerCountryCodevarchar(6)NULL Country Code for the Pager Number
PagerAreaCodevarchar(6)NULL Area Code for the Pager Number
BirthTimedatetimeNULL Birth Time of the Person
LastCngDtimedatetimeNULL System UTC date /time when row was updated.
Ethnicityvarchar(255)NULL Ethnicity.May contain up to three ethnicities, separated by comma. Each Ethnicity is a DDI item where Item Type Code is "Person.Ethnicity"
IsDOBEstimatedsmallintNULL Indicates whether DOB is estimated or not. 0: means DOB is not estimated, 1: means DOB is estimated.
MaidenOrAliasLastNamevarchar(60)NULL Maiden or Alias Last Name.
BirthSextinyintNULL Gender of the Person at birth. Allowable Values: 0 - Male, 1 - Female, 3 - Unknown
GenderIdentityvarchar(64)NULL Gender Identity of the Person. This is a DDI item with item type code "Person.GenderIdentity".
SexualOrientationvarchar(64)NULL Sexual Orientation of the Person. This is a DDI item with item type code "Person.SexualOrientation".
PreferredNamevarchar(128)NULL The name that patient preferred to use during registration.
IDAliasvarchar(32)NULL This is used as FHIR patient resource logical-Id that needs to be unique.

Return to Table-Index

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