Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBTrackingBoard This table holds the definition of tracking boards.
Column Name Column Datatype Column Null Option Column Comment
TrackingBoardOidINTNOT NULL This is the primary key.
TrackingBoardNameVARCHAR(64)NOT NULL This is the name of the tracking board.
TrackingBoardDescVARCHAR(255)NOT NULL This is the description of the tracking board.
EntityIDINTNOT NULL This is the ID of the owning entity.
TrackingBoardStartedByOidINTNOT NULL This is the user who created the entry.
TrackingBoardEndedByOidINTNULL This is the user who deleted the entry.
TrackingBoardStartDTimeMinsSMALLDATETIMENOT NULL This indicates the start date/time of the tracking board.
TrackingBoardEndDTimeMinsSMALLDATETIMENULL This indicates the end date/time of the tracking board.
TrackingBoardStartedByVARCHAR(100)NOT NULL This is the login ID of the user who created the tracking board.
TrackingBoardEndedByVARCHAR(100)NULL This is the login ID of the user who ended the tracking board.
TrackingBoardIsEndedSMALLINTNOT NULL This indicates if the tracking board is inactive. Allowable Values: 0 - No, 1 - Yes.
PreviousVisitHistoryDaysSMALLINTNULL This is no longer used.
TrackingBoardTypeSMALLINTNOT NULL This indicates what kind of tracking board it is. Allowable values: 0, 1.
TrackingBoardTypeDescVARCHAR(10)NOT NULL This is the corresponding character value for TrackingBoardType. Allowable values: ED, Other.
MedRecProcessingTypeVARCHAR(30)NOT NULL This indicates the default processing for MedRec. Allowable values: 'Continue All Home Meds','Do Not Continue All Home Meds'.
LayoutMnemonicVARCHAR(30)NULL This indicates which clinical summary layout is used for the chart view.
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