USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORY_2

The load procedure used by the edit dataform template "Educational History Edit Form 2"

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.
@ISPRIMARYRECORD	bit	INOUT	Primary education information
@EDUCATIONALINSTITUTIONID	uniqueidentifier	INOUT	Educational institution
@ACADEMICCATALOGPROGRAMID	uniqueidentifier	INOUT	Program
@EDUCATIONALPROGRAMCODEID	uniqueidentifier	INOUT	Program
@CONSTITUENCYSTATUSCODE	tinyint	INOUT	Status
@DATEGRADUATED	UDT_FUZZYDATE	INOUT	Graduation date
@DATELEFT	UDT_FUZZYDATE	INOUT	To
@ACADEMICCATALOGDEGREEID	uniqueidentifier	INOUT	Degree
@EDUCATIONALDEGREECODEID	uniqueidentifier	INOUT	Degree
@EDUCATIONALAWARDCODEID	uniqueidentifier	INOUT	Honor awarded
@STARTDATE	UDT_FUZZYDATE	INOUT	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
@UNAFFILIATEDADDITIONALINFORMATION	xml	INOUT
@ISAFFILIATED	bit	INOUT	Affiliated
@EDUCATIONALHISTORYLEVELCODEID	uniqueidentifier	INOUT	Level
@EDUCATIONALHISTORYREASONCODEID	uniqueidentifier	INOUT	Reason
@USEACADEMICCATALOG	bit	INOUT	Use academic catalog
@EDUCATIONALHISTORYSTATUSID	uniqueidentifier	INOUT	Status

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALHISTORY_2
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @ISPRIMARYRECORD bit = null output,
    @EDUCATIONALINSTITUTIONID uniqueidentifier = null output,
    @ACADEMICCATALOGPROGRAMID uniqueidentifier = null output,
    @EDUCATIONALPROGRAMCODEID uniqueidentifier = null output,
    @CONSTITUENCYSTATUSCODE tinyint = null output,
    @DATEGRADUATED dbo.UDT_FUZZYDATE = null output,
    @DATELEFT 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,
    @ISAFFILIATED bit = null output,
    @EDUCATIONALHISTORYLEVELCODEID uniqueidentifier = null output,
    @EDUCATIONALHISTORYREASONCODEID uniqueidentifier = 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,
        @ISPRIMARYRECORD = ISPRIMARYRECORD,
        @EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTIONID,
        @ACADEMICCATALOGPROGRAMID = ACADEMICCATALOGPROGRAMID,
        @EDUCATIONALPROGRAMCODEID = EDUCATIONALPROGRAMCODEID,
        @CONSTITUENCYSTATUSCODE = CONSTITUENCYSTATUSCODE,
        @DATEGRADUATED = DATEGRADUATED,
        @DATELEFT = DATELEFT,
        @ACADEMICCATALOGDEGREEID = ACADEMICCATALOGDEGREEID,
        @EDUCATIONALDEGREECODEID = EDUCATIONALDEGREECODEID,
        @EDUCATIONALAWARDCODEID = EDUCATIONALAWARDCODEID,
        @STARTDATE = STARTDATE,
        @CLASSYEAR = CLASSOF,
        @PREFERREDCLASSYEAR = PREFERREDCLASSYEAR,
        @EDUCATIONALSOURCECODEID = EDUCATIONALSOURCECODEID,
        @EDUCATIONALSOURCEDATE = EDUCATIONALSOURCEDATE,
        @COMMENT = COMMENT,
        @AFFILIATEDADDITIONALINFORMATION = dbo.UFN_EDUCATIONALHISTORY_GETAFFILIATEDADDITIONALINFORMATION_TOITEMLISTXML(@ID),
        @UNAFFILIATEDADDITIONALINFORMATION = dbo.UFN_EDUCATIONALHISTORY_GETUNAFFILIATEDADDITIONALINFORMATION_TOITEMLISTXML(@ID),
        @ISAFFILIATED = (select ISAFFILIATED from dbo.EDUCATIONALINSTITUTION where ID = EDUCATIONALINSTITUTIONID),
        @EDUCATIONALHISTORYLEVELCODEID = EDUCATIONALHISTORYLEVELCODEID,
        @EDUCATIONALHISTORYREASONCODEID = EDUCATIONALHISTORYREASONCODEID,
        @EDUCATIONALHISTORYSTATUSID = EDUCATIONALHISTORYSTATUSID
    from
        dbo.EDUCATIONALHISTORY
    where
        ID = @ID;

    select top 1
        @USEACADEMICCATALOG = EC.USEACADEMICCATALOG
    from
        dbo.EDUCATIONALCONFIGURATION EC;

    set @USEACADEMICCATALOG = coalesce(@USEACADEMICCATALOG,0);

    return 0;