Personal Financial Review

This ERD (see the following figure) illustrates the information captured during the process of reviewing the financial status of an individual customer. The financial review process itself is tracked as an activity and becomes the source of the rest of the personal financial information of the contact, including assets, liabilities, income, expenses, and financial needs (such as retirement savings). When the financial needs of the contact are not fully addressed by his or her current financial product holdings, assets, or liabilities, the salesperson makes one or more financial recommendations. When a financial recommendation leads to a purchased product, such as a savings account or mortgage, the product instance can be associated with the recommendation that led to it. Assets can be located at a personal address and can be a source of income. Similarly, a liability, such as a mortgage, can be secured by an associated asset and can have periodic expenses associated with the liability.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Activity	S_EVT_ACT
Activity Product Instance	S_ACT_ASSET
Asset (Liability)	S_FN_ASSET_LIAB
Asset (Liability) Contact	S_FN_ASSET_LIAB_CON
Contact	S_CONTACT, S_PARTY
Contact Relationship	S_CONTACT_REL
Financial Need	S_FN_NEED
Financial Recommendation	S_FN_RCMD
Household/Account	S_ORG_GROUP, S_PARTY
Income (Expense)	S_FN_INCM_EXP
Income (Expense) Contact	S_FN_INCM_EXP_CON
Need Contact	S_FN_NEED_CON
Opportunity	S_OPTY
Organization Unit	S_ORG_EXT, S_PARTY
Product	S_PROD_INT
Product Instance	S_ASSET
Product Instance Contact	S_ASSET_CON
Received Product Instance	S_FN_RCMD_ASSET
Recommendation Contact	S_FN_RCMD_CON