 |
 |
|
|
This view exposes the rows in the table that represent marriages, joined with basic information about the two parties. Note that marriage encompasses civil partnerships.
The software allows a marriage to be entered without specifying to whom the person is married. It is therefore possible that either of the person's details will be all null.
Also, if marriage dates are not specified on two or more marriages between the same people, then the Practice Suite will only show one of the marriages.
Base view suitable for advanced end users.
InternalId1 |
The internal identifier of the first person |
Name1 |
A single string name for the first person |
Surname1 |
The first person's surname |
MaidenName1 |
The first person's maiden name |
Initials1 |
The first person's initials |
Title1 |
The first person's title |
Forenames1 |
The first person's forenames |
FormalSalutation1 |
Formal salutation for the first person |
InformalSalutation1 |
Informal salutation for the first person |
Sex1 |
'M' = male, 'F' = female (for the first person) |
DateOfBirth1 |
The first person's date of birth |
DateOfDeath1 |
The first person's date of death |
InternalId2 |
The internal identifier of the second person |
Name2 |
A single string name for the second person |
Surname2 |
The second person's surname |
MaidenName2 |
The second person's maiden name |
Initials2 |
The second person's initials |
Title2 |
The second person's title |
Forenames2 |
The second person's forenames |
FormalSalutation2 |
Formal salutation for the second person |
InformalSalutation2 |
Informal salutation for the second person |
Sex2 |
'M' = male, 'F' = female (for the second person) |
DateOfBirth2 |
The second person's date of birth |
DateOfDeath2 |
The second person's date of death |
DateMarried |
Date marriage took place |
DateSeparated |
Date of separation (or null) |
DateDivorced |
Date of divorce (or null) |
DateWidowed |
Date widowed (or null) |