USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALINVOLVEMENT_2

Maintained for backwards compatibility

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EDUCATIONALINVOLVEMENTTYPECODEID	uniqueidentifier	IN	Type
@EDUCATIONALINVOLVEMENTNAMEID	uniqueidentifier	IN	Name
@DATEFROM	UDT_FUZZYDATE	IN	Date from
@DATETO	UDT_FUZZYDATE	IN	Date to
@EDUCATIONALINSTITUTIONID	uniqueidentifier	IN	Educational institution
@COMMENT	nvarchar(500)	IN	Notes
@EDUCATIONALINVOLVEMENTAWARDCODEID	uniqueidentifier	IN	Award

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALINVOLVEMENT_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier,
    @EDUCATIONALINVOLVEMENTNAMEID uniqueidentifier,
    @DATEFROM dbo.UDT_FUZZYDATE,
    @DATETO dbo.UDT_FUZZYDATE,
    @EDUCATIONALINSTITUTIONID uniqueidentifier,
    @COMMENT nvarchar(500),
    @EDUCATIONALINVOLVEMENTAWARDCODEID uniqueidentifier
)
as
begin

set nocount on

declare @ACADEMICCATALOGPROGRAMID uniqueidentifier
declare @ACADEMICCATALOGCOLLEGEID uniqueidentifier
declare @ACADEMICCATALOGDEPARTMENTID uniqueidentifier
declare @EDUCATIONALDEPARTMENTCODEID uniqueidentifier

declare @DATALOADED bit
declare @TSLONG bigint
declare @CONSTITUENTID uniqueidentifier
declare @EDUCATIONALINVOLVEMENTTYPECODEID_OLD uniqueidentifier
declare @EDUCATIONALINVOLVEMENTNAMEID_OLD uniqueidentifier
declare @DATEFROM_OLD dbo.UDT_FUZZYDATE
declare @DATETO_OLD dbo.UDT_FUZZYDATE
declare @EDUCATIONALINSTITUTIONID_OLD uniqueidentifier
declare @COMMENT_OLD nvarchar(500)
declare @EDUCATIONALINVOLVEMENTAWARDCODEID_OLD uniqueidentifier

exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALINVOLVEMENT_2 @ID, @DATALOADED output, @TSLONG output,
                        @CONSTITUENTID output, 
                        @EDUCATIONALINVOLVEMENTTYPECODEID_OLD output,
                        @EDUCATIONALINVOLVEMENTNAMEID_OLD output,
                        @DATEFROM_OLD output,
                        @DATETO_OLD output,
                        @EDUCATIONALINSTITUTIONID_OLD output,
                        @COMMENT_OLD output,
                        @EDUCATIONALINVOLVEMENTAWARDCODEID_OLD output,
                        @ACADEMICCATALOGPROGRAMID output,
                        @ACADEMICCATALOGCOLLEGEID output,
                        @ACADEMICCATALOGDEPARTMENTID output,
                        @EDUCATIONALDEPARTMENTCODEID output

exec.USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALINVOLVEMENT_3
                        @ID,
                        @CHANGEAGENTID,
                        @EDUCATIONALINVOLVEMENTTYPECODEID,
                        @EDUCATIONALINVOLVEMENTNAMEID,
                        @DATEFROM,
                        @DATETO,
                        @EDUCATIONALINSTITUTIONID,
                        @COMMENT,
                        @EDUCATIONALINVOLVEMENTAWARDCODEID,
                        @ACADEMICCATALOGPROGRAMID,
                        @ACADEMICCATALOGCOLLEGEID,
                        @ACADEMICCATALOGDEPARTMENTID,
                        @EDUCATIONALDEPARTMENTCODEID

end