USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEDUCATIONALHISTORYUPDATEBATCHCOMMIT

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

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEDUCATIONALHISTORYUPDATEBATCHCOMMIT(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @VALIDATEONLY bit = null output,
    @CONSTITUENTLOOKUPID nvarchar(100) = null output,
    @CONSTITUENTKEYNAME nvarchar(100) = null output,
    @CONSTITUENTFIRSTNAME nvarchar(50) = null output,
    @EDUCATIONALINSTITUTIONID uniqueidentifier = null output,
    @EDUCATIONALINSTITUTIONNAME nvarchar(100) = null output,
    @EDUCATIONALINSTITUTIONFICECODE nvarchar(50) = null output,
    @EDUCATIONALINSTITUTIONCOUNTRYID uniqueidentifier = null output,
    @EDUCATIONALINSTITUTIONCITY nvarchar(150) = null output,
    @EDUCATIONALINSTITUTIONSTATEID uniqueidentifier = null output,
    @ISPRIMARYRECORD bit = null output,
    @ACADEMICCATALOGPROGRAMID uniqueidentifier = null output,
    @EDUCATIONALPROGRAMCODEID uniqueidentifier = null output,
    @CONSTITUENCYSTATUSCODE tinyint = null output,
    @EDUCATIONALHISTORYREASONCODEID uniqueidentifier = null output,
    @EDUCATIONALHISTORYLEVELCODEID uniqueidentifier = null output,
    @DATELEFT dbo.UDT_FUZZYDATE = null output,
    @DATEGRADUATED dbo.UDT_FUZZYDATE = null output,
    @ACADEMICCATALOGDEGREEID uniqueidentifier = null output,
    @EDUCATIONALDEGREECODEID uniqueidentifier = null output,
    @EDUCATIONALAWARDCODEID uniqueidentifier = null output,
    @STARTDATE dbo.UDT_FUZZYDATE = null output,
    @CLASSYEAR dbo.UDT_YEAR = null output,
    @PREFERREDCLASSYEAR dbo.UDT_YEAR = null output,
    @EDUCATIONALSOURCECODEID uniqueidentifier = null output,
    @EDUCATIONALSOURCEDATE dbo.UDT_FUZZYDATE = null output,
    @COMMENT nvarchar(500) = null output,
    @AFFILIATEDADDITIONALINFORMATION xml = null output,
    @UNAFFILIATEDADDITIONALINFORMATION xml = null output,
    @EDUCATIONALINVOLVEMENTS xml = null output,
    @USEACADEMICCATALOG bit = null output,
    @EDUCATIONALHISTORYSTATUSID uniqueidentifier = null output) as
set nocount on;

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

    declare @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_DATALOADED bit;
    declare @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_TSLONG bigint;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE @ID = @ID, @DATALOADED = @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_DATALOADED output, @TSLONG = @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_TSLONG output, @VALIDATEONLY = @VALIDATEONLY output, @CONSTITUENTLOOKUPID = @CONSTITUENTLOOKUPID output, @CONSTITUENTKEYNAME = @CONSTITUENTKEYNAME output, @CONSTITUENTFIRSTNAME = @CONSTITUENTFIRSTNAME output, @EDUCATIONALINSTITUTIONID = @EDUCATIONALINSTITUTIONID output, @EDUCATIONALINSTITUTIONFICECODE = @EDUCATIONALINSTITUTIONFICECODE output, @EDUCATIONALINSTITUTIONNAME = @EDUCATIONALINSTITUTIONNAME output, @EDUCATIONALINSTITUTIONCOUNTRYID = @EDUCATIONALINSTITUTIONCOUNTRYID output, @EDUCATIONALINSTITUTIONCITY = @EDUCATIONALINSTITUTIONCITY output, @EDUCATIONALINSTITUTIONSTATEID = @EDUCATIONALINSTITUTIONSTATEID output, @ISPRIMARYRECORD = @ISPRIMARYRECORD output, @ACADEMICCATALOGPROGRAMID = @ACADEMICCATALOGPROGRAMID output, @EDUCATIONALPROGRAMCODEID = @EDUCATIONALPROGRAMCODEID output, @CONSTITUENCYSTATUSCODE = @CONSTITUENCYSTATUSCODE output, @EDUCATIONALHISTORYREASONCODEID = @EDUCATIONALHISTORYREASONCODEID output, @EDUCATIONALHISTORYLEVELCODEID = @EDUCATIONALHISTORYLEVELCODEID output, @DATELEFT = @DATELEFT output, @DATEGRADUATED = @DATEGRADUATED output, @ACADEMICCATALOGDEGREEID = @ACADEMICCATALOGDEGREEID output, @EDUCATIONALDEGREECODEID = @EDUCATIONALDEGREECODEID output, @EDUCATIONALAWARDCODEID = @EDUCATIONALAWARDCODEID output, @STARTDATE = @STARTDATE output, @CLASSYEAR = @CLASSYEAR output, @PREFERREDCLASSYEAR = @PREFERREDCLASSYEAR output, @EDUCATIONALSOURCECODEID = @EDUCATIONALSOURCECODEID output, @EDUCATIONALSOURCEDATE = @EDUCATIONALSOURCEDATE output, @COMMENT = @COMMENT output, @AFFILIATEDADDITIONALINFORMATION = @AFFILIATEDADDITIONALINFORMATION output, @UNAFFILIATEDADDITIONALINFORMATION = @UNAFFILIATEDADDITIONALINFORMATION output, @EDUCATIONALINVOLVEMENTS = @EDUCATIONALINVOLVEMENTS output, @USEACADEMICCATALOG = @USEACADEMICCATALOG output, @EDUCATIONALHISTORYSTATUSID = @EDUCATIONALHISTORYSTATUSID output;

    set @DATALOADED = @DATALOADED | @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_DATALOADED;
    select @TSLONG = convert(bigint,((@TSLONG + @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_TSLONG) + ABS(@TSLONG - @USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORYUPDATEBATCHTEMPLATE_TSLONG))/2);


return 0;