Missing Role in the alerts for invalid Members

[apmuthu]

Kept getting Missing Role in the alerts.
Can suppress it for those not assigned to families and for Admin.

The relationship field (family role) is stored in the person_per table in the per_fmr_ID field (person's family role ID) taken from:

SELECT lst_OptionID, lst_OptionName FROM list_lst WHERE lst_ID=2;

lst_OptionID	lst_OptionName
1	Head of Household
2	Spouse
3	Child
4	Other Relative
5	Non Relative
6	Parents