Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCallbackAttempt This table is used to store callback attempt information.
Column Name Column Datatype Column Null Option Column Comment
CallbackAttemptOidBIGINTNOT NULL This is the primary key.
CallbackOidBIGINTNOT NULL This is a foreign key to the HCallback table.
DocumentOidBIGINTNULL This is the unique document ID of the attempt.
AttemptResultVARCHAR(255)NULL This indicates the result of this callback attempt.
AttemptByUserOidINTNOT NULL This is the user making the callback attempt.
AttemptByUserLoginIdVARCHAR(100)NOT NULL This is the login ID of the user making this callback attempt.
AttemptDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when the attempt was made.
IsAttemptErroneousSMALLINTNOT NULL This indicates if the attempt has been marked erroneous. Allowable Values: 0 - No, 1 - Yes.
IsAttemptCompleteSMALLINTNOT NULL This indicates if the attempt has been completed. Allowable Values: 0 - No, 1 - Yes.
IsAttemptSMALLINTNOT NULL This indicates if this callback document is an attempt to reach the patient. Allowable Values: 0 - No, 1 - Yes.
IsDocumentUpdatedBITNULL This indicates if this callback attempt document has been updated. Allowable Values: NULL - N/A, 0 - No, 1 - Yes.
IsResultTruncatedBITNULL This indicates if the result text is larger than the 255 characters boundary of the document. Allowable Values: NULL - N/A, 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