Use the Age Function tab to specify
parameters for aging data when using a Column Map.
These values are applied to columns for
which you specify the Age function as AGE(DEF) or AGE(RU=DEF).
These values are also used to complete incomplete specifications for
date adjustment values in columns defined with the Age function.
Date Adjustment Values
Select one of the following options:
- None
- Specifies that an aging increment is not used.
- Years, Months, Weeks, Days
- Adjusts
dates incrementally by a specified number of years, months, weeks,
and/or days. Use a minus (-) sign to decrement the date. The plus
(+) sign is not required to increment the date.
- Years
- Number of years (-2500 to +1581) to adjust the date.
- Months
- Number of months (-30000 to +30000) to adjust the
date.
- Weeks
- Number of weeks (-30000 to +30000) to adjust the
date.
- Days
- Number of days (-99999 to +99999) to adjust the
date.
- Specific Year
- Adjusts the date to a specific four-digit year (1582
to 3999).
- Specific Date
- Adjusts the date to a specific date. To select a
date from a perpetual calendar, click on the down arrow. Click the
arrow buttons to set the month and year. Click on a day to set the
day of the month.
Note: If you do not specify a date, the system (current)
date displays. The date format is based on the Regional Settings on
the Control Panel of your computer.
- Base/Target
- Adjusts the date incrementally by a calculated aging
amount. The aging amount is the number of days between the Base date
and the Target date. To select a base or target
date from a perpetual calendar, click on the down arrow. Click the
arrow buttons to set the month and year. Click on a day to set the
day of the month.
- Base
- Specify an explicit start date for calculating the
aging amount.
- Target
- Specify an explicit end date for calculating the
aging amount.
- Multiple/Rule
- Adjusts
the date by applying the specified date aging rule the specified number
of times. For example, if the rule is defined as NEXTPAYDAY and you
specify 4 as the multiple, the date is adjusted from the source date
to the fourth NEXTPAYDAY.
- Multiple
- Number of times (1 to 30000) to apply the specified
rule for date aging.
- Rule
- Name of the rule to use.
Date Adjustment Options
- Calendar
- Enter the name of the calendar to use
by default. To select from a list of available calendars, click the
down arrow.
- Rule
- Enter
the name of the rule to use by default. To select from a list of available
rules, click the down arrow.
Note: Define calendars and rules by clicking . For details on defining calendars and rules, see the Common Elements Manual.
- Century Pivot
- Enter
the value to use to determine the appropriate century when a date
value is defined with a two-digit year. If you do not specify a value,
65 is used by default. For example, if you specify 55 as the Century
Pivot, then:
- All two-digit years equal to or greater than 55
are assumed to be in the 20th century.
- All two-digit years less than 55 are assumed to
be in the 21st century.
Exception Options
Select
the following exception options to handle special date values when
aging data. Rather than treat these dates as errors, the dates are
moved directly from the source to the destination if the column attributes
are identical.
- Process
rows with invalid dates — If you select this check box,
rows with columns that contain invalid dates are processed and the
results are written to the destination. If you clear the check box,
the rows are discarded and are noted in the Control File.
- Process
Rows with skipped dates — If you select this check box,
rows with columns formatted as skipped dates are processed and the
results are written to the destination. If you clear the check box,
the rows are discarded and are noted in the Control File.
At times, special values called skipped dates
are used to indicate special handling or unique conditions. To determine
whether or not to skip a date, the date aging function evaluates each
date for the following:
- If a date column contains all spaces, hexadecimal
zeros (low values), or hexadecimal 'FF' (high values), the date is
skipped.
- If a date column contains a skipped date value,
the value is parsed based on the specified date format or exit routine.
The date aging function recognizes the following
as skipped dates:
Date Format |
Skipped Date Value |
Date Format |
Skipped Date Value |
Y/M/D |
1999/99/99 |
Y/M |
1999/999 |
9999/99/99 |
9999/999 |
9999/12/31 |
1900/0 |
1900/0/0 |
2000/0 |
2000/0/0 |
0/0 |
0/0/0 |
Y |
9999 |
1/1/1 |
0 |
Y/J |
1999/999 |
M/D |
99/99 |
9999/999 |
0/0 |
1900/0 |
M |
99 |
2000/0/0 |
0/0 |
0/0 |
D |
9/9 |
|
0/0 |
This list is intended to be as comprehensive
as possible. If you require additional skipped dates, contact Technical
Support.