UFN_FAFEVENT_GETREGISTRATIONOPTION_FROMITEMLISTXML

create function dbo.UFN_FAFEVENT_GETREGISTRATIONOPTION_FROMITEMLISTXML(@ITEMLISTXML xml)
returns table
  as return 
  (
    select 
      T.c.value('(ALLOWPARTICIPANTSWAIVEBENEFITS)[1]','bit') AS 'ALLOWPARTICIPANTSWAIVEBENEFITS',
        T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
      T.c.value('(COPYSOURCEID)[1]','uniqueidentifier') AS 'COPYSOURCEID',
      T.c.value('(COPYBATCHGUID)[1]', 'uniqueidentifier') AS 'COPYBATCHGUID',
        T.c.value('(DESCRIPTION)[1]','nvarchar(1000)') AS 'DESCRIPTION',
        T.c.value('(DISPLAYSPOTSAVAILABLE)[1]','bit') AS 'DISPLAYSPOTSAVAILABLE',
        T.c.value('(EARLYREGISTRATIONDATE)[1]','datetime') AS 'EARLYREGISTRATIONDATE',
        T.c.value('(EARLYREGISTRATIONDISCOUNT)[1]','money') AS 'EARLYREGISTRATIONDISCOUNT',
        T.c.value('(EVENTREGISTRATIONTYPEID)[1]','uniqueidentifier') AS 'EVENTREGISTRATIONTYPEID',
        T.c.value('(FAFREGISTRATIONCATEGORYID)[1]','uniqueidentifier') AS 'FAFREGISTRATIONCATEGORYID',
        T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
        T.c.value('(ISACTIVE)[1]','bit') AS 'ISACTIVE',
        T.c.value('(ISNOTAVAILABLEONLINEREG)[1]','bit') AS 'ISNOTAVAILABLEONLINEREG',
        T.c.value('(ISREGTYPEAVAILABLECOMPANYLEADER)[1]','bit') AS 'ISREGTYPEAVAILABLECOMPANYLEADER',
        T.c.value('(ISREGTYPEAVAILABLEFAMILYMEMBER)[1]','bit') AS 'ISREGTYPEAVAILABLEFAMILYMEMBER',
        T.c.value('(ISREGTYPEAVAILABLEHEADHOUSEHOLD)[1]','bit') AS 'ISREGTYPEAVAILABLEHEADHOUSEHOLD',
        T.c.value('(ISREGTYPEAVAILABLEINDIVIDUAL)[1]','bit') AS 'ISREGTYPEAVAILABLEINDIVIDUAL',
        T.c.value('(ISREGTYPEAVAILABLETEAMLEADER)[1]','bit') AS 'ISREGTYPEAVAILABLETEAMLEADER',
        T.c.value('(ISREGTYPEAVAILABLETEAMMEMBER)[1]','bit') AS 'ISREGTYPEAVAILABLETEAMMEMBER',
        T.c.value('(LATEFEE)[1]','money') AS 'LATEFEE',
        T.c.value('(LATEFEEDATE)[1]','datetime') AS 'LATEFEEDATE',
        T.c.value('(MAXIMUMAGE)[1]','int') AS 'MAXIMUMAGE',
        T.c.value('(MAXQUANTITY)[1]','int') AS 'MAXQUANTITY',
        T.c.value('(MINIMUMAGE)[1]','int') AS 'MINIMUMAGE',
        T.c.value('(NAME)[1]','nvarchar(100)') AS 'NAME',
        T.c.value('(RECEIPTAMOUNT)[1]','money') AS 'RECEIPTAMOUNT',
        T.c.value('(REGISTRATIONCOUNT)[1]','int') AS 'REGISTRATIONCOUNT',
        T.c.value('(SENDEVENTCONTACTALERTMAXREACHED)[1]','bit') AS 'SENDEVENTCONTACTALERTMAXREACHED',
        T.c.value('(TURNONWAITLIST)[1]','bit') AS 'TURNONWAITLIST',
        T.c.value('(USEDQUANTITY)[1]','int') AS 'USEDQUANTITY',
        T.c.value('(WAITLISTMESSAGE)[1]','nvarchar(1000)') AS 'WAITLISTMESSAGE',
        T.c.query('(REGOPTIONGOALS)') AS 'GOALS'
        FROM @ITEMLISTXML.nodes('/REGISTRATIONOPTIONS/OPTION') T(c)
  )