Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtOutcomeHistoryDetail History of changes to values for Patient Outcomes (HPtOutcomeHistory)
Column Name Column Datatype Column Null Option Column Comment
PtOutcomeHistoryDetailOIDintNOT NULL Object ID of an Outcome History Detail
PtOutcomeHistoryOIDintNOT NULL Object ID of the Expected Outcome a change in value is for(HPtOutcomeHistory)
FieldChangedvarchar(254)NOT NULL Name of the field in the Expected Outcome that was changed
OldValuevarchar(254)NULL Value prior to this change
NewValuevarchar(254)NULL New value given for this change
RevisionReasonvarchar(125)NULL User entered reason for changing a value
IsDateFieldsmallintNOT NULL Is the field that was changed a Date time value
Allowable values:
0 - No
1 - Yes
LastCngSeqNointNOT NULL Number of times this outcome was changed(Initial creation value will be 1)

Return to Table-Index

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