CONTROLVALUEID (PK)

Unique identifier for this control value.

VALUEORDER (PK)

Revision of this value record.

CONTEXTID

Foreign key to PF_ITEMDATA to PF_ITEMCONTEXT. Identifier of the Item context.

AUDITORDER

FK to PF_ITEMDATA. Revision number of this row; timestamp matching transaction revision.

CONTROLID

Identifier of the control metadata identifier.

PARENTCONTROLVALUEID

Identifier of the Parent Control Value (refers to this table). If NULL, this is the top level control.

PARENTVALUEORDER

Corresponding revision to the ParentControlValueID.

SUBJECTID

Numeric identifier for the subject associated with the current version of the control.

SUBJECTTYPE

Describes the form type. Subject forms are CRFs and Enrollment forms; Site type is for Reg Docs and Visit Reports:

1 - Subject
2 - Site

SUBJECTVISITID

Numeric identifier for the subject visit with which the control is associated.

VISITID

Numeric identifier for the visit associated with the current version of the control.

VISITINDEX

Identifier for the visit instance on which the control exists:

0 - expected visit
1 - started, non-repeating visit
<revisionnumber> - repeating visit

FORMID

Numeric identifier for the form associated with the current version of the control.

FORMREV

Numeric identifier for the form revision associated with the current version of the control.

FORMINDEX

Identifier for the form instance on which the control exists:

0 - unstarted form
1 - non-repeating form
<revisionnumber> - repeating form

SECTIONID

Numeric identifier for the section associated with the current version of the control.

ITEMSETID

Numeric identifier for the itemset associated with the current version of the control.

ITEMSETINDEX

Numeric identifier for the itemset instance associated with the current version of the control.

ITEMID

Numeric identifier for the item associated with the current version of the control.

ITEMSDVED

Item on which the control exists has been source verified:

0 - No

1 - Yes

TRANSACTIONID

Numeric identifier for the transaction that last modified the state of the item on which the control exists.

LASTENTEREDDATE

Date and time when the control data was last modified.

ENTEREDBY

User who last modified the control data.

ENTEREDREASON

Supplied reason for the last data change.

SDVTIME

Time when the item on which the control exists was source verified.

STATE

One of the following bitmask values for the item state:

• DELETED—1
• SDV—2

ITEMSETSTATE

One of the following:

• If the control exists in an itemset—Value from the STATE column
• If the control does not exist in an itemset—NULL

CONTROLVALUE

Value entered for the control, converted to VARCHAR2 data type.

IMPUTEDDATETIME

InForm-provided data, entered when user-entered dates are partial or invalid.

• Month—January
• Day—1
• Time—12:00 a.m.

CONTROLHASDATA

Control has data:

0 - No

1 - Yes

DATATYPE

Type of data for the control:

-1 - INVALID

0 - NULL

1 - LONG

2 - DOUBLE

3 - STRING

4 - TEXT

5 - DATETIME

NUMVALUE

Value if the datatype is 1 (LONG).

FLOATVALUE

Value if the datatype is 2 (DOUBLE).

STRVALUE

Value if the datatype is 3 (STRING).

NORMALIZEDVALUE

Normalized value for the control.

NORMALIZEDUNITID

Numeric identifier for the normalized unit associated with the control.

UNITID

Numeric identifier for the unit associated with the control.

PFDATETIME

Value if the datatype is 5 (DATETIME), and the value is a complete valid date.

MONTH

Month value entered for the control if the datatype is 5 (DATETIME).

DAY

Day value entered for the control if the datatype is 5 (DATETIME).

YEAR

Year value entered for the control if the datatype is 5 (DATETIME).

HOUR

Hour value entered for the control if the datatype is 5 (DATETIME).

MINUTE

Minute value entered for the control if the datatype is 5 (DATETIME).

SECOND

Second value entered for the control if the datatype is 5 (DATETIME).

BLOBVALUE

Value if the datatype is 4 (TEXT).

FD_ITEMSETID

For internal Oracle use only.

FD_SECTIONID

For internal Oracle use only.

BLANK

The item exists in a Repeating Data itemset, and is blank in the itemset.

0 - No

1 - Yes

CREATEDATETIME

Date and time when the control was started; that is, when a user entered data in the control or triggered a rule that entered data in the control.

CREATEDBYUSERID

User ID of the user who started the control by entering data in the control or triggering a rule that entered data in the control.

MODIFIEDDATETIME

Date and time when the control was most recently modified; that is, when a user most recently entered data in the control or triggered a rule that entered data in the control.

MODIFIEDBYUSERID

User ID of the user who most recently modified the control by entering data in the control or triggering a rule that entered data in the control.

ORADELPAGEUID_LAST

Internal column used to calculate MODIFIEDBYUSERID.

ORADELPAGEDATE_LAST

Internal column used to calculate MODIFIEDDATETIME.

ORADELROWUID_LAST

Internal column used to calculate MODIFIEDBYUSERID.

ORADELROWDATE_LAST

Internal column used to calculate MODIFIEDDATETIME.