V_QUERY_STUDENT_PROGRESSION

Provides support for querying on Student Progression information.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
ENROLLMENTID	uniqueidentifier		ENROLLMENTID
SCHOOL	nvarchar(100)	yes	School
ACADEMICYEARNAME	nvarchar(100)	yes	Academic year
GRADELEVEL	nvarchar(10)	yes	Grade level
HOMEROOMTEACHERID	uniqueidentifier	yes	Homeroom teacher
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  4/29/2010 7:31:38 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_STUDENT_PROGRESSION AS



                select
                    STUDENTPROGRESSION.[ID],
                    STUDENTPROGRESSION.[ENROLLMENTID],
                    [CONSTIT_SCHOOL].[KEYNAME] AS [SCHOOL],
                    ACADEMICYEARNAMECODE.[DESCRIPTION] AS ACADEMICYEARNAME,
                    GRADELEVEL.[ABBREVIATION] AS [GRADELEVEL],
                    STUDENTPROGRESSION.[HOMEROOMTEACHERID],
                    ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
                    CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
                    STUDENTPROGRESSION.[DATEADDED],
                    STUDENTPROGRESSION.[DATECHANGED],
                    STUDENTPROGRESSION.[TSLONG]
                from 
                    dbo.STUDENTPROGRESSION
                    left join dbo. SCHOOLGRADELEVEL on dbo.STUDENTPROGRESSION.[SCHOOLGRADELEVELID] = dbo.SCHOOLGRADELEVEL.[ID]
                    left join dbo.SCHOOL on dbo.SCHOOLGRADELEVEL.[SCHOOLID] = dbo.SCHOOL.[ID]
                    left join dbo.CONSTITUENT as [CONSTIT_SCHOOL] on dbo.SCHOOL.[ID] = [CONSTIT_SCHOOL].[ID]
                    left join dbo.GRADELEVEL on dbo.SCHOOLGRADELEVEL.[GRADELEVELID] = GRADELEVEL.[ID]
                    left join dbo.ACADEMICYEAR on dbo.ACADEMICYEAR.[ID] =  dbo.UFN_ACADEMICYEAR_GET_FORSCHOOL_BYDATE(dbo.SCHOOLGRADELEVEL.[SCHOOLID], dbo.STUDENTPROGRESSION.[STARTDATE], dbo.STUDENTPROGRESSION.[ENDDATE])
                    left join dbo.ACADEMICYEARNAMECODE on dbo.ACADEMICYEARNAMECODE.ID = dbo.ACADEMICYEAR.ACADEMICYEARNAMECODEID 
                    left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = dbo.STUDENTPROGRESSION.[ADDEDBYID]
                    left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = dbo.STUDENTPROGRESSION.[CHANGEDBYID]