USP_FEPSUBMITPROCESS_GETPARAMETERS

Returns the parameter set used to for the fundraising effectiveness project submit process

Parameters

Parameter	Parameter Type	Mode	Description
@PARAMETERSETID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_FEPSUBMITPROCESS_GETPARAMETERS
(
    @PARAMETERSETID uniqueidentifier
)
as
begin

    select
        INSTALLATIONINFO.[SERIALNUMBER],        
        FEPPROCESS.SITEID,
        FEPPROCESS.ORGANIZATIONNAME,
        dbo.UFN_COUNTRY_GETABBREVIATION(FEPPROCESS.COUNTRYID) as COUNTRYABBREVIATION,
        FEPPROCESS.POSTCODE,
        FEPPROCESS.IDNUMBER,
        FEPPROCESS.CONTACTNAME,
        FEPPROCESS.CONTACTPHONE,
        FEPPROCESS.CONTACTEMAIL,
        FEPPROCESS.AFP,
        FEPPROCESS.[CASE],
        FEPPROCESS.AHP,
        FEPPROCESS.ALDE,
        FEPPROCESS.NCPG,
        FEPPROCESS.CRD,
        FEPPROCESS.OTHER,
        FEPPROCESS.OTHERAFFILIATION,
        FEPPROCESS.INITIALYEAR,
        FEPPROCESS.SUBSECTORCODE,
        FEPPROCESS.FUNDRAISINGEXPENSES,
        FEPPROCESS.FTEPROFESSIONAL,
        FEPPROCESS.FTESUPPORT,
        FEPPROCESS.FTECONSULTANT,
        FEPPROCESS.FTEVOLUNTEER,
        FEPPROCESS.COMMENTS,    
        FEPSUBMITPROCESS.PERIOD1STARTDATE,
        FEPSUBMITPROCESS.PERIOD1ENDDATE,
        FEPSUBMITPROCESS.PERIOD2STARTDATE,
        FEPSUBMITPROCESS.PERIOD2ENDDATE

    from dbo.FEPSUBMITPROCESS
    inner join dbo.FEPPROCESS
        on FEPSUBMITPROCESS.FEPPROCESSID = FEPPROCESS.ID
    cross join dbo.INSTALLATIONINFO

    where FEPSUBMITPROCESS.ID = @PARAMETERSETID;

end