ALTER FUNCTION [App].[Fn_IsCovType]
(
	@ApplicationrequestTypeID SMALLINT
)
RETURNS BIT
AS
BEGIN
	DECLARE @ResultVar BIT = 0

	IF 
		@ApplicationrequestTypeID  = 3 /*Replacements (COV)*/ OR 
		@ApplicationrequestTypeID = 14 /*Renewal and COV*/ OR 
		@ApplicationrequestTypeID = 15 /*Renewal and COV and Increase in Carrying Capacity*/ OR 
		@ApplicationrequestTypeID = 18 /*Renewal and deceased transfer and increase in carrying capacity and COV*/ OR 
		@ApplicationrequestTypeID = 19 /*Duplicate and COV*/ OR 
		@ApplicationrequestTypeID = 21 /*Duplicate and COV and Increase in carrying capacity*/ OR 
		@ApplicationrequestTypeID = 22 /*Increase in Carrying Capacity and COV*/ OR 						
		@ApplicationrequestTypeID = 24 /*Renewal and Normal Transfer and COV*/ OR 
		@ApplicationrequestTypeID = 26 /*Renewal and deceased transfer and COV*/
	BEGIN
		SET @ResultVar = 1
	END
	
	RETURN @ResultVar

END