Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtProblemParameter Parameters for Problems associated with a Patient
Column Name Column Datatype Column Null Option Column Comment
PtProblemParameterOIDintNOT NULL Object ID of a Problem Parameter
ProblemParameterCVEIdvarchar(32)NOT NULL Common Vocabulary Engine(CVE) identifier of the Problem Parameter
ChangeDateTimesmalldatetimeNOT NULL Date and time(Local) the parameter was changed
ChangedByNamevarchar(188)NOT NULL Name of the User who made a change to this parameter(HSUser)
DisplayNamevarchar(254)NOT NULL Name that is displayed for this problem parameter
DataTypevarchar(20)NOT NULL Data Type of the value for this Problem Parameter
Allowable Values:
1 - DateOffset
2 - Numeric
3 - Encoded
4 - FreeText
5 - Date
6 - Partial Date
Valuevarchar(254)NULL Value Parameter defined in Common Vocabulary Engine(CVE)
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
BehaviorCdvarchar(32)NULL The behavior code of the patient's expected outcome parameter name. It is dervived from the parameters ERCD code
LastCngSeqNointNOT NULL This represents the optimistic lock column(number of updates to this row, 1 = inserted)
PtProblem_oidintNOT NULL Object ID of Patient's Problem(HPtProblem)
SetSeqNointNULL Determines in what relative position the parameter will appear in the display
ValDsplyintNOT 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
ChangedBy_oidintNOT NULL Object ID of the User who made a change to this Problem Parameter(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