What are the RD Column names in RDE Analytics tables?
RD Column Name in RDE Analytics tables
RD Column Name |
Source of data |
Column data type |
---|---|---|
Text, integer, or float item without units: |
|
|
|
Entered value |
VARCHAR2, NUMBER, or FLOAT, depending on the data type of the item. |
|
Reason why an item is incomplete (Not Done, Not Applicable, or Unknown). |
VARCHAR2 |
Integer or float item with units: |
|
|
|
Entered value |
NUMBER or FLOAT |
|
Normalized value |
NUMBER or FLOAT |
|
Entered unit symbol |
VARCHAR2 |
|
Normalized unit symbol |
VARCHAR2 |
|
Reason why an item is incomplete (Not Done, Not Applicable, or Unknown). |
VARCHAR2 |
Radio buttons or drop-down lists: |
|
|
|
Label |
VARCHAR2 |
|
Coded value |
VARCHAR2, NUMBER, or FLOAT, depending on the data type of the item. |
|
Reason why an item is incomplete (Not Done, Not Applicable, or Unknown). |
VARCHAR2 |
Checkboxes |
|
|
Two columns for each checkbox: |
|
|
|
Label of codelist item control in child item. |
VARCHAR2 |
|
Coded value of codelist item control in child item. |
VARCHAR2, NUMBER, or FLOAT, depending on the data type of the item. |
Dates and times: |
|
|
|
Valid, complete date time or complete date plus hours and minutes (A complete date time can include UNK or ND entries). |
DATE |
|
Date string |
VARCHAR2 |
|
Appears when:
|
VARCHAR2 |
|
Time string |
VARCHAR2 |
|
Appears when:
|
VARCHAR2 |
|
Reason why an item is incomplete (Not Done, Not Applicable, or Unknown). |
VARCHAR2 |
Compound items (parent item): |
|
|
|
Reason why an item is incomplete (Not Done, Not Applicable, or Unknown). |
VARCHAR2 |
Compound items (child item): |
|
|
|
Based on the type of the child item or control. |
Based on the type of the child item or control. |