Each Duration Alias returns seven values that can be referenced in other parameters.
Duration Aliases names can only be 9 characters long because multiple result values are returned when resolved. These additional secondary values can be referenced in most places where a primary duration alias can be referenced by adding the numbers 2 through 7 to the duration alias name.
Secondary Values
Duration Alias | Result | Description | Formula |
MYDUR | 65.497 | Unrounded | Resolved According to Duration Options |
MYDUR2 | 65.500 | Rounded to Whole Months | = Round(MYDUR – Truncate(MYDUR,0),0) + Round(Round(Round(MYDUR – Truncate(MYDUR,0),0) x 12,0) / 12,6) |
MYDUR3 | 65 or 66 | Rounded to Whole Years | If Use Monthly Equivalents = Trucate(MYDUR2,0) Else = Round(MYDUR2,0) |
MYDUR4 | 786 | Total Whole Months | = Round(MYDUR2 x 12,0) |
MYDUR5 | .497 or .500 | Fractional Years | If Use Monthly Equivalents = Round(Round(Round(MYDUR – Truncate(MyDUR,0),0) x 12,0) / 12,6) Else = MYDUR – Truncate(MYDUR,0) |
MYDUR6 | 6 | Fraction Years as the Number of Months | = Round(Round(Round(Round(MYDUR – Truncate(MYDUR,0),0) x 12,0) / 12,6) * 12, 0) |
MYDUR7 | 181 or 182 | Fractional Years as the Number of Days | = Truncate(MYDUR5 x 365, 0) |
Formula Details
The source for Formula details is PAPUDTMN.cbl sections FA100-COMPUTE-DUR-OUTPUT, FA200-MTH-EQUIV, and FA300-CALC-REM-MTHS
Use Monthly Equivalents is a checkbox on the Conversion Options Page of the Duration Method Component:
Set Up HCM > Product Related > Pension > Calculation Rules > Duration > Conversion Options > Use Monthly Equivalents
Hints
Query PS_PA_CLC_ALS_VAL to see the seven Duration Alias results resolved during a calculation.
Leave a Reply
You must be logged in to post a comment.