4.0-Version-59 0.74 (Complete)SQL Database Schema

aspnet_Applications

Field Type Size Nullable? Foreign Key
ApplicationName nvarchar 256  
LoweredApplicationName nvarchar 256  
ApplicationId uniqueidentifier    
Description nvarchar 256  
Fields Being Referenced Foreign Table.Foreign Key
ApplicationId aspnet_Membership.ApplicationId
ApplicationId aspnet_Roles.ApplicationId
ApplicationId aspnet_Users.ApplicationId

aspnet_Membership

Field Type Size Nullable? Foreign Key
ApplicationId uniqueidentifier   aspnet_Applications.ApplicationId
UserId uniqueidentifier   aspnet_Users.UserId
Password nvarchar 128  
PasswordFormat int    
PasswordSalt nvarchar 128  
MobilePIN nvarchar 16  
Email nvarchar 256  
LoweredEmail nvarchar 256  
PasswordQuestion nvarchar 256  
PasswordAnswer nvarchar 128  
IsApproved bit    
IsLockedOut bit    
CreateDate datetime    
LastLoginDate datetime    
LastPasswordChangedDate datetime    
LastLockoutDate datetime    
FailedPasswordAttemptCount int    
FailedPasswordAttemptWindowStart datetime    
FailedPasswordAnswerAttemptCount int    
FailedPasswordAnswerAttemptWindowStart datetime    
Comment ntext 1073741823  

aspnet_Profile

Field Type Size Nullable? Foreign Key
UserId uniqueidentifier   aspnet_Users.UserId
PropertyNames ntext 1073741823  
PropertyValuesString ntext 1073741823  
PropertyValuesBinary image 2147483647  
LastUpdatedDate datetime    

aspnet_Roles

Field Type Size Nullable? Foreign Key
ApplicationId uniqueidentifier   aspnet_Applications.ApplicationId
RoleId uniqueidentifier    
RoleName nvarchar 256  
LoweredRoleName nvarchar 256  
Description nvarchar 256  
Fields Being Referenced Foreign Table.Foreign Key
RoleId aspnet_UsersInRoles.RoleId

aspnet_SchemaVersions

Field Type Size Nullable? Foreign Key
Feature nvarchar 128  
CompatibleSchemaVersion nvarchar 128  
IsCurrentVersion bit    

aspnet_Users

Field Type Size Nullable? Foreign Key
ApplicationId uniqueidentifier   aspnet_Applications.ApplicationId
UserId uniqueidentifier    
UserName nvarchar 256  
LoweredUserName nvarchar 256  
MobileAlias nvarchar 16  
IsAnonymous bit    
LastActivityDate datetime    
Fields Being Referenced Foreign Table.Foreign Key
UserId aspnet_Membership.UserId
UserId aspnet_Profile.UserId
UserId aspnet_UsersInRoles.UserId

aspnet_UsersInRoles

Field Type Size Nullable? Foreign Key
UserId uniqueidentifier   aspnet_Users.UserId
RoleId uniqueidentifier   aspnet_Roles.RoleId

EXPORT_Clients

Field Type Size Nullable? Foreign Key
ID int    
LastName nvarchar 50  
FirstName nvarchar 50  
FamilyHeadID int    
Gender int    
DateOfBirth datetime2    
AboriginalIndicator int    
CitizenshipStatus int    
VeteranIndicator int    
CountryOfBirth int    
FamilyRoleType int    
Fields Being Referenced Foreign Table.Foreign Key
ID EXPORT_Indicators.ClientID
ID EXPORT_Stays.ClientID
ID EXPORT_Turnaways.ClientID

EXPORT_CustomLookups

Field Type Size Nullable? Foreign Key
ID int    
Type int    
TypeID int    
RollupTypeID int    
NameEnglish nvarchar -1  
NameFrench nvarchar -1  

EXPORT_ExportProgress

Field Type Size Nullable? Foreign Key
Exporting int    
ProgressStatus int    

EXPORT_Indicators

Field Type Size Nullable? Foreign Key
ID int    
ClientID int   EXPORT_Clients.ID
Type int    
TypeID int    
StartDate datetime2    
EndDate datetime2    

EXPORT_Organizations

Field Type Size Nullable? Foreign Key
ID int    
Name varchar 255  
BedType int    
ProviderType int    
ServiceOfferedType int    
CityName varchar 255  
RegularBedCount int    
OverflowBedCount int    
Fields Being Referenced Foreign Table.Foreign Key
ID EXPORT_Stays.OrganizationID
ID EXPORT_Turnaways.OrganizationID

EXPORT_Stays

Field Type Size Nullable? Foreign Key
ID int    
ClientID int   EXPORT_Clients.ID
OrganizationID int   EXPORT_Organizations.ID
StartDate datetime2    
EndDate datetime2    
ReasonForService int    
ReasonForDischarge int    
FamilyHeadClientID int    
FamilyRoleID int    
HistoricalAboriginalIndicator int    
HistoricalCitizenshipStatus int    

EXPORT_Turnaways

Field Type Size Nullable? Foreign Key
ID int    
ClientID int   EXPORT_Clients.ID
OrganizationID int   EXPORT_Organizations.ID
Date datetime2    
ReasonForTurnaway int    
AgeCategory int    
Gender int    
ObservedAboriginal bit    
ObservedDisability bit    

HIFIS_AboriginalIndicatorTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
LegacyID int    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_AboriginalIndicatorTypes_SP.LookupID
ID HIFIS_Clients.AboriginalIndicatorID

HIFIS_AboriginalIndicatorTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_AboriginalIndicatorTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Activities

Field Type Size Nullable? Foreign Key
ActivitiesID int    
ActivitiesTypeID smallint   HIFIS_ActivitiesTypes.ID
DateStart datetime2    
DateEnd datetime2    
Minutes int    
UnitCost decimal    
UnitPrice decimal    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
GoodsActivitiesID int   HIFIS_GoodsActivities.GoodsActivitiesID
Fields Being Referenced Foreign Table.Foreign Key
ActivitiesID HIFIS_Activities_ReportCategories.ActivitiesID

HIFIS_Activities_Items

Field Type Size Nullable? Foreign Key
ActivitiesItemID int    
ActivitiesTypeID smallint   HIFIS_ActivitiesTypes.ID
Minutes int    
UnitCost decimal    
UnitPrice decimal    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ActiveYN char 1  
Name nvarchar 50  
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ActivitiesItemID HIFIS_Activities_Items_ServiceProviders.ActivitiesItemID

HIFIS_Activities_Items_ServiceProviders

Field Type Size Nullable? Foreign Key
ActivitiesItemsSPID int    
ActivitiesItemID int   HIFIS_Activities_Items.ActivitiesItemID
OrgID int   HIFIS_Organizations.OrganizationID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
HifisRowVersion timestamp    

HIFIS_Activities_ReportCategories

Field Type Size Nullable? Foreign Key
ActivitiesReportCategoriesID int    
ActivitiesID int   HIFIS_Activities.ActivitiesID
ReportCategoriesTypeID smallint   HIFIS_ReportCategoriesTypes.ID
NumberOfServicedPeople smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_ActivitiesTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Activities.ActivitiesTypeID
ID HIFIS_Activities_Items.ActivitiesTypeID
ID HIFIS_ActivitiesTypes_SP.LookupID

HIFIS_ActivitiesTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ActivitiesTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Addresses

Field Type Size Nullable? Foreign Key
AddressID int    
Building nvarchar 50  
Floor nvarchar 100  
AddressLn1 nvarchar 50  
AddressLn2 nvarchar 50  
CityID int   HIFIS_CityTypes.CityTypeID
ProvinceID smallint   HIFIS_ProvinceTypes.ID
CountryID smallint   HIFIS_CountryTypes.ID
PostalCode nvarchar 6  
InternationalCityName nvarchar 50  
InternationalProvinceName nvarchar 50  
InternationalPostalCode nvarchar 20  
HifisRowVersion timestamp    
Unit nvarchar 6  
GeoRegionID smallint    
Longitude decimal    
Latitude decimal    
AddressMappingInfoID int   HIFIS_AddressMappingInfo.AddressMappingInfoID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
MetaDataSearch nvarchar 500  
Fields Being Referenced Foreign Table.Foreign Key
AddressID HIFIS_Addresses_GeoRegion.AddressID
AddressID HIFIS_Houses.AddressID
AddressID HIFIS_Organizations.AddressID
AddressID HIFIS_People_Addresses.AddressID
AddressID HIFIS_Places.AddressID

HIFIS_Addresses_GeoRegion

Field Type Size Nullable? Foreign Key
AddGeoRegionID int    
AddressID int   HIFIS_Addresses.AddressID
GeoRegionID smallint   HIFIS_GeoRegionTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_AddressMappingInfo

Field Type Size Nullable? Foreign Key
AddressMappingInfoID int    
URL nvarchar 500  
Image varbinary -1  
MIMEType nvarchar 50  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
AddressMappingInfoID HIFIS_Addresses.AddressMappingInfoID

HIFIS_AFoodItems_Services_Totals

Field Type Size Nullable? Foreign Key
AFoodItemServiceTotalID int    
ServiceID bigint   HIFIS_Services.ServiceID
FoodItemTypeID smallint   HIFIS_FoodItemTypes.ID
TotalNoOfItems smallint    
UnitOfMeasureTypeID smallint   HIFIS_UnitOfMeasureTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
AFoodItemServiceTotalID HIFIS_AFoodItemsTotal_ReportCategories.ServicesFoodItemID

HIFIS_AFoodItemsTotal_ReportCategories

Field Type Size Nullable? Foreign Key
AFoodItemsTotal_ReportCategoryID int    
ReportCategoriesTypeID smallint   HIFIS_ReportCategoriesTypes.ID
ServicesFoodItemID int   HIFIS_AFoodItems_Services_Totals.AFoodItemServiceTotalID
NumberOfItems smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_AgeCategoryTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_AgeCategoryTypes_SP.LookupID
ID HIFIS_Anonymous.AgeCategoryTypeID

HIFIS_AgeCategoryTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_AgeCategoryTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_AMeals_Services_Totals

Field Type Size Nullable? Foreign Key
AMealServiceTotalID int    
ServiceID bigint   HIFIS_Services.ServiceID
TotalServings smallint    
Total nchar 10  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
AMealServiceTotalID HIFIS_AMealsTotal_ReportCategories.AnonymousServiceID

HIFIS_AMealsTotal_ReportCategories

Field Type Size Nullable? Foreign Key
AAMealsTotal_ReportCategoryID int    
ReportCategoriesTypeID smallint   HIFIS_ReportCategoriesTypes.ID
AnonymousServiceID int   HIFIS_AMeals_Services_Totals.AMealServiceTotalID
NumberOfServings smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_Anonymous

Field Type Size Nullable? Foreign Key
AnonymousID int    
PresumedAboriginalYN char 1  
ObservedDisability char 1  
GenderTypeID smallint   HIFIS_GenderTypes.ID
AgeCategoryTypeID smallint   HIFIS_AgeCategoryTypes.ID
NoOfChildren smallint    
NoOfAdults smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
AnonymousID HIFIS_Turnaways.AnonymousID

HIFIS_ApplicationTabs

Field Type Size Nullable? Foreign Key
ApplicationTabID tinyint    
ParentItemID tinyint   HIFIS_ApplicationTabs.ApplicationTabID
PositionE tinyint    
NameE nvarchar 80  
NameF nvarchar 80  
URL varchar 200  
IsClickableYN char 1  
ActiveYN char 1  
HifisRowVersion timestamp    
LastUpdatedBy int    
RightID int    
PositionF tinyint    
Fields Being Referenced Foreign Table.Foreign Key
ApplicationTabID HIFIS_ApplicationTabs.ParentItemID

HIFIS_Appointments

Field Type Size Nullable? Foreign Key
AppointmentID int    
StartDateTime datetime2    
FollowThroughYN char 1  
HifisRowVersion timestamp    
PlaceID int   HIFIS_Places.PlaceID
PersonID int   HIFIS_People.PersonID
AppointmentTypeID smallint   HIFIS_AppointmentTypes.ID
Comments nvarchar 2000  
ClientID int   HIFIS_Clients.ClientID
Description nvarchar 200  
EndDateTime datetime2    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
AppointmentID HIFIS_Session_Appointments.AppointmentID

HIFIS_AppointmentTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Appointments.AppointmentTypeID
ID HIFIS_AppointmentTypes_SP.LookupID

HIFIS_AppointmentTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_AppointmentTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ArmedConflictsTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
RollUpID int    
Stratum tinyint    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ArmedConflictsTypes_SP.LookupID
ID HIFIS_ArmyServicePeriods.ArmedConflictID

HIFIS_ArmedConflictsTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ArmedConflictsTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ArmedForceOfTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ArmedForceOfTypes_SP.LookupID
ID HIFIS_ArmyServicePeriods.ArmedForceOfTypeID

HIFIS_ArmedForceOfTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ArmedForceOfTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ArmedForcesElementTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ArmedForcesElementTypes_SP.LookupID
ID HIFIS_ArmyServicePeriods.ElementtTypeID

HIFIS_ArmedForcesElementTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ArmedForcesElementTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ArmyRankTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
Stratum tinyint    
ActiveYN char 1  
HifisRowVersion timestamp    
RollUpID int    
LegacyID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ArmyRankTypes_SP.LookupID
ID HIFIS_ArmyServicePeriods.ArmyRankTypeID

HIFIS_ArmyRankTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ArmyRankTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ArmyRoleTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ArmyRoleTypes_SP.LookupID
ID HIFIS_ArmyServicePeriods.ArmyRoleTypeID

HIFIS_ArmyRoleTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ArmyRoleTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ArmyServicePeriods

Field Type Size Nullable? Foreign Key
ArmyServicePeriodID int    
ClientID int   HIFIS_Clients.ClientID
DateStart datetime2    
DateEnd datetime2    
ArmedConflictID smallint   HIFIS_ArmedConflictsTypes.ID
ArmedForceOfTypeID smallint   HIFIS_ArmedForceOfTypes.ID
ReasonForDischargeTypeID smallint   HIFIS_ReasonForDischargeVeteransTypes.ID
ElementtTypeID smallint   HIFIS_ArmedForcesElementTypes.ID
ArmyRoleTypeID smallint   HIFIS_ArmyRoleTypes.ID
IDNumberForConflict nvarchar 30  
VACCaseWorker nvarchar 50  
Comments nvarchar 2000  
HifisRowVersion timestamp    
ArmyRankTypeID smallint   HIFIS_ArmyRankTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
ArmyServicePeriodID HIFIS_ArmyServicePeriods_VeternsAttributeTypes.ArmyServicePeriodID

HIFIS_ArmyServicePeriods_VeternsAttributeTypes

Field Type Size Nullable? Foreign Key
ArmyServiceVeteranAttributesID int    
ArmyServicePeriodID int   HIFIS_ArmyServicePeriods.ArmyServicePeriodID
VeteranAttributeTypeID smallint   HIFIS_VeteransAttributeTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ArrivingByTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 100  
NameF nvarchar 100  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ArrivingByTypes_SP.LookupID
ID HIFIS_Client_Refugee.ArrivingByID
ID HIFIS_PortOfEntry.ArrivingByID

HIFIS_ArrivingByTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ArrivingByTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_AssetTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_AssetTypes_SP.LookupID
ID HIFIS_LiabilitiesOrAssests.AssetTypeID

HIFIS_AssetTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_AssetTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_AtRiskstatusTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 100  
NameF nvarchar 100  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_AtRiskstatusTypes_SP.LookupID
ID HIFIS_RisksOfHomelessness.AtRiskStatusTypeID

HIFIS_AtRiskstatusTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_AtRiskstatusTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_AuditLog

Field Type Size Nullable? Foreign Key
AuditLogID bigint    
UserID int   HIFIS_UserProfiles.UserID
OrgID int   HIFIS_Organizations.OrganizationID
ClientID int   HIFIS_Clients.ClientID
PersonID int   HIFIS_People.PersonID
IPAddress nvarchar 25  
URL nvarchar 255  
Controller nvarchar 100  
Action nvarchar 50  
Timestamp datetime2    
SuccessYN char 1  
AuditMessageID smallint   HIFIS_AuditMessages.AuditMessageID
ModuleType smallint   HIFIS_ModuleTypes.ID
SearchValue nvarchar 150  
Fields Being Referenced Foreign Table.Foreign Key
AuditLogID HIFIS_Client_Attestation.AuditLogID

HIFIS_AuditMessages

Field Type Size Nullable? Foreign Key
AuditMessageID smallint    
MessageE nvarchar 255  
MessageF nvarchar 255  
Fields Being Referenced Foreign Table.Foreign Key
AuditMessageID HIFIS_AuditLog.AuditMessageID

HIFIS_BailEvents

Field Type Size Nullable? Foreign Key
BailEventID int    
PeopleLifeEventID int   HIFIS_People_LifeEvents.PeopleLifeEventID
Curfew time    
RiskTypeID smallint   HIFIS_RiskTypes.ID
Comments nvarchar 2000  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_BandNameTypes

Field Type Size Nullable? Foreign Key
BandTypeID smallint    
LegacyID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
ProvinceID smallint   HIFIS_ProvinceTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
BandNumber nvarchar 20  
Fields Being Referenced Foreign Table.Foreign Key
BandTypeID HIFIS_IndianStatus.BandNameType

HIFIS_Barred_Modules

Field Type Size Nullable? Foreign Key
BarredModuleID int    
ClientBarredPeriodID int   HIFIS_Client_Barred_Periods.ClientBarredPeriodID
ServiceRestrictionModuleTypeID smallint   HIFIS_ServiceRestrictionsModuleTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Beds

Field Type Size Nullable? Foreign Key
BedID int    
RoomID int   HIFIS_Rooms.RoomID
BedName nvarchar 50  
BedTypeID smallint   HIFIS_BedTypes.ID
BedStatusTypeID smallint   HIFIS_BedStatusTypes.ID
OverflowYN char 1  
MobileYN char 1  
ReservedYN char 1  
ActiveYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
EffectiveDate datetime2    
Fields Being Referenced Foreign Table.Foreign Key
BedID HIFIS_BedStatusHistory.BedID
BedID HIFIS_StaysRoomBedsHistory.BedID

HIFIS_BedStatusHistory

Field Type Size Nullable? Foreign Key
BedStatusHistoryID int    
BedID int   HIFIS_Beds.BedID
BedStatusTypeID smallint   HIFIS_BedStatusTypes.ID
StartDate datetime2    
EndDate datetime2    
Comments nvarchar 2000  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_BedStatusTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 100  
NameF nvarchar 100  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Beds.BedStatusTypeID
ID HIFIS_BedStatusHistory.BedStatusTypeID
ID HIFIS_BedStatusTypes_SP.LookupID

HIFIS_BedStatusTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_BedStatusTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_BedTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Beds.BedTypeID
ID HIFIS_BedTypes_SP.LookupID

HIFIS_BedTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_BedTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_BehaviorTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
LegacyID int    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_BehaviorTypes_SP.LookupID
ID HIFIS_FoodBankItems.BehaviourTypeID

HIFIS_BehaviorTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_BehaviorTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_BehaviouralFactorTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
LegacyID int    
ActiveYN char 1  
Stratum tinyint    
RollUpID int    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_BehaviouralFactorTypes_SP.LookupID
ID HIFIS_Client_BehaviouralFactor.BehavioralTypeID

HIFIS_BehaviouralFactorTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_BehaviouralFactorTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_BuildingTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
RollUpID int    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_BuildingTypes_SP.LookupID
ID HIFIS_Houses.BuildingTypeID

HIFIS_BuildingTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_BuildingTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_BulletinPriorityTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_BulletinPriorityTypes_SP.LookupID
ID HIFIS_Bulletins.BulletinPriorityTypeID

HIFIS_BulletinPriorityTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_BulletinPriorityTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Bulletins

Field Type Size Nullable? Foreign Key
BulletinID int    
BulletinPriorityTypeID smallint   HIFIS_BulletinPriorityTypes.ID
Subject nvarchar 250  
Description nvarchar -1  
DateStart datetime2    
DateEnd datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OnBehalfOf int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
BulletinID HIFIS_Bulletins_Clients.BulletinID
BulletinID HIFIS_Bulletins_Users.BulletinID
BulletinID HIFIS_BulletinsOrganizations.BulletinID

HIFIS_Bulletins_Clients

Field Type Size Nullable? Foreign Key
BulletinClientID int    
BulletinID int   HIFIS_Bulletins.BulletinID
ClientID int   HIFIS_Clients.ClientID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Bulletins_Users

Field Type Size Nullable? Foreign Key
BulletinUserID int    
BulletinID int   HIFIS_Bulletins.BulletinID
AcknowledgedYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
UserID int   HIFIS_UserProfiles.UserID
LastUpdatedBy int    
CreatedBy int    

HIFIS_BulletinsOrganizations

Field Type Size Nullable? Foreign Key
BulletinOrganizationID int    
BulletinID int   HIFIS_Bulletins.BulletinID
OrganizationID int   HIFIS_Organizations.OrganizationID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Case_Comments

Field Type Size Nullable? Foreign Key
CaseCommentID int    
CaseID int   HIFIS_Cases.CaseID
CommentsID int   HIFIS_Comments.CommentsID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Case_Documents

Field Type Size Nullable? Foreign Key
CaseDocumentID int    
CaseID int   HIFIS_Cases.CaseID
HifisRowVersion timestamp    
DocumentID int   HIFIS_Documents.DocumentID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Cases

Field Type Size Nullable? Foreign Key
CaseID int    
CaseNumber varchar 50  
CaseStateTypeID smallint   HIFIS_CaseStateTypes.ID
DesiredOutcomeTypeID smallint   HIFIS_DesiredOutcomeTypes.ID
DesiredOutcomeTargetDate date    
DateCaseOpened date    
DateCaseClosed date    
HifisRowVersion timestamp    
CaseWorkerID int   HIFIS_People.PersonID
HIFIS_ProgramServiceProviderID int   HIFIS_Program_ServiceProviders.HIFIS_ProgramServiceProviderID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ServiceID bigint   HIFIS_Services.ServiceID
Fields Being Referenced Foreign Table.Foreign Key
CaseID HIFIS_Case_Comments.CaseID
CaseID HIFIS_Case_Documents.CaseID
CaseID HIFIS_Cases_ClientFactors.CaseID
CaseID HIFIS_Sessions.CaseID

HIFIS_Cases_ClientFactors

Field Type Size Nullable? Foreign Key
CaseClientFactorID int    
CaseID int   HIFIS_Cases.CaseID
FactorTypeID smallint   HIFIS_ContributingFactorTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_CaseStateTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Cases.CaseStateTypeID
ID HIFIS_CaseStateTypes_SP.LookupID

HIFIS_CaseStateTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_CaseStateTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_CauseOfDeathTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
RollUpID int    
Stratum tinyint    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_CauseOfDeathTypes_SP.LookupID
ID HIFIS_Clients.CauseOfDeathID

HIFIS_CauseOfDeathTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_CauseOfDeathTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Chores

Field Type Size Nullable? Foreign Key
ChoreID int    
ClientID int   HIFIS_Clients.ClientID
ChoreTypeID smallint   HIFIS_ChoreTypes.ID
DateStart datetime2    
DateEnd datetime2    
MinutesToDate int    
Description nvarchar 250  
StayID bigint   HIFIS_Stays.StayID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ChoreTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Chores.ChoreTypeID
ID HIFIS_ChoreTypes_SP.LookupID

HIFIS_ChoreTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ChoreTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_CitizenshipTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_CitizenshipTypes_SP.LookupID
ID HIFIS_Clients.CitizenshipTypeID

HIFIS_CitizenshipTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_CitizenshipTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_CityTypes

Field Type Size Nullable? Foreign Key
CityTypeID int    
LegacyID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
ProvinceID smallint   HIFIS_ProvinceTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ReserveYN char 1  
Fields Being Referenced Foreign Table.Foreign Key
CityTypeID HIFIS_Addresses.CityID
CityTypeID HIFIS_FirstNationsCommunities.CityID
CityTypeID HIFIS_GeoRegion_CityTypes.CityID
CityTypeID HIFIS_PiTQuestionnaires.CityID
CityTypeID HIFIS_PiTQuestionsAnswers.CityID
CityTypeID HIFIS_PortOfEntry.CityTypeID

HIFIS_Client_Attestation

Field Type Size Nullable? Foreign Key
AttestationID int    
ClientID int   HIFIS_Clients.ClientID
OrgID int   HIFIS_Organizations.OrganizationID
UserID int   HIFIS_UserProfiles.UserID
Date datetime2    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
HifisRowVersion timestamp    
ActiveYN char 1  
AuditLogID bigint   HIFIS_AuditLog.AuditLogID

HIFIS_Client_Barred_Periods

Field Type Size Nullable? Foreign Key
ClientBarredPeriodID int    
DateStart datetime2    
DateEnd datetime2    
ClientID int   HIFIS_Clients.ClientID
Comments nvarchar -1  
HifisRowVersion timestamp    
OnBehalfOfPersonID int   HIFIS_People.PersonID
ReasonBarredTypeID smallint   HIFIS_ReasonBarredTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
ClientBarredPeriodID HIFIS_Barred_Modules.ClientBarredPeriodID
ClientBarredPeriodID HIFIS_Organizations_Client_Barred_Periods.ClientBarredPeriodID

HIFIS_Client_BehaviouralFactor

Field Type Size Nullable? Foreign Key
ClientBehaviouralFactorID int    
ClientID int   HIFIS_Clients.ClientID
BehavioralTypeID smallint   HIFIS_BehaviouralFactorTypes.ID
DateStart datetime2    
DateEnd datetime2    
Comments nvarchar 2000  
HifisRowVersion timestamp    
ProbabilityTypeID smallint   HIFIS_ProbabilityTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_ContactEventTypes

Field Type Size Nullable? Foreign Key
ClientContactEventTypeID bigint    
ClientID int   HIFIS_Clients.ClientID
ContactEventTypeID smallint   HIFIS_ContactEventTypes.ID
OrganizationID int   HIFIS_Organizations.OrganizationID
EventDateTime datetime2    
OtherPartyName nvarchar 50  
Comments nvarchar -1  
HifisRowVersion timestamp    
DurationMinutes int    
ExResidentYN char 1  
GeoRegionTypeID smallint   HIFIS_GeoRegionTypes.ID
Subject nvarchar 200  
NatureOfContactTypeID smallint   HIFIS_NatureOfContactTypes.ID
IncomingYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_ContributingFactor

Field Type Size Nullable? Foreign Key
ClientContributingFactorID int    
ClientID int   HIFIS_Clients.ClientID
ContributingTypeID smallint   HIFIS_ContributingFactorTypes.ID
DateStart datetime2    
DateEnd datetime2    
Comments nvarchar 2000  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_DistinguishingFeatures

Field Type Size Nullable? Foreign Key
ClientDistinguishingFeatureID int    
DistinguishingFeatureTypeID smallint   HIFIS_DistinguishingFeatureTypes.ID
ClientID int   HIFIS_Clients.ClientID
Description nvarchar 2000  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_ParentSituations

Field Type Size Nullable? Foreign Key
ClientParentSituationID int    
ClientID int   HIFIS_Clients.ClientID
ParentSituationTypeID smallint   HIFIS_ParentSituationTypes.ID
DateStart datetime2    
DateEnd datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_Refugee

Field Type Size Nullable? Foreign Key
ClientRefugeeID int    
ClientID int   HIFIS_Clients.ClientID
ArrivingByID smallint   HIFIS_ArrivingByTypes.ID
ArrivingFromID smallint   HIFIS_CountryTypes.ID
PortOfEntryID smallint   HIFIS_PortOfEntry.PortOfEntryID
DateOfEntry datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_RelationToParentTypes

Field Type Size Nullable? Foreign Key
ClientRelationToParentTypeID int    
ClientID int   HIFIS_Clients.ClientID
RelationToParentType smallint   HIFIS_RelationToParentTypes.ID
DateStart datetime2    
DateEnd datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Client_SchoolEnrolmentProblems

Field Type Size Nullable? Foreign Key
ClientSchoolEnrolmentProblemID int    
ClientID int   HIFIS_Clients.ClientID
SchoolEnrolProblemTypeID smallint   HIFIS_SchoolEnrolProblemTypes.ID
DateStart datetime2    
DateEnd datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_Client_Services

Field Type Size Nullable? Foreign Key
ClientServiceID bigint    
ServiceID bigint   HIFIS_Services.ServiceID
ClientID int   HIFIS_Clients.ClientID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
PrimaryClientYN char 1  

HIFIS_Client_WatchConcerns

Field Type Size Nullable? Foreign Key
ClientWatchConcernID int    
ClientID int   HIFIS_Clients.ClientID
WatchConcernTypeID smallint   HIFIS_WatchConcernTypes.ID
DateStart datetime2    
DateEnd datetime2    
Comments nvarchar -1  
HifisRowVersion timestamp    
ProbabilityTypeID smallint   HIFIS_ProbabilityTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ClientCitizenships

Field Type Size Nullable? Foreign Key
ClientCitizenshipID int    
LegacyID int    
CitizenshipTypeID int    
ClientID int   HIFIS_Clients.ClientID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ClientDiets

Field Type Size Nullable? Foreign Key
ClientDietID int    
ClientID int   HIFIS_Clients.ClientID
DietCategoryTypeID smallint   HIFIS_DietCategoryTypes.ID
DietFoodItemTypeID smallint   HIFIS_DietFoodItemTypes.ID
AvoidedDietYN char 1  
ActiveYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ClientEducationLevels

Field Type Size Nullable? Foreign Key
ClientEducationLevelID int    
ClientID int   HIFIS_Clients.ClientID
PlaceID int   HIFIS_Places.PlaceID
EducationLevelTypeID smallint   HIFIS_EducationLevelTypes.ID
DateEnd datetime2    
DateStart datetime2    
HifisRowVersion timestamp    
CompletedYN char 1  
Comments nvarchar 2000  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ClientExpenses

Field Type Size Nullable? Foreign Key
ClientExpenseID bigint    
ExpenseTypeID smallint   HIFIS_ExpenseTypes.ID
ClientID int   HIFIS_Clients.ClientID
DateStart datetime2    
DateEnd datetime2    
PayFrequencyTypeID smallint   HIFIS_PayFrequencyTypes.ID
ExpenseAmount decimal    
IsEssentialYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
ShareYN char 1  
EditableYN char 1  
Comment nvarchar -1  
ExpenseHoursDays decimal    

HIFIS_ClientFlags

Field Type Size Nullable? Foreign Key
ClientFlagID int    
ClientID int   HIFIS_Clients.ClientID
UserFlagTypeID smallint   HIFIS_ClientFlagTypes.ID
FlagValueYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_ClientFlagTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientFlags.UserFlagTypeID
ID HIFIS_ClientFlagTypes_SP.LookupID

HIFIS_ClientFlagTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ClientFlagTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ClientHistory_FieldTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Sequence smallint    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientHistoryChanges.FieldTypeID

HIFIS_ClientHistoryChanges

Field Type Size Nullable? Foreign Key
ClientHistoryChanges int    
ClientID int   HIFIS_Clients.ClientID
FieldTypeID smallint   HIFIS_ClientHistory_FieldTypes.ID
Value nvarchar 50  
DateOfChange datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ClientHousingStatusTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
LegacyID int    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Clients.ClientHousingStatusTypeID

HIFIS_ClientIncomes

Field Type Size Nullable? Foreign Key
ClientIncomeID int    
ClientID int   HIFIS_Clients.ClientID
IncomeTypeID smallint   HIFIS_IncomeTypes.ID
MonthlyAmount decimal    
FrequencyTypeID smallint   HIFIS_PayFrequencyTypes.ID
DateEnd datetime2    
DateStart datetime2    
HifisRowVersion timestamp    
EmployerTypeID smallint   HIFIS_EmployerTypes.ID
EmploymentTypeID smallint   HIFIS_EmploymentTypes.ID
EmployerName nvarchar 100  
PrimaryYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
HoursDays decimal    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
ShareYN char 1  
EditableYN char 1  
Comment nvarchar -1  
Fields Being Referenced Foreign Table.Foreign Key
ClientIncomeID HIFIS_SocialAssistManagers.ClientIncomeID

HIFIS_ClientPhotos

Field Type Size Nullable? Foreign Key
ClientPhotoID int    
ClientID int   HIFIS_Clients.ClientID
ClientImageTypeID int    
Name nvarchar 50  
PhotoImage varbinary -1  
PhotoDate nchar 10  
DefaultYN char 1  
Description nvarchar 2000  
MIMEType nvarchar 50  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_ClientQuestionnaires

Field Type Size Nullable? Foreign Key
ClientQuestionnaireID int    
ClientID int   HIFIS_Clients.ClientID
QuestionnaireID int   HIFIS_Questionnaires.QuestionnaireID
DateAnswered datetime2    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
OrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ClientQuestionnaireID HIFIS_QuestionAnswered.ClientQuestionnaireID

HIFIS_Clients

Field Type Size Nullable? Foreign Key
ClientID int    
ClientStateTypeID smallint   HIFIS_ClientStateTypes.ID
FileNumber nvarchar 50  
IsClient char 1  
CountryOfBirth smallint   HIFIS_CountryTypes.ID
ProvinceOfBirth int    
ProvinceFreeText nvarchar 50  
CityOfBirth int    
CityFreeText nvarchar 50  
CitizenshipTypeID smallint   HIFIS_CitizenshipTypes.ID
AboriginalIndicatorID smallint   HIFIS_AboriginalIndicatorTypes.ID
HairColorTypeID smallint   HIFIS_HairColorTypes.ID
EyeColorTypeID smallint   HIFIS_EyeColorTypes.ID
ClientHeight smallint    
ClientWeight smallint    
AdditionalAttributes nvarchar 2000  
IsStealthYN char 1  
HifisRowVersion timestamp    
VeteranStateID smallint   HIFIS_VeteranStatesTypes.ID
PersonID int   HIFIS_People.PersonID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
DateOfDeath datetime2    
CauseOfDeathID smallint   HIFIS_CauseOfDeathTypes.ID
DeathDateAproxYN char 1  
DisabilityYN char 1  
MedicAlertYN char 1  
InfoVerifiedYN char 1  
ClientHousingStatusTypeID smallint   HIFIS_ClientHousingStatusTypes.ID
RecentAcitivityModuleTypeID smallint    
RecentActivityDateTime datetime2    
Fields Being Referenced Foreign Table.Foreign Key
ClientID HIFIS_Appointments.ClientID
ClientID HIFIS_ArmyServicePeriods.ClientID
ClientID HIFIS_AuditLog.ClientID
ClientID HIFIS_Bulletins_Clients.ClientID
ClientID HIFIS_Chores.ClientID
ClientID HIFIS_Client_Attestation.ClientID
ClientID HIFIS_Client_Barred_Periods.ClientID
ClientID HIFIS_Client_BehaviouralFactor.ClientID
ClientID HIFIS_Client_ContactEventTypes.ClientID
ClientID HIFIS_Client_ContributingFactor.ClientID
ClientID HIFIS_Client_DistinguishingFeatures.ClientID
ClientID HIFIS_Client_ParentSituations.ClientID
ClientID HIFIS_Client_Refugee.ClientID
ClientID HIFIS_Client_RelationToParentTypes.ClientID
ClientID HIFIS_Client_SchoolEnrolmentProblems.ClientID
ClientID HIFIS_Client_Services.ClientID
ClientID HIFIS_Client_WatchConcerns.ClientID
ClientID HIFIS_ClientCitizenships.ClientID
ClientID HIFIS_ClientDiets.ClientID
ClientID HIFIS_ClientEducationLevels.ClientID
ClientID HIFIS_ClientExpenses.ClientID
ClientID HIFIS_ClientFlags.ClientID
ClientID HIFIS_ClientHistoryChanges.ClientID
ClientID HIFIS_ClientIncomes.ClientID
ClientID HIFIS_ClientPhotos.ClientID
ClientID HIFIS_ClientQuestionnaires.ClientID
ClientID HIFIS_Clients_Comments.ClientID
ClientID HIFIS_Clients_HousePlacements.ClientID
ClientID HIFIS_Clients_Houses.ClientID
ClientID HIFIS_Clients_Turnaways.ClientID
ClientID HIFIS_ClientWaitingLists.ClientID
ClientID HIFIS_Comments.ClientID
ClientID HIFIS_Consent.ClientID
ClientID HIFIS_FirstNations_Clients.ClientID
ClientID HIFIS_GroupActivities_Clients.ClientID
ClientID HIFIS_HealthIssues.ClientID
ClientID HIFIS_HousePlacements.PrimaryClientID
ClientID HIFIS_IndianStatus.ClientID
ClientID HIFIS_LiabilitiesOrAssests.ClientID
ClientID HIFIS_Medications.ClientID
ClientID HIFIS_RisksOfHomelessness.ClientID
ClientID HIFIS_ScheduledFollowUps.ClientID
ClientID HIFIS_SocialAssistManagers.ClientID
ClientID HIFIS_Turnaways.PrimaryClientID
ClientID HIFIS_User_MaritalStatuses.ClientID

HIFIS_Clients_Comments

Field Type Size Nullable? Foreign Key
ClientCommentID int    
CommentsID int   HIFIS_Comments.CommentsID
ClientID int   HIFIS_Clients.ClientID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Clients_Groups_FamilyExtension

Field Type Size Nullable? Foreign Key
ClientGroupFamilyExtensionID int   HIFIS_People_Groups.PeopleGroupID
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_Clients_HousePlacements

Field Type Size Nullable? Foreign Key
ClientHousePlacementID int    
HousePlacementID int   HIFIS_HousePlacements.HousePlacementID
ClientID int   HIFIS_Clients.ClientID
HifisRowVersion timestamp    
HousePlacementFollowUpID int   HIFIS_FollowUps.FollowUpID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Clients_Houses

Field Type Size Nullable? Foreign Key
ClientHouseID int    
HouseID int   HIFIS_Houses.HouseID
ClientID int   HIFIS_Clients.ClientID
DateStart datetime2    
DateEnd datetime2    
HifisRowVersion timestamp    
LastRent decimal    
Telephone1 nvarchar 15  
Telephone1Ext nvarchar 6  
Telephone2 nvarchar 15  
MobilePhone nvarchar 15  
Email nvarchar 100  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
HousePlacementID int   HIFIS_HousePlacements.HousePlacementID
HouseRetentionID int   HIFIS_HousePlacements.HousePlacementID
Fields Being Referenced Foreign Table.Foreign Key
ClientHouseID HIFIS_ClientsHousePlacements_ReasonLeftHousingTypes.ClientHouseID
ClientHouseID HIFIS_Followup_Housing.ClientHouseID
ClientHouseID HIFIS_HousingSubsidy.ClientHouseID

HIFIS_Clients_Turnaways

Field Type Size Nullable? Foreign Key
ClientTurnawayID int    
TurnawayID bigint   HIFIS_Turnaways.TurnawayID
ClientID int   HIFIS_Clients.ClientID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ClientsHousePlacements_ReasonLeftHousingType

Field Type Size Nullable? Foreign Key

HIFIS_ClientStateTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
LegacyID int    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Clients.ClientStateTypeID

HIFIS_ClientWaitingLists

Field Type Size Nullable? Foreign Key
ClientWaitingListID bigint    
WaitingListID int   HIFIS_WaitingLists.WaitingListID
ClientID int   HIFIS_Clients.ClientID
WaitingRequestPriorityTypeID smallint   HIFIS_WaitingRequestPriorityTypes.ID
DateStart datetime2    
DateEnd datetime2    
Comment nvarchar 2000  
HifisRowVersion timestamp    
WaitingRequestReasonTypeID smallint   HIFIS_WaitingRequestReasonTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
ClientWaitingListID HIFIS_WaitingListStatusHistory.ClientWaitingListID

HIFIS_Cluster

Field Type Size Nullable? Foreign Key
ClusterID smallint    
Name nvarchar 100  
CreatedBy int    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
EnforceConsentYN char 1  
ConsentExpiryDays smallint    
EnableSharingYN char 1  
RestrictClientSearchYN char 1  
TriggerMinAgeConsent smallint    
EnableAttestationYN char 1  
AttestationTextEng nvarchar -1  
AttestationTextFr nvarchar -1  
RegistrationID int   HIFIS_Registration.ID
InactivityThreshold int    
HousingInactivityThreshold int    
ShelterStaysInHousingYN char 1  
Fields Being Referenced Foreign Table.Foreign Key
ClusterID HIFIS_Houses.ClusterID
ClusterID HIFIS_Organizations.ClusterID
ClusterID HIFIS_People.ClusterID
ClusterID HIFIS_Places.ClusterID

HIFIS_Comments

Field Type Size Nullable? Foreign Key
CommentsID int    
CommentTypeID smallint   HIFIS_CommentTypes.ID
ClientID int   HIFIS_Clients.ClientID
DateCreated datetime2    
Subject nvarchar 255  
CommentBody nvarchar -1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ParentCommentsID int   HIFIS_Comments.CommentsID
OrgID int   HIFIS_Organizations.OrganizationID
ShareYN char 1  
EditableYN char 1  
Fields Being Referenced Foreign Table.Foreign Key
CommentsID HIFIS_Case_Comments.CommentsID
CommentsID HIFIS_Clients_Comments.CommentsID
CommentsID HIFIS_Comments.ParentCommentsID
CommentsID HIFIS_SessionComments.CommentsID

HIFIS_CommentTypes

Field Type Size Nullable? Foreign Key
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
RollUpID int    
ID smallint    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Comments.CommentTypeID
ID HIFIS_CommentTypes_SP.LookupID

HIFIS_CommentTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_CommentTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Conflicts

Field Type Size Nullable? Foreign Key
ConflictID int    
FirstPersonID int   HIFIS_People.PersonID
FirstIsVictim char 1  
SecondPersonID int   HIFIS_People.PersonID
SecondIsVictim char 1  
DateStart datetime2    
DateEnd datetime2    
IntensityTypeID smallint   HIFIS_IntensityTypes.ID
ProbabilityTypeID smallint   HIFIS_ProbabilityTypes.ID
RelationshipTypeID smallint   HIFIS_RelationshipTypes.ID
Comments nvarchar -1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ConflictID HIFIS_Conflicts_ConflictTypes.ConflictID
ConflictID HIFIS_Conflicts_LocationTypes.ConflictID
ConflictID HIFIS_Conflicts_RefferedBy.ConflictID
ConflictID HIFIS_Conflicts_RefferedTo.ConflictID

HIFIS_Conflicts_ConflictTypes

Field Type Size Nullable? Foreign Key
CCTypeID int    
ConflictID int   HIFIS_Conflicts.ConflictID
ConflictTypeID smallint   HIFIS_ConflictTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Conflicts_LocationTypes

Field Type Size Nullable? Foreign Key
ConflictsLocationTypeID int    
ConflictID int   HIFIS_Conflicts.ConflictID
LocationTypeID smallint   HIFIS_LocationTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Conflicts_RefferedBy

Field Type Size Nullable? Foreign Key
ConflictsRefferedByID int    
ConflictID int   HIFIS_Conflicts.ConflictID
PlaceID int   HIFIS_Places.PlaceID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Conflicts_RefferedTo

Field Type Size Nullable? Foreign Key
ConflictsRefferedToID int    
ConflictID int   HIFIS_Conflicts.ConflictID
PlaceID int   HIFIS_Places.PlaceID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ConflictTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
LastUpdatedBy int    
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Conflicts_ConflictTypes.ConflictTypeID
ID HIFIS_ConflictTypes_SP.LookupID

HIFIS_ConflictTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ConflictTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    
Field Type Size Nullable? Foreign Key
ConsentID int    
ClientID int   HIFIS_Clients.ClientID
AcceptYN char 1  
StartDate datetime2    
ExpiryDate datetime2    
DocumentID int   HIFIS_Documents.DocumentID
Comment nvarchar -1  
HifisRowVersion timestamp    
LastUpdatedDate datetime2    
CreatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ConsentTypeID smallint   HIFIS_ConsentTypes.ID
ParentConsentID int   HIFIS_Consent.ConsentID
Fields Being Referenced Foreign Table.Foreign Key
ConsentID HIFIS_Consent.ParentConsentID
ConsentID HIFIS_Consent_ServiceProviders.ConsentID
Field Type Size Nullable? Foreign Key
ConsentSPID int    
ConsentID int   HIFIS_Consent.ConsentID
OrgID int   HIFIS_Organizations.OrganizationID
StartDate datetime2    
EndDate datetime2    
HifisRowVersion timestamp    
LastUpdatedDate datetime2    
CreatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_ConsentTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Consent.ConsentTypeID
ID HIFIS_ConsentTypes_SP.LookupID

HIFIS_ConsentTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ConsentTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ContactEventTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Client_ContactEventTypes.ContactEventTypeID
ID HIFIS_ContactEventTypes_SP.LookupID

HIFIS_ContactEventTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ContactEventTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ContinuumCategories

Field Type Size Nullable? Foreign Key
ContinuumCategoryID int    
ContinuumID int   HIFIS_Continuums.ContinuumID
Name nvarchar 100  
Sequence smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
RollUpID int   HIFIS_ContinuumCategories.ContinuumCategoryID
Fields Being Referenced Foreign Table.Foreign Key
ContinuumCategoryID HIFIS_ContinuumCategories.RollUpID
ContinuumCategoryID HIFIS_ContinuumCategoryHouseTypes.ContinuumCategoryID

HIFIS_ContinuumCategoryHouseTypes

Field Type Size Nullable? Foreign Key
ContinuumCategoryID int   HIFIS_ContinuumCategories.ContinuumCategoryID
HouseTypeID smallint   HIFIS_HouseTypes.ID
ContinuumCategoryHouseTypeID int    

HIFIS_Continuums

Field Type Size Nullable? Foreign Key
ContinuumID int    
Name nvarchar 200  
OwnerOrganizationID int   HIFIS_Organizations.OrganizationID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ContinuumTypeID int   HIFIS_ContinuumTypes.ID
Fields Being Referenced Foreign Table.Foreign Key
ContinuumID HIFIS_ContinuumCategories.ContinuumID

HIFIS_ContinuumTypes

Field Type Size Nullable? Foreign Key
ID int    
NameEn nvarchar 80  
NameFr nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
LegacyId int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Continuums.ContinuumTypeID

HIFIS_ContributingFactorTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
LegacyID int    
ActiveYN char 1  
Stratum tinyint    
RollUpID int    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Cases_ClientFactors.FactorTypeID
ID HIFIS_Client_ContributingFactor.ContributingTypeID
ID HIFIS_ContributingFactorTypes_SP.LookupID

HIFIS_ContributingFactorTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ContributingFactorTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_CountryTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Addresses.CountryID
ID HIFIS_Client_Refugee.ArrivingFromID
ID HIFIS_Clients.CountryOfBirth
ID HIFIS_CountryTypes_SP.LookupID
ID HIFIS_LiabilitiesOrAssests.CountryID
ID HIFIS_PiTQuestionsAnswers.CountryID
ID HIFIS_ProvinceTypes.CountryID

HIFIS_CountryTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_CountryTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_CustomData

Field Type Size Nullable? Foreign Key
CustomDataID int    
CustomFieldID int   HIFIS_CustomFields.CustomFieldID
TextValue nvarchar -1  
BooleanValue bit    
NumericValue int    
DecimalValue float    
DocumentID int   HIFIS_Documents.DocumentID
CustomLinkID int   HIFIS_CustomLinks.CustomLinkID
HifisRowVersion timestamp    
DateValue date    
TimeValue time    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
CustomDataID HIFIS_CustomDataDropDownSelected.CustomDataID

HIFIS_CustomDataDropDownSelected

Field Type Size Nullable? Foreign Key
CustomDataDropDownID int    
CustomLookUpID smallint   HIFIS_CustomLookUps.ID
CustomDataID int   HIFIS_CustomData.CustomDataID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_CustomFields

Field Type Size Nullable? Foreign Key
CustomFieldID int    
CustomTableID int   HIFIS_CustomTables.CustomTableID
FieldTypeID smallint   HIFIS_CustomFieldTypes.ID
NameE nvarchar -1  
NameF nvarchar -1  
MandatoryYN char 1  
Minimum int    
Maximum int    
Mask nvarchar 255  
HifisRowVersion timestamp    
xCoordinate int    
yCoordinate int    
ActiveYN char 1  
Position int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
EnableOtherYN char 1  
LookupTablesID int   HIFIS_LookupTables.LookupTablesID
Fields Being Referenced Foreign Table.Foreign Key
CustomFieldID HIFIS_CustomData.CustomFieldID
CustomFieldID HIFIS_CustomLookUps.CustomFieldID

HIFIS_CustomFieldTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
LegacyID int    
Stratum tinyint    
ActiveYN char 1  
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_CustomFields.FieldTypeID
ID HIFIS_CustomFieldTypes_SP.LookupID

HIFIS_CustomFieldTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_CustomFieldTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    
Field Type Size Nullable? Foreign Key
CustomLinkID int    
CustomTableID int   HIFIS_CustomTables.CustomTableID
PrimaryID int    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
CustomLinkID HIFIS_CustomData.CustomLinkID

HIFIS_CustomLookUps

Field Type Size Nullable? Foreign Key
ID smallint    
CustomFieldID int   HIFIS_CustomFields.CustomFieldID
NameE nvarchar 80  
NameF nvarchar 80  
LegacyID int    
HifisRowVersion timestamp    
ActiveYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Sequence smallint    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_CustomDataDropDownSelected.CustomLookUpID

HIFIS_CustomTables

Field Type Size Nullable? Foreign Key
CustomTableID int    
ModuleTypeID smallint   HIFIS_ModuleTypes.ID
NameE nvarchar 80  
NameF nvarchar 80  
Sequence smallint    
ActiveYN char 1  
One2Many char 1  
HifisRowVersion timestamp    
AutoWidthYN char 1  
LayoutTypeID smallint   HIFIS_LayoutTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
CustomTableID HIFIS_CustomFields.CustomTableID
CustomTableID HIFIS_CustomLinks.CustomTableID
CustomTableID HIFIS_Org_CustomTables.CustomTableID

HIFIS_DataExports

Field Type Size Nullable? Foreign Key
ID int    
InitiatedBy int   HIFIS_UserProfiles.UserID
AutoExportYN char 1  
ExportTypeID int    
ExportDateTimeStart datetime2    
ExportDateTimeEnd datetime2    
LastExportProgress int    
SuccessYN char 1  
ExportSize bigint    
Error nvarchar -1  
CreatedDate datetime2    
CreatedBy int    
LastUpdatedDate datetime2    
LastUpdatedBy int    

HIFIS_DesiredOutcomeTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Cases.DesiredOutcomeTypeID
ID HIFIS_DesiredOutcomeTypes_SP.LookupID
ID HIFIS_SessionActivitiesTypes.DesiredOutcomeTypeID

HIFIS_DesiredOutcomeTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DesiredOutcomeTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_DietCategoryTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientDiets.DietCategoryTypeID
ID HIFIS_DietCategoryTypes_SP.LookupID

HIFIS_DietCategoryTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DietCategoryTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_DietFoodItemTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientDiets.DietFoodItemTypeID
ID HIFIS_DietFoodItemTypes_SP.LookupID

HIFIS_DietFoodItemTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DietFoodItemTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_DigitalContacts

Field Type Size Nullable? Foreign Key
DigitalContactID int    
OrganizationID int   HIFIS_Organizations.OrganizationID
DigitalContactValue nvarchar 200  
DigitalContactTypeID smallint   HIFIS_DigitalContactTypes.ID
HifisRowVersion timestamp    
PersonID int   HIFIS_People.PersonID
DigitalContactExt int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
PlaceID int   HIFIS_Places.PlaceID

HIFIS_DigitalContactTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_DigitalContacts.DigitalContactTypeID
ID HIFIS_DigitalContactTypes_SP.LookupID

HIFIS_DigitalContactTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DigitalContactTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Dispensing

Field Type Size Nullable? Foreign Key
DispensingID bigint    
NumberOfPills smallint    
DateOfDispensing date    
DispensingDoneByID int   HIFIS_People.PersonID
HifisRowVersion timestamp    
MedicationID int   HIFIS_Medications.MedicationID
RecurrenceTypeID smallint   HIFIS_RecurrenceTypes.ID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
DispensingTypeID smallint   HIFIS_DispensingTypes.ID
Comment nvarchar 2000  

HIFIS_DispensingTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Dispensing.DispensingTypeID
ID HIFIS_DispensingTypes_SP.LookupID

HIFIS_DispensingTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DispensingTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_DispositionTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_DispositionTypes_SP.LookupID
ID HIFIS_Incidents.DispositionTypeID

HIFIS_DispositionTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DispositionTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_DistinguishingFeatureTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Client_DistinguishingFeatures.DistinguishingFeatureTypeID
ID HIFIS_DistinguishingFeatureTypes_SP.LookupID

HIFIS_DistinguishingFeatureTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DistinguishingFeatureTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Documents

Field Type Size Nullable? Foreign Key
DocumentID int    
DocumentTypeID smallint   HIFIS_DocumentTypes.ID
Name nvarchar 255  
Body varbinary -1  
MIMEType nvarchar 255  
HifisRowVersion timestamp    
PersonID int   HIFIS_People.PersonID
Description nvarchar 255  
DateUploaded datetime2    
ConfidentialYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ReferenceID int    
FileSizeBytes int    
Fields Being Referenced Foreign Table.Foreign Key
DocumentID HIFIS_Case_Documents.DocumentID
DocumentID HIFIS_Consent.DocumentID
DocumentID HIFIS_CustomData.DocumentID
DocumentID HIFIS_DocumentVersions.CurrentDocumentID
DocumentID HIFIS_DocumentVersions.DocumentID
DocumentID HIFIS_Incidents_Documents.DocumentID
DocumentID HIFIS_PeopleIdentificationAttachments.DocumentID
DocumentID HIFIS_VAT_Intake.DocumentID

HIFIS_DocumentTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
LegacyID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Documents.DocumentTypeID
ID HIFIS_DocumentTypes_SP.LookupID

HIFIS_DocumentTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DocumentTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_DocumentVersions

Field Type Size Nullable? Foreign Key
DocumentVersionID smallint    
CurrentDocumentID int   HIFIS_Documents.DocumentID
DocumentID int   HIFIS_Documents.DocumentID
VersionNumber tinyint    
HifisRowVersion timestamp    
LastUpdatedDate datetime2    
CreatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_DomainOperationTypes

Field Type Size Nullable? Foreign Key
ID smallint    
OperationName nvarchar 50  
NameE nvarchar 80  
NameF nvarchar 80  
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Rights.DomainOperationTypeID

HIFIS_DomainSectionTypes

Field Type Size Nullable? Foreign Key
ID smallint    
ModuleName nvarchar 50  
NameE nvarchar 80  
NameF nvarchar 80  

HIFIS_DomainServiceTypes

Field Type Size Nullable? Foreign Key
ID smallint    
ServiceName nvarchar 50  
NameE nvarchar 50  
NameF nvarchar 50  
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Rights.DomainServiceTypeID

HIFIS_DosageTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_DosageTypes_SP.LookupID
ID HIFIS_Medications.DosageTypeID

HIFIS_DosageTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_DosageTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_EducationLevelTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientEducationLevels.EducationLevelTypeID
ID HIFIS_EducationLevelTypes_SP.LookupID

HIFIS_EducationLevelTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_EducationLevelTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_ELearning_Material

Field Type Size Nullable? Foreign Key
MaterialID int    
ContentTypeID smallint   HIFIS_HelpContentTypes.ID
ContentE nvarchar -1  
ContentF nvarchar -1  
EHelpImageID int   HIFIS_HelpImage.HelpImageID
ContentTitleE nvarchar 100  
ContentTitleF nvarchar 100  
MaterialNameE nvarchar 100  
MaterialNameF nvarchar 100  
QuizQuestionID int   HIFIS_ELearning_QuizQuestion.QuizQuestionID
FHelpImageID int   HIFIS_HelpImage.HelpImageID

HIFIS_ELearning_Modules

Field Type Size Nullable? Foreign Key
ModuleID int    
NameE nvarchar 100  
NameF nvarchar 100  
DescriptionE nvarchar -1  
DescriptionF nvarchar -1  
Fields Being Referenced Foreign Table.Foreign Key
ModuleID HIFIS_ELearning_PlayLists_Modules.ModuleID
ModuleID HIFIS_ELearning_Topics.ModuleID

HIFIS_ELearning_Playlists

Field Type Size Nullable? Foreign Key
PlaylistID int    
NameE nvarchar 200  
NameF nvarchar 200  
DescriptionE nvarchar -1  
DescriptionF nvarchar -1  
Sequence smallint    
Fields Being Referenced Foreign Table.Foreign Key
PlaylistID HIFIS_ELearning_PlayLists_Modules.PlaylistID

HIFIS_ELearning_PlayLists_Modules

Field Type Size Nullable? Foreign Key
PlayListModuleID int    
PlaylistID int   HIFIS_ELearning_Playlists.PlaylistID
ModuleID int   HIFIS_ELearning_Modules.ModuleID
Sequence smallint    

HIFIS_ELearning_QuizQuestion

Field Type Size Nullable? Foreign Key
QuizQuestionID int    
QuestionE nvarchar 255  
QuestionF nvarchar 255  
QuestionType smallint    
QuestionAnswerYN char 1  
QuestionChoiceE1 nvarchar 100  
QuestionChoiceE2 nvarchar 100  
QuestionChoiceE3 nvarchar 100  
QuestionChoiceE4 nvarchar 100  
QuestionChoiceAnswer tinyint    
QuestionChoiceF1 nvarchar 100  
QuestionChoiceF2 nvarchar 100  
QuestionChoiceF3 nvarchar 100  
QuestionChoiceF4 nvarchar 100  
DescriptionE nvarchar 255  
DescriptionF nvarchar 255  
Fields Being Referenced Foreign Table.Foreign Key
QuizQuestionID HIFIS_ELearning_Material.QuizQuestionID

HIFIS_ELearning_Topic_Glossary

Field Type Size Nullable? Foreign Key
TopicsGlossaryID int    
TopicID int   HIFIS_ELearning_Topics.TopicID
HelpGlossaryID int   HIFIS_HelpGlossary.HelpGlossaryID

HIFIS_ELearning_Topic_Material

Field Type Size Nullable? Foreign Key
TopicsMaterialID int    
TopicID int   HIFIS_ELearning_Topics.TopicID
MaterialID int    
MaterialStylesID smallint   HIFIS_HelpMaterialStyles.ID
LayoutOrder smallint    

HIFIS_ELearning_Topics

Field Type Size Nullable? Foreign Key
TopicID int    
NameE nvarchar 100  
NameF nvarchar 100  
DescriptionE nvarchar -1  
DescriptionF nvarchar -1  
ModuleID int   HIFIS_ELearning_Modules.ModuleID
Sequence smallint    
IsSubTopicYN char 1  
TopicType smallint   HIFIS_ELearning_TopicTypes.ID
Fields Being Referenced Foreign Table.Foreign Key
TopicID HIFIS_ELearning_Topic_Glossary.TopicID
TopicID HIFIS_ELearning_Topic_Material.TopicID

HIFIS_ELearning_TopicTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 50  
NameF nvarchar 50  
ActiveYN char 1  
Sequence smallint    
Stratum tinyint    
RollUpID int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ELearning_Topics.TopicType

HIFIS_EmergencyServiceTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_EmergencyServiceTypes_SP.LookupID
ID HIFIS_Incidents_EmergencyTypes.EmergencyServiceTypeID

HIFIS_EmergencyServiceTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_EmergencyServiceTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_EmployerTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientIncomes.EmployerTypeID
ID HIFIS_EmployerTypes_SP.LookupID

HIFIS_EmployerTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_EmployerTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_EmploymentStatusTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_EmploymentStatusTypes_SP.LookupID

HIFIS_EmploymentStatusTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_EmploymentStatusTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_EmploymentTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientIncomes.EmploymentTypeID
ID HIFIS_EmploymentTypes_SP.LookupID

HIFIS_EmploymentTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_EmploymentTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Errors

Field Type Size Nullable? Foreign Key
ErrorID bigint    
DateIssued datetime2    
ErrorMessage nvarchar 4000  
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_ExpenseTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 100  
NameF nvarchar 100  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientExpenses.ExpenseTypeID
ID HIFIS_ExpenseTypes_SP.LookupID

HIFIS_ExpenseTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_ExpenseTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_EyeColorTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Clients.EyeColorTypeID
ID HIFIS_EyeColorTypes_SP.LookupID

HIFIS_EyeColorTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_EyeColorTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_FamilyRelationshipTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
RollUpID int    
Stratum tinyint    
LegacyID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_FamilyRelationshipTypes_SP.LookupID

HIFIS_FamilyRelationshipTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_FamilyRelationshipTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_FirstNations_Clients

Field Type Size Nullable? Foreign Key
FirstNationsClientID int    
FirstNationsCommunityID int   HIFIS_FirstNationsCommunities.FirstNationsCommunityID
ClientID int   HIFIS_Clients.ClientID
DateEnd datetime2    
DateStart datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_FirstNationsCommunities

Field Type Size Nullable? Foreign Key
FirstNationsCommunityID int    
NameE nvarchar 100  
NameF nvarchar 100  
CityID int   HIFIS_CityTypes.CityTypeID
IsReserveYN char 1  
ActiveYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
FirstNationsCommunityID HIFIS_FirstNations_Clients.FirstNationsCommunityID

HIFIS_Followup_Housing

Field Type Size Nullable? Foreign Key
FollowupHousingID int    
FollowUpID int   HIFIS_FollowUps.FollowUpID
ClientHouseID int   HIFIS_Clients_Houses.ClientHouseID
ClientStillInHouseYN char 1  
HousedElsewhereYN char 1  
StillInHousingTypeID smallint   HIFIS_StillInHousingTypes.ID
ReasonLeftHouseTypeID smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_FollowUps

Field Type Size Nullable? Foreign Key
FollowUpID int    
HousePlacementID int    
DateOfCheck datetime2    
Comments nvarchar -1  
HifisRowVersion timestamp    
NumberOfMonths smallint    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OrgID int   HIFIS_Organizations.OrganizationID
ClientHouseID int    
ServiceID bigint   HIFIS_Services.ServiceID
Fields Being Referenced Foreign Table.Foreign Key
FollowUpID HIFIS_Clients_HousePlacements.HousePlacementFollowUpID
FollowUpID HIFIS_Followup_Housing.FollowUpID
FollowUpID HIFIS_ScheduledFollowUps.FollowUpID

HIFIS_FoodBank

Field Type Size Nullable? Foreign Key
FoodBankID int    
ServiceID bigint   HIFIS_Services.ServiceID
FoodBankItemID int   HIFIS_FoodBankItems.FoodBankItemID
Quantity smallint    
HifisRowVersion timestamp    
UnitCost decimal    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_FoodBankItems

Field Type Size Nullable? Foreign Key
FoodBankItemID int    
NameE nvarchar 80  
NameF nvarchar 80  
DaysCovered smallint    
UnitCost decimal    
ActiveYN char 1  
BehaviourTypeID smallint   HIFIS_BehaviorTypes.ID
HifisRowVersion timestamp    
NumberOfAdults smallint    
NumberOfChildren smallint    
ProductCode nvarchar 50  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
FoodBankItemID HIFIS_FoodBank.FoodBankItemID

HIFIS_FoodItemTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_AFoodItems_Services_Totals.FoodItemTypeID
ID HIFIS_FoodItemTypes_SP.LookupID

HIFIS_FoodItemTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_FoodItemTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_FundingCategoryTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_FundingCategoryTypes_SP.LookupID
ID HIFIS_FundingOrganizations.FundingOrgsTypeID

HIFIS_FundingCategoryTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_FundingCategoryTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_FundingOrganizations

Field Type Size Nullable? Foreign Key
FundingOrganizationID smallint    
LegacyID int    
FundingOrgsTypeID smallint   HIFIS_FundingCategoryTypes.ID
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_GangAffiliation

Field Type Size Nullable? Foreign Key
GangAffiliationID int    
PeopleLifeEventID int   HIFIS_People_LifeEvents.PeopleLifeEventID
GangName nvarchar 100  
DirectInvolvementYN char 1  
Comments nvarchar 2000  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    

HIFIS_GenderTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Anonymous.GenderTypeID
ID HIFIS_GenderTypes_SP.LookupID
ID HIFIS_Organization_GenderTypes.GenderTypeID
ID HIFIS_People.GenderTypeID

HIFIS_GenderTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_GenderTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_GeoRegion_CityTypes

Field Type Size Nullable? Foreign Key
ID int    
GeoRegion smallint   HIFIS_GeoRegionTypes.ID
CityID int   HIFIS_CityTypes.CityTypeID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_GeoRegionTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Addresses_GeoRegion.GeoRegionID
ID HIFIS_Client_ContactEventTypes.GeoRegionTypeID
ID HIFIS_GeoRegion_CityTypes.GeoRegion
ID HIFIS_GeoRegionTypes_SP.LookupID
ID HIFIS_People.GeoRegionTypeID

HIFIS_GeoRegionTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_GeoRegionTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Goods

Field Type Size Nullable? Foreign Key
GoodsID int    
GoodTypeID smallint   HIFIS_GoodsTypes.ID
NoOfUnits smallint    
UnitOfMeasureTypeID smallint   HIFIS_UnitOfMeasureTypes.ID
UnitPrice decimal    
UnitCost decimal    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
GoodsActivitiesID int   HIFIS_GoodsActivities.GoodsActivitiesID
Fields Being Referenced Foreign Table.Foreign Key
GoodsID HIFIS_Goods_ReportCategories.GoodsID

HIFIS_Goods_Items

Field Type Size Nullable? Foreign Key
GoodItemID int    
GoodTypeID smallint   HIFIS_GoodsTypes.ID
UnitOfMeasureTypeID smallint   HIFIS_UnitOfMeasureTypes.ID
NoOfUnits smallint    
UnitPrice decimal    
UnitCost decimal    
ActiveYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
HifisRowVersion timestamp    
Name nvarchar 50  
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
GoodItemID HIFIS_Goods_Items_ServiceProviders.GoodItemID

HIFIS_Goods_Items_ServiceProviders

Field Type Size Nullable? Foreign Key
GoodsItemsSPID int    
GoodItemID int   HIFIS_Goods_Items.GoodItemID
OrgID int   HIFIS_Organizations.OrganizationID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
HifisRowVersion timestamp    

HIFIS_Goods_ReportCategories

Field Type Size Nullable? Foreign Key
GoodsReportCategoryID int    
GoodsID int   HIFIS_Goods.GoodsID
ReportCategoriesTypeID smallint   HIFIS_ReportCategoriesTypes.ID
NumberOfItems smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    

HIFIS_GoodsActivities

Field Type Size Nullable? Foreign Key
GoodsActivitiesID int    
ServiceID bigint   HIFIS_Services.ServiceID
ReasonForGoodsActivityTypeID smallint   HIFIS_ReasonForGoodsActivityTypes.ID
Fields Being Referenced Foreign Table.Foreign Key
GoodsActivitiesID HIFIS_Activities.GoodsActivitiesID
GoodsActivitiesID HIFIS_Goods.GoodsActivitiesID

HIFIS_GoodsTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Goods.GoodTypeID
ID HIFIS_Goods_Items.GoodTypeID
ID HIFIS_GoodsTypes_SP.LookupID

HIFIS_GoodsTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_GoodsTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_GroupActivities

Field Type Size Nullable? Foreign Key
GroupActivityID int    
ServiceID bigint   HIFIS_Services.ServiceID
GroupActivityTypeID smallint   HIFIS_GroupActivitiesTypes.ID
DurationMinutes int    
Description nvarchar 250  
PlaceID int   HIFIS_Places.PlaceID
OwnerOrgID int   HIFIS_Organizations.OrganizationID
AnonymousCount smallint    
DemoChildYouthCount smallint    
DemoAdultCount smallint    
DemoSeniorCount smallint    
DemoMaleCount smallint    
DemoFemaleCount smallint    
DemoOtherCount smallint    
DemoAboriginalCount smallint    
DemoNonAboriginalCount smallint    
DemoDisabledCount smallint    
DemoNonDisabledCount smallint    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
GroupActivityID HIFIS_GroupActivities_Clients.GroupActivityID
GroupActivityID HIFIS_GroupActivities_Contacts.GroupActivityID

HIFIS_GroupActivities_Clients

Field Type Size Nullable? Foreign Key
GroupActivitiesClientID int    
ClientID int   HIFIS_Clients.ClientID
GroupActivityID int   HIFIS_GroupActivities.GroupActivityID
AttendanceYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_GroupActivities_Contacts

Field Type Size Nullable? Foreign Key
GroupActivitiesContactID int    
PersonID int   HIFIS_People.PersonID
GroupActivityID int   HIFIS_GroupActivities.GroupActivityID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_GroupActivitiesTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_GroupActivities.GroupActivityTypeID
ID HIFIS_GroupActivitiesTypes_SP.LookupID

HIFIS_GroupActivitiesTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_GroupActivitiesTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_GroupRoleTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
GroupTypeID smallint   HIFIS_GroupTypes.ID
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_GroupRoleTypes_SP.LookupID
ID HIFIS_People_Groups.GroupRoleTypeID

HIFIS_GroupRoleTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_GroupRoleTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Groups

Field Type Size Nullable? Foreign Key
GroupID int    
GroupCode nvarchar 50  
GroupTypeID smallint   HIFIS_GroupTypes.ID
DateStart datetime2    
DateEnd datetime2    
GroupHeadClientID int    
HifisRowVersion timestamp    
GroupHeadPersonID int   HIFIS_People.PersonID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
GroupID HIFIS_People_Groups.GroupID
GroupID HIFIS_Services_Groups.GroupID

HIFIS_GroupTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_GroupRoleTypes.GroupTypeID
ID HIFIS_Groups.GroupTypeID
ID HIFIS_GroupTypes_ClientRelationshipTypes.GroupTypeID
ID HIFIS_GroupTypes_SP.LookupID

HIFIS_GroupTypes_ClientRelationshipTypes

Field Type Size Nullable? Foreign Key
GroupTypeClientRelationshipTypeID int    
ClientRelationshipTypeID smallint   HIFIS_PeopleRelationshipTypes.ID
GroupTypeID smallint   HIFIS_GroupTypes.ID
ActiveYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_GroupTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_GroupTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_HairColorTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
RollUpID int    
Stratum tinyint    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Clients.HairColorTypeID
ID HIFIS_HairColorTypes_SP.LookupID

HIFIS_HairColorTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_HairColorTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_HealthIssues

Field Type Size Nullable? Foreign Key
HealthIssueID int    
ClientID int   HIFIS_Clients.ClientID
HealthIssueTypeID smallint   HIFIS_HealthIssueTypes.ID
DateFrom date    
DateTo date    
Description nvarchar 2000  
Symptoms nvarchar -1  
Medication nvarchar -1  
Treatment nvarchar -1  
SelfReportedYN char 1  
SuspectedYN char 1  
DiagnosedYN char 1  
ContagiousYN char 1  
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
ShareYN char 1  
EditableYN char 1  
Fields Being Referenced Foreign Table.Foreign Key
HealthIssueID HIFIS_HealthIssues_SP.HealthIssueID
HealthIssueID HIFIS_HealthIssuesHistory.HealthIssueID
HealthIssueID HIFIS_Medications.HealthIssueID

HIFIS_HealthIssues_SP

Field Type Size Nullable? Foreign Key
HealthIssueSPID int    
HealthIssueID int   HIFIS_HealthIssues.HealthIssueID
OrgID int   HIFIS_Organizations.OrganizationID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HealthIssuesHistory

Field Type Size Nullable? Foreign Key
HealthIssueHistoryID int    
HealthIssueID int   HIFIS_HealthIssues.HealthIssueID
HealthIssueTypeID int    
DateFrom date    
DateTo date    
Description nvarchar 2000  
Medication nvarchar 500  
Treatment nvarchar 500  
SelfReportedYN char 1  
SuspectedYN char 1  
DiagnosedYN char 1  
ContagiousYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HealthIssueTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_HealthIssues.HealthIssueTypeID
ID HIFIS_HealthIssueTypes_SP.LookupID

HIFIS_HealthIssueTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_HealthIssueTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Help_SearchHistory

Field Type Size Nullable? Foreign Key
SearchHistoryID int    
UserID int    
SearchTerm nvarchar 100  
DateTimeOfSearch datetime2    
NoOfResults smallint    
HelpTopicID int   HIFIS_HelpTopics.HelpTopicID

HIFIS_Help_Topics_Glossary

Field Type Size Nullable? Foreign Key
HelpTopicsGlossaryID int    
HelpTopicID int   HIFIS_HelpTopics.HelpTopicID
HelpGlossaryID int   HIFIS_HelpGlossary.HelpGlossaryID

HIFIS_HelpCategoryTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 50  
NameF nvarchar 50  
ActiveYN char 1  
Sequence smallint    
Stratum tinyint    
RollUpID int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_HelpModules.CategoryTypeID

HIFIS_HelpContentTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 50  
NameF nvarchar 50  
ActiveYN char 1  
Sequence smallint    
Stratum tinyint    
RollUpID int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ELearning_Material.ContentTypeID
ID HIFIS_HelpMaterial.ContentTypeID

HIFIS_HelpField

Field Type Size Nullable? Foreign Key
ID int    
LabelKey nvarchar 100  
LabelNameE nvarchar 250  
LabelNameF nvarchar 250  
LabelDescriptionE nvarchar 1000  
LabelDescriptionF nvarchar 1000  

HIFIS_HelpFieldCustom

Field Type Size Nullable? Foreign Key
ID int    
LabelKey nvarchar 100  
LabelDescriptionE nvarchar 1000  
LabelDescriptionF nvarchar 1000  

HIFIS_HelpFriendlyNames

Field Type Size Nullable? Foreign Key
ID int    
ControllerName nvarchar 75  
ActionName nvarchar 75  
FriendlyNameID smallint   HIFIS_HelpFriendlyTypes.ID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_HelpModules.FriendlyNameID

HIFIS_HelpFriendlyTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 50  
NameF nvarchar 50  
ActiveYN char 1  
Sequence smallint    
Stratum tinyint    
RollUpID int    
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_HelpFriendlyNames.FriendlyNameID

HIFIS_HelpGlossary

Field Type Size Nullable? Foreign Key
HelpGlossaryID int    
WordE nvarchar 50  
WordF nvarchar 50  
DefinitionE nvarchar 1000  
DefinitionF nvarchar 1000  
Fields Being Referenced Foreign Table.Foreign Key
HelpGlossaryID HIFIS_ELearning_Topic_Glossary.HelpGlossaryID
HelpGlossaryID HIFIS_Help_Topics_Glossary.HelpGlossaryID

HIFIS_HelpImage

Field Type Size Nullable? Foreign Key
HelpImageID int    
NameE nvarchar -1  
NameF nvarchar -1  
Body varbinary -1  
MIMEType nvarchar 255  
DescriptionE nvarchar -1  
DescriptionF nvarchar -1  
FileName nvarchar 255  
Fields Being Referenced Foreign Table.Foreign Key
HelpImageID HIFIS_ELearning_Material.EHelpImageID
HelpImageID HIFIS_ELearning_Material.FHelpImageID
HelpImageID HIFIS_HelpMaterial.EHelpImageID
HelpImageID HIFIS_HelpMaterial.FHelpImageID

HIFIS_HelpMaterial

Field Type Size Nullable? Foreign Key
HelpMaterialID int    
ContentTypeID smallint   HIFIS_HelpContentTypes.ID
ContentE nvarchar -1  
ContentF nvarchar -1  
EHelpImageID int   HIFIS_HelpImage.HelpImageID
ContentTitleE nvarchar 100  
ContentTitleF nvarchar 100  
MaterialNameE nvarchar 100  
MaterialNameF nvarchar 100  
FHelpImageID int   HIFIS_HelpImage.HelpImageID
Fields Being Referenced Foreign Table.Foreign Key
HelpMaterialID HIFIS_HelpTopics_Material.HelpMaterialID

HIFIS_HelpMaterialStyles

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 100  
NameF nvarchar 100  
StyleString nvarchar 255  
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ELearning_Topic_Material.MaterialStylesID
ID HIFIS_HelpTopics_Material.MaterialStylesID

HIFIS_HelpModules

Field Type Size Nullable? Foreign Key
HelpModuleID int    
NameE nvarchar 100  
NameF nvarchar 100  
DescriptionE nvarchar -1  
DescriptionF nvarchar -1  
CategoryTypeID smallint   HIFIS_HelpCategoryTypes.ID
FriendlyNameID int   HIFIS_HelpFriendlyNames.ID
Fields Being Referenced Foreign Table.Foreign Key
HelpModuleID HIFIS_HelpTopics.HelpModuleID

HIFIS_HelpTopics

Field Type Size Nullable? Foreign Key
HelpTopicID int    
NameE nvarchar 100  
NameF nvarchar 100  
HelpModuleID int   HIFIS_HelpModules.HelpModuleID
RankOrder tinyint    
Fields Being Referenced Foreign Table.Foreign Key
HelpTopicID HIFIS_Help_SearchHistory.HelpTopicID
HelpTopicID HIFIS_Help_Topics_Glossary.HelpTopicID
HelpTopicID HIFIS_HelpTopics_Material.HelpTopicID

HIFIS_HelpTopics_Material

Field Type Size Nullable? Foreign Key
HelpTopicMaterialID int    
HelpTopicID int   HIFIS_HelpTopics.HelpTopicID
HelpMaterialID int   HIFIS_HelpMaterial.HelpMaterialID
LayoutOrder smallint    
MaterialStylesID smallint   HIFIS_HelpMaterialStyles.ID

HIFIS_HomeReserveTypes

Field Type Size Nullable? Foreign Key
HomeReserveTypeID smallint    
LegacyID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
ProvinceID smallint   HIFIS_ProvinceTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
HomeReserveTypeID HIFIS_IndianStatus.HomeReserveType

HIFIS_House_HouseAttributes

Field Type Size Nullable? Foreign Key
HouseHouseAttributesID int    
HouseID int   HIFIS_Houses.HouseID
HouseAttributeTypeID smallint   HIFIS_HouseAttributeTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HouseAttributeTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
Stratum tinyint    
HifisRowVersion timestamp    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_House_HouseAttributes.HouseAttributeTypeID
ID HIFIS_HouseAttributeTypes_SP.LookupID

HIFIS_HouseAttributeTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_HouseAttributeTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_HouseMaintenance

Field Type Size Nullable? Foreign Key
HouseMaintenanceID int    
HouseID int   HIFIS_Houses.HouseID
MaintenanceTypeID smallint   HIFIS_MaintenanceTypes.ID
ScheduledStartDate date    
ScheduledEndDate date    
ScheduledCost decimal    
ContractingCompany nvarchar 100  
PersonID int   HIFIS_People.PersonID
Comments nvarchar 2000  
HifisRowVersion timestamp    
ActualStartDate date    
ActualEndDate date    
ActualCost decimal    
Description nvarchar 100  
CompletedYN char 1  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HousePhotos

Field Type Size Nullable? Foreign Key
HousePhotoID bigint    
HouseID int   HIFIS_Houses.HouseID
PhotoImage varbinary -1  
PhotoDate date    
HifisRowVersion timestamp    
Comments nvarchar 2000  
MIMEType nvarchar 50  
FileName nvarchar 255  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HousePlacementAttempt

Field Type Size Nullable? Foreign Key
HousePlacementAttemptID int    
ReasonHousingNotSecuredTypeID smallint   HIFIS_ReasonHousingNotSecuredTypes.ID
AttemptedDate date    
CaseWorkerID int   HIFIS_People.PersonID
Comment nvarchar 2000  
HifisRowVersion timestamp    
HousePlacementID int   HIFIS_HousePlacements.HousePlacementID
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HousePlacementFollowUps_ReasonLeftTypes

Field Type Size Nullable? Foreign Key
HousePlacementFollowUpReasonTypeID int    
HousePlacementFollowUpID int    
ReasonLeftHouseTypeID smallint   HIFIS_ReasonLeftHouseTypes.ID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
CreatedBy int    
LastUpdatedBy int    

HIFIS_HousePlacements

Field Type Size Nullable? Foreign Key
HousePlacementID int    
ServiceID bigint   HIFIS_Services.ServiceID
DateSearchStarted date    
DateHousingSecured date    
DateExpectedMoveIn date    
PrimaryClientID int   HIFIS_Clients.ClientID
DateSearchEnded date    
CaseWorkerID int   HIFIS_People.PersonID
HouseID int   HIFIS_Houses.HouseID
HifisRowVersion timestamp    
MovedInDate datetime2    
FollowUpCompleteYN char 1  
NextScheduledFollowup datetime2    
PlacementEndedYN char 1  
TargetDate date    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Fields Being Referenced Foreign Table.Foreign Key
HousePlacementID HIFIS_Clients_HousePlacements.HousePlacementID
HousePlacementID HIFIS_Clients_Houses.HousePlacementID
HousePlacementID HIFIS_Clients_Houses.HouseRetentionID
HousePlacementID HIFIS_HousePlacementAttempt.HousePlacementID
HousePlacementID HIFIS_HousingTypes_HousingPlacements.HousePlacementID

HIFIS_Houses

Field Type Size Nullable? Foreign Key
HouseID int    
HouseTypeID smallint   HIFIS_HouseTypes.ID
YearOfBuilt smallint    
NoOfBedrooms tinyint    
NoOfFloors tinyint    
AreaSqFt numeric    
Rent decimal    
PlacementInventoryYN char 1  
Comments nvarchar -1  
HifisRowVersion timestamp    
LandlordPersonID int   HIFIS_People.PersonID
ShareableYN char 1  
AddressID int   HIFIS_Addresses.AddressID
ActiveYN char 1  
OrganizationID int   HIFIS_Organizations.OrganizationID
BuildingTypeID smallint   HIFIS_BuildingTypes.ID
MultiLevel char 1  
Floor tinyint    
CreatedDate datetime2    
LastUpdatedDate datetime2    
OccupancyStatusTypeID smallint   HIFIS_OccupancyStatusTypes.ID
DateOfOccupancy datetime2    
OccupancyComment nvarchar 2000  
LastUpdatedBy int    
CreatedBy int    
ClusterID smallint   HIFIS_Cluster.ClusterID
Fields Being Referenced Foreign Table.Foreign Key
HouseID HIFIS_Clients_Houses.HouseID
HouseID HIFIS_House_HouseAttributes.HouseID
HouseID HIFIS_HouseMaintenance.HouseID
HouseID HIFIS_HousePhotos.HouseID
HouseID HIFIS_HousePlacements.HouseID
HouseID HIFIS_Houses_HouseStatus.HouseID
HouseID HIFIS_Houses_SP.HouseID

HIFIS_Houses_HouseStatus

Field Type Size Nullable? Foreign Key
HouseHouseStatusID int    
HouseID int   HIFIS_Houses.HouseID
HouseStatusTypeID smallint   HIFIS_HouseStatusTypes.ID
StatusDate date    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Houses_SP

Field Type Size Nullable? Foreign Key
HouseSPID int    
HouseID int   HIFIS_Houses.HouseID
OrgID int   HIFIS_Organizations.OrganizationID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_HouseStatusTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Houses_HouseStatus.HouseStatusTypeID
ID HIFIS_HouseStatusTypes_SP.LookupID

HIFIS_HouseStatusTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_HouseStatusTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_HouseTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
placeableYN char 1  
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ContinuumCategoryHouseTypes.HouseTypeID
ID HIFIS_Houses.HouseTypeID
ID HIFIS_HouseTypes_SP.LookupID
ID HIFIS_HousingTypes_HousingPlacements.HouseTypeID

HIFIS_HouseTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_HouseTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_HousingSubsidy

Field Type Size Nullable? Foreign Key
HousingSubsidyID int    
ServiceProviderID int   HIFIS_Organizations.OrganizationID
DateStart datetime2    
DateEnd datetime2    
ProgramID int   HIFIS_Program_ServiceProviders.HIFIS_ProgramServiceProviderID
Amount decimal    
ClientHouseID int   HIFIS_Clients_Houses.ClientHouseID
LastUpdatedDate datetime2    
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ServiceID bigint   HIFIS_Services.ServiceID
PaymentDate datetime2    
Comment nvarchar -1  
PayFrequencyType smallint   HIFIS_PayFrequencyTypes.ID

HIFIS_HousingTypes_HousingPlacements

Field Type Size Nullable? Foreign Key
HouseTypeHousePlacementID int    
HouseTypeID smallint   HIFIS_HouseTypes.ID
HousePlacementID int   HIFIS_HousePlacements.HousePlacementID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_IdentificationTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 80  
NameF nvarchar 80  
SingleInstanceYN char 1  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_IdentificationTypes_SP.LookupID
ID HIFIS_PeopleIdentification.IdentificationTypeID

HIFIS_IdentificationTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_IdentificationTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_Incident_PeopleInvolved

Field Type Size Nullable? Foreign Key
PeopleInvolvedID int    
IncidentID int   HIFIS_Incidents.IncidentID
PersonID int   HIFIS_People.PersonID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Incident_PeopleWitnesses

Field Type Size Nullable? Foreign Key
PeopleWitnessID int    
IncidentID int   HIFIS_Incidents.IncidentID
PersonID int   HIFIS_People.PersonID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Incidents

Field Type Size Nullable? Foreign Key
IncidentID int    
IncidentTypeID smallint   HIFIS_IncidentTypes.ID
OrganizationID int   HIFIS_Organizations.OrganizationID
IncidentDateAndTime datetime2    
PoliceReportNo nvarchar 50  
PoliceBadge nvarchar 20  
ChargesLaidYN char 1  
DispositionTypeID smallint   HIFIS_DispositionTypes.ID
HifisRowVersion timestamp    
Comments nvarchar -1  
Location nvarchar 255  
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
Cost decimal    
Fields Being Referenced Foreign Table.Foreign Key
IncidentID HIFIS_Incident_PeopleInvolved.IncidentID
IncidentID HIFIS_Incident_PeopleWitnesses.IncidentID
IncidentID HIFIS_Incidents_Documents.IncidentID
IncidentID HIFIS_Incidents_EmergencyTypes.IncidentID

HIFIS_Incidents_Documents

Field Type Size Nullable? Foreign Key
IncidentDocumentID int    
IncidentID int   HIFIS_Incidents.IncidentID
DocumentID int   HIFIS_Documents.DocumentID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_Incidents_EmergencyTypes

Field Type Size Nullable? Foreign Key
Incidents_EmergencyTypeID int    
EmergencyServiceTypeID smallint   HIFIS_EmergencyServiceTypes.ID
IncidentID int   HIFIS_Incidents.IncidentID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    

HIFIS_IncidentTypes

Field Type Size Nullable? Foreign Key
ID smallint    
NameE nvarchar 80  
NameF nvarchar 80  
ActiveYN char 1  
HifisRowVersion timestamp    
LegacyID int    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_Incidents.IncidentTypeID
ID HIFIS_IncidentTypes_SP.LookupID

HIFIS_IncidentTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_IncidentTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_IncomeTypes

Field Type Size Nullable? Foreign Key
ID smallint    
LegacyID int    
NameE nvarchar 100  
NameF nvarchar 100  
ActiveYN char 1  
HifisRowVersion timestamp    
Stratum tinyint    
RollUpID int    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
OwnerOrgID int   HIFIS_Organizations.OrganizationID
Fields Being Referenced Foreign Table.Foreign Key
ID HIFIS_ClientIncomes.IncomeTypeID
ID HIFIS_IncomeTypes_SP.LookupID

HIFIS_IncomeTypes_SP

Field Type Size Nullable? Foreign Key
ID int    
LookupID smallint   HIFIS_IncomeTypes.ID
OrgID int   HIFIS_Organizations.OrganizationID
Sequence smallint    

HIFIS_IndianStatus

Field Type Size Nullable? Foreign Key
IndianStatusID int    
TreatyNumber nvarchar 20  
ProvinceID smallint   HIFIS_ProvinceTypes.ID
BandNameType smallint   HIFIS_BandNameTypes.BandTypeID
HomeReserveType smallint   HIFIS_HomeReserveTypes.HomeReserveTypeID
HifisRowVersion timestamp    
CreatedDate datetime2    
LastUpdatedDate datetime2    
LastUpdatedBy int    
CreatedBy int    
ClientID int   HIFIS_Clients.ClientID

HIFIS_IntakeAssessmentSummary

Field Type Size Nullable? Foreign Key
IntakeAssessmentSummaryID int    
CreatedDate datetime2    
CreatedBy int    
LastUpdatedDate datetime2    
LastUpdatedBy int    
IntakeID bigint    
ClientName nvarchar 100  
OrganizationName nvarchar 200  
IntakeDate datetime2    
IntakeDescription nvarchar -1  
IntakeTool nvarchar 5