USP_SIMPLEDATALIST_RECEIVABLEPAYMENTPAIDBYRELATIONSHIPS

This simple datalist returns the possible payers for a given student includes the student and the relationships.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_RECEIVABLEPAYMENTPAIDBYRELATIONSHIPS(@CONSTITUENTID uniqueidentifier)
                as
                    set nocount on;

                    (
                        select 
                            CONSTITUENT.ID VALUE,
                            CONSTITUENT.NAME LABEL
                        from
                            dbo.CONSTITUENT
                        where 
                            CONSTITUENT.ID = @CONSTITUENTID
                    )
                    UNION
                    (
                        select    
                            CONSTITUENT.ID VALUE,
                            CONSTITUENT.NAME LABEL
                        from 
                            dbo.RELATIONSHIP 
                            inner join dbo.CONSTITUENT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONSTITUENT.ID
                        where 
                            RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
                    )