UFN_GETEDUCATIONALINVOLVEMENTNAME

Returns information about an educational involvement name.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_GETEDUCATIONALINVOLVEMENTNAME
            (
                @EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    NAME,
                    INACTIVE
                from
                    dbo.EDUCATIONALINVOLVEMENTNAME
                where
                    EDUCATIONALINVOLVEMENTTYPECODEID = @EDUCATIONALINVOLVEMENTTYPECODEID
            )