RT_CONTROLDATA
This table contains a reference to the current version of each control that has or has had a value (was cleared).
Columns in the RT_CONTROLDATA table
RT_CONTROLDATA |
RT_CONTROLDATA |
---|---|
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 |
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 |
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 |
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:
|
ITEMSETSTATE |
One of the following:
|
CONTROLVALUE |
Value entered for the control, converted to VARCHAR2 data type. |
IMPUTEDDATETIME |
InForm-provided data, entered when user-entered dates are partial or invalid.
|
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. |