DIM_SPONSORSHIPOPPORTUNITYCHILD

Stores information about sponsorship opportunity children

Primary Key

Primary Key	Field Type
SPONSORSHIPOPPORTUNITYCHILDDIMID	int

Fields

Field	Field Type	Null	Notes	Description
SPONSORSHIPOPPORTUNITYCHILDSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[CONSTITUENTID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[SPONSORSHIPOPPORTUNITYCHILD].[CONSTITUENTID]
FULLNAME	nvarchar(154)	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[NAME]
FIRSTNAME	nvarchar(50)	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[FIRSTNAME]
MIDDLENAME	nvarchar(50)	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[MIDDLENAME]
LASTNAME	nvarchar(100)	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[LASTNAME]
GENDERCODE	tinyint	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[GENDERCODE]
GENDER	nvarchar(25)	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[GENDER]
BIRTHDATE	UDT_FUZZYDATE	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[BIRTHDATE]
AGE	int	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[AGE]
ISHIVPOSITIVE	bit	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[ISHIVPOSITIVE]
ISORPHANED	bit	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[ISORPHANED]
CONDITIONCODESYSTEMID	uniqueidentifier	yes		dbo.[SPROPPCHILDCONDITIONCODE].[ID]
CONDITION	nvarchar(100)	yes		dbo.[SPROPPCHILDCONDITIONCODE].[DESCRIPTION]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used.
ETLCONTROLID	int	yes		ID generated through the ETL process.
INELIGIBLESPONSORSHIPREASONDIMID	int	yes		Reference key to the sponsorship reason dimension, derived from dbo.[SPONSORSHIPOPPORTUNITY].[SPONSORSHIPREASONID]
ELIGIBILITYCODE	smallint	yes		dbo.[SPONSORSHIPOPPORTUNITY].[ELIGIBILITYCODE]
ELIGIBILITY	nvarchar(25)	yes		dbo.[SPONSORSHIPOPPORTUNITY].[ELIGIBILITY]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_SPONSORSHIPOPPORTUNITYCHILD	SPONSORSHIPOPPORTUNITYCHILDDIMID	yes	yes	yes