Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtOutcomeHistory History / Changes made to Expected Outcome Information
Column Name Column Datatype Column Null Option Column Comment
PtOutcomeHistoryOIDintNOT NULL Object ID of the Expected Outcome History Row
PtExpectedOutcome_oidintNOT NULL Object ID of the Expected Outcome this change is associated with
PtActualOutcome_oidintNULL Object ID of the Actual Outcome associated with this Expected Outcome
When Null, an Actual Outcome has not been assigned
Actionvarchar(254)NOT NULL Action made on the Outcome for the history entry
Allowable Values:
ADDED
CHARTED
REVISED
ChartingStatusvarchar(254)NULL Charting Status value for the history entry
Allowable Values:
Improved
Met
Not Met
Progressing
StatusCdvarchar(32)NULL Status code
Allowable Values:
NULL
ACTIVE
INACTIVE
ChangeDateTimesmalldatetimeNOT NULL Date and time(Local) the information for this Expected Outcome was updated
ChangedByOidintNOT NULL Object ID of the User making a change to the information for this Expected Outcome(HSUser)
ChangedByNamevarchar(188)NOT NULL Name of the User making a change to the information for this Expected Outcome Parameter
LastCngSeqNointNOT NULL Number of times this problem has been changed(Initial creation value will be 1)

Return to Table-Index

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