USP_DATAFORMTEMPLATE_ADD_BATCHEDUCATIONALHISTORYUPDATEBATCHCOMMIT

The save procedure used by the add dataform template "Educational History Update Batch Row Commit Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@VALIDATEONLY	bit	IN	Validate only
@PRIMARYCONTEXTRECORDID	uniqueidentifier	IN	Constituent
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@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_ADD_BATCHEDUCATIONALHISTORYUPDATEBATCHCOMMIT(
    @ID uniqueidentifier = null output,
    @VALIDATEONLY bit = 0,
    @PRIMARYCONTEXTRECORDID uniqueidentifier = null,
    @CHANGEAGENTID uniqueidentifier,
    @CONSTITUENTLOOKUPID nvarchar(100) = '',
    @CONSTITUENTKEYNAME nvarchar(100) = '',
    @CONSTITUENTFIRSTNAME nvarchar(50) = '',
    @EDUCATIONALINSTITUTIONID uniqueidentifier = null,
    @EDUCATIONALINSTITUTIONNAME nvarchar(100) = '',
    @EDUCATIONALINSTITUTIONFICECODE nvarchar(50) = '',
    @EDUCATIONALINSTITUTIONCOUNTRYID uniqueidentifier = null,
    @EDUCATIONALINSTITUTIONCITY nvarchar(150) = '',
    @EDUCATIONALINSTITUTIONSTATEID uniqueidentifier = null,
    @ISPRIMARYRECORD bit = 0,
    @ACADEMICCATALOGPROGRAMID uniqueidentifier = null,
    @EDUCATIONALPROGRAMCODEID uniqueidentifier = null,
    @CONSTITUENCYSTATUSCODE tinyint = 0,
    @EDUCATIONALHISTORYREASONCODEID uniqueidentifier = null,
    @EDUCATIONALHISTORYLEVELCODEID uniqueidentifier = null,
    @DATELEFT dbo.UDT_FUZZYDATE = '00000000',
    @DATEGRADUATED dbo.UDT_FUZZYDATE = '00000000',
    @ACADEMICCATALOGDEGREEID uniqueidentifier = null,
    @EDUCATIONALDEGREECODEID uniqueidentifier = null,
    @EDUCATIONALAWARDCODEID uniqueidentifier = null,
    @STARTDATE dbo.UDT_FUZZYDATE = '00000000',
    @CLASSYEAR dbo.UDT_YEAR = 0,
    @PREFERREDCLASSYEAR dbo.UDT_YEAR = 0,
    @EDUCATIONALSOURCECODEID uniqueidentifier = null,
    @EDUCATIONALSOURCEDATE dbo.UDT_FUZZYDATE = '00000000',
    @COMMENT nvarchar(500) = '',
    @AFFILIATEDADDITIONALINFORMATION xml = null,
    @UNAFFILIATEDADDITIONALINFORMATION xml = null,
    @EDUCATIONALINVOLVEMENTS xml = null,
    @EDUCATIONALHISTORYSTATUSID uniqueidentifier = null) as
set nocount on;

declare @CURRENTDATE datetime;

if @ID is null
    set @ID = newid();

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

set @CURRENTDATE = getdate();

begin try


    exec dbo.USP_DATAFORMTEMPLATE_ADD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE @ID = @ID output, @CHANGEAGENTID = @CHANGEAGENTID, @CONSTITUENTID = @PRIMARYCONTEXTRECORDID, @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;