Schedule of active participant data
The Schedule of Active Participant Data parameter values are set under the Active Data topic of the Census Specifications. This topic includes the following inputs:
A field or Service Definition to specify credited service for purposes of the schedule.
In modes other than U.S. qualified pension, a check box to specify whether average valuation salary should be included.
In the U.S. qualified pension mode, a check box to specify whether an average should be included and, if so, whether the amount averaged should be valuation salary or accrued benefit.
In the U.S. qualified mode, a check box to specify whether average cash balance account information should be included.
The following methodologies are employed:
In the U.S. qualified and U.S. public pension modes, if average valuation salary is included, it is limited to the Internal Revenue Code 401(a)(17) limit.
Exact age is based on the date of birth field specified under the Active Data topic of the Census Specifications.
Exact service is based on the credited service field or Service Definition specified for the schedule. If the default, <date of hire>, is selected and a hire age is specified instead of a date, exact service is calculated as exact age on the Valuation Date minus exact hire age.
The following criteria are applied to create age and service groups. Based on the criteria, the age groups could be interpreted as referring to “attained age” or “age last birthday” (e.g., “30 to 34” contains records with attained ages 30 to 34). Similarly, the service groups could be interpreted as referring to “completed years of service”.
| Age Group | Criteria |
| Under 25 | exact age < 25 |
| 25 to 29 | 25 <= exact age < 30 |
| 30 to 34 | 30 <= exact age < 35 |
| 35 to 39 | 35 <= exact age < 40 |
| 40 to 44 | 40 <= exact age < 45 |
| 45 to 49 | 45 <= exact age < 50 |
| 50 to 54 | 50 <= exact age < 55 |
| 55 to 59 | 55 <= exact age < 60 |
| 60 to 64 | 60 <= exact age < 65 |
| 65 to 69 | 65 <= exact age < 70 |
| 70 & up | 70 <= exact age |
| Service Group | Criteria |
| less than 1 | exact service < 1 |
| 1 to 4 | 1 <= exact service < 5 |
| 5 to 9 | 5 <= exact service < 10 |
| 10 to 14 | 10 <= exact service < 15 |
| 15 to 19 | 15 <= exact service < 20 |
| 20 to 24 | 20 <= exact service < 25 |
| 25 to 29 | 25 <= exact service < 30 |
| 30 to 34 | 30 <= exact service < 35 |
| 35 to 39 | 35 <= exact service < 40 |
| 40 & up | 40 <= exact service |