JOHN_TV-PC # John
C:\APPS\ERGO\FAM_MEMBER.DBF_DD.htm
Thursday August 20th, 2015

Genealogical Accounting Framework (GAF) - Record of Family Member individuals

FAM_MEMBER.DBF

Family Tree Data Base - Production Data as used to populate gystdoit.com/family website - local version
approximates ..\..\gystdoit\jpg\FAMILY_TREE.XML
Table Last Updated: 08/10/2015 18:41:22

Records: 438

Dependent Files:
C:\APPS\ERGO\FAM_MEMBER.CDX
C:\APPS\ERGO\FAM_MEMBER.FPT

Fieldname Type(Size) DescriptionExample
FAM_ID Numeric Family ID follows binary ancestory branches see FamilyTree_Number_Scheme.jpg 2
IND_ID C( 12) Individual ID - Unique Number used to identify each family member

IND_ID Format

Left of decimal seperator Right of decimal
FAM_ID decimal or dash

2.40 = 2-40 		>
Assigned based on birth order
10 first child
20 second child
90 ninth child
Assigned to identify people marrying into the family
01 first spouse
02 second spouse
  • In the example provided, IND_ID value 2.40 is
  • the fourth person born to Family # 2, my father's family
  • which happens to be my father.
2.40
GIVEN C( 52) Given Name FirstName MI LastName William F. Gaffey
BORN Date Date of Birth 05/31/1931
DIED Date
  • Date of Death
  • Use the CDIED field below if recording imprecise RIP dates
05/21/2012
NOTE C(250)
  • A place to record random data associated with this individual.
  • .e.g I gave the eulogy at Dad's funeral.
FILE_ID C( 40)
  • Form a predictable filename root
    • to use for jpg files associated with this family member.
    • Based on
      • Given Name
      • IND_ID
    • Serves as predictable filename prefix to suport links to pictures, obituaries,.. related to the family member.
William_P_Gaffey_1-10
FILE_ID2 C( 40) Abbreviated form of FILE_ID _1-10
DECEASED Logical
  • False for living family members
  • Useful for stratifying Birthday calendars, address books where dead family members would not be listed.
False
FAMSIDE C( 1)
  • Filter and sort family members for different audiences
    • Dad's Side =
      • Family IDs (2,4,5,8,9,10,11)
      • and their decendent families (e.g. 201,2011,...)
      • distinguish with red text
    • Mom's Side =
      • Family IDs (3,6,7,12,13,14,15)
      • and their decendent families (e.g. 304,3091,...)
      • distinguish with red text
      Decendents of Mom and Dad
      • Family IDs = 1
      • and their decendent families (e.g. 101,1021,...)
      • distinguish with purple text
  • Useful when producing calendars and stratifying web pages to direct navigation
    		• F/M/D
    MALE Logical True for boys False for girls True
    MSTATUS C( 1)
    • Marital Status
    • Single/Married/Divorced/Widowed
    		S/M/D/W
    MARRIED C( 52) Married Name
    Leave Blank for men and unmarried women
    CBORN C(200)
    • Birthdate expressed as text;
    • useful for imprecise dates;
    • .i.e we know the year but not the date
    • Leave blank if we have precise Birthdate recorded in BORN column.
    CDIED C(200)
    • RIP date expressed as text
    • Leave blank if we have precise death date recorded in DIED column.
    AGE Numeric
    • Age of family member
      • as of RIP date for deceased
      • current Age of living
      • must be regularly updated to keep website current.
      • Function Age2.prg - AGE2( BORN,DIED ) is used to populate/refresh this field.
    		80
    OBIT C(100) URL / pathfile of obituary.jpg file for this family member. William_F_Gaffey_2-40_obit.jpg

    Note: Variations on suffix are acceptable , eg - William_F_Gaffey_2-40_eulogy.htm
    PHOTO C(100) URL / pathfile of primary head shot jpg file for this family member. William_F_Gaffey_2-40.jpg