USP_DATAFORMTEMPLATE_VIEW_EDUCATIONALINVOLVEMENT

The load procedure used by the view dataform template "Educational Involvement 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.
@PROGRAM	nvarchar(100)	INOUT	Program
@COLLEGE	nvarchar(100)	INOUT	College/School
@DEPARTMENT	nvarchar(100)	INOUT	Department
@AWARD	nvarchar(100)	INOUT	Award
@COMMENT	nvarchar(max)	INOUT	Notes
@DIVISION	nvarchar(100)	INOUT	Division
@SUBDEPARTMENT	nvarchar(100)	INOUT	Sub department

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EDUCATIONALINVOLVEMENT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @PROGRAM nvarchar(100) = null output,
    @COLLEGE nvarchar(100) = null output,
    @DEPARTMENT nvarchar(100) = null output,
    @AWARD nvarchar(100) = null output,
    @COMMENT nvarchar(max) = null output,
    @DIVISION nvarchar(100) = null output,
    @SUBDEPARTMENT nvarchar(100) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @PROGRAM = case
            when ACADEMICCATALOGPROGRAMID is not null then dbo.UFN_ACADEMICCATALOGPROGRAM_GETNAME(ACADEMICCATALOGPROGRAMID)
            when EDUCATIONALPROGRAMCODEID is not null then dbo.UFN_EDUCATIONALPROGRAMCODE_GETDESCRIPTION(EDUCATIONALPROGRAMCODEID)
        end,
        @COLLEGE = case
            when ACADEMICCATALOGCOLLEGEID is not null then dbo.UFN_ACADEMICCATALOGCOLLEGE_GETNAME(ACADEMICCATALOGCOLLEGEID)
            when EDUCATIONALCOLLEGECODEID is not null then dbo.UFN_EDUCATIONALCOLLEGECODE_GETDESCRIPTION(EDUCATIONALCOLLEGECODEID)
        end,
        @DIVISION = case
            when ACADEMICCATALOGDIVISIONID is not null then dbo.UFN_ACADEMICCATALOGDIVISION_GETNAME(ACADEMICCATALOGDIVISIONID)
            when EDUCATIONALDIVISIONCODEID is not null then dbo.UFN_EDUCATIONALDIVISIONCODE_GETDESCRIPTION(EDUCATIONALDIVISIONCODEID)
        end,
        @DEPARTMENT = case
            when ACADEMICCATALOGDEPARTMENTID is not null then dbo.UFN_ACADEMICCATALOGDEPARTMENT_GETNAME(ACADEMICCATALOGDEPARTMENTID)
            when EDUCATIONALDEPARTMENTCODEID is not null then dbo.UFN_EDUCATIONALDEPARTMENTCODE_GETDESCRIPTION(EDUCATIONALDEPARTMENTCODEID)
        end,
        @SUBDEPARTMENT = case
            when ACADEMICCATALOGSUBDEPARTMENTID is not null then dbo.UFN_ACADEMICCATALOGSUBDEPARTMENT_GETNAME(ACADEMICCATALOGSUBDEPARTMENTID)
            when EDUCATIONALSUBDEPARTMENTCODEID is not null then dbo.UFN_EDUCATIONALSUBDEPARTMENTCODE_GETDESCRIPTION(EDUCATIONALSUBDEPARTMENTCODEID)
        end,
        @AWARD = dbo.UFN_EDUCATIONINVOLVEMENTAWARDCODE_GETDESCRIPTION(EDUCATIONALINVOLVEMENTAWARDCODEID),
        @COMMENT = COMMENT
    from 
        dbo.EDUCATIONALINVOLVEMENT
    where 
        ID = @ID;

    return 0;