View - dbo.uvw_StudentRace

Property	Value
Name	uvw_StudentRace
Schema	dbo
Quoted Identifier Status	True
Ansi Nulls Status	True
Returns View Metadata	False
Create Date	5/10/2012 2:36 PM
Description

Column Name	Data Type	Allow Nulls	Fulltext Indexed	Identity	Description / Computed Formula
AmIndianAKNative	varchar(3)	False	False	False
Asian	varchar(3)	False	False	False
BlackAfricanAmerican	varchar(3)	False	False	False
HawaiianPacIslander	varchar(3)	False	False	False
ISN_ST_STDNT_A	int(10, 0)	False	False	False
NotReported	varchar(3)	False	False	False
White	varchar(3)	False	False	False

Name

Insert

Update

Delete

Instead

Name

Clustered

Columns

Name	Type
ST_STDNT_A_RACE	Table
arch_Student	View
usp_DimStudent_Select	StoredProcedure

Name	Type
arch_Student	VIEW
usp_DimStudent_Select	STOREDPROCEDURE
ST_STDNT_A_RACE	TABLE

Object

Property

Value

Object

Property

Value

/****** Object: View [dbo].[uvw_StudentRace] Script Date: 03/09/2017 16:47:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW uvw_StudentRace
AS
SELECT
    PivotedRaceByStudent.ISN_ST_STDNT_A,
    CASE
        WHEN PivotedRaceByStudent.A IS NULL THEN 'No'
        ELSE 'Yes'
    End AS Asian,
    CASE
        WHEN PivotedRaceByStudent.B IS NULL THEN 'No'
        ELSE 'Yes'
    End AS BlackAfricanAmerican,
    CASE
        WHEN PivotedRaceByStudent.I IS NULL THEN 'No'
        ELSE 'Yes'
    End AS AmIndianAKNative,
    CASE
        WHEN PivotedRaceByStudent.P IS NULL THEN 'No'
        ELSE 'Yes'
    End AS HawaiianPacIslander,
    CASE
        WHEN PivotedRaceByStudent.W IS NULL THEN 'No'
        ELSE 'Yes'
    End AS White,
    CASE
        WHEN PivotedRaceByStudent.X IS NULL THEN 'No'
        ELSE 'Yes'
    End AS NotReported
FROM
        (
        SELECT ISN_ST_STDNT_A,
            [A],
            [B],
            [I],
            [P],
            [W],
            [X]
        FROM
        (SELECT ISN_ST_STDNT_A, Race, 1 AS Cnter
            FROM ST_STDNT_A_RACE) AS SourceTable
        PIVOT
        (
        SUM(Cnter)
        FOR Race IN ([A], [B], [I], [P], [W], [X])
        ) AS Pivoted
        ) PivotedRaceByStudent