Columns
Column name |
Data type |
Description |
---|---|---|
VISITGUID |
VARCHAR2(36) |
GUID of an InForm visit. |
PAGEGUID |
VARCHAR2(36) |
GUID of an InForm form. |
SECTIONGUID |
VARCHAR2(36) |
GUID of an InForm section. |
ITEMSETGUID |
VARCHAR2(36) |
GUID of an InForm itemset. |
ITEMGUID |
VARCHAR2(36) |
GUID of an InForm item. |
CONTROL1GUID |
VARCHAR2(36) |
GUID of an InForm control. |
CONTROL2GUID, |
VARCHAR2(36) |
GUID of an InForm control nested within another control. Each additional column denotes another level of nesting, up to the five levels supported by the InForm software. |
BLOCKKEY |
VARCHAR2(100) |
Page key value specified for the mapping. |
PAGEKEY |
VARCHAR2(100) |
Block key value specified for the mapping. |
PANELNAME |
VARCHAR2(36) |
Name of the Clintrial panel targeted by the InForm path that the GUIDs define. |
ITEMNAME |
VARCHAR2(36) |
Name of the Clintrial item targeted by the Clintrial path that the GUIDs define. |
SUBSETVALUE |
VARCHAR2(2000) |
Subset Value to store with the InForm path that the GUIDs define. |
SUBSETITEM |
VARCHAR2(36) |
Name of the Clintrial item in which to store the Subset Value. |
DATEPART |
NUMBER |
Date time control component to be stored in the Clintrial item, if the components are being stored separately:
|
INFSITEUSERMAP |
NUMBER |
Not used. |
INFSITEUSERPROPERTY |
VARCHAR2(64) |
Not used. |