USP_EDUCATIONALHISTORY_RO_EDUCATIONALSOURCEID

Returns the educational source ID for registrar's office and creates one if one does not exist.

Parameters

Parameter	Parameter Type	Mode	Description
@SOURCEID	uniqueidentifier	INOUT

Definition

Copy



        CREATE procedure dbo.USP_EDUCATIONALHISTORY_RO_EDUCATIONALSOURCEID 
            @SOURCEID uniqueidentifier output
        as
        begin
            declare @CURRENTDATE datetime;
            declare @CHANGEAGENTID uniqueidentifier;

            set @CURRENTDATE = getdate()
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            select @SOURCEID = dbo.EDUCATIONALSOURCECODE.[ID]
            from 
                dbo.EDUCATIONALSOURCECODE
                where dbo.EDUCATIONALSOURCECODE.[DESCRIPTION] = 'Registrar'+Char(39)+'s Office'

            if @SOURCEID is null 
            begin
                set @SOURCEID = newid()

                insert into dbo.EDUCATIONALSOURCECODE
                (ID, DESCRIPTION, ACTIVE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values
                (@SOURCEID, 'Registrar'+Char(39)+'s Office', '1', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
            end
        end