Looking for the Desktop version of this article?
Projects Fields are used to "tag" Task Item answers within Projects so that the tagged Task Item can be viewed in queries and reports, filtered upon when mass launching projects, or used to target certain contacts for Blast Email.
For example, if a Task Item was tagged with a Project Field called "Top Heavy Percentage," a report or query would display the answers across all types of plans, plan years, or project types that contain the "Top Heavy Percentage" Project Field tag. Additionally, if a Blast Email template was created to inform certain plan sponsors that their plan was approaching the 60% top heavy limit, Project Fields could be displayed on the Blast Email Recipients tab and filtered to only display those that would receive the email, i.e. greater than 50%. Project Fields can also be used to populate Blast Emails and, in our Business tier, can be used to fill data fields when using the Merge Document feature.
Use Project Fields to tag any data in your projects that could be useful for client communications, merging data to reports or other documents, launching projects, or just simple analysis.
Tier Availability: Essential, Premium, Business
Security Rights Required: Maintenance
Note: Some items may not be available in all tiers.
Note: Tabs and fields will vary depending on the tier the user is on.
Menu:
- Creating and Editing a Project Field List Value
- Adding a Project Field to a Project Template
- Adding Project Fields to an Excel Project Template
- Reporting on Project Fields
- Adding Project Field Merge Fields to Blast Email Templates
- Frequently Asked Questions
To use Project Fields in Projects, the user must first create the desired Project Fields that will be "tagged" in a Project Template.
Note: Project fields cannot be used with the Plan Contacts - No Duplicates, Proposal Contacts, or Prospect Contacts mailing types.
Creating and Editing a Project Field List Value
To Create a Project Field List Value
- Click Maintenance > List Values > Core > Project. Select the Project Field sub-menu.
- A list of any pre-existing Project Fields will be shown in the grid with a Description.
- Click the Add icon in the upper right corner of the grid. The Add Project Field window will appear.
- Enter a Display Name for the Project Field and a Description. For example, "Top Heavy Percentage" or "2021 AFTAP"
- Be sure to not include any trailing spaces at the end of the Display Name text.
- Confirm the Active box is checked and click Save.
To Edit an Existing Project Field List Value
- Click Maintenance > List Values > Core > Project. Select the Project Field sub-menu.
- A list of any pre-existing Project Fields will be shown in the grid with a Description.
- Please Note: Project Fields cannot be deleted once created.
- Hover over the Project Field and click the Edit icon. The Edit Project Field window will appear.
- Edit the Description and/or Active status.
- Users should not rename Project Field Display Names. If the Project Field will no longer be used, users should mark the Project Field as Inactive.
- Click Save.
Adding a Project Field to a Project Template
- Click Maintenance > Templates.
- A list of saved templates will appear in the grid with a Description.
- Double-click the Project Name to open the Template.
- Click the Workflow menu.
- Double-click the Task Grouping and then double-click the Task to display the list of Task Items from which to choose.
- Click the Edit icon to the right of a Task Item and the Edit Task Item pop-up will appear. Click the Project Field dropdown to display the active Project Fields. Select the Project Field from the dropdown.
- The system displays two choices below the Project Field selection: Show on Project Summary and Show on Plan Summary.
- If Show on Project Summary is selected, the answer recorded by the user for this Task Item will be reflected on the Project Fields grid of a Project.
- If Show on Plan Summary is selected, the answer recorded by the user for this Task Item will be reflected on the Projects Fields grid of a Plan.
- The user may choose to select one, neither, or both.
- Click Save.
Updating the template will only affect new projects launched. It does not affect previously launched projects.
Adding Project Fields to an Excel Project Template
Project Fields can be added to an exported Excel Project Template for upload into PensionPro.
- Click Maintenance > Templates.
- A list of saved Templates will appear in the grid. Click once on the template to select it and click the More icon in the upper right corner of the grid.
- Three export options will appear in the dropdown. Select the desired export option.
- Save the exported file to a folder.
- Open the exported Excel template.
- Type in the Project Field Display Name in the Project Field Column of the desired Task Item row.
- Repeat step 6 for as many Project Fields that are applicable.
- Save the Template and close out of it.
- Click Maintenance > Templates in PensionPro.
- Click the More icon in the upper right corner of the grid and select the Project Template Import option.
- Select the updated template Excel file.
- Users may need to change the Project Name or delete the old Project Template in PensionPro if updating a current template.
Reporting on Project Fields
Users can report on Project Field answers by using the Project Field Values report. This report can be found by clicking Reporting > Projects > Project Field Values. Users can select the projects and Project Fields to report on.
Adding Project Field Merge Fields to Blast Email Templates
Users can add Project Fields as Merge Fields in Blast Email.
- Click Communications > Blast Email.
- Double-click a Blast Email template to open it.
- Click Next to advance to the Subject and Body step and click the Edit icon.
- Place the cursor in the Subject or Message Body window where the Merge Field should be added.
- Expand the Project Fields selection under the Merge Fields list to the right of the screen.
- Double-click on the target Project Field Merge Field to add it to the Blast Email template.
- Click Save.
Note: Project Fields will not appear as Merge Fields if the Mailing Type of the Blast Email is set to one of the following: Plan Contacts - No duplicates, Proposal Contacts or Prospect Contacts.
Frequently Asked Questions
- My current template does not have Project Fields tagged to Task Items. Can I update my template to bring over the Project Fields for launched projects? Updating the template will only affect new projects launched. It does not affect previously launched projects.
- Does Fetch have the capability to report on Project Fields? Yes. Users can find a Project Fields node under the Projects selection in Fetch.
- I've selected to show Project Fields on the Project Summary. Where do they appear? Project Fields tagged as such will appear on the Project Fields grid of the project.
- I've selected to show Project Fields on the Plan Summary. Where do they appear? Project Fields tagged as such will appear on the Project Fields grid of the plan.
- Can I rename the Display Name of a previously used Project Field if it is no longer being used? Users should not recycle or rename Project Field Display Names as it may result in reporting issues for the old Project Field Name. Users can edit the "old" Project Field and mark it as inactive and then create an entirely new Project Field for the new Display Name that will be used.