Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBVisitIndicator This table holds indicators assigned to a visit.
Column Name Column Datatype Column Null Option Column Comment
TBVisitIndicatorOidINTNOT NULL This is the primary key.
TBVisitOidINTNOT NULL This is a foreign key to HTBVisit.
TBVisitStatusSMALLINTNOT NULL This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended.
TBIndicatorOidINTNOT NULL This indicates which indicator is assigned to the visit.
TBVisitIndicatorStartDTimeMinsSMALLDATETIMENOT NULL This is the start date/time of the indicator assignment.
TBVisitIndicatorStartedByOidINTNOT NULL This indicates the user who assigned the indicator.
TBVisitIndicatorEndedDTimeMinsSMALLDATETIMENULL This is the end date/time of the indicator asssignment.
TBVisitIndicatorEndedByOidINTNULL This indicates the user who ended the indicator.
TBVisitIndicatorStartedByVARCHAR(100)NOT NULL This is the login ID of the user who started the indicator assignment.
TBVisitIndicatorEndedByVARCHAR(100)NULL This is the login ID of the user who ended the indicator assignment.
TBVisitIndicatorIsEndedSMALLINTNOT NULL This indicates if the indicator assignment has ended. Allowable Values: 0 - No, 1 - Yes.
LastCngDtimeDATETIMENOT NULL This indicates the current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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