USP_DATAFORMTEMPLATE_VIEW_STUDENTENROLLMENT

The load procedure used by the view dataform template "Student Enrollment View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DATESATTENDED	nvarchar(50)	INOUT	Dates attended
@CURRENTSTATUS	nvarchar(100)	INOUT	Current status
@SCHOOLNAME	nvarchar(154)	INOUT	School name
@STUDENTPROGRESSIONS	xml	INOUT	Student Progressions

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STUDENTENROLLMENT
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @DATESATTENDED nvarchar(50) = null output,
                @CURRENTSTATUS nvarchar(100) = null output,
                @SCHOOLNAME nvarchar(154) = null output,
                @STUDENTPROGRESSIONS xml = null output
            )
            as
                set nocount on;

                -- be sure to set this, in case the select returns no rows

                set @DATALOADED = 0;

                -- populate the output parameters, which correspond to fields on the form.  Note that

                -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

                -- will display a "no data loaded" message.

                select @DATALOADED = 1,
                       @DATESATTENDED = CONVERT(varchar(10),dbo.UFN_DATE_FROMFUZZYDATE(STARTDATE),101) + CASE DATELEFT WHEN '00000000' THEN ' - Present' ELSE +' - ' + CONVERT(varchar(10),dbo.UFN_DATE_FROMFUZZYDATE(DATELEFT),101) END, 
                       @CURRENTSTATUS = dbo.EDUCATIONALHISTORYSTATUS.[DESCRIPTION],
                       @SCHOOLNAME = CONSTIT_SCHOOL.[KEYNAME],
                       @STUDENTPROGRESSIONS = dbo.UFN_STUDENTENROLLMENT_GETPROGRESSIONS_TOITEMLISTXML(@ID)
                from dbo.EDUCATIONALHISTORY
                inner join CONSTITUENT as CONSTIT_SCHOOL on dbo.EDUCATIONALHISTORY.[EDUCATIONALINSTITUTIONID] = CONSTIT_SCHOOL.[ID]
                inner join dbo.EDUCATIONALHISTORYSTATUSHISTORY on dbo.UFN_EDUCATIONALHISTORY_GETCURRENTSTATUSHISTORYID(dbo.EDUCATIONALHISTORY.[ID]) = dbo.EDUCATIONALHISTORYSTATUSHISTORY.[ID]
                inner join dbo.EDUCATIONALHISTORYSTATUS on dbo.EDUCATIONALHISTORYSTATUS.[ID] = dbo.EDUCATIONALHISTORYSTATUSHISTORY.[EDUCATIONALHISTORYSTATUSID]
                where dbo.EDUCATIONALHISTORY.[ID] = @ID

                return 0;