Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtActualOutcome Actual Outcomes of a Patient's Expected Outcomes
Column Name Column Datatype Column Null Option Column Comment
PtActualOutcomeOIDintNOT NULL Object ID of an Actual Outcome for a Patient
ActualOutcomeChartedBy_oidintNOT NULL Object ID of the User who charted the actual outcome(HSUser)
ActualOutcomeChartedDateTimedatetimeNOT NULL Date and time(Local) the Actual Outcome was charted for
ActualOutcomeChartedByNamevarchar(188)NULL Name of the User who charted the Actual Outcome(Format First Last, Title)
ActualOutcomeStatusvarchar(254)NOT NULL Outcome status that was actually charted
Allowable Values:
Met
Not Met
Progressing
Improved
Stabilized
Deteriorated
LastCngSeqNointNOT NULL Number of times this outcome has been changed(Initial creation value will be 1)
PtExpectedOutcome_oidintNOT NULL Object ID of the Patient's Expected Outcome(HPtExpectedOutcome)
IsMarkedErroneoussmallintNOT NULL Actual Outcome for this Expected Outcome has been marked as erroneous
Allowable Values:
0 - False
1 - True
HasClinNotesmallintNOT NULL Are there Clinical Note(s) associated with this Outcome
Allowable Values:
0 - False
1 - True
ChangedBy_oidintNOT NULL Object ID of the User who updated the actual outcome(HSUser)
ChangeDateTimesmalldatetimeNOT NULL Date and time(Local) the information was updated
ChangedByNamevarchar(188)NOT NULL Name of the User who made a change to the actual outcome information(Format First Last, Title)
ActualOutcomeStatusCVEIdvarchar(32)NOT NULL Common Vocabulary Engine(CVE) identifier for the status
Patient_oidintNOT NULL Object ID of the patient(HPatient) the acutal outcome is associated with
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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