RT_CONTROLDATA
This table contains a reference to the current version of each control that has or has had a value (was cleared).
| Column name (Key indicator) | Column description |
|---|---|
| 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:
|
| 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. |