USP_DATALIST_ORGANIZATIONPARENTHISTORY

Data list containing parent history records for an organization.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ORGANIZATIONPARENTHISTORY(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    declare @CURRENTPARENTCORPID uniqueidentifier
    select @CURRENTPARENTCORPID = PARENTCORPID
    from dbo.ORGANIZATIONDATA
    where ID = @CONTEXTID

    select ORGANIZATIONPARENTHISTORY.ID,
           PARENTCORPID,
           NAME,
           STARTDATE,
           ENDDATE,
           (case 
             when @CURRENTPARENTCORPID = ORGANIZATIONPARENTHISTORY.PARENTCORPID then 1
             else 0
           end)
    from dbo.ORGANIZATIONPARENTHISTORY
        inner join dbo.CONSTITUENT on ORGANIZATIONPARENTHISTORY.PARENTCORPID = CONSTITUENT.ID
    where ORGANIZATIONPARENTHISTORY.CHILDCORPID = @CONTEXTID
    order by STARTDATE desc, ORGANIZATIONPARENTHISTORY.DATEADDED desc