UFN_CONSTITUENT_ADDRESSES_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:11:24 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CONSTITUENT_ADDRESSES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CONSTITUENT_ADDRESSES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ADDRESSTYPE)[1]','nvarchar(100)') AS 'ADDRESSTYPE',
T.c.value('(DATEADDED)[1]','datetime') AS 'DATEADDED',
T.c.value('(DESCRIPTION)[1]','nvarchar(300)') AS 'DESCRIPTION',
T.c.value('(DONOTMAIL)[1]','bit') AS 'DONOTMAIL',
T.c.value('(ENDDATE_SORT)[1]','date') AS 'ENDDATE_SORT',
T.c.value('(HISTORICALENDDATE)[1]','datetime') AS 'HISTORICALENDDATE',
T.c.value('(HISTORICALSTARTDATE)[1]','datetime') AS 'HISTORICALSTARTDATE',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(IMAGEKEY)[1]','nvarchar(15)') AS 'IMAGEKEY',
T.c.value('(INVALIDGEOCODE)[1]','bit') AS 'INVALIDGEOCODE',
T.c.value('(ISCONFIDENTIAL)[1]','bit') AS 'ISCONFIDENTIAL',
T.c.value('(ISFORMER)[1]','bit') AS 'ISFORMER',
T.c.value('(ISGEOCODED)[1]','bit') AS 'ISGEOCODED',
T.c.value('(ISPRIMARY)[1]','bit') AS 'ISPRIMARY',
T.c.value('(MAPCONTEXTID)[1]','nvarchar(108)') AS 'MAPCONTEXTID',
T.c.value('(PENDINGGEOCODE)[1]','bit') AS 'PENDINGGEOCODE',
T.c.value('(SEASONALENDDATE)[1]','char(4)') AS 'SEASONALENDDATE',
T.c.value('(SEASONALSTARTDATE)[1]','char(4)') AS 'SEASONALSTARTDATE',
T.c.value('(STARTDATE_SORT)[1]','date') AS 'STARTDATE_SORT'
FROM @ITEMLISTXML.nodes('/ADDRESSES/ITEM') T(c)
)