USP_DATAFORMTEMPLATE_VIEW_OUTSIDEEDUCATION

The load procedure used by the view dataform template "Outside Education 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.
@EDUCATIONALINSTITUTIONNAME	nvarchar(100)	INOUT	EDUCATIONALINSTITUTIONNAME
@GRADELEVELENROLLED	nvarchar(100)	INOUT	Grade enrolled
@GRADELEVELLEFT	nvarchar(100)	INOUT	Grade left
@REASONLEFT	nvarchar(100)	INOUT	Reason left
@EDUCATIONALHISTORYSTATUS	nvarchar(100)	INOUT	Current status
@STARTDATE	UDT_FUZZYDATE	INOUT	STARTDATE
@DATELEFT	UDT_FUZZYDATE	INOUT	DATELEFT
@GRADUATIONDATE	UDT_FUZZYDATE	INOUT	Graduation date
@CLASSOF	UDT_YEAR	INOUT	Class of
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@CONSTITUENTNAME	nvarchar(400)	INOUT	CONSTITUENTNAME
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_OUTSIDEEDUCATION
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @EDUCATIONALINSTITUTIONNAME nvarchar(100) = null output,
                    @GRADELEVELENROLLED nvarchar(100) = null output,
                    @GRADELEVELLEFT nvarchar(100) = null output,
                    @REASONLEFT nvarchar(100) = null output,
                    @EDUCATIONALHISTORYSTATUS nvarchar(100) = null output,
                    @STARTDATE UDT_FUZZYDATE = null output,
                    @DATELEFT UDT_FUZZYDATE = null output,
                    @GRADUATIONDATE UDT_FUZZYDATE = null output,
                    @CLASSOF UDT_YEAR = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @CONSTITUENTNAME nvarchar(400) = null output,
                    @ATTRIBUTEDEFINED bit = null output,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select @DATALOADED = 1,
                           @EDUCATIONALINSTITUTIONNAME = EDUCATIONALINSTITUTION_CONSTITUENT.KEYNAME,
                           @GRADELEVELENROLLED = GRADELEVELENROLLED.DESCRIPTION,
                           @GRADELEVELLEFT = GRADELEVELLEFT.DESCRIPTION,
                           @REASONLEFT = EDUCATIONALREASONLEFTCODE.DESCRIPTION,
                           @EDUCATIONALHISTORYSTATUS = EDUCATIONALHISTORYSTATUS.DESCRIPTION,
                           @STARTDATE = EDUCATIONALHISTORY.STARTDATE,
                           @DATELEFT = EDUCATIONALHISTORY.DATELEFT,
                           @GRADUATIONDATE = EDUCATIONALHISTORY.DATEGRADUATED,
                           @CLASSOF = EDUCATIONALHISTORY.CLASSOF,
                           @CONSTITUENTID = CONSTITUENT.ID,
                           @CONSTITUENTNAME = CONSTITUENT.NAME,
                           @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('EDUCATIONAL HISTORY', @CURRENTAPPUSERID)
                    from dbo.EDUCATIONALHISTORY
                        left outer join dbo.GRADELEVEL as GRADELEVELENROLLED
                            on EDUCATIONALHISTORY.GRADELEVELENROLLEDID = GRADELEVELENROLLED.ID
                        left outer join dbo.GRADELEVEL as GRADELEVELLEFT
                            on EDUCATIONALHISTORY.GRADELEVELLEFTID = GRADELEVELLEFT.ID
                        left outer join dbo.EDUCATIONALHISTORYSTATUS
                            on EDUCATIONALHISTORYSTATUS.ID = EDUCATIONALHISTORY.EDUCATIONALHISTORYSTATUSID
                        left outer join dbo.EDUCATIONALREASONLEFTCODE
                            on EDUCATIONALREASONLEFTCODE.ID = EDUCATIONALHISTORY.EDUCATIONALREASONLEFTCODEID
                        inner join dbo.CONSTITUENT as EDUCATIONALINSTITUTION_CONSTITUENT
                            on EDUCATIONALINSTITUTION_CONSTITUENT.ID = EDUCATIONALHISTORY.EDUCATIONALINSTITUTIONID
                        inner join dbo.CONSTITUENT 
                            on CONSTITUENT.ID = EDUCATIONALHISTORY.CONSTITUENTID
                    where EDUCATIONALHISTORY.ID = @ID

                    return 0;