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:

NameSentence
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[date] [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.