Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtProblemHistory History of additions and changes to Problems associated with a Patient
Column Name Column Datatype Column Null Option Column Comment
PtProblemHistoryOIDintNOT NULL Object ID of the Problem History
ProblemNamevarchar(254)NOT NULL Name of the Problem
ProblemParameterCVEIdvarchar(32)NULL Common Vocabulary Engine(CVE) ID for the Problem
FieldChangedvarchar(254)NULL Name of the field changed
OldValuevarchar(254)NULL Value prior to this change
NewValuevarchar(254)NULL New value given for this change
ChangeDateTimedatetimeNOT NULL Date and time(Local) a change was made to the problem information for a patient
ChangedByNamevarchar(188)NOT NULL Name of the User making a change to the problem information for a patient(Format First Last, Title)
StatusCdvarchar(32)NOT NULL Status value of the problem
Allowable Values:
ACTIVE
ERRONEOUS
INACTIVE
RESOLVED
LastCngSeqNointNOT NULL Number of times this problem has been changed(Initial creation value will be 1)
PtProblem_oidintNOT NULL Object ID of the Problem associated with a Patient(HPtProblem)
ChangedBy_oidintNOT NULL Object ID of the User who made a change to the problem information(HSUser)
Patient_oidintNOT NULL Object ID of the patient(HPatient) the problem information is associated with
IsDateFieldsmallintNOT NULL Is the field that was changed a Date
Allowable values:
0 - No
1 - Yes
Actionvarchar(32)NOT NULL Change action to the problem information
Allowable Values:
REVISED
ADDED
NOTE
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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