The luRelationship lookup table defines relationships that can exist between community members and how these are handled in Synergetic.
Relationships are shown on the Relations tab of Community Maintenance. See Community Maintenance - Relations tab.
Note: You can define the order of the luRelationship lookup table fields in drop-down lists using the FieldOrderCSV configuration setting. Organisations upgrading to Version 70 from an earlier version of Synergetic will automatically have the FieldOrderCSV configuration setting pre-configured for the luRelationship lookup table. See FieldOrderCSV configuration setting.
Code for the type of relationship.
Description for the type of relationship.
Difference in generation between the two members in the relationship.
The code for the other person of the relationship where they are a male.
The code for the other person of the relationship where they are a female.
|RevRelationshipOther||The code for the other person of the relationship where they have another gender.|
Code for the spouse of the relation.
SynergyMeaning for the relationship.
List of SynergyMeanings
Note: Certain SynergyMeanings trigger special behaviour in Synergetic, such as listing relations as siblings.
Use this field to prioritise relations in the same generation.
For example, a mother and an aunt are in the same generation. To ensure a mother is listed before an aunt, give the mother relation a GenerationGapSort of 1, and the aunt a higher number.
SetDefaultEmail / SetDefaultSMS
Select if the Use Email or Use SMS flag should be selected on the Relations tab of Community Maintenance by default for the relation. See Community Maintenance - Relations tab in the Community manual.
Date and time the lookup table entry was last modified.
User that last modified the lookup table entry.