UFN_EDUCATIONALHISTORY_CURRENTEDUCATIONALHISTORYSTATUS

CREATE function dbo.UFN_EDUCATIONALHISTORY_CURRENTEDUCATIONALHISTORYSTATUS
(
  @EDUCATIONALHISTORYID uniqueidentifier
)
returns uniqueidentifier
with execute as caller
as begin
  declare @RETVAL uniqueidentifier = null;

  select top 1 @RETVAL = EDUCATIONALHISTORYSTATUSHISTORY.EDUCATIONALHISTORYSTATUSID
  from dbo.EDUCATIONALHISTORYSTATUSHISTORY
  where EDUCATIONALHISTORYSTATUSHISTORY.EDUCATIONALHISTORYID = @EDUCATIONALHISTORYID
  order by STATUSDATE desc, DATECHANGED desc;

  if (@RETVAL is null)
  begin
    declare @CONSTITUENCYSTATUSCODE tinyint;

    select @CONSTITUENCYSTATUSCODE = EDUCATIONALHISTORY.CONSTITUENCYSTATUSCODE
    from dbo.EDUCATIONALHISTORY
    where EDUCATIONALHISTORY.ID = @EDUCATIONALHISTORYID

    set @RETVAL = dbo.UFN_EDUCATIONALHISTORYSTATUS_FROMCONSTITUENCYSTATUSCODE(@CONSTITUENCYSTATUSCODE);
  end

  return @RETVAL;
end