USE [ATIUnderwriting]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      Adam McCartney
-- Create date: 18/11/2010
-- Description: calculate earned premium function
-- =============================================
ALTER FUNCTION [dbo].[fnEarnedPremium]
(   
    -- Add the parameters for the function here
        @issuedate datetime,
    @outdate datetime,
    @returndate datetime,
    @experiencedate datetime,
    @pretripearnings decimal(10,2),
    @premium decimal(10,2)
)
RETURNS decimal(10,2)
AS

begin

declare @earnedpremium decimal(10,2)
declare @tripearnings decimal(10,2)
--declare @tripearningsperc decimal(10,2)
--declare @ptep decimal(10,2)
declare @datediff decimal(10,2)



if datediff(day, @experiencedate, @returndate) < 0 
    set @Earnedpremium = @premium
else if datediff(day, @issuedate, @experiencedate) < datediff(day, @issuedate, @outdate)
    set @earnedpremium = @premium * (@pretripearnings / datediff(day, @issuedate, @experiencedate))
Else 
    set @earnedpremium = @premium * (@pretripearnings + (@tripearnings / datediff(day, @outdate, @experiencedate)))



RETURN @earnedpremium 

end