UFN_PROSPECTSEGMENTATION_SECTIONS_PRIMARY

Gets a table of primary variable sections for a Prospect Segmentation given a variable ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@VARIABLEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTSEGMENTATION_SECTIONS_PRIMARY(@VARIABLEID uniqueidentifier) 
            returns table
            as return
                select
                    ID,
                    SEQUENCE,
                    LABEL,
                    RANGELOW,
                    RANGEHIGH,
                    ESTIMATEDWEALTHLOWID,
                    ESTIMATEDWEALTHHIGHID,
                    MAJORGIVINGCAPACITYLOWID,
                    MAJORGIVINGCAPACITYHIGHID,
                    TARGETGIFTRANGELOWID,
                    TARGETGIFTRANGEHIGHID,
                    WEALTHESTIMATORRATINGLOWID,
                    WEALTHESTIMATORRATINGHIGHID 
                from
                    dbo.PROSPECTSEGMENTATIONSECTION
                where
                    VARIABLEID=@VARIABLEID