Looking for the Desktop version of this article?
PensionPro provides users with the ability to import and maintain Plan Document Specifications for any Plan maintained in the system that is not indicated as an Internal Plan. Document Specifications can be very useful to:
- Customize blast emails to enhance customer service or data requests
- Launch more targeted projects that may apply to certain plan types
- Give an at-a-glance view of Document Specifications to PensionPro users
Document Specifications are maintained in PensionPro by building a Document Template with the desired Document Specification Fields and then adding Document Specifications by manual entry or a data import routine.
Software Required: Team, Core, Essential, Premium, Business
Security Rights Required: Maintenance, Add/Edit Plan Doc Specs
Menu:
- Creating a Document Template
- Adding a Document Provider
- Adding and Maintaining Document Template Types
- Adding and Maintaining Document Specification Data Types
- Adding a Document Template Specification Field
- Document Specifications Maintenance (Video)
- Frequently Asked Questions
Creating a Document Specification Template is the first step in adding Document Specifications for Plans.
Creating a Document Template
To add and view Document Specifications in PensionPro, the user must first create a Document Template with the Document Specification Fields desired to be stored in the system. To create a Document Template, follow the steps below:
- Add a Document Provider
- Add Document Template Types
- Add Document Specification Fields
Adding a Document Provider
To add a Document Provider:
- From the Navigation Panel, click Maintenance > Preferences > Document Specifications.
- Click on the Providers tab.
- Click the Add button and the Add Document Provider slider will appear.
- Enter a Provider Name for the Document Provider.
- Select a Vendor from the dropdown menu. If not using the ftwilliam.com integration feature, select Common.
- Select the Preferred Checkbox if this is the firm's primary Plan Document Provider.
- Click the Save button.
Adding and Maintaining Document Templates Types
Add a Document Template Type:
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Templates tab.
- Click the Add button to the right of the Document Template Types dropdown. An Add Document Template Type slider will appear.
- In the slider, choose one of the following Actions:
- Copy from Existing Template - This option allows the user to copy from a template they have already created in the system.
- Copy from Library Template - This option allows the user to copy an existing template from the template library. The available templates will be based on the Provider and Vendor that has been selected.
- Create New Template - This option allows the user to create their own template.
- Select the name of the Provider for the Document Type Template.
- Select a Default Status for the Document Template Type by selecting the desired value from the dropdown menu. "Active" is the most common entry for this field. If there are internal processes for the entry and approval of Plan Document Specifications, other statuses may be entered, by clicking the Add button to the right of the Default Status field. For example, Pending or Archived might be appropriate. The selection made for this field will be the Default Status when Template is used when entering or importing Document Specifications.
- Enter a Template Name. For example Standardized 401(k) Prototype or Volume Submitter 401(k).
- Enter a Description for the Template.
- Click the Save button.
Edit a Document Template Type:
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Templates tab.
- Select a Template from the Document Template Types dropdown menu.
- Click the Edit button to the right of the Document Template Types dropdown menu.
- Edit the Default Status, Template Name or Description as necessary. It is recommended that users do not edit the system default templates included in the template library. To customize these templates, users should first copy the default template and make any edits to the new copied version.
- Click Save.
Delete a Document Template Type:
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Templates tab.
- Select a Template from the Document Template Types dropdown menu.
- Click the Delete button to the right of the Document Template Types dropdown menu.
- Click "Yes" to confirm the deletion. Deleting the template will not delete previously established specifications on plans.
Adding and Maintaining Document Specification Data Types
Users can add additional data types to their specification templates to create customized answer dropdowns to keep answer formats concise. Several sample Data Types are pre-populated in the system as defaulted Values. The user can add Data Types or edit the existing Values. Many users add Data Types for ease when manually entering Document Specifications or to define imported Document Specifications that may be abbreviated in Provider exports.
Add a Document Template Data Type:
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Data Type tab.
- Click the Add button to the right of the Specification Data Types and Values grid.
- Enter a name for the Data Type in the Data Type Name text box.
- Enter a brief description in the Description Text box.
- Confirm the Active checkbox is checked.
- Click Save. The new Data Type will appear in the grid.
Edit a Document Template Data Type:
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Data Type tab.
- Click once on a Template Data Type to highlight it.
- Click the Edit button to the far right of the Specification Data Types and Values grid.
- Make changes to the Display Name, Description and Active status and click Save.
Delete a Document Template Data Type:
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Data Type tab.
- Click once on a Template Data Type to highlight it.
- Click the Delete button to the far right of the Specification Data Types and Values grid.
- Click Yes to confirm the deletion.
Add values for a Document Template Data Type:
- Locate the Data Type from the Specification Data Types and Values Grid.
- Click the (+) button to the left of the Data Type Name. A Values grid will appear below.
- Click the Add button to the far right of the Values grid.
- Enter a name for the value in the Value Name text box.
- Enter a description for the Value Name in the Description text box.
- Confirm the Active checkbox is checked and click Save.
- Repeat steps 3-6 until all desired values have been added for the Data Type.
Edit values for a Document Template Data Type:
- Locate the Data Type from the Specification Data Types and Values Grid.
- Click the (+) button to the left of the Data Type Name. A Values grid will appear below.
- Click once on the Data Type value to highlight it.
- Click the Edit button to the far right of the Values grid.
- Make changes to the display name, description or active status and click Save.
Delete values for a Document Template Data Type:
- Locate the Data Type from the Specification Data Types and Values Grid.
- Click the (+) button to the left of the Data Type Name. A Values grid will appear below.
- Click once on the Data Type value to highlight it.
- Click the Delete button to the far right of the Values grid.
- Click "Yes" to confirm the deletion.
Adding/Deleting a Document Template Specification Field
Document Templates are comprised of Document Template Specification Fields. Users can create as many or as few Specification Fields in a Document Template as desired.
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Templates tab.
- To add a specification to the template, click the Add button to the far right of the Specification Fields grid and an Add Specification Field slider will appear.
- Click in the the Tag Search field to search for the tag and select the desired tag from the dropdown menu. Tag Names and Specification Sections are hardcoded and cannot be added, edited, or deleted.
-
Enter a name for the Specification Name. If possible, use the same field name that might appear as a header or field name in an export file from the Document Provider or other external data source that may be used for importing Document Specifications. Matching field names will enable auto-mapping for importing Document Specifications.
-
Enter a description of the Specification Field. This field can further define the Name field. For example, if the Name field is ProfitSharingVesting, the Description might be Employer Discretionary Vesting Schedule.
- Select a Data Type for the provision. If importing, Text is a universal data type. To add a Data Type, follow the instructions for Adding Data Types for Specifications Fields in this article.
-
Enter a Default Value for the provision if applicable. When adding Document Specifications manually, the value entered will be pre-populated in the template each time the template is applied to a Plan.
- Click Save.
- To delete a specification from the template, select the specification and click the Delete button. Click "Yes" to confirm the deletion.
Repeat the steps above to build a Plan Document Specifications Template.
Document Specifications Maintenance
Users can access the Document Specifications Maintenance screen to export their Document Specifications templates to Excel to be provided with a blank copy of the template to populate or to delete a recent import of a template. For information on importing document specifications, please review Adding and Importing Document Specifications.
Export a Blank Template
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Maintenance Tab.
- From the Export a Document Specification Template File grid, select the Provider, Template Type, and Mapping Style of the Template to be exported.
- Once the Export button is activated in the right corner of the screen, click the Export button to save a copy of the file.
Delete a Recent Import
Users can delete a recent import up to 7 days after the import was made.
- From the Application Menu, click Maintenance > Preferences > Document Specifications.
- Click on the Maintenance tab.
- From the Delete a Recent Import grid, click once on the target Import record to highlight it.
- The record will indicate the title of the import when it was imported, and the name of the employee who imported the file.
- Click the Delete button to the right of the grid.
- Click Yes to confirm the deletion.
Frequently Asked Questions
-
I've imported the wrong template of data, can I delete an entire import? Users can delete an import by following the Delete a Recent Import directions found under the Document Specifications Maintenance Section above.
-
If I Delete a Document Specifications template, does it delete those templates I have on my Plans? Deleting a template only removes the Document Specifications Template, not specifications that have been added to plans.
- Can I copy a template so I don't have to recreate it from scratch? Users can Click the Add button located to the right of the Document Template Types dropdown menu on the Templates tab and select "Copy from Existing" and choose the template they wish to copy from.