USP_DATAFORMTEMPLATE_EDIT_BATCHEDUCATIONALHISTORYUPDATEBATCHCOMMIT

The save procedure used by the edit dataform template "Educational History Update Batch Row Commit 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.
@VALIDATEONLY	bit	IN	Validate only
@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_BATCHEDUCATIONALHISTORYUPDATEBATCHCOMMIT(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @VALIDATEONLY bit,
    @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;

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

    begin try
    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE @ID = @ID, @CHANGEAGENTID = @CHANGEAGENTID, @VALIDATEONLY = @VALIDATEONLY, @CONSTITUENTLOOKUPID = @CONSTITUENTLOOKUPID, @CONSTITUENTKEYNAME = @CONSTITUENTKEYNAME, @CONSTITUENTFIRSTNAME = @CONSTITUENTFIRSTNAME, @EDUCATIONALINSTITUTIONID = @EDUCATIONALINSTITUTIONID, @EDUCATIONALINSTITUTIONNAME = @EDUCATIONALINSTITUTIONNAME, @EDUCATIONALINSTITUTIONFICECODE = @EDUCATIONALINSTITUTIONFICECODE, @EDUCATIONALINSTITUTIONCOUNTRYID = @EDUCATIONALINSTITUTIONCOUNTRYID, @EDUCATIONALINSTITUTIONCITY = @EDUCATIONALINSTITUTIONCITY, @EDUCATIONALINSTITUTIONSTATEID = @EDUCATIONALINSTITUTIONSTATEID, @ISPRIMARYRECORD = @ISPRIMARYRECORD, @ACADEMICCATALOGPROGRAMID = @ACADEMICCATALOGPROGRAMID, @EDUCATIONALPROGRAMCODEID = @EDUCATIONALPROGRAMCODEID, @CONSTITUENCYSTATUSCODE = @CONSTITUENCYSTATUSCODE, @EDUCATIONALHISTORYREASONCODEID = @EDUCATIONALHISTORYREASONCODEID, @EDUCATIONALHISTORYLEVELCODEID = @EDUCATIONALHISTORYLEVELCODEID, @DATELEFT = @DATELEFT, @DATEGRADUATED = @DATEGRADUATED, @ACADEMICCATALOGDEGREEID = @ACADEMICCATALOGDEGREEID, @EDUCATIONALDEGREECODEID = @EDUCATIONALDEGREECODEID, @EDUCATIONALAWARDCODEID = @EDUCATIONALAWARDCODEID, @STARTDATE = @STARTDATE, @CLASSYEAR = @CLASSYEAR, @PREFERREDCLASSYEAR = @PREFERREDCLASSYEAR, @EDUCATIONALSOURCECODEID = @EDUCATIONALSOURCECODEID, @EDUCATIONALSOURCEDATE = @EDUCATIONALSOURCEDATE, @COMMENT = @COMMENT, @AFFILIATEDADDITIONALINFORMATION = @AFFILIATEDADDITIONALINFORMATION, @UNAFFILIATEDADDITIONALINFORMATION = @UNAFFILIATEDADDITIONALINFORMATION, @EDUCATIONALINVOLVEMENTS = @EDUCATIONALINVOLVEMENTS, @EDUCATIONALHISTORYSTATUSID =@EDUCATIONALHISTORYSTATUSID;

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

return 0;