USP_DATALIST_REVENUELIFECYCLE

Displays a list of current and historical donor lifecycle information for a given constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_REVENUELIFECYCLE
(
    @CONSTITUENTID uniqueidentifier
)
as
    set nocount on;

    select 
        REVENUELIFECYCLE.ID,
        REVENUELIFECYCLE.CONSTITUENTID,
        REVENUELIFECYCLE.LIFECYCLETYPEID,
        LIFECYCLETYPE.NAME as LIFECYCLESTATE,
        REVENUELIFECYCLE.DONORSTATECODE,
        REVENUELIFECYCLE.DONORSTATE,
        REVENUELIFECYCLE.STARTDATE,
        null as ENDDATE,
        1 ACTIVE
    from 
        dbo.REVENUELIFECYCLE
        inner join dbo.LIFECYCLETYPE on LIFECYCLETYPE.ID = REVENUELIFECYCLE.LIFECYCLETYPEID            
    where 
        CONSTITUENTID = @CONSTITUENTID        
    union
    select
        REVENUELIFECYCLEHISTORY.ID,
        REVENUELIFECYCLEHISTORY.CONSTITUENTID,
        REVENUELIFECYCLEHISTORY.LIFECYCLETYPEID,
        LIFECYCLETYPE.NAME as LIFECYCLESTATE,
        REVENUELIFECYCLEHISTORY.DONORSTATECODE,
        REVENUELIFECYCLEHISTORY.DONORSTATE,
        REVENUELIFECYCLEHISTORY.STARTDATE,
        REVENUELIFECYCLEHISTORY.ENDDATE,
        0 ACTIVE
    from 
        dbo.REVENUELIFECYCLEHISTORY
        inner join dbo.LIFECYCLETYPE on LIFECYCLETYPE.ID = REVENUELIFECYCLEHISTORY.LIFECYCLETYPEID    
    where 
        CONSTITUENTID = @CONSTITUENTID        
    order by 
        9 desc, 7 desc