UFN_CONSTITUENTBATCH_GETPHONESWITHSEASONAL_FROMITEMLISTXML

            CREATE function dbo.UFN_CONSTITUENTBATCH_GETPHONESWITHSEASONAL_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            )
            returns table
            as
            return
            (
                select
                    T.c.value('(COUNTRYID)[1]','uniqueidentifier') AS 'COUNTRYID',
                    T.c.value('(ENDTIME)[1]','char(4)') AS 'ENDTIME',
                    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                    T.c.value('(ISPRIMARY)[1]','bit') AS 'ISPRIMARY',
                    T.c.value('(NUMBER)[1]','nvarchar(100)') AS 'NUMBER',
                    T.c.value('(PHONETYPECODEID)[1]','uniqueidentifier') AS 'PHONETYPECODEID',
                    coalesce(T.c.value('(SEASONALENDDATE)[1]','varchar(4)'), '0000') AS 'SEASONALENDDATE',
                    coalesce(T.c.value('(SEASONALSTARTDATE)[1]','varchar(4)'), '0000') 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('(INFOSOURCECODEID)[1]','uniqueidentifier') AS 'INFOSOURCECODEID',
                    T.c.value('(INFOSOURCECOMMENTS)[1]','nvarchar(256)') AS 'INFOSOURCECOMMENTS'
                from
                    @ITEMLISTXML.nodes('/PHONES/ITEM') T(c)
            );