View or edit data default properties for a data map.
Date Default Settings
Default date settings for century, year, month, and day. If you define a field mask and values in the mask are missing, the missing values default to these settings. For example, if you define a field mask as Y2-MM, and you provide input data of 99-04, the century and day values are missing. PowerExchange constructs the date field by using the default century and day values, which are 19 and 01 respectively, as follows:
19990401
The default date settings are:
Century: 19
Year: 80
Month: 1
Day: 1
Missing Century
Specify one of the following actions for a missing century value:
Default
. Complete the default action.
Fixed
. Check the year against the
Pivot
value. If the input year value is less than the
Pivot
value, the century is assumed to be 20. Otherwise, it is assumed to be 19.
Moveable
. Calculate a boundary value by subtracting the current year value from the input year. If the boundary is less than zero, one hundred is added to the boundary value. If the
Pivot
value is less than the boundary value, the century is assumed to be 20. Otherwise it is assumed to be 19.
Character Replacement
If data checking is enabled for CHAR fields and the data in the field fails data checking, the character in the
Value
box replaces either the first character or all characters in the field, as follows:
Single Char
. First character in the field.
All Chars
. All characters in the field.
Strict Signs in Keys
Returns data if it exactly matches the correct signing conventions of the appropriate datatype. For example, SPACKED.