FAM_MEMBER_Table.htm
Sunday February 25th, 2018 1:38 PM

Updated Fam_Member.dbf Table

Objective:


Note the format and record count of the recently modified Fam_Member.dbf table used in Family Passport application fpp.exe

Conclusion:


The newly formatted Family Member table (Fam_Member.dbf) was migrated to production today.

We have accounted for 800 family members thus far
[Note: There are many other records with missing bits of informtion - eg. Birth Dates, Death Dates, Obituaries and Photos

Revisions to Fam_Member Fam_ID was changed from numeric to character format

FSCODE field added to track FamilySearch website codes; greatly assists in research by tying in with resource maintained by Church of Latter Day Saints.
source

FAM_MEMBER.DBF untitled
Sunday February 25th, 2018

FAM_MEMBER.DBF

Table Last Updated: 02/20/2018 11:12:40

Records: 800

Dependent Files:
C:\JPG\FAM_MEMBER.CDX

Fieldname Type(Size) DescriptionExample
FAM_ID C( 20)
  • Family ID Number
  • used to correlate Family and Family Member Table data
  • ( join Fam_Member.dbf to Family.dbf to support queries of combined information)
2
IND_ID C( 24) Family Member Individual ID Number 2.40
GIVEN C( 52) Family Member's Given Name William F. Gaffey
BORN Date Birth Date 05/31/1931
DIED Date Death Date 05/21/2012
NOTE C(250)
DECEASED Logical True if Dead True
FAMSIDE C( 1)
  • Family Side Code
  • F / M / D
  • F = Father's Side of the Family
  • M = Mother's Side
  • D = Descendants of Mother and Father
F
MALE Logical True if Family Member is Male True
MARRIED C( 52) Married Name

Blank for Male and Unmarried Female Family Members
PHOTO C(100) William_Gaffey_2-40_pp.jpg
OBIT C(100)
  • Obituary Column filename
  • Usually captured as an image file (JPEG format)
  • downloaded from Funeral Home and Newspaper websites
  • but can also be HTM document


William_F_Gaffey_2-40_obit.jpg
RCDSTAT Numeric
  • Record Status
  • Numeric value between 1 and 15
  • Indicates the Completeness Status of the record
  • Scale runs from
  • 1 for Blank Records to
  • 15 for Complete records
  • Not fully implemented
15
FSCODE C( 8)