Generate Missing Relationships

Overview

Each night a process runs that creates "missing" relationships between people based on preexisting relationships.  Typically only immediate-family relationships and sometimes grandparent relationships are entered by users of Veracross.  Based on these relationships, Veracross can create additional relationships to create extended family-trees.  This results in more accurate profiles for Students, Parents, Donors, etc.  It also has particular benefit to Admissions departments who depend on such relationships to determine the Legacy status of a Prospect or Applicant.

While this feature creates tremendous benefit in the form of additional relationship data and reduced data-entry, it can magnify data-integrity problems if the preexisting relationships are not accurate.  Inaccurate relationships typically comprise less than 1-2% of all relationships, so while there exists the possibility of producing additional inaccurate relationships, such problems pale in comparison to the benefit of the vast number of new, accurate relationships.

Below is a table of the rules that are used to create additional relationships.

If I Am (m/f)My
Is MyRequire Same Last Name Require Same Household

Husband'sFatherFather-In-Law


Husband'sMotherMother-In-Law


Husband'sSonSon(Son and I)

Husband'sDaughterDaughter(Daughter and I)

Husband'sBrotherBrother-In-Law


Husband'sSisterSister-In-Law


Husband'sNephewNephew


Husband'sNieceNiece


Husband'sSon-In-LawSon-In-Law


Husband'sDaughter-In-LawDaughter-In-Law


Husband'sStep-FatherFather-In-Law


Husband'sStep-MotherMother-In-Law


Husband'sStep-BrotherBrother-In-Law


Husband'sStep-SisterSister-In-Law


Husband'sNeighborNeighbor
(Husband and I)

Wife'sFatherFather-In-Law


Wife'sMotherMother-In-Law


Wife'sSonSon(Wife and Son)

Wife'sDaughterDaughter(Wife and Daughter)

Wife'sBrotherBrother-In-Law


Wife'sSisterSister-In-Law


Wife'sNephewNephew


Wife'sNieceNiece


Wife'sSon-In-LawSon-In-Law


Wife'sDaughter-In-LawDaughter-In-Law


Wife'sStep-FatherFather-In-Law


Wife'sStep-MotherMother-In-Law


Wife'sStep-BrotherBrother-In-Law


Wife'sStep-SisterSister-In-Law


Wife'sNeighborNeighbor
(Wife and I)

Father'sWifeMother(Mother and I)(Mother and I)

Father'sFatherGrandfather


Father'sMotherGrandmother


Father'sSonBrother(Brother and I)

Father'sDaughterSister(Sister and I)

Father'sBrotherUncle


Father'sSisterAunt


Father'sNephewCousin


Father'sNieceCousin


Father'sFather-In-LawGrandfather


Father'sMother-In-LawGrandmother


Father'sSon-In-LawBrother-In-Law
(Father and I)

Father'sDaughter-In-LawSister-In-Law
(Father and I)

Father'sBrother-In-LawUncle


Father'sSister-In-LawAunt


Father'sStep-FatherGrandfather


Father'sStep-MotherGrandmother


Father'sStep-SonStep-Brother
(Step-Brother and I)

Father'sStep-DaughterStep-Sister
(Step-Sister and I)

Father'sStep-BrotherUncle


Father'sStep-SisterAunt


Mother'sHusbandFather(Father and I)(Father and I)

Mother'sFatherGrandfather


Mother'sMotherGrandmother


Mother'sSonBrother(Mother and Brother)

Mother'sDaughterSister(Mother and Sister)

Mother'sBrotherUncle


Mother'sSisterAunt


Mother'sNephewCousin


Mother'sNieceCousin


Mother'sFather-In-LawGrandfather


Mother'sMother-In-LawGrandmother


Mother'sSon-In-LawBrother-In-Law
(Mother and I)

Mother'sDaughter-In-LawSister-In-Law
(Mother and I)

Mother'sBrother-In-LawUncle


Mother'sSister-In-LawAunt


Mother'sStep-FatherGrandfather


Mother'sStep-MotherGrandmother


Mother'sStep-SonStep-Brother
(Step-Brother and I)

Mother'sStep-DaughterStep-Sister
(Step-Sister and I)

Mother'sStep-BrotherUncle


Mother'sStep-SisterAunt


Son'sWifeDaughter-In-Law

femaleSon'sFatherHusband(Husband and I)(Husband and I)
maleSon'sMotherWife(Wife and I)(Wife and I)

Son'sSonGrandson


Son'sDaughterGranddaughter


Son'sBrotherSon(Son and I)(Son and I)

Son'sSisterDaughter(Daughter and I)(Daughter and I)
maleSon'sGrandfatherFather(Father and I)
maleSon'sGrandmotherMother(Mother and I)
maleSon'sUncleBrother(Brother and I)
maleSon'sAuntSister(Sister and I)

Son'sStep-SonGrandson


Son'sStep-DaughterGranddaughter


Son'sStep-BrotherStep-Son
(Step-Son and I)

Son'sStep-SisterStep-Daughter
(Step-Daughter and I)

Daughter'sHusbandSon-In-Law

femaleDaughter'sFatherHusband(Husband and I)(Husband and I)
maleDaughter'sMotherWife(Wife and I)(Wife and I)

Daughter'sSonGrandson


Daughter'sDaughterGranddaughter


Daughter'sBrotherSon(Son and I)(Son and I)

Daughter'sSisterDaughter(Daughter and I)(Daughter and I)
maleDaughter'sGrandfatherFather(Father and I)
maleDaughter'sGrandmotherMother(Mother and I)
maleDaughter'sUncleBrother(Brother and I)
maleDaughter'sAuntSister(Sister and I)

Daughter'sStep-SonGrandson


Daughter'sStep-DaughterGranddaughter


Daughter'sStep-BrotherStep-Son
(Step-Son and I)

Daughter'sStep-SisterStep-Daughter
(Step-Daughter and I)

Brother'sWifeSister-In-Law


Brother'sFatherFather


Brother'sMotherMother


Brother'sSonNephew


Brother'sDaughterNiece


Brother'sBrotherBrother
(Brother and I)

Brother'sSisterSister
(Sister and I)

Brother'sGrandfatherGrandfather(Brother and I)

Brother'sGrandmotherGrandmother(Brother and I)

Brother'sUncleUncle(Brother and I)

Brother'sAuntAunt(Brother and I)

Brother'sCousinCousin(Brother and I)

Brother'sStep-FatherStep-Father
(Step-Father and I)

Brother'sStep-MotherStep-Mother
(Step-Mother and I)

Brother'sStep-BrotherStep-Brother
(Step-Brother and I)

Brother'sStep-SisterStep-Sister
(Step-Sister and I)

Sister'sHusbandBrother-In-Law


Sister'sFatherFather


Sister'sMotherMother


Sister'sSonNephew


Sister'sDaughterNiece


Sister'sBrotherBrother
(Brother and I)

Sister'sSisterSister
(Sister and I)

Sister'sGrandfatherGrandfather(Sister and I)

Sister'sGrandmotherGrandmother(Sister and I)

Sister'sUncleUncle(Sister and I)

Sister'sAuntAunt(Sister and I)

Sister'sCousinCousin(Sister and I)

Sister'sStep-FatherStep-Father
(Step-Father and I)

Sister'sStep-MotherStep-Mother
(Step-Mother and I)

Sister'sStep-BrotherStep-Brother
(Step-Brother and I)

Sister'sStep-SisterStep-Sister
(Step-Sister and I)

Grandfather'sWifeGrandmother


Grandmother'sHusbandGrandfather


Grandson'sBrotherGrandson
(Grandson and Grandson)

Grandson'sSisterGranddaughter
(Grandson and Granddaughter)

Granddaughter'sBrotherGrandson
(Granddaughter and Grandson)

Granddaughter'sSisterGranddaughter
(Granddaughter and Granddaughter)

Uncle'sWifeAunt


Uncle'sSonCousin


Uncle'sDaughterCousin


Aunt'sHusbandUncle


Aunt'sSonCousin


Aunt'sDaughterCousin


Nephew'sWifeNiece


Niece'sHusbandNephew


Cousin'sHusbandCousin


Cousin'sWifeCousin


Father-In-Law'sWifeMother-In-Law


Father-In-Law'sSonBrother-In-Law


Father-In-Law'sDaughterSister-In-Law


Mother-In-Law'sHusbandFather-In-Law


Mother-In-Law'sSonBrother-In-Law


Mother-In-Law'sDaughterSister-In-Law


Son-In-Law'sWifeDaughter


Son-In-Law'sSonGrandson


Son-In-Law'sDaughterGranddaughter


Daughter-In-Law'sHusbandSon


Daughter-In-Law'sSonGrandson


Daughter-In-Law'sDaughterGranddaughter


Brother-In-Law'sSonNephew


Brother-In-Law'sDaughterNiece


Sister-In-Law'sSonNephew


Sister-In-Law'sDaughterNiece


Step-Father'sWifeMother


Step-Father'sSonStep-Brother


Step-Father'sDaughterStep-Sister


Step-Mother'sHusbandFather


Step-Mother'sSonStep-Brother


Step-Mother'sDaughterStep-Sister