Date and time validation
The InForm Data Import utility performs the following validation checks for datetime data:
Date and time validation
Validation check |
Description |
---|---|
DISPLAY attribute of CRF datetime control. |
The MedML DISPLAY attribute must be set to True for the components of the CRF datetime control into which a date, time, or datetime item is being imported. The InForm Data Import utility ignores date and time components for which the DISPLAY attribute is False, and it does not import them. |
Year value of import field. |
If the imported year is outside the range allowed in the CRF datetime control, the InForm Data Import utility issues an error. |
Day value of import field. |
If the Year and Month values are valid, the InForm Data Import utility checks for a valid day value. |
REQUIRED attribute of CRF datetime control. |
If any datetime component is coded as REQUIRED in the CRF datetime control and is missing in the import file, the InForm Data Import utility issues an error. |
UNKNOWN attribute of CRF datetime control. |
If an imported datetime component is coded UNK, but the UNKNOWN attribute of the CRF datetime control is not enabled, the InForm Data Import utility issues an error. |
Consistency checking. |
If consistency checking is enabled in the CRF datetime control, the InForm Data Import utility issues an error if a datetime component is present in the import file without a higher component, or an UNK value, in the following sequence: ss:mm:hh dd/mm/yy For example, if the imported datetime includes a Day field without a Month, the InForm Data Import utility issues an error. |
Hour and Minute values of import field. |
The values for both Hour and Minute must be within valid ranges or coded as UNK. |