Universal Holders Question

Started by brinkerdana, October 02, 2011, 07:47:11 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

brinkerdana

Is there a report that I can run that tells me which universal holders are actually in use?  Is it possible to search certificates?

Dana Brinkerhoff
Retired

Lance Bateman

Have never figured that out - usually ended up running a list, passing to department managers to review and mark those they know are needed.  Then review for dups.  End up trying to clean up, delete those no one wants.

Long process, not clean.  Ended up taking away rights to add them, staff had to ask for new one to be added or address on one to be changed.

Sherry Burrell

Dana,

In Tam, I ran a SEARCH - Forms - Cert (Simp) and limited my Issue Date to the last couple of years span.  Then on fields for the report, I chose Account #, Certholder Code, name and address and the issue date.

You could compare it to those in the system (and all of the duplicates!) to delete the one not used recently.
Sherry Burrell
Oakbridge Insurance Agency-Duluth GA
Epic Online w/CSR24, +500 users

Lance Bateman

Sherry, thanks for that idea.  I'll try it here also.

Matthew Udovich

Quote from: Sherry Burrell on October 03, 2011, 01:58:25 PM
In Tam, I ran a SEARCH - Forms - Cert (Simp)...

Just to clarify, since I'm a bit thick headed, you run a search of the certs (SIMP) with an issue date of around 2 yrs, then you run a report of the entire Universal Cert list and delete the ones from the Universal list that are not present on the search? Do you do the deleting from the Universal Cert Holder list in TAM or from the Universal Holder Delete Utility in the utility manger?

I just did the compare and came up with 8643 that did not show up on search going back to 1-1-2009 to present YIKES! That's a big list.

Thanks for the clarification :-)

Lance Bateman

I'd do the delete from the list, not via the utility.  They may have been used outside of your report dates, but within your retention parameters (such as 7 years).

Yup, huge list - that's why I limited almost everyone from adding to the list after it was cleaned up, they had to request it.

brinkerdana

Quote from: Sherry Burrell on October 03, 2011, 01:58:25 PM
Dana,

In Tam, I ran a SEARCH - Forms - Cert (Simp) and limited my Issue Date to the last couple of years span.  Then on fields for the report, I chose Account #, Certholder Code, name and address and the issue date.

You could compare it to those in the system (and all of the duplicates!) to delete the one not used recently.

Thanks, Sherry!  I have a 214 page list of holders and I'd guess 200 pages of coding changes.  This report will enable me to delete the old ones no longer in use and simplify cleanup. 

Dana Brinkerhoff
Retired

Jim Jensen

Wow, would it be more efficient to blow away the whole list, then enter those that ARE needed?
Jim Jensen
CIC, CEO, CIO, COO, CFO, Producer, CSR, Claims Handler, janitor....whatever else.
Jensen Ford Insurance
Indianapolis

brinkerdana

Quote from: Jim Jensen on October 04, 2011, 08:16:36 AM
Wow, would it be more efficient to blow away the whole list, then enter those that ARE needed?

Yes, but they didn't want to go in that direction.
Dana Brinkerhoff
Retired

Jim Jensen

Quote from: brinkerdana on October 04, 2011, 08:23:19 AM
Quote from: Jim Jensen on October 04, 2011, 08:16:36 AM
Wow, would it be more efficient to blow away the whole list, then enter those that ARE needed?

Yes, but they didn't want to go in that direction.

Ok, their money for your time...
Jim Jensen
CIC, CEO, CIO, COO, CFO, Producer, CSR, Claims Handler, janitor....whatever else.
Jensen Ford Insurance
Indianapolis