UFN_CONSTITUENT_GETMEMBERSHIPS_FROMITEMLISTXML

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

T.c.value('(EXPIRATIONDATE)[1]','datetime') AS 'EXPIRATIONDATE',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(JOINDATE)[1]','datetime') AS 'JOINDATE',
T.c.value('(LOOKUPID)[1]','nvarchar(100)') AS 'LOOKUPID',
T.c.value('(MEMBERSHIPLEVELNAME)[1]','nvarchar(100)') AS 'MEMBERSHIPLEVELNAME',
T.c.value('(MEMBERSHIPPROGRAMID)[1]','uniqueidentifier') AS 'MEMBERSHIPPROGRAMID',
T.c.value('(MEMBERSHIPPROGRAMNAME)[1]','nvarchar(100)') AS 'MEMBERSHIPPROGRAMNAME',
T.c.value('(PRIMARYMEMBERID)[1]','uniqueidentifier') AS 'PRIMARYMEMBERID',
T.c.value('(PRIMARYMEMBERNAME)[1]','nvarchar(154)') AS 'PRIMARYMEMBERNAME',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(STATUS)[1]','nvarchar(9)') AS 'STATUS',
T.c.value('(STATUSCODE)[1]','tinyint') AS 'STATUSCODE'
FROM @ITEMLISTXML.nodes('/MEMBERSHIPS/ITEM') T(c)
)