UFN_CONSTITUENT_GETEDUCATIONALINVOLVEMENTS_FORUPDATEBATCH

This function returns the educational involvements for a given constituent by educational institution for the update batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@EDUCATIONALINSTITUTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_GETEDUCATIONALINVOLVEMENTS_FORUPDATEBATCH (
                @CONSTITUENTID uniqueidentifier,
                @EDUCATIONALINSTITUTIONID uniqueidentifier = null
            ) returns table
                as return
                    select
                        EI.[ID] EDUCATIONALINVOLVEMENTID,
                        EI.[EDUCATIONALINVOLVEMENTTYPECODEID] EDUCATIONALINVOLVEMENTTYPECODEID,
                        EI.[EDUCATIONALINVOLVEMENTNAMEID] EDUCATIONALINVOLVEMENTNAMEID,
                        coalesce(EI.[DATEFROM], '00000000') DATEFROM,
                        coalesce(EI.[DATETO], '00000000') DATETO,
                        EI.[EDUCATIONALINVOLVEMENTAWARDCODEID] EDUCATIONALINVOLVEMENTAWARDCODEID,
                        coalesce(EI.[COMMENT], '') COMMENT,
                        coalesce(EI.[POSITION], '') POSITION
                    from
                        dbo.[EDUCATIONALINVOLVEMENT] EI
                    where
                        EI.[CONSTITUENTID] = @CONSTITUENTID and
                        (EI.[EDUCATIONALINSTITUTIONID] = @EDUCATIONALINSTITUTIONID or @EDUCATIONALINSTITUTIONID is null);