USP_DATAFORMTEMPLATE_VIEW_EDUCATIONALHISTORYLIST

The load procedure used by the view dataform template "Educational History List 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.
@NAME	nvarchar(100)	INOUT	Name
@ISPRIMARY	bit	INOUT	Primary
@TYPE	nvarchar(255)	INOUT	Type
@CONSTITUENCYSTATUS	nvarchar(255)	INOUT	Status
@DEGREE	nvarchar(255)	INOUT	Degree
@STARTDATE	UDT_FUZZYDATE	INOUT	Start date
@ENDDATE	UDT_FUZZYDATE	INOUT	End date
@MAJOR	nvarchar(255)	INOUT	Major
@MINOR	nvarchar(255)	INOUT	Minor
@GPA	nvarchar(5)	INOUT	GPA
@CLASSOF	nvarchar(4)	INOUT	Class of
@KNOWNNAME	nvarchar(50)	INOUT	Known name
@FRATERNITY	nvarchar(50)	INOUT	Greek affiliation

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EDUCATIONALHISTORYLIST (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @ISPRIMARY bit = null output,
                    @TYPE nvarchar(255) = null output,
                    @CONSTITUENCYSTATUS nvarchar(255) = null output,
                    @DEGREE nvarchar(255) = null output,
                    @STARTDATE dbo.UDT_FUZZYDATE = null output,
                    @ENDDATE dbo.UDT_FUZZYDATE = null output,
                    @MAJOR nvarchar(255) = null output,
                    @MINOR nvarchar(255) = null output,
                    @GPA nvarchar(5) = null output,
                    @CLASSOF nvarchar(4) = null output,
                    @KNOWNNAME nvarchar(50) = null output,
                    @FRATERNITY nvarchar(50) = null output
                ) as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    select distinct
                        @DATALOADED = 1,
                        @NAME = INSTITUTION.NAME,
                        @ISPRIMARY = HISTORY.ISPRIMARYRECORD,
                        @TYPE = TYPE.DESCRIPTION,
                        @CONSTITUENCYSTATUS = HISTORY.CONSTITUENCYSTATUS,
                        @DEGREE = DEGREE.DESCRIPTION,
                        @STARTDATE = HISTORY.STARTDATE,
                        @ENDDATE = HISTORY.ENDDATE,
                        @MAJOR = dbo.UFN_EDUCATIONALMAJOR_GETNAME(HISTORY.ID),
                        @MINOR = dbo.UFN_EDUCATIONALMINOR_GETNAME(HISTORY.ID),
                        @GPA =     case when HISTORY.GPA = 0 then '' else cast(HISTORY.GPA as nvarchar(5)) end,
                        @CLASSOF =     case when HISTORY.CLASSOF = 0 then '' else cast(HISTORY.CLASSOF as nvarchar(4))    end,
                        @KNOWNNAME = HISTORY.KNOWNNAME,
                        @FRATERNITY = HISTORY.FRATERNITY

                    from dbo.EDUCATIONALHISTORY as HISTORY
                        inner join dbo.EDUCATIONALINSTITUTION as INSTITUTION on HISTORY.EDUCATIONALINSTITUTIONID = INSTITUTION.ID
                        left join dbo.EDUCATIONALDEGREECODE as DEGREE on HISTORY.EDUCATIONALDEGREECODEID = DEGREE.ID
                        left join dbo.EDUCATIONALHISTORYTYPECODE as TYPE on HISTORY.EDUCATIONALHISTORYTYPECODEID = TYPE.ID
                        left join dbo.EDUCATIONALHISTORYSTATUSCODE as STATUS on HISTORY.EDUCATIONALHISTORYSTATUSCODEID = STATUS.ID                
                    where
                        HISTORY.ID = @ID;

                    return 0;

                end