Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtExpectedOutcomeParameter Parameters and their Values that are associated with an Expected Outcome for a Patient
Column Name Column Datatype Column Null Option Column Comment
PtExpectedOutcomeParameterOIDintNOT NULL Object ID of an Expected Outcome Parameter
ExpectedOutcomeParameterCVEIdvarchar(32)NOT NULL Common Vocabulary Engine(CVE) Identifier of the Expected Outcome Parameter
ChangeDateTimesmalldatetimeNOT NULL Date and time(Local) the information for this Expected Outcome Parameter was updated
ChangedByNamevarchar(188)NOT NULL Name of the User who made a change to the information for this Expected Outcome Parameter
ChangedBy_oidintNOT NULL Object ID of the User who made a change to the information for this Expected Outcome Parameter(HSUser)
DisplayNamevarchar(254)NOT NULL Display Name of the Expected Outcome Parameter. Default value is from the Common Vocabulary Engine(CVE) definition
DataTypevarchar(20)NOT NULL Any of the data types as defined in the CVE
Allowable Values:
1 - DateOffset
2 - Numeric
3 - Encoded
4 - FreeText
5 - Date
6 - Partial Date
Valuevarchar(254)NULL The value of the Patient's Expected Outcome Parameter
ValueCVEIdvarchar(32)NULL The CVE Id for the patient's expected outcome parameter value. This is determined by the Display Name Preference of the concept in the CVE
ValueBehaviorCdvarchar(32)NULL The behavior code of the patient's expected outcome parameter's value derived from the values ERCD code from CVE
BehaviorCdvarchar(32)NULL The behavior code of the patient's expected outcome parameter name. It is dervived from the parameters ERCD code from CVE
LastCngSeqNointNOT NULL This represents the optimistic lock column(number of updates to this row, 1 = inserted)
PtExpectedOutcome_oidintNOT NULL Object ID of the associate expected outcome(HPtExpectedOutcome)
SetSeqNointNULL Determines in what relative position the parameter will appear in the display
ValDsplybitNOT NULL Determines if the attribute appears on the application detail regardless of whether or not a value is defaulted or entered
Allowable Values:
0 - False
1 - True
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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