USP_SIMPLEDATALIST_AFFILIATEDEDUCATIONALHISTORY

Returns all affiliated education history records for the given constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_AFFILIATEDEDUCATIONALHISTORY(@CONSTITUENTID uniqueidentifier = null) 
            as

                set nocount on;

                select EDUCATIONALHISTORY.ID as VALUE, EDUCATIONALINSTITUTION.NAME + ' (' + EDUCATIONSTATUS.DESCRIPTION + ')' as LABEL
                from dbo.EDUCATIONALHISTORY
                inner join dbo.EDUCATIONALINSTITUTION on EDUCATIONALHISTORY.EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTION.ID
        inner join dbo.EDUCATIONALHISTORYSTATUS EDUCATIONSTATUS on EDUCATIONALHISTORY.EDUCATIONALHISTORYSTATUSID = EDUCATIONSTATUS.ID
                where EDUCATIONALHISTORY.CONSTITUENTID = @CONSTITUENTID and EDUCATIONALINSTITUTION.ISAFFILIATED = 1;