Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HRESuggestedActionField This table optionally stores fields for suggested actions.
Column Name Column Datatype Column Null Option Column Comment
AlertIDintNOT NULL The Alert ID with which the Role_OID is mapped.
SuggActionIDsmallintNOT NULL The unique ID of the suggested action associated with the alert. This is a unique sequence number within the scope of an alert.
RecordsetNamevarchar(30)NOT NULL The name of the record set.
FieldNamevarchar(30)NOT NULL The name of the field in the record.
FieldValuevarchar(1000)NOT NULL The value of the field in the record.
RecordIDsmallintNOT NULL The record ID of the record. It is a unique sequence within the same record set, suggested action and alert.
RecordsetSequenceIDsmallintNOT NULL The unique sequence ID for the record set.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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