DQM function 204 validates the date and time format of the value
of the UMF tag.
The function applies an output format of YYYY/MM/DD or YYYY-MM-DD,
depending upon the system date delimiter. The system date delimiter "-" or
"/" are determined by configuration requirements. If Output time
component with dates? (Y/N) of this is set to "Y", a time component
in the format of HH:mm:SS is expected in the input date.
If you configure
the DQM rule to correct the data, and the date is invalid or is not able to
be properly formatted, the function removes the value from the UMF tag. If
the correction procedure is not configured to correct an error, the function
logs an exception to the configured error log and the value will or will not
be loaded according to the exception severity.
Function parameters
- Output time component with dates? (Y/N)
- Include time component with date value of the UMF tag. If this parameter
is set to Y, and no time value exists in the input value, a time value of
00:00:00 will be added to the output value. (DEFAULT = N)
- User-Specified Date Format n
- User defined date formats. If configured, contains a supported input date
format, for the current UMF segment. If no other parameters are configured,
the only input date formats accepted by the validation process are “YYYY/MM/DD”
or “YYYY-MM-DD”. If Output time component with dates? (Y/N) is
set to Y, any User-Specified Date Format n parameters
will include the addition of both HH:mm and HH:mm:SS time formats for validation.
Supported
User-Specified
Date Format n date mask characters:
- DD for two digit day
- MM for two digit month
- YY for two digit year
- YYYY for four digit year
- - for date delimiter
- / for date delimiter
Supported 8 digit user defined input date formats:
- YYYYMMDD
- MMDDYYYY
- DDMMYYYY
- MM/DD/YYYY
- MM-DD-YYYY
- DD/MM/YYYY
- DD-MM-YYYY
Supported 6 digit user defined input date formats:
- MM/DD/YY
- MM-DD-YY
- YY/MM/DD
- YY-MM-DD
- DD/MM/YY
- DD-MM-YY
- YYMMDD
- MMDDYY
- DDMMYY
- YYYY/MM
- YYYY-MM
- YYYYMM
- MM/YYYY
- MM-YYYY
- MMYYYY
Supported 4 digit user defined input date formats:
- MM/YY
- MM-YY
- MMYY
- YY/MM
- YY-MM
- YYMM
- YYYY
Incoming dates are first validated using the default date formats
“YYYY/MM/DD” or .YYYY-MM-DD. If configured, the User-Specified Date
Format n values are validated in the order they are recorded. If
you use conflicting date formats, this may result in the validation of dates
that may be correctly or incorrectly ambiguous. For example, using the User-Specified
Date Format n parameter, if you configure an eight digit date MM-DD-YYYY
followed by a conflicting eight digit date DD-MM-YYYY, and the date value
12-02-2004 is passed through, the following occurs: - The date value (12-02-2004) is compared to the first User-Specified
Date Format n parameter MM-DD-YYYY.
- According to the parameter, the date value is considered valid.
- A date of December 2, 2004 is recorded.
Even if the date should have been February 12, 2004, because 12-02-2004
satisfies the 1st Second (+) parameter, that is the parameter used to define
the date.
Exception codes
Exception Code |
Description |
Severity* |
-2 |
Unsupported input format. |
3 |
-1 |
The value of the UMF tag is not a valid date (Correction
Procedure not configured). |
3 |
1 |
The value of the UMF tag has been validated. |
0 |
2 |
The value of the UMF tag has been validated and reformatted
(all components included on input – reformatted to be in valid output format
– nothing added or removed. |
0 |
3 |
The value of the UMF tag is empty. |
1 |
4 |
The time component from the value of the UMF tag has been removed. |
3 |
5 |
The value of the UMF tag value modified to create a valid date (input
date has missing components). |
0 |
6 |
Correction Procedure configured. The value of the UMF tag was invalid
and corrected by blanking out the value. |
1 |
7 |
The value of the UMF tag was modified by completing date and removing
time component. |
3 |