Family Members Dataset

This view compiles information about the family memberships of clients in HIFIS. Each record represents a client's family membership, with applicable date ranges, along with their family role. It also pulls basic information about the family head and each family member, including age and gender.

The dataset also includes foreign keys that can easily be linked with other client and service data.

The view contains the following columns:

• GroupID
  
• FamilyStartDate
  
• FamilyEndDate
  
• CurrentFamilyTF
  
• FamilyHeadClientID
  
• FamilyHeadName
  
• FamilyHeadGender
  
• FamilyHeadDOB
  
• FamilyHeadCurrentAge
  
• PeopleGroupID
  
• ClientID
  
• FamilyHeadTF
  
• DateJoinedFamily
  
• DateLeftFamily
  
• CurrentFamilyMemberTF
  
• ClientName
  
• GroupRole
  
• RelationshipToHead
  
• ClientGender
  
• ClientDOB
  
• ClientCurrentAge
  
• ClientActivityStatus
  
• ClientHousingStatus
  
• ClientIndigenousStatus
  
• ClientVeteranStatus
  
• ClientCitizenshipStatus
  
• ViewVersion

Documentation

• vw_ACRE_FamilyMembers - Schema.csv
• vw_ACRE_FamilyMembers - Sample Output.csv