USP_DATAFORMTEMPLATE_EDIT_BATCHEDUCATIONALHISTORYUPDATEBATCHROW

The save procedure used by the edit dataform template "Educational History Update Batch Row Edit Form".

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.
@SEQUENCE	int	IN	Sequence
@PRIMARYRECORDID	uniqueidentifier	IN	Educational history
@PRIMARYCONTEXTRECORDID	uniqueidentifier	IN	Constituent
@CONSTITUENTLOOKUPID	nvarchar(100)	IN	Lookup ID
@CONSTITUENTKEYNAME	nvarchar(100)	IN	Last name
@CONSTITUENTFIRSTNAME	nvarchar(50)	IN	First name
@EDUCATIONALINSTITUTIONID	uniqueidentifier	IN	Educational institution
@EDUCATIONALINSTITUTIONNAME	nvarchar(100)	IN	Educational institution name
@EDUCATIONALINSTITUTIONFICECODE	nvarchar(50)	IN	Educational institution FICE code
@EDUCATIONALINSTITUTIONCOUNTRYID	uniqueidentifier	IN	Educational institution country
@EDUCATIONALINSTITUTIONCITY	nvarchar(150)	IN	Educational institution city
@EDUCATIONALINSTITUTIONSTATEID	uniqueidentifier	IN	Educational institution state
@ISPRIMARYRECORD	bit	IN	Primary education information
@ACADEMICCATALOGPROGRAMID	uniqueidentifier	IN	Academic catalog program
@EDUCATIONALPROGRAMCODEID	uniqueidentifier	IN	Educational program
@CONSTITUENCYSTATUSCODE	tinyint	IN	Status
@EDUCATIONALHISTORYREASONCODEID	uniqueidentifier	IN	Reason
@EDUCATIONALHISTORYLEVELCODEID	uniqueidentifier	IN	Level
@DATELEFT	UDT_FUZZYDATE	IN	Date attended to
@DATEGRADUATED	UDT_FUZZYDATE	IN	Graduation date
@ACADEMICCATALOGDEGREEID	uniqueidentifier	IN	Academic catalog degree
@EDUCATIONALDEGREECODEID	uniqueidentifier	IN	Educational degree
@EDUCATIONALAWARDCODEID	uniqueidentifier	IN	Honor awarded
@STARTDATE	UDT_FUZZYDATE	IN	Date attended from
@CLASSYEAR	UDT_YEAR	IN	Class of
@PREFERREDCLASSYEAR	UDT_YEAR	IN	Preferred class of
@EDUCATIONALSOURCECODEID	uniqueidentifier	IN	Information source
@EDUCATIONALSOURCEDATE	UDT_FUZZYDATE	IN	Source date
@COMMENT	nvarchar(500)	IN	Comments
@AFFILIATEDADDITIONALINFORMATION	xml	IN	Academic catalog additional information
@UNAFFILIATEDADDITIONALINFORMATION	xml	IN	Educational additional information
@EDUCATIONALINVOLVEMENTS	xml	IN	Educational involvements
@EDUCATIONALHISTORYSTATUSID	uniqueidentifier	IN	Status

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEDUCATIONALHISTORYUPDATEBATCHROW(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @PRIMARYRECORDID uniqueidentifier,
    @PRIMARYCONTEXTRECORDID uniqueidentifier,
    @CONSTITUENTLOOKUPID nvarchar(100),
    @CONSTITUENTKEYNAME nvarchar(100),
    @CONSTITUENTFIRSTNAME nvarchar(50),
    @EDUCATIONALINSTITUTIONID uniqueidentifier,
    @EDUCATIONALINSTITUTIONNAME nvarchar(100),
    @EDUCATIONALINSTITUTIONFICECODE nvarchar(50),
    @EDUCATIONALINSTITUTIONCOUNTRYID uniqueidentifier,
    @EDUCATIONALINSTITUTIONCITY nvarchar(150),
    @EDUCATIONALINSTITUTIONSTATEID uniqueidentifier,
    @ISPRIMARYRECORD bit,
    @ACADEMICCATALOGPROGRAMID uniqueidentifier,
    @EDUCATIONALPROGRAMCODEID uniqueidentifier,
    @CONSTITUENCYSTATUSCODE tinyint,
    @EDUCATIONALHISTORYREASONCODEID uniqueidentifier,
    @EDUCATIONALHISTORYLEVELCODEID uniqueidentifier,
    @DATELEFT dbo.UDT_FUZZYDATE,
    @DATEGRADUATED dbo.UDT_FUZZYDATE,
    @ACADEMICCATALOGDEGREEID uniqueidentifier,
    @EDUCATIONALDEGREECODEID uniqueidentifier,
    @EDUCATIONALAWARDCODEID uniqueidentifier,
    @STARTDATE dbo.UDT_FUZZYDATE,
    @CLASSYEAR dbo.UDT_YEAR,
    @PREFERREDCLASSYEAR dbo.UDT_YEAR,
    @EDUCATIONALSOURCECODEID uniqueidentifier,
    @EDUCATIONALSOURCEDATE dbo.UDT_FUZZYDATE,
    @COMMENT nvarchar(500),
    @AFFILIATEDADDITIONALINFORMATION xml,
    @UNAFFILIATEDADDITIONALINFORMATION xml,
    @EDUCATIONALINVOLVEMENTS xml,
    @EDUCATIONALHISTORYSTATUSID uniqueidentifier) as
set nocount on;

declare @CURRENTDATE datetime;

if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

set @CURRENTDATE = getdate();

begin try
update dbo.BATCHEDUCATIONALHISTORYUPDATE
    set [SEQUENCE] = @SEQUENCE,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE,
        [PRIMARYRECORDID] = @PRIMARYRECORDID,
        [PRIMARYCONTEXTRECORDID] = @PRIMARYCONTEXTRECORDID,
        [CONSTITUENTLOOKUPID] = coalesce(@CONSTITUENTLOOKUPID, ''),
        [CONSTITUENTKEYNAME] = coalesce(@CONSTITUENTKEYNAME, ''),
        [CONSTITUENTFIRSTNAME] = coalesce(@CONSTITUENTFIRSTNAME, ''),
        [EDUCATIONALINSTITUTIONID] = @EDUCATIONALINSTITUTIONID,
        [EDUCATIONALINSTITUTIONNAME] = coalesce(@EDUCATIONALINSTITUTIONNAME, ''),
        [EDUCATIONALINSTITUTIONFICECODE] = coalesce(@EDUCATIONALINSTITUTIONFICECODE, ''),
        [EDUCATIONALINSTITUTIONCOUNTRYID] = @EDUCATIONALINSTITUTIONCOUNTRYID,
        [EDUCATIONALINSTITUTIONCITY] = coalesce(@EDUCATIONALINSTITUTIONCITY, ''),
        [EDUCATIONALINSTITUTIONSTATEID] = @EDUCATIONALINSTITUTIONSTATEID,
        [ISPRIMARYRECORD] = coalesce(@ISPRIMARYRECORD, 0),
        [ACADEMICCATALOGPROGRAMID] = @ACADEMICCATALOGPROGRAMID,
        [EDUCATIONALPROGRAMCODEID] = @EDUCATIONALPROGRAMCODEID,
        [CONSTITUENCYSTATUSCODE] = coalesce(@CONSTITUENCYSTATUSCODE, 0),
        [EDUCATIONALHISTORYREASONCODEID] = @EDUCATIONALHISTORYREASONCODEID,
        [EDUCATIONALHISTORYLEVELCODEID] = @EDUCATIONALHISTORYLEVELCODEID,
        [DATELEFT] = coalesce(@DATELEFT, '00000000'),
        [DATEGRADUATED] = coalesce(@DATEGRADUATED, '00000000'),
        [ACADEMICCATALOGDEGREEID] = @ACADEMICCATALOGDEGREEID,
        [EDUCATIONALDEGREECODEID] = @EDUCATIONALDEGREECODEID,
        [EDUCATIONALAWARDCODEID] = @EDUCATIONALAWARDCODEID,
        [STARTDATE] = coalesce(@STARTDATE, '00000000'),
        [CLASSYEAR] = coalesce(@CLASSYEAR, 0),
        [PREFERREDCLASSYEAR] = coalesce(@PREFERREDCLASSYEAR, 0),
        [EDUCATIONALSOURCECODEID] = @EDUCATIONALSOURCECODEID,
        [EDUCATIONALSOURCEDATE] = coalesce(@EDUCATIONALSOURCEDATE, '00000000'),
        [COMMENT] = coalesce(@COMMENT, ''),
        [EDUCATIONALHISTORYSTATUSID]=coalesce(@EDUCATIONALHISTORYSTATUSID,'00000000-0000-0000-0000-000000000001')
    where
        ID = @ID

exec dbo.USP_BATCHEDUCATIONALHISTORYUPDATE_GETAFFILIATEDADDITIONALINFORMATION_UPDATEFROMXML @ID, @AFFILIATEDADDITIONALINFORMATION, @CHANGEAGENTID


exec dbo.USP_BATCHEDUCATIONALHISTORYUPDATE_GETUNAFFILIATEDADDITIONALINFORMATION_UPDATEFROMXML @ID, @UNAFFILIATEDADDITIONALINFORMATION, @CHANGEAGENTID


exec dbo.USP_BATCHEDUCATIONALHISTORYUPDATE_GETEDUCATIONALINVOLVEMENTS_UPDATEFROMXML @ID, @EDUCATIONALINVOLVEMENTS, @CHANGEAGENTID

end try
begin catch
    exec.dbo.USP_RAISE_ERROR;
    return 1;
end catch

return 0;