|
|
|
|
Clinical data table structure
Each UPDATE, DATA, and AUDIT table has the same structure, consisting of a column for each:
- System item created by the Clintrial software. System items are:
- ENTRY_DATETIME and MERGE_DATETIME—Entry and merge datetime stamps.
- DB_ID, CT_RECID, ENTRY_ID, and SUBJECT_ID—Internal database, record, user, and subject IDs. The ENTRY_ID is the InForm user account who entered or last modified InForm data.To find the name of the user who performed an operation such as validation or coding on data in Clintrial, check the job log.
- STATUS—Record status.
- CTS$REASON—Reason that the record was changed or deleted.
- CONTEXT panel item identifying the study subject and the block and page with which the clinical data row is associated. The record might contain additional CONTEXT panel items defined by the study designer and used to uniquely identify the record.
- Clinical data item.
