Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtExpectedOutcome Expected Outcomes of a Patient
Column Name Column Datatype Column Null Option Column Comment
PtExpectedOutcomeOIDintNOT NULL Object ID of an Expected Outcome for a Patient
ExpectedOutcomeCVEIdvarchar(32)NOT NULL Common Vocabulary Engine(CVE) identifier for the expected outcome
AssignedBy_oidintNOT NULL Object ID of the User who assigned the expected outcome(HSUser)
AssignedDateTimesmalldatetimeNOT NULL Date and time(Local) the expected outcome was assigned
AssignedByNamevarchar(188)NOT NULL Name of the User who assigned the expected outcome
ChangeDateTimesmalldatetimeNOT NULL Date and time(Local) this expected outcome information was changed
ChangedByNamevarchar(188)NOT NULL Name of the User making a change to the expected outcome information
DisplayNamevarchar(254)NOT NULL Name displayed for the Expected Outcome as defined in Common Vocabulary Engine(CVE)
Statusvarchar(254)NOT NULL Status of the Expected Outcome
Allowable Values:
Active
Resolved
Inactive
Erroneous
StatusCdvarchar(32)NOT NULL Status Code of the Expected Outcome
Allowable Values:
ACTIVE
INACTIVE
RESOLVED
ERRONEOUS
HasRevisionHistorysmallintNULL Expected Outcome information was revised
Allowable Values:
0 / Null - False
1 - True
LastCngSeqNointNOT NULL Number of times this expected outcome was changed(Initial creation value will be 1)
HasActualOutcomeAndVisitDeletedsmallintNULL The patient visit associated with this outcome has been cancelled/deleted AND an actual outcome was assigned
Allowable Values:
0 / Null - False
1 - True
Patient_oidintNOT NULL Object ID of the Patient(HPatient) the expected outcome information is associated with
PatientVisit_oidintNULL Object ID of the patient visit(HPatientVisit)
Object ID of the patient visit(HPatientVisit) the expected outcome information is associated with
Valued when the Expected Outcome is associated with a Visit
Null when:
- The Expected Outcome is associated at the Patient Level and not a specific visit
- The Patient's Visit this Expected Outcome had been associated with was Canceled / Deleted so this Expected Outcome is no longer associated with a specific visit but is still associated to the Patient
ChangedBy_oidintNOT NULL Object ID of the User making a change to the expected outcome information(HSUser)
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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