Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
CallbackAttemptOid | BIGINT | NOT NULL | This is the primary key. |
CallbackOid | BIGINT | NOT NULL | This is a foreign key to the HCallback table. |
DocumentOid | BIGINT | NULL | This is the unique document ID of the attempt. |
AttemptResult | VARCHAR(255) | NULL | This indicates the result of this callback attempt. |
AttemptByUserOid | INT | NOT NULL | This is the user making the callback attempt. |
AttemptByUserLoginId | VARCHAR(100) | NOT NULL | This is the login ID of the user making this callback attempt. |
AttemptDTimeMins | SMALLDATETIME | NOT NULL | This indicates the date/time when the attempt was made. |
IsAttemptErroneous | SMALLINT | NOT NULL | This indicates if the attempt has been marked erroneous. Allowable Values: 0 - No, 1 - Yes. |
IsAttemptComplete | SMALLINT | NOT NULL | This indicates if the attempt has been completed. Allowable Values: 0 - No, 1 - Yes. |
IsAttempt | SMALLINT | NOT NULL | This indicates if this callback document is an attempt to reach the patient. Allowable Values: 0 - No, 1 - Yes. |
IsDocumentUpdated | BIT | NULL | This indicates if this callback attempt document has been updated. Allowable Values: NULL - N/A, 0 - No, 1 - Yes. |
IsResultTruncated | BIT | NULL | 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. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |
|