Previous Topic

Next Topic

Book Contents

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,
CONTROL3GUID,
CONTROL4GUID,
CONTROL5GUID

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:

  • 1—Month
  • 2—Day
  • 3—Year
  • 4—Hour
  • 5—Minute
  • 6—Second

INFSITEUSERMAP

NUMBER

Not used.

INFSITEUSERPROPERTY

VARCHAR2(64)

Not used.

Send Feedback