V_QUERY_BBDW_SPONSORSHIPOPPORTUNITYCHILD
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPOPPORTUNITYCHILDDIMID | int | ||
| SPONSORSHIPOPPORTUNITYCHILDSYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTDIMID | int | yes | |
| FULLNAME | nvarchar(154) | yes | |
| FIRSTNAME | nvarchar(50) | yes | |
| MIDDLENAME | nvarchar(50) | yes | |
| LASTNAME | nvarchar(100) | yes | |
| BIRTHDATE | UDT_FUZZYDATE | yes | |
| AGE | int | yes | |
| GENDER | nvarchar(25) | yes | |
| ISHIVPOSITIVE | bit | yes | |
| ISORPHANED | bit | yes | |
| CONDITION | nvarchar(100) | yes | |
| ELIGIBILITY | nvarchar(25) | yes | |
| SPONSORSHIPREASON | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SPONSORSHIPOPPORTUNITYCHILD] as
select
soc.[SPONSORSHIPOPPORTUNITYCHILDDIMID],
soc.[SPONSORSHIPOPPORTUNITYCHILDSYSTEMID],
soc.[CONSTITUENTDIMID],
soc.[FULLNAME],
soc.[FIRSTNAME],
soc.[MIDDLENAME],
soc.[LASTNAME],
soc.[BIRTHDATE],
soc.[AGE],
soc.[GENDER],
soc.[ISHIVPOSITIVE],
soc.[ISORPHANED],
soc.[CONDITION],
soc.[ELIGIBILITY],
sr.[SPONSORSHIPREASON]
from [BBDW].[DIM_SPONSORSHIPOPPORTUNITYCHILD] soc
left join [BBDW].[DIM_SPONSORSHIPREASON] sr on soc.[INELIGIBLESPONSORSHIPREASONDIMID] = sr.[SPONSORSHIPREASONDIMID] and soc.[INELIGIBLESPONSORSHIPREASONDIMID] <> 0
where soc.[SPONSORSHIPOPPORTUNITYCHILDDIMID] > 0