CRM Implementation
CRM Implementation
CRM Implementation
____________________________________________________________________________________________________
4800 Lyons Technology Parkway, Suite 4 Coconut Creek, Fl 33073 | 877.4.VUESOFT | www.VUEsoftware.com
Document History
Approvals
Date Name Role
Reviewers
Date Name Role
____________________________________________________________________________________________________
www.VUEsoftware.com 2 of 26
Table of Contents
Document History...................................................................................................................... 2
Approvals.................................................................................................................................. 2
Reviewers................................................................................................................................. 2
Overview............................................................................................................................................... 4
1. Dashboard/Views/Reports.........................................................................................................5
1.1. Policy Dashboard...................................................................................................................... 5
1.2. Phase List View......................................................................................................................... 7
1.3. Status Reason List View............................................................................................................ 8
1.4. My Policy Summary................................................................................................................... 9
1.5. My Pending List View.............................................................................................................. 10
1.6. My Active List View................................................................................................................. 11
1.7. My Policies with Outstanding Requirements List View............................................................12
1.8. Team Phase List View...............................................................Error! Bookmark not defined.
1.9. Team Status Reason List View..................................................Error! Bookmark not defined.
1.10. Team Pending List View.......................................................................................................... 13
1.11. Team Active List View............................................................................................................. 14
1.12. Team Policies with Outstanding Requirements List View........................................................14
1.13. UW Requirements List View on Policy....................................................................................15
1.14. Policy Detail Report................................................................................................................. 16
1.15. Disposition Summary & Detail Report.....................................................................................18
2. Frequency/Scheduling............................................................................................................. 19
3. Output Generation Trigger.......................................................................................................19
4. Security/Access....................................................................................................................... 19
5. Data Glossary.......................................................................................................................... 19
6. Appendices............................................................................................................................. 24
Appendix A: Policy Phase/Agent Action/CRM Policy Status Mapping.....................................24
____________________________________________________________________________________________________
www.VUEsoftware.com 3 of 26
Overview
The current case reporting does not provide clarity to the key points in the lifecycle or where agent
action is required. The data is made available as a whole, but further refinement is required to drive
agents to the tasks which need to be worked.
Status mapping is changing which will allow for a greater granularity of tracking where agent action
is required.
____________________________________________________________________________________________________
www.VUEsoftware.com 4 of 26
1. Dashboard/Views/Reports
1.1. Policy Dashboard
Traceability 3.1.1 60
Requirement Create a dashboard to provide an overview of policies by phase and policy
status reason for a given agent/hierarchy. The summary page should be an
on screen display and will not require printing. It should be located in CRM
under Workplace (on the left navigator) and positioned below Agent Desktop.
The agents should be able to drill down into a particular phase and view a list
of policies currently in that phase. If possible, the agents should also be able
to drill down into a particular policy status reason and view a list of the
policies with that status reason as well.
Summarized view of policy data containing counts broken out by Policy Phases
and Policy Status Reasons.
Page should contain drop down select boxes for filter criteria.
Once filters are selected by the user, the page should automatically refresh.
Page should contain Agent Action icons for each Policy Status Reason. (See
Appendix A)
The Policy Phases and Policy Status Reasons should be a link to the applicable
list view, including selected filter criteria.
Page should contain legend for Agent Action icon.
____________________________________________________________________________________________________
www.VUEsoftware.com 5 of 26
Location Link located below "Agent Desktop" under Workplace in CRM
Title Policy Dashboard
Fields/Column Carrier
Headers
Policy Phase
Policy Status Reason
Totals
Filters Dropdown selection list:
Secondary Dropdown - Carrier [Use a Carrier List to select specific
carrier]
My Policies
Team Policies
Selection Criteria Should contain counts of policies by Phase and Policy Status Reason based on
____________________________________________________________________________________________________
www.VUEsoftware.com 6 of 26
filter criteria entered by the user.
Sort Carrier
Policy Phase in the following order:
Application Submitted
Application Received
In Underwriting
UW Decision Complete
Policy Activation
Active
Terminated
Within each phase, sort by Policy Status Reason.
Grouping / Sub- Group By:
Totals
Carrier
Policy Phase
Policy Status Reason
Totals:
Policy Phase
Sub-Totals:
Policy Status Reason
Assumptions Standard CRM Audits
We are assuming that there will be dropdown for the carrier and the above
screenshot will show the data for that carrier from where the user can drill down,
if you want to change the carrier, the carrier will be changed from the dropdown
and the screen will refresh to display the data of the selected carrier.
Security Roles
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 7 of 26
Policy Number
Policy Status
Policy Status Reason
Issue Date
Effective Date
Filters None
Selection Criteria Should contain list of policies based on:
Phase selected on Policy Dashboard AND
Filter criteria entered by the user on Policy Dashboard
Sort Agent Name
Policy Phase
Policy Status Reason
Assumptions Use standard CRM grid/list view.
Standard CRM Audits ( why is this assumption here?)
Clicking on the Phase name in the dashboard will let the user to see this View
Security Roles
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 8 of 26
Filters None
Selection Criteria Should contain list of policies based on:
Status Reason selected on Policy Dashboard AND
Filter criteria entered by the user on Policy Dashboard
Sort Agent Name
Policy Phase
Policy Status Reason
Assumptions Use standard CRM grid/list view.
Standard CRM Audits ( why is this assumption here?)
Security Roles
Questions Why do we need this sorting critiera itself when it will is already filtered when the
user is in this VIEW
____________________________________________________________________________________________________
www.VUEsoftware.com 9 of 26
Location On "Agent Desktop" page in CRM (exists today)
Title
Fields/Column
Headers
Filters
Selection Criteria
Sort
Assumptions
Security Roles
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 10 of 26
Location Via My Policy Summary in CRM
Title My Policies - Pending
Fields/Column App Date
Headers
Action Required
Carrier
Client Name
Policy Number
Policy Status
Policy Status Reason
Issue Date
Effective Date
Filters None
Selection Criteria Should contain a list of policies where:
Policy Status = Pending AND
User is the owner of the policy
Sort Agent Name
Policy Phase
Policy Status Reason
Assumptions Use standard CRM grid/list view.
Standard CRM Audits
Security Roles
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 11 of 26
Policy Status
Policy Status Reason
Issue Date
Effective Date
Filters None
Selection Criteria Should contain a list of policies where:
Policy Status = Active AND
User is the owner of the policy
Sort Agent Name
Policy Phase
Policy Status Reason
Assumptions Use standard CRM grid/list view.
Standard CRM Audits
Security Roles
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 12 of 26
Policy Status
Policy Status Reason
Filters None
Selection Criteria Should contain a list of outstanding requirements for policies where:
Policy Status = Pending AND
UW Requirements Activity Status Category = Outstanding AND
User is the owner of the policy
Sort Policy Status Date in ascending order.
Policy number
Assumptions Use standard CRM grid/list view.
Standard CRM Audits
Assuming that all other fields that are mentioned above is part of the Policy entity
and will be pushed from VUE to CRM
Security Roles
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 13 of 26
Policy Status = Pending AND
Policy owner is in user's hierarchy
Sort Agent Name
Policy Phase
Policy Status Reason
Assumptions Use standard CRM grid/list view.
Standard CRM Audits
Security Roles The user's security in CRM should determine whether the user is eligible to see
other agents' policies or only their own.
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 14 of 26
Assumptions Use standard CRM grid/list view.
Standard CRM Audits
Assuming that all other fields that are mentioned above is part of the Policy entity
and will be pushed from VUE to CRM
Security Roles The user's security in CRM should determine whether the user is eligible to see
other agents' policies or only their own.
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 15 of 26
Policy number
Assumptions Use standard CRM grid/list view.
Standard CRM Audits
Security Roles The data visible to the user should mimic the existing user's security in CRM.
Questions
____________________________________________________________________________________________________
www.VUEsoftware.com 16 of 26
4.1.3 should already be in model
Security Roles
Questions
Printable report containing aggregate view of all policy activity that currently
exists on the Policy entity in CRM, including UW requirements and UW Notes.
____________________________________________________________________________________________________
www.VUEsoftware.com 17 of 26
Location Via any policy list view in CRM
Title
Fields/Column
Headers
Filters Dropdown selection list:
Carrier [Use a Carrier List to select specific carrier]
Selection Criteria Should contain all policies where:
Policy Status = Pending AND
Filter criteria entered by the user
Sort
Assumptions The report will be pulled from VUE Directly and shown in CRM as per the above
requirement ( there is a possibility that if at an stage where the policy in VVUE is
not in synch with CRM) then the data that is available in VUE will be displayed in
the report.
Security Roles
____________________________________________________________________________________________________
www.VUEsoftware.com 18 of 26
What do we need to show under the Underwriting Message section?
Fields/Column
Headers
Filters Dropdown selection list:
Secondary Dropdown - Carrier [Use a Carrier List to select specific
carrier]
My Policies
Team Policies
Policy Status
Date Range
Selection Criteria Should contain policies where:
Policy Status Date is within date range selected by the user
Sort
Assumptions
Security Roles
Questions
2. Frequency/Scheduling
The output will be generated upon arrival to the appropriate screen in CRM. No scheduling will be
required. The data will be populated based on the existing VUE IP to CRM daily load schedule.
4. Security/Access
____________________________________________________________________________________________________
www.VUEsoftware.com 19 of 26
The following users should have access to the dashboards/views/reports/, based on existing
CRM/Resource Center security:
Note: "Wrote" (as being used below) refers to the agent tied to the policy in VUE and the Owner of
the policy in CRM.
# User CRM User Role Access
1. Agent Insphere Agent Ability to see policies he/she wrote (set
as default)
2. Sales Assistant Insphere Ability to see policies he/she wrote (set
Administrative as default)
Assistant Ability to see policies written by
Insphere New hierarchy
Business Specialist
3. Sales Leader Insphere Sales Ability to see policies he/she wrote (set
Manager as default)
Ability to see policies written by
hierarchy
4. Agency Manager Insphere Agency Ability to see policies he/she wrote (set
Manager as default)
Ability to see policies written by
hierarchy
5. Zone Manager Insphere Zone Ability to see policies he/she wrote (set
Manager as default)
Ability to see policies written by
hierarchy
Intouch Team Insphere National Ability to see all policies.
Sales Support
Insphere Insphere Corporate Ability to see all policies.
Corporate User User
5. Data Glossary
The following table contains a list of data elements, definitions and business rules required to
populate one or more of the new reports requested in section 3.
Note: Not all of the data elements listed below are available. The requirement for 3.2.1 Policy
Detail Report is to include the data that is currently available for a policy.
____________________________________________________________________________________________________
www.VUEsoftware.com 20 of 26
Data Term Definition Field Name Field Name Rules
in VUE in CRM
for a policy in an effort to Available options are:
assist the agent with Definite Action Required
managing his business. Possible Action Required
____________________________________________________________________________________________________
www.VUEsoftware.com 21 of 26
Data Term Definition Field Name Field Name Rules
in VUE in CRM
Issue Date Issued Date Issued Date
Line of Category of products LOB Line of
Business (LOB) based on market segment. Business
____________________________________________________________________________________________________
www.VUEsoftware.com 22 of 26
Data Term Definition Field Name Field Name Rules
in VUE in CRM
Quoted
Product The type of Insurance Product Code Product
Coverage. Products roll
up into specific Lines of
Business.
Product Name Product Product
Name Name
Requested By "Necessary
& Necessary Before" is
Before (MN Life being added
only) under INS-
2121 & INS-
2165. CR's
are not
assigned to a
release.
"Requested
By" is not
currently
available in
CRM.
Requested Requested Requested
Date Date Date
Requirement Currently, the following Activity Status Activity *See UW Requirements Activity
Status statuses may be provided Status Status Category
from the various carriers:
Approved
Cancelled
Closed
Declined
Received
Waived
Active
Null
Outstanding
Pending
Sent to Client
Submitted
Split Agent Agent
Code
Split Split Split %
Percentage Percentage
Status Detail This field should be hidden and
all associated workflows
removed.
Submitted Date Submitted Submitted
Date Date
Target Amount Target
Amount
UW Req Details Concatenated The following columns should be
Requirement columns: concatenated in VUE and CRM
Description Activity as one is applicable for UW
Description Requirements and the other for
____________________________________________________________________________________________________
www.VUEsoftware.com 23 of 26
Data Term Definition Field Name Field Name Rules
in VUE in CRM
and UW Notes, but both provide the
Comments same information:
Activity Description
Comments
UW Req Code Activity
Requirement Code?
Name
UW Does not Does not Derived field in VUE based on
Requirements exist exist UW Requirements Activity
Activity Status Status, which is then passed to
Category CRM. The statuses are grouped
into the following 3 categories:
ALL - Contains all UW
Requirements, regardless
of status.
Closed - Contains UW
Requirements in the
following statuses:
o Approved
o Cancelled
o Closed
o Declined
o Received
o Waived
Outstanding - Contains
UW Requirements in the
following statuses:
o Active
o Null
o Outstanding
o Pending
o Sent to Client
o Submitted
*Note: The business includes
ALL UW Notes in the
"Outstanding" bucket as they do
not have a status.
____________________________________________________________________________________________________
www.VUEsoftware.com 24 of 26
6. Appendices
Appendix A: Policy Phase/Agent Action/CRM Policy Status Mapping
Policy Status Policy Status Reason Policy Phase Agent Action Identifier CRM Policy Statuses
ACTIVE Re-instated Active Monitor Cases
ACTIVE Replacement Conversion Active Monitor Cases
ACTIVE Suspended Active Monitor Cases
ACTIVE InForce Active Monitor Cases
ACTIVE Issued, Not InForce Policy Activation Possible Action Required
PENDING App Received By Carrier Application Received Possible Action Required
PENDING Issued, Not InForce Policy Activation Possible Action Required
PENDING Underwriting Decision Complete UW Decision Complete Monitor Cases
PENDING Approved, Issue/Activation Pending UW Decision Complete Possible Action Required
PENDING In Underwriting In Underwriting Possible Action Required
PENDING Teleapp In Process Application Submitted Possible Action Required
PENDING Not an App or App Started Application Received Monitor Cases
PENDING Teleapp Interview Complete Application Received Monitor Cases
PENDING Incomplete App Application Submitted Definite Action Required
PENDING Submitted to Carrier Application Submitted Monitor Cases
PENDING Delivery Receipt Outstanding In Underwriting Definite Action Required
PENDING App Received Application Received Possible Action Required
TERMINATE
D Withdrawn Terminated No Action Required
TERMINATE
D Term After Issue Terminated No Action Required
TERMINATE
D Deceased Terminated No Action Required
TERMINATE
D Cancelled by Customer Terminated No Action Required
TERMINATE
D Decline Terminated No Action Required
TERMINATE
D Closed (Incomplete) Terminated No Action Required
TERMINATE
D Expired Terminated No Action Required
TERMINATE Replaced Terminated No Action Required
______________________________________________________________________________________________________
4800 Lyons Technology Parkway, Suite 4 Coconut Creek, Fl 33073 | 877.4.VUESOFT | www.VUEsoftware.com
D
TERMINATE
D Duplicate App Need to exclude policies in this status. N/A
_____________________________________________________________________________________________________
www.VUEsoftware.com 26 of 26