UFN_CONSTITUENT_GETCURRENTCONTACTS_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  6/23/2017 11:54:01 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.170.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CONSTITUENT_GETCURRENTCONTACTS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CONSTITUENT_GETCURRENTCONTACTS_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(CONTACTISDECEASED)[1]','int') AS 'CONTACTISDECEASED',
T.c.value('(CONTACTISINACTIVE)[1]','bit') AS 'CONTACTISINACTIVE',
T.c.value('(CONTACTNAME)[1]','nvarchar(154)') AS 'CONTACTNAME',
T.c.value('(CONTACTTYPE)[1]','nvarchar(100)') AS 'CONTACTTYPE',
T.c.value('(DONOTCALL)[1]','bit') AS 'DONOTCALL',
T.c.value('(DONOTEMAIL)[1]','bit') AS 'DONOTEMAIL',
T.c.value('(EMAILADDRESS)[1]','nvarchar(100)') AS 'EMAILADDRESS',
T.c.value('(FIRSTNAME)[1]','nvarchar(50)') AS 'FIRSTNAME',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(ISCONFIDENTIAL)[1]','bit') AS 'ISCONFIDENTIAL',
T.c.value('(ISPRIMARYCONTACT)[1]','bit') AS 'ISPRIMARYCONTACT',
T.c.value('(KEYNAME)[1]','nvarchar(100)') AS 'KEYNAME',
T.c.value('(PHONENUMBER)[1]','nvarchar(110)') AS 'PHONENUMBER',
T.c.value('(USERHASPERMISSIONTOVIEWCONTACT)[1]','int') AS 'USERHASPERMISSIONTOVIEWCONTACT'
FROM @ITEMLISTXML.nodes('/CONTACTS/ITEM') T(c)
)