Columns
Column name |
Data type |
Description |
---|---|---|
CTRECID |
VARCHAR2(40) |
Clintrial database identifier of the object that encapsulates the transaction to send to the InForm software. This joins with the CTRECID column of the INF_ERRORSTATUS table. |
TRANSACTIONSEQUENCE |
NUMBER |
Ordinal used to identify separate transactions for the same object. |
TRANSACTIONGUID |
VARCHAR2(36) |
Unique identifier of the transaction (NULL until sent). |
TRANSACTIONREVISION |
FLOAT |
Revision number that encapsulates the timestamp of the creation of the transaction record (NULL until sent). |
ENTRY_DATETIME |
DATE |
Timestamp of the entry of this record. |
TRANSACTIONTYPE |
NUMBER |
Identifies the transaction type as a query transaction. |