luRelationship lookup table

Description

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.
 

Example

 
 

Fields

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.

Field

Description

Code

Code for the type of relationship.

Description

Description for the type of relationship.

GenerationGap

Difference in generation between the two members in the relationship.

RevRelationshipMale

The code for the other person of the relationship where they are a male.

RevRelationshipFemale

The code for the other person of the relationship where they are a female.

RevRelationshipOtherThe code for the other person of the relationship where they have another gender.

RelationshipSpouse

Code for the spouse of the relation.

SynergyMeaning

SynergyMeaning for the relationship.



 List of SynergyMeanings
SynergyMeaning
ADOPTIVEDAUGHTER
ADOPTIVEFATHER
ADOPTIVEMOTHER
ADOPTIVESON
AGENT
AUNT
BROTHER
DAUGHTER
FATHER
FOSTERFATHER
FOSTERMOTHER
FRIEND
GRANDDAUGHTER
GRANDFATHER
GRANDMOTHER
GRANDSON
HOSTCHILD
HOSTPARENT
MOTHER
NEPHEW
NIECE
RELATIVE
REPORTSTO
SELF
SISTER
SON
SPSDEFACTO
STEPDAUGHTER
STEPFATHER
STEPMOTHER
STEPSON
UNCLE

Note: Certain SynergyMeanings trigger special behaviour in Synergetic, such as listing relations as siblings.

GenerationGapSort

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.

ModifiedDate

Date and time the lookup table entry was last modified.

ModifiedUser

User that last modified the lookup table entry.