Forum

Please or Register to create posts and topics.

Sentences for Fact Types & Roles #factypes #sharedevents #roles

This query gives some useful results for reviewing default sentences in your database. It was prompted by this post in the RootsMagic Community:

List of RootsMagic-created fact types and their default sentences

SELECT Name
,Sentence
FROM (
SELECT Name
,Abbrev
,GedcomTag
,Sentence
,FactTypeID
FROM FactTypeTable

UNION ALL

SELECT Name || '-' || RoleName
,'' AS Abbrev
,'' AS GedcomTag
,R.Sentence
,EventType
FROM RoleTable R
JOIN FactTypeTable ON EventType = FactTypeID
)
ORDER BY Name;

Here's the result from a new, empty, unmodified RM8 database:

Name Sentence
Adoption [person] was adopted< [Date]>< [PlaceDetails]>< [Place]>.
Adoption-Witness [ThisPerson] witnessed the adoption of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Alternate name [person] was also known as [Desc]< [Date]>.
Ancestral File Number [person] has Ancestral File Number [Desc].
Annulment [couple] had their marriage annulled< [Date]>< [PlaceDetails]>< [Place]>.
Annulment-Witness [ThisPerson] witnessed the annulment of the marriage of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Baptism [person] was baptized< [Date]>< [PlaceDetails]>< [Place]>.
Baptism-Witness [ThisPerson] witnessed the baptism of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Bar Mitzvah [person] celebrated his bar mitzvah< [Date]>< [PlaceDetails]>< [Place]>.
Bar Mitzvah-Witness [ThisPerson] witnessed the bar mitzvah of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Bas Mitzvah [person] celebrated her bas mitzvah< [Date]>< [PlaceDetails]>< [Place]>.
Bas Mitzvah-Witness [ThisPerson] witnessed the bas mitzvah of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Birth [person] was born< [Date]>< [PlaceDetails]>< [Place]>.
Birth-Doctor [ThisPerson] delivered [person]< [Date]>< [PlaceDetails]>< [Place]>.
Birth-Witness [ThisPerson] witnessed the birth of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Blessing [person] was blessed< [Date]>< [PlaceDetails]>< [Place]>.
Blessing-Witness [ThisPerson] witnessed the blessing of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Burial [person] was buried< [Date]>< [PlaceDetails]>< [Place]>.
Burial-Witness [ThisPerson] witnessed the burial of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Caste [person] was associated with [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Caste-Witness [ThisPerson] witnessed the associated with [Desc] of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Census [person] appeared in the census< [Date]>< [PlaceDetails]>< [Place]>.
Census (family) [couple] appeared in the census< [Date]>< [PlaceDetails]>< [Place]>.
Census (family)-Witness [ThisPerson] appeared in the census in the household of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Census-Witness [ThisPerson] appeared in the household of [person] in the census< [Date]>< [PlaceDetails]>< [Place]>.
Christen [person] was christened< [Date]>< [PlaceDetails]>< [Place]>.
Christen (adult) [person] was christened< [Date]>< [PlaceDetails]>< [Place]>.
Christen (adult)-Witness [ThisPerson] witnessed the christening of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Christen-Witness [ThisPerson] witnessed the christening of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Confirmation [person] was confirmed< [Date]>< [PlaceDetails]>< [Place]>.
Confirmation-Witness [ThisPerson] witnessed the confirmation of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Cremation [person] was cremated< [Date]>< [PlaceDetails]>< [Place]>.
Cremation-Witness [ThisPerson] witnessed the cremation of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Death [person] died< [Desc]>< [Date]>< [person:Age]>< [PlaceDetails]>< [Place]>.
Death-Witness [ThisPerson] witnessed the death of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Degree [person] received a< [desc]> degree< [Date]>< [PlaceDetails]>< [Place]>.
Degree-Witness [ThisPerson] witnessed the degree of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Description [person] was described as [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Description-Witness [ThisPerson] witnessed the appearance of [person] as [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Divorce [couple] <#Couple#was|were> divorced< [Date]>< [PlaceDetails]>< [Place]>.
Divorce filed [couple] filed for divorce< [Date]>< [PlaceDetails]>< [Place]>.
Divorce filed-Witness [ThisPerson] witnessed the divorce filing of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Divorce-Witness [ThisPerson] witnessed the divorce of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
DNA test [person] had a DNA test performed< [Date]>.
Education [person] was educated < [Desc]>< [Date]>< [PlaceDetails]>< [Place]>.
Education-Witness [ThisPerson] witnessed the education of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Election [person] was elected< as [Desc]>< [Date]>< [PlaceDetails]>< [Place]>.
Election-Witness [ThisPerson] witnessed the election of [person] as [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Emigration [person] emigrated< [Date]>< from [Place:plain]>< [PlaceDetails]>.
Emigration-Witness [ThisPerson] witnessed the emigration of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Engagement [couple] <#Couple#was|were> engaged< [Date]>< [PlaceDetails]>< [Place]>.
Engagement-Witness [ThisPerson] witnessed the engagement of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Excommunication [person] was excommunicated< [Date]>< [PlaceDetails]>< [Place]>.
Excommunication-Witness [ThisPerson] witnessed the excommunication of [person]< [Date]>< [PlaceDetails]>< [Place]>.
First communion [person] received first communion< [Date]>< [PlaceDetails]>< [Place]>.
First communion-Witness [ThisPerson] witnessed the first communion of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Graduation [person] graduated< [Date]>< [PlaceDetails]>< [Place]>.
Graduation-Witness [ThisPerson] witnessed the graduation of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Illness [person] was ill< with [Desc]>< [Date]>< [PlaceDetails]>< [Place]>.
Illness-Witness [ThisPerson] witnessed the illness of [person] with [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Immigration [person] immigrated< [Date]>< to [Place:plain]>< [PlaceDetails]>.
Immigration-Witness [ThisPerson] witnessed the immigration of [person]< [Date]>< [PlaceDetails]>< [Place]>.
LDS Baptism [person] was baptized into the LDS Church< [Date]>< [PlaceDetails]>< [Place]>.
LDS Baptism-Witness [ThisPerson] witnessed the baptism of [person] into the LDS Church< [Date]>< [PlaceDetails]>< [Place]>.
LDS Confirmation [person] was confirmed a member of the LDS Church< [Date]>< [PlaceDetails]>< [Place]>.
LDS Confirmation-Witness [ThisPerson] witnessed the confirmation of [person] as a member of the LDS Church< [Date]>< [PlaceDetails]>< [Place]>.
LDS Endowment [person] was endowed< [Date]>< [PlaceDetails]>< [Place]>.
LDS Endowment-Witness [ThisPerson] witnessed the endowment of [person]< [Date]>< [PlaceDetails]>< [Place]>.
LDS Initiatory [person] received LDS initiatory< [Date]>< [PlaceDetails]>< [Place]>.
LDS Initiatory-Witness [ThisPerson] witnessed the LDS initiatory of [person]< [Date]>< [PlaceDetails]>< [Place]>.
LDS Seal to parents [person] was sealed to [person:hisher] parents< [Date]>< [PlaceDetails]>< [Place]>.
LDS Seal to parents-Witness [ThisPerson] witnessed the sealed to parents of [person]< [Date]>< [PlaceDetails]>< [Place]>.
LDS Seal to spouse [couple] were sealed together< [Date]>< [PlaceDetails]>< [Place]>.
LDS Seal to spouse-Witness [ThisPerson] witnessed the sealing of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Living [person] was living< [Date]>< [PlaceDetails]>< [Place]>.
Marriage [couple] <#Couple#was|were> married< [Date]>< [PlaceDetails]>< [Place]>.
Marriage Bann [couple] had marriage banns published< [Date]>< [PlaceDetails]>< [Place]>.
Marriage Bann-Witness [ThisPerson] witnessed the publishing of the marriage banns of [couple]<[Date]>< [PlaceDetails]>< [Place]>.
Marriage Contract [couple] signed a marriage contract< [Date]>< [PlaceDetails]>< [Place]>.
Marriage Contract-Witness [ThisPerson] witnessed the marriage contract of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Marriage License [couple] obtained a marriage license< [Date]>< [PlaceDetails]>< [Place]>.
Marriage License-Witness [ThisPerson] witnessed the obtaining of the marriage license by [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Marriage Settlement [couple] obtained a marriage settlement< [Date]>< [PlaceDetails]>< [Place]>.
Marriage Settlement-Witness [ThisPerson] witnessed the marriage settlement of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Marriage-Witness [ThisPerson] witnessed the marriage of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Military [person] served in the military< [Desc]>< [Date]>< [PlaceDetails]>< [Place]>.
Military-Witness [ThisPerson] witnessed the military service of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Miscellaneous [person]< [Desc]>< [Date]>< [PlaceDetails]>< [Place]>.
Miscellaneous-Witness [person]< [Desc]>< [Date]>< [PlaceDetails]>< [Place]>.
Mission [person] served a mission< [Date]>< [PlaceDetails]>< [Place]>.
Mission-Witness [ThisPerson] witnessed the mission of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Namesake [person] was named after [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Nationality [person] was [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Nationality-Witness [ThisPerson] witnessed the nationality of [person] as [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Naturalization [person] was naturalized< [Date]>< [PlaceDetails]>< [Place]>.
Naturalization-Witness [ThisPerson] witnessed the naturalization of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Occupation 2022 [person] was [Desc:A]< [PlaceDetails]>< [Place]>.
Occupation-Witness [ThisPerson] witnessed the occupation of [person]< [Date]> as [Desc:A]< [PlaceDetails]>< [Place]>.
Ordination [person] was ordained< [Date]>< [PlaceDetails]>< [Place]>.
Ordination-Witness [ThisPerson] witnessed the ordination of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Probate [person] had [person:hisher] estate probated< [Date]>< [PlaceDetails]>< [Place]>.
Probate-Witness [ThisPerson] witnessed the probate of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Property [person] owned [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Property-Witness [ThisPerson] witnessed the property of [person] as [Desc:A]< [Date]>< [PlaceDetails]>< [Place]>.
Reference No [person] has reference number [Desc].
Religion [person] was [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Religion-Witness [ThisPerson] witnessed the religion of [person] as [Desc:A]< [Date]>< [PlaceDetails]>< [Place]>.
Residence [person] lived< [Desc]>< [PlaceDetails]>< [Place]>< [Date]>.
Residence (family) [couple] lived < [Desc]>< [PlaceDetails]>< [Place]>< [Date]>.
Residence-Witness [ThisPerson] lived in the residence of [person] < [PlaceDetails]>< [Place]>< [Date]>.
Retirement [person] retired< [Date]>< [PlaceDetails]>< [Place]>.
Retirement-Witness [ThisPerson] witnessed the retirement of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Separation [couple] were separated< [Date]>< [PlaceDetails]>< [Place]>.
Separation-Witness [ThisPerson] witnessed the separation of [couple]< [Date]>< [PlaceDetails]>< [Place]>.
Soc Sec No [person] had Social Security Number [Desc].
Stillborn [person] was stillborn< [Date]>< [PlaceDetails]>< [Place]>.
Stillborn-Witness [ThisPerson] witnessed the stillbirth of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Title (Nobility) [person] held the title of [Desc]< [Date]>< [PlaceDetails]>< [Place]>.
Will [person] signed a will< [Date]>< [PlaceDetails]>< [Place]>.
Will-Executor [ThisPerson] was named an executor for the will of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Will-Heir [ThisPerson] was named an heir in the will of [person]< [Date]>< [PlaceDetails]>< [Place]>.
Will-Witness [ThisPerson] witnessed the will of [person]< [Date]>< [PlaceDetails]>< [Place]>.

Thanks! That is quite useful.  One can easily  see what FactTypes have not yet been setup and also see other ones the may want to imitate.