Information for the AnalyticsSourceFamilyHistorical

Columns

• Id (datatype: int) Required Primary Key
• FamilyId (datatype: int) Required Primary Key
• CurrentRowIndicator (datatype: bit) Required Primary Key
• EffectiveDate (datatype: date) Required Primary Key
• ExpireDate (datatype: date) Required Primary Key
• Name (datatype: nvarchar(100)) Required Primary Key
• FamilyTitle (datatype: nvarchar(250)) Required Primary Key
• CampusId (datatype: int) Required Primary Key
• ConnectionStatus (datatype: nvarchar(250)) Required Primary Key
• IsFamilyActive (datatype: bit) Required Primary Key
• AdultCount (datatype: int) Required Primary Key
• ChildCount (datatype: int) Required Primary Key
• HeadOfHouseholdPersonKey (datatype: int) Required Primary Key
• IsEra (datatype: bit) Required Primary Key
• MailingAddressLocationId (datatype: int) Required Primary Key
• MappedAddressLocationId (datatype: int) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• Count (datatype: int) Required Primary Key