UFN_BATCHCONSTITUENTUPDATE_GETPHONES_WITHDATES_FROMITEMLISTXML

CREATE FUNCTION dbo.[UFN_BATCHCONSTITUENTUPDATE_GETPHONES_WITHDATES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(COUNTRYID)[1]','uniqueidentifier') AS 'COUNTRYID',
T.c.value('(DONOTCALL)[1]','bit') AS 'DONOTCALL',
T.c.value('(ENDDATE)[1]','date') AS 'ENDDATE',
T.c.value('(ENDTIME)[1]','char(4)') AS 'ENDTIME',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(INFOSOURCECODEID)[1]','uniqueidentifier') AS 'INFOSOURCECODEID',
T.c.value('(ISPRIMARY)[1]','bit') AS 'ISPRIMARY',
T.c.value('(NUMBER)[1]','nvarchar(max)') AS 'NUMBER',
T.c.value('(PHONEID)[1]','uniqueidentifier') AS 'PHONEID',
T.c.value('(PHONETYPECODEID)[1]','uniqueidentifier') AS 'PHONETYPECODEID',
coalesce(T.c.value('(ROWORIGINCODE)[1]','tinyint'), cast(0 as tinyint)) AS 'ROWORIGINCODE',
T.c.value('(SEASONALENDDATE)[1]','char(4)') AS 'SEASONALENDDATE',
T.c.value('(SEASONALSTARTDATE)[1]','char(4)') AS 'SEASONALSTARTDATE',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(STARTDATE)[1]','date') AS 'STARTDATE',
T.c.value('(STARTTIME)[1]','char(4)') AS 'STARTTIME',
T.c.value('(UPDATEHOUSEHOLD)[1]','bit') AS 'UPDATEHOUSEHOLD',
T.c.value('(DONOTTEXT)[1]','bit') AS 'DONOTTEXT',
T.c.value('(INFOSOURCECOMMENTS)[1]','nvarchar(256)') AS 'INFOSOURCECOMMENTS'
FROM @ITEMLISTXML.nodes('/PHONES/ITEM') T(c)
)