USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEDUCATIONALHISTORYUPDATEBATCHROW

The load 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 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.
@SEQUENCE	int	INOUT	Sequence
@PRIMARYRECORDID	uniqueidentifier	INOUT	Educational history
@PRIMARYCONTEXTRECORDID	uniqueidentifier	INOUT	Constituent
@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_BATCHEDUCATIONALHISTORYUPDATEBATCHROW(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SEQUENCE int = null output,
    @PRIMARYRECORDID uniqueidentifier = null output,
    @PRIMARYCONTEXTRECORDID uniqueidentifier = 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;

select
    @DATALOADED = 1,
    @TSLONG = [TSLONG],
    @SEQUENCE = [SEQUENCE],
    @PRIMARYRECORDID = [PRIMARYRECORDID],
    @PRIMARYCONTEXTRECORDID = [PRIMARYCONTEXTRECORDID],
    @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 = dbo.UFN_BATCHEDUCATIONALHISTORYUPDATE_GETAFFILIATEDADDITIONALINFORMATION_TOITEMLISTXML(ID),
    @UNAFFILIATEDADDITIONALINFORMATION = dbo.UFN_BATCHEDUCATIONALHISTORYUPDATE_GETUNAFFILIATEDADDITIONALINFORMATION_TOITEMLISTXML(ID),
    @EDUCATIONALINVOLVEMENTS = dbo.UFN_BATCHEDUCATIONALHISTORYUPDATE_GETEDUCATIONALINVOLVEMENTS_TOITEMLISTXML(ID),
    @USEACADEMICCATALOG = [USEACADEMICCATALOG],
    @EDUCATIONALHISTORYSTATUSID = [EDUCATIONALHISTORYSTATUSID]
from
    dbo.BATCHEDUCATIONALHISTORYUPDATE
where
    BATCHEDUCATIONALHISTORYUPDATE.ID = @ID;

return 0;