v_DIM_SPONSORSHIPOPPORTUNITYCHILD

Stores information about sponsorship opportunity children

Fields

Field	Field Type	Null	Description
SPONSORSHIPOPPORTUNITYCHILDDIMID	int		BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[SPONSORSHIPOPPORTUNITYCHILDDIMID]
SPONSORSHIPOPPORTUNITYCHILDSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[SPONSORSHIPOPPORTUNITYCHILDSYSTEMID]
CONSTITUENTDIMID	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[CONSTITUENTDIMID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[CONSTITUENTSYSTEMID]
FULLNAME	nvarchar(154)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[FULLNAME]
FIRSTNAME	nvarchar(50)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[FIRSTNAME]
MIDDLENAME	nvarchar(50)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[MIDDLENAME]
LASTNAME	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[LASTNAME]
GENDER	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[GENDER]
BIRTHDATE	UDT_FUZZYDATE	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[BIRTHDATE]
AGE	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[AGE]
ISHIVPOSITIVE	bit	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[ISHIVPOSITIVE]
ISORPHANED	bit	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[ISORPHANED]
CONDITION	nvarchar(100)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[CONDITION]
INELIGIBLESPONSORSHIPREASONDIMID	int	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[INELIGIBLESPONSORSHIPREASONDIMID]
ELIGIBILITY	nvarchar(25)	yes	BBDW.[DIM_SPONSORSHIPOPPORTUNITYCHILD].[ELIGIBILITY]

Definition

Copy


CREATE view [BBDW].[v_DIM_SPONSORSHIPOPPORTUNITYCHILD] as 
  select 
    [SPONSORSHIPOPPORTUNITYCHILDDIMID],
    [SPONSORSHIPOPPORTUNITYCHILDSYSTEMID],    
    [CONSTITUENTDIMID],
    [CONSTITUENTSYSTEMID],
    [FULLNAME],
    [FIRSTNAME],
    [MIDDLENAME],
    [LASTNAME],
    [GENDER],
    [BIRTHDATE],
    [AGE],
    [ISHIVPOSITIVE],
    [ISORPHANED],
    [CONDITION],
    [INELIGIBLESPONSORSHIPREASONDIMID],
    [ELIGIBILITY]
  from [BBDW].[DIM_SPONSORSHIPOPPORTUNITYCHILD];