I would agree with both Larry and John that the maintenance of employment, organizations, parents, and subsidiaries is really a nightmare!!!
CRM does require a relationship with an organization to add employment, making a better case only to add those relationships that are worth tracking. Generally, large organizations that are important for your community include large employers, matching gift companies, and those who donate or sponsor. Keeping these is beneficial for your organization. Typically employment append companies will give you the size and revenue of the company and how many alumni work there. This could help you determine if a company is worth tracking in your database.
There are two poor workarounds in CRM, and I do not advocate for them,
- Keep track of the employment information within the business address and have the employer name by line 2; the address validation works for this solution.
- The second workaround is to create a dummy-employer record and link these more minor relationships. The downside is that if there is no data entry consistency, you will end with a record with a gazillion relationships, and cleanup and maintenance will be very hard.
Again both workarounds are not optimal but helpful if you need to track all the employment information.
I hope this helps
 | Adriana Bitoun Director of Strategic Advancement Resources (ST.A.R) U.S. NAVAL ACADEMY ALUMNI ASSOCIATION & FOUNDATION 247 King George Street Annapolis, MD 21402 p. 410-295-4150 m. 562-805-8815 |