DIM_SPONSORSHIPOPPORTUNITYCHILD_STAGE

Intermediate storage for sponsorship opportunity child records

Fields

Field	Field Type	Null	Notes	Description
SPONSORSHIPOPPORTUNITYCHILDSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPOPPORTUNITYCHILD].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		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]