ProAdmin’s Fulfillment Tool allows you to use Structured Query Language (SQL) within Microsoft Access to create data fields for use within the Tool. To use this command, you must first develop the query and save it within the Access database.

The Query Mapping dialog box is accessed by clicking the button on the task bar, or selecting Query Mapping... from the Edit Menu. If There are no Queries defined in the current Access database, a dialog box will provide this information and then exit the command upon your clicking the OK button. If the database does include Queries, the following information is presented:

The Query Name column shows the names by number of the queries saved within the Access database. Each of these queries will need to be associated with a table contained within the Access database, … is like Table Name provides a multi-choice field for selecting the table that reflects the structure of the query. The available options are:

Results_which_do_not_vary_by_Commencement_Date is a table that contains fields whose values are established at decrement date. The data included in this table would typically include such things as participant date of birth and beneficiary information.

Results_which_ vary_by_Commencement_Date is a table that contains fields whose values are established at commencement date. Examples are benefit payable at early retirement where the accrued benefit is reduced by an early retirement factor based on the member’s age at commencement date. Note there can be more than one Commencement Date, each with its own record of information.

Results_which_ vary_by_Payment_Form_within_Commencement_Date is a table that contains fields whose values are established within payment forms. Once the benefit amount is established at commencement date, further results for payment forms can be determined. Note: there can be more than one Payment Form within each Commencement Date, each with its own record of information.

The three table types have distinctive structures. Select the type that “is like” one of the optional table forms.