USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITEDUCATIONALINVOLVEMENTDATA

The load procedure used by the view dataform template "NetCommunity Constituent Educational Involvement Data 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.
@EDUCATIONALINSTITUTION	nvarchar(100)	INOUT	EDUCATIONALINSTITUTION
@TYPE	nvarchar(100)	INOUT	TYPE
@STARTDATE	UDT_FUZZYDATE	INOUT	STARTDATE
@ENDDATE	UDT_FUZZYDATE	INOUT	ENDDATE
@NAME	nvarchar(150)	INOUT	NAME
@NOTES	nvarchar(500)	INOUT	NOTES
@PROGRAM	nvarchar(100)	INOUT	PROGRAM
@COLLEGE	nvarchar(100)	INOUT	COLLEGE
@DIVISION	nvarchar(100)	INOUT	DIVISION
@DEPARTMENT	nvarchar(100)	INOUT	DEPARTMENT
@SUBDEPARTMENT	nvarchar(100)	INOUT	SUBDEPARTMENT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITEDUCATIONALINVOLVEMENTDATA
                (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @EDUCATIONALINSTITUTION nvarchar(100) = null output,
          @TYPE nvarchar(100) = null output,
          @STARTDATE dbo.UDT_FUZZYDATE = null output,
          @ENDDATE dbo.UDT_FUZZYDATE = null output,
          @NAME nvarchar(150) = null output,
          @NOTES nvarchar(500) = null output,
          @PROGRAM nvarchar(100) = null output,
          @COLLEGE nvarchar(100) = null output,
          @DIVISION nvarchar(100) = null output,
          @DEPARTMENT nvarchar(100) = null output,
          @SUBDEPARTMENT nvarchar(100) = null output
                )
        as
        set nocount on;
        set @DATALOADED = 0;

        declare @T table(
          EDUCATIONALINSTITUTION nvarchar(100), 
          TYPE nvarchar(100),
          STARTDATE dbo.UDT_FUZZYDATE,
          ENDDATE dbo.UDT_FUZZYDATE,
          NAME nvarchar(150),
          NOTES nvarchar(500),
          PROGRAM nvarchar(100),
          COLLEGE nvarchar(100),
          DIVISION nvarchar(100),
          DEPARTMENT nvarchar(100),
          SUBDEPARTMENT nvarchar(100)
        );

        insert into @T 
        (
          EDUCATIONALINSTITUTION, 
          TYPE,
          STARTDATE,
          ENDDATE,
          NAME,
          NOTES,
          PROGRAM,
          COLLEGE,
          DIVISION,
          DEPARTMENT,
          SUBDEPARTMENT
        )
        select
          EDUCATIONALINSTITUTION.NAME,
          EDUCATIONALINVOLVEMENTTYPECODE.DESCRIPTION,
          EDUCATIONALINVOLVEMENT.DATEFROM,
          EDUCATIONALINVOLVEMENT.DATETO,
          EDUCATIONALINVOLVEMENTNAME.NAME,
          EDUCATIONALINVOLVEMENT.COMMENT,
          EDUCATIONALPROGRAMCODE.DESCRIPTION,
          EDUCATIONALCOLLEGECODE.DESCRIPTION,
          EDUCATIONALDIVISIONCODE.DESCRIPTION,
          EDUCATIONALDEPARTMENTCODE.DESCRIPTION,
          EDUCATIONALSUBDEPARTMENTCODE.DESCRIPTION
        from
          dbo.EDUCATIONALINVOLVEMENT
        left join 
          dbo.EDUCATIONALINSTITUTION on EDUCATIONALINVOLVEMENT.EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTION.ID
        inner join
          dbo.EDUCATIONALINVOLVEMENTTYPECODE on EDUCATIONALINVOLVEMENT.EDUCATIONALINVOLVEMENTTYPECODEID = EDUCATIONALINVOLVEMENTTYPECODE.ID
        inner join
          dbo.EDUCATIONALINVOLVEMENTNAME on EDUCATIONALINVOLVEMENT.EDUCATIONALINVOLVEMENTNAMEID = EDUCATIONALINVOLVEMENTNAME.ID
        left join
          dbo.EDUCATIONALPROGRAMCODE on EDUCATIONALINVOLVEMENT.EDUCATIONALPROGRAMCODEID = EDUCATIONALPROGRAMCODE.ID
        left join
          dbo.EDUCATIONALCOLLEGECODE on EDUCATIONALINVOLVEMENT.EDUCATIONALCOLLEGECODEID = EDUCATIONALCOLLEGECODE.ID
        left join
          dbo.EDUCATIONALDIVISIONCODE on EDUCATIONALINVOLVEMENT.EDUCATIONALDIVISIONCODEID = EDUCATIONALDIVISIONCODE.ID
        left join
          dbo.EDUCATIONALDEPARTMENTCODE on EDUCATIONALINVOLVEMENT.EDUCATIONALDEPARTMENTCODEID = EDUCATIONALDEPARTMENTCODE.ID
        left join
          dbo.EDUCATIONALSUBDEPARTMENTCODE on EDUCATIONALINVOLVEMENT.EDUCATIONALSUBDEPARTMENTCODEID = EDUCATIONALSUBDEPARTMENTCODE.ID
        where 
          EDUCATIONALINVOLVEMENT.ID = @ID;

        select top 1 
          @EDUCATIONALINSTITUTION = EDUCATIONALINSTITUTION,
          @TYPE = TYPE,
          @STARTDATE = STARTDATE,
          @ENDDATE = ENDDATE,
          @NAME = NAME,
          @NOTES = NOTES,
          @PROGRAM = PROGRAM,
          @COLLEGE = COLLEGE,
          @DIVISION = DIVISION,
          @DEPARTMENT = DEPARTMENT,
          @SUBDEPARTMENT = SUBDEPARTMENT,
          @DATALOADED = 1
        from @T

        return 0;