USP_DATALIST_EDUCATIONALINVOLVEMENT

Returns a list of educational involvement records for a given constituent.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_EDUCATIONALINVOLVEMENT
                    (
                        @CONSTITUENTID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select
                            ID,
                            EDUCATIONALINVOLVEMENTTYPECODE,
                            NAME,
                            POSITION,
                            DATEFROM,
                            DATETO,
                            COMMENT,
                            INSTITUTION,
                            EDUCATIONALINVOLVEMENTAWARDCODE,
                            DEPARTMENT
                        from
                            dbo.UFN_EDUCATIONALINVOLVEMENT_GETLIST() INVOLVEMENT
                        where
                            INVOLVEMENT.CONSTITUENTID = @CONSTITUENTID;