Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientIdentifiers Contains information about all patient Identifiers like MRN,MPI,SSN
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPatientIdentifiers Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(184)NULL This field can be Null or user can put the patient name there(Often when entering MPI number).
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 HPatientIdentifiers row
CreationTimesmalldatetimeNULL Date and time when HPatientIdentifiers row is created.
TYpevarchar(64)NULL Type of the patient identifier like MRN,MPI,SSN or any DDI item created by the client(ItemTypeCode = "Person.IDDocument.Type")
Valuevarchar(30)NULL Value associated with the type of the patient identifier. This can be any value entered by user during patient registration.
AssigningAuthorityTypevarchar(6)NULL Type of assigning authority associated with the patient identifier.
Allowable Values: H - Healthcare Entity or Unit, N - Nonaffiliated Organization Unit(NAOU) , NULL
AssigningAuthorityvarchar(30)NULL Abbreviation of the internal or the external healthcare organization associated with the patient identifier.
VerificationKeyTypevarchar(6)NULL Type of the verification key entered by the user. The verification key can be used to verify the details of a person. It can be any value(SSN for example) or NULL.
VerificationKeyvarchar(30)NULL Verification key as entered by the user. The verification key can be used to verify the details of a person.
ValidOndatetimeNULL The date and time from when the patient identifier is valid.
ExpiresOndatetimeNULL The date and time on which the patient identifier is no longer valid.
Patient_oidintNOT NULL Patient OID same as Objectid in HPatient Table.
EntityOIDintNULL The object ID of the entity associated with the patient identifier.
EntityNamevarchar(75)NULL The name of the entity associated with the patient identifier.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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