Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtProblem Problems associated with a Patient
Column Name Column Datatype Column Null Option Column Comment
PtProblemOIDintNOT NULL Object ID of Patient's Problem
ProblemCVEIdvarchar(32)NOT NULL Common Vocabulary Engine(CVE) ID for the Problem
AssignedDateTimesmalldatetimeNOT NULL Date and time(local) Problem was assigned to a patient
AssignedByNamevarchar(188)NOT NULL Name of the User that Assigned the Problem(Format First Last, Title)
ChangeDateTimesmalldatetimeNOT NULL Date and time(local) the Problem was changed
ChangedByNamevarchar(188)NOT NULL Name of the User that Changed the Problem(Format First Last, Title)
ClosedDateTimesmalldatetimeNULL Date and time(local) the Problem was closed
ClosedByNamevarchar(188)NULL Name of the User that Closed the Problem(Format First Last, Title)
DisplayNamevarchar(254)NOT NULL Name of the Problem - used for display on the UI and Reports
HasClinNotessmallintNOT NULL Are there Clinical Note(s) associated with this Problem
Allowable Values:
0 - False
1 - True
Statusvarchar(254)NOT NULL Patient Problem Status
StatusCdvarchar(32)NOT NULL Status Code for the Patient Problem Status
Allowable Values:
ACTIVE
ERRONEOUS
INACTIVE
RESOLVED
RankValuevarchar(254)NULL Ranked value for the Patient Problem(NULL allowed)
HasHistorysmallintNOT NULL This Problem has a history / has been updated
Allowable values:
0 - False
1 - True
LastCngSeqNointNOT NULL Number of times this problem has been changed(Initial creation value will be 1)
Patient_oidintNOT NULL Object ID of the Patient(HPatient) the Problem is assigned to
AssignedBy_oidintNOT NULL Object ID of the User who Assigned the Problem(HSUser)
ClosedBy_oidintNULL Object ID of the User who Closed the Problem(HSUser)
ChangedBy_oidintNOT NULL Object ID of the User who Changed the Problem(HSUser)
IsPastMedicalHistorysmallintNULL Is Past Medical History Problem
Allowable Values:
0 / Null - False
1 - True
SnomedCodevarchar(18)NULL SNOMED Code for this Problem
SnomedDescriptionvarchar(256)NULL SNOMED Description for this Problem
ImoCodevarchar(15)NULL Intelligent Medical Objects(IMO) Code for this Problem(IMO is third party vendor used to look up problems and reutrn SNOMED/ICD10 codes and descriptions)
IsChronicbitNULL Problem is a Chronic Problem
Allowable Values:
0 / Null - False
1 - True
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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