|
|
|
|
Columns
Column name |
Data type |
Description |
|---|---|---|
PATIENTGUID |
VARCHAR2(36) |
InForm patient identifier. |
VISITGUID |
VARCHAR2(36) |
InForm visit identifier. |
VISITINDEX |
FLOAT |
InForm visit index, if the visit is repeating. |
PAGEGUID |
VARCHAR2(36) |
InForm page identifier. |
PAGEINDEX |
FLOAT |
InForm page index, if the page is repeating. |
SECTIONGUID |
VARCHAR2(36) |
InForm section identifier. |
ITEMSETGUID |
VARCHAR2(36) |
InForm itemset identifier, if the item occurs within an itemset. |
ITEMSETINDEX |
FLOAT |
InForm itemset index, if the instance is an itemset. The corresponding Clintrial repeat identifier is stored as a suffix to the CTRECID. |
ITEMGUID |
VARCHAR2(36) |
InForm item identifier. |
RECREVISIONNUMBER |
NUMBER |
Revision number (timestamp) of the status change for the item. The highest number is the current revision. |
PFDATETIME |
DATE |
Date and time when the status of the item changed in the InForm software. |
USERGUID |
VARCHAR2(36) |
GUID of the InForm user who caused the status change. |
SDVSTATE |
NUMBERPS(38,0) |
Flag indicating whether the item has been source verified:
|
