USP_DATAFORMTEMPLATE_ADD_EDUCATIONALHISTORY_PRELOAD_2

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@USEACADEMICCATALOG	bit	INOUT	Use academic catalog
@ISPRIMARYRECORD	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EDUCATIONALHISTORY_PRELOAD_2 (
    @CONSTITUENTID uniqueidentifier,
    @USEACADEMICCATALOG bit = null output,
  @ISPRIMARYRECORD bit = null output
) as
    set nocount on;

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

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

  if exists (select ISPRIMARYRECORD from dbo.EDUCATIONALHISTORY where CONSTITUENTID = @CONSTITUENTID and ISPRIMARYRECORD = 1)
    set @ISPRIMARYRECORD = 1

    return 0;