USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALINVOLVEMENT_2

The load procedure used by the edit dataform template "Educational Involvement Edit Form 2"

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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@EDUCATIONALINVOLVEMENTTYPECODEID	uniqueidentifier	INOUT	Type
@EDUCATIONALINVOLVEMENTNAMEID	uniqueidentifier	INOUT	Name
@DATEFROM	UDT_FUZZYDATE	INOUT	Start date
@DATETO	UDT_FUZZYDATE	INOUT	End date
@EDUCATIONALINSTITUTIONID	uniqueidentifier	INOUT	Educational institution
@COMMENT	nvarchar(500)	INOUT	Notes
@EDUCATIONALINVOLVEMENTAWARDCODEID	uniqueidentifier	INOUT	Award
@ACADEMICCATALOGPROGRAMID	uniqueidentifier	INOUT	Program
@ACADEMICCATALOGCOLLEGEID	uniqueidentifier	INOUT	College/School
@ACADEMICCATALOGDEPARTMENTID	uniqueidentifier	INOUT	Department
@EDUCATIONALPROGRAMCODEID	uniqueidentifier	INOUT	Program
@EDUCATIONALCOLLEGECODEID	uniqueidentifier	INOUT	College/School
@EDUCATIONALDEPARTMENTCODEID	uniqueidentifier	INOUT	Department
@ACADEMICCATALOGDIVISIONID	uniqueidentifier	INOUT	Division
@ACADEMICCATALOGSUBDEPARTMENTID	uniqueidentifier	INOUT	Sub department
@EDUCATIONALDIVISIONCODEID	uniqueidentifier	INOUT	Division
@EDUCATIONALSUBDEPARTMENTCODEID	uniqueidentifier	INOUT	Sub department
@POSITION	nvarchar(256)	INOUT	Position

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALINVOLVEMENT_2
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @CONSTITUENTID uniqueidentifier = null output,
    @EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier = null output,
    @EDUCATIONALINVOLVEMENTNAMEID uniqueidentifier = null output,
    @DATEFROM dbo.UDT_FUZZYDATE = null output,
    @DATETO dbo.UDT_FUZZYDATE = null output,
    @EDUCATIONALINSTITUTIONID uniqueidentifier = null output,
    @COMMENT nvarchar(500) = null output,
    @EDUCATIONALINVOLVEMENTAWARDCODEID uniqueidentifier = null output,
    @ACADEMICCATALOGPROGRAMID uniqueidentifier = null output,
    @ACADEMICCATALOGCOLLEGEID uniqueidentifier = null output,
    @ACADEMICCATALOGDEPARTMENTID uniqueidentifier = null output,
    @EDUCATIONALPROGRAMCODEID uniqueidentifier = null output,
    @EDUCATIONALCOLLEGECODEID uniqueidentifier = null output,
    @EDUCATIONALDEPARTMENTCODEID uniqueidentifier = null output,
    @ACADEMICCATALOGDIVISIONID uniqueidentifier = null output,
    @ACADEMICCATALOGSUBDEPARTMENTID uniqueidentifier = null output,
    @EDUCATIONALDIVISIONCODEID uniqueidentifier = null output,
    @EDUCATIONALSUBDEPARTMENTCODEID uniqueidentifier = null output,
    @POSITION nvarchar(256) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @CONSTITUENTID = CONSTITUENTID,
        @EDUCATIONALINVOLVEMENTTYPECODEID = EDUCATIONALINVOLVEMENTTYPECODEID,
        @EDUCATIONALINVOLVEMENTNAMEID = EDUCATIONALINVOLVEMENTNAMEID,
        @DATEFROM = DATEFROM,
        @DATETO = DATETO,
        @EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTIONID,
        @COMMENT = COMMENT,
        @EDUCATIONALINVOLVEMENTAWARDCODEID = EDUCATIONALINVOLVEMENTAWARDCODEID,
        @TSLONG = TSLONG,
        @ACADEMICCATALOGPROGRAMID = ACADEMICCATALOGPROGRAMID,
        @ACADEMICCATALOGCOLLEGEID = ACADEMICCATALOGCOLLEGEID,
        @ACADEMICCATALOGDEPARTMENTID = ACADEMICCATALOGDEPARTMENTID,
        @EDUCATIONALPROGRAMCODEID = EDUCATIONALPROGRAMCODEID,
        @EDUCATIONALCOLLEGECODEID = EDUCATIONALCOLLEGECODEID,
        @EDUCATIONALDEPARTMENTCODEID = EDUCATIONALDEPARTMENTCODEID,
        @ACADEMICCATALOGDIVISIONID = ACADEMICCATALOGDIVISIONID,
        @ACADEMICCATALOGSUBDEPARTMENTID = ACADEMICCATALOGSUBDEPARTMENTID,
        @EDUCATIONALDIVISIONCODEID = EDUCATIONALDIVISIONCODEID,
        @EDUCATIONALSUBDEPARTMENTCODEID = EDUCATIONALSUBDEPARTMENTCODEID,
        @POSITION = POSITION
    from
        dbo.EDUCATIONALINVOLVEMENT
    where
        ID = @ID;

    return 0;