UFN_PEOPLELINKORGANIZATION_CONTACTS

Gets a table of contacts for a given PEOPLELINKORGANIZATION ID.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@PEOPLELINKORGANIZATIONID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_PEOPLELINKORGANIZATION_CONTACTS(@PEOPLELINKORGANIZATIONID uniqueidentifier) 
            returns table
            as return
                select
                    ID,
                    FULLNAME,
                    RELATIONSHIP
                from
                    dbo.PEOPLELINKCONTACT
                where
                    PEOPLELINKORGANIZATIONID=@PEOPLELINKORGANIZATIONID