Date controls
Date controls can be mapped to up to seven columns depending on the date control attribute values.
Columns in clinical views for date controls
View column name |
View column type |
Report element name |
Report element folder |
Content |
---|---|---|---|---|
DT_<CORECOLUMNNAME> |
DATE |
Date ~ <COREITEMNAME> |
Basic Data |
Date without time component. This column is generated only if the Year, Month, and Day DISPLAY attributes are all set to TRUE. This column will be populated if a user selects a value other than Empty or Unknown for all three Year, Month and Day components. |
MY_<CORECOLUMNNAME> |
DATE |
Month Yr ~ <COREITEMNAME> |
Basic Data |
Date without day and time components. This column is generated only if the Year and Month DISPLAY attributes are set to TRUE. This column will be populated if a user selects a value other than Empty or Unknown for all Year and Month components. |
DTS_<CORECOLUMNNAME> |
VARCHAR2 |
YYYY/MM/DD ~ <COREITEMNAME> |
Basic Data |
This column is generated only if the Year, Month and Day DISPLAY attributes are all set to TRUE and one or all of these components' REQUIRED attributes is set to FALSE, or the UNKNOWN attribute is set to TRUE. Date components are populated with entered numbers, or with NULL if you do not select a value, or with UNK if you select Unknown. |
TM_<CORECOLUMNNAME> |
DATE |
Time ~ <COREITEMNAME> |
Basic Data |
This column is generated only if the Hour and Minute DISPLAY attributes are all set to TRUE. This column will be populated if a user selects a value other than Empty or Unknown for all Hour and Minute components. Seconds component values are used if selected by the user. |
TMS_<CORECOLUMNNAME> |
VARCHAR2 |
HH24:MM:SS ~ <COREITEMNAME> |
Basic Data |
This column is generated only if the Hour and Minute DISPLAY attributes are all set to TRUE and one of these components' REQUIRED attribute is set to FALSE or the UNKNOWN attribute is set to TRUE. As with Date Strings, these column values use the format HH24:MM:SS (or HH24:MM if no seconds are displayed). This column is populated with values for HH, MM, and SS if selected, NULL if you do not make a selection, or UNK if you select Unknown. |
Y_<CORECOLUMNNAME> |
DATE |
Year ~ <COREITEMNAME> |
Additional Data |
This column is generated only if the Year DISPLAY attribute is set to TRUE. This column will be populated if a user selects a value other than Empty or Unknown for Year components. Month and Day components are ignored. |
M_<CORECOLUMNNAME> |
DATE |
Month ~ <COREITEMNAME> |
Additional Data |
This column is generated only if the control Month DISPLAY attribute is set to TRUE. This column will be populated if a user selects a value other than Empty or Unknown for Month components. Year and Day components are ignored. |
The following examples illustrate mapping a datetime control.
Central Designer Properties Browser view
MedML definition
Display in the InForm application
Database view
Cognos model