Report Breakpoints
Reports are generated only for the assumptions you selected for study. This topic lets you control how results are grouped and subtotaled in the reports.
Select a report lists the applicable reports:
| Selected Assumptions | Reports Available |
| Decrements: | |
| Retirement | Retirement Probabilities |
| Termination | Termination Probabilities |
| Death | Mortality Probabilities |
| Disability | Disability Probabilities |
| Active Salary Growth | Total Salary Increases |
| Inactive Mortality for: | |
| Retired Members | Retired Members |
| Vested Members | Vested Members |
| Survivor Beneficiaries | Survivors & Beneficiaries |
| Disabled Members | Disabled Members |
| Election Probabilities | Each Benefit Definition with an associated election probability |
Click the name of a report to edit its report settings.
Each report can be grouped by age, service and/or sex. For example, you might group retirement decrements by ages “from 55 to 65 step 1” but group termination decrements by ages “from 20 to 65 step 5”. You might group the termination decrements by service also (e.g., “from 1 to 5 step 1”) to see how terminations vary by service. You may group by sex and, optionally, show totals of males and females. Each report will have the appropriate grouping columns and results columns, as in this sample of the first rows of a termination probabilities report that is grouped by age, service and sex:
| Sex | Service | Near Age | Exposed | Actual Terminations | Expected Terminations | Actual q's | Expected q's | Ratio: Actual over Expected |
|
Male |
<1 |
<20 |
0
|
0
|
0.00 |
0.0 |
0.000000 |
0.000 |
If grouping by service is not selected, then the Service column is omitted and results are not broken down by service. Similarly, if separate male/female totals is not selected, then the Sex column is omitted and results are not broken down by sex.
In the Total salary increases report, check Show rounded salary totals to round salaries so no more than nine significant digits are displayed in the report.
Note several important aspects of age and service breakpoints:
Breakpoints must be integers. If fractional breakpoints are entered, they will be rounded.
Breakpoints always include totals. Blank breakpoints will be interpreted as “totals only”. Note that this treatment is different from that of Descriptive Statistics, Group Data, etc., where blank breakpoints are interpreted as “use every encountered value as a breakpoint”.
Age for grouping is computed at any valuation date as the record’s age on the birthday nearest the valuation date (often referred to as “age nearest birthday”). Note: If salaries for actives are coded (under the Active & Vested Valued Through Active Data topic) as ending, rather than beginning, on the valuation date, then salaries in the Prior Year Salaries column are grouped according to age on the preceding valuation date. Service for grouping, generally, is computed as the difference between the record’s age nearest birthday on the valuation date (aka rounded attained age) and the record’s age nearest birthday on the specified hire date (aka rounded hire age). These computation methods are consistent with ProVal’s computation of age and service for a Valuation. Note, however, that if the Valuation Assumptions (selected under the Assumptions topic) contain a decrement rate table, election probability table or salary merit scale table with a service dimension and the associated definition of table service specifies a data field containing a start date or a numeric service amount (instead of specifying “<rounded attained age – rounded hire age>”), then service for studying that assumption is computed (instead) as rounded elapsed time.
The subtotal field lets you generate reports for subgroups. For example, if your database contains both hourly and salaried workers, with the field CLASS indicating a plan participant’s classification, then you may subtotal results according to the codes in this field. This is useful if you have assumptions that vary by classification (and are contained in one Valuation Assumptions library entry, varying by coded database field) and wish to study the assumptions separately. If the value contained in a record’s subtotal field has changed from one year to the next (as commonly occurs, for example, with participant status), the beginning-of-year value determines which subgroup the record is placed in. You can also select <year> to view year-by-year results.