UFN_FAFEVENT_GETEVENTTEAMFAFCONFIG_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:25:49 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_FAFEVENT_GETEVENTTEAMFAFCONFIG
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETEVENTTEAMFAFCONFIG_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(COMPANIESFUNDRAISE)[1]','bit') AS 'COMPANIESFUNDRAISE',
T.c.value('(COMPANYLEADERAPPOINTCOMPANYCOLEADERS)[1]','tinyint') AS 'COMPANYLEADERAPPOINTCOMPANYCOLEADERS',
T.c.value('(COMPANYLEADERAPPROVETEAMS)[1]','bit') AS 'COMPANYLEADERAPPROVETEAMS',
T.c.value('(COMPANYLEADEROPTIONAPPROVETEAMS)[1]','bit') AS 'COMPANYLEADEROPTIONAPPROVETEAMS',
T.c.value('(COMPANYNAMECHANGEAFTERREG)[1]','bit') AS 'COMPANYNAMECHANGEAFTERREG',
T.c.value('(COMPANYTEAMMEMBERSLIMIT)[1]','int') AS 'COMPANYTEAMMEMBERSLIMIT',
T.c.value('(COMPANYTEAMSAPPROVEBYEVENTADMIN)[1]','bit') AS 'COMPANYTEAMSAPPROVEBYEVENTADMIN',
T.c.value('(COMPANYTEAMSLIMIT)[1]','int') AS 'COMPANYTEAMSLIMIT',
T.c.value('(COPYBATCHGUID)[1]','uniqueidentifier') AS 'COPYBATCHGUID',
T.c.value('(COPYSOURCEID)[1]','uniqueidentifier') AS 'COPYSOURCEID',
T.c.value('(FORMERCOMPANYCANREACTIVATETEAMSCODE)[1]','tinyint') AS 'FORMERCOMPANYCANREACTIVATETEAMSCODE',
T.c.value('(FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE)[1]','tinyint') AS 'FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE',
T.c.value('(FORMERTEAMCANREACTIVATETEAMSCODE)[1]','tinyint') AS 'FORMERTEAMCANREACTIVATETEAMSCODE',
T.c.value('(HOUSEHOLDAPPROVEBYEVENTADMIN)[1]','bit') AS 'HOUSEHOLDAPPROVEBYEVENTADMIN',
T.c.value('(HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS)[1]','tinyint') AS 'HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS',
T.c.value('(HOUSEHOLDMEMBERSLIMIT)[1]','int') AS 'HOUSEHOLDMEMBERSLIMIT',
T.c.value('(HOUSEHOLDSFUNDRAISE)[1]','bit') AS 'HOUSEHOLDSFUNDRAISE',
T.c.value('(HOUSEHOLDSJOINTEAMS)[1]','bit') AS 'HOUSEHOLDSJOINTEAMS',
T.c.value('(ID)[1]','varchar(36)') AS 'ID',
T.c.value('(INDIVIDUALSFUNDRAISE)[1]','bit') AS 'INDIVIDUALSFUNDRAISE',
T.c.value('(PARTICIPANTSCANREACTIVATECOMPANYTEAMS)[1]','bit') AS 'PARTICIPANTSCANREACTIVATECOMPANYTEAMS',
T.c.value('(PARTICIPANTSCANREACTIVATEHOUSEHOLDS)[1]','bit') AS 'PARTICIPANTSCANREACTIVATEHOUSEHOLDS',
T.c.value('(PARTICIPANTSCANREACTIVATETEAMS)[1]','bit') AS 'PARTICIPANTSCANREACTIVATETEAMS',
T.c.value('(TEAMLEADERAPPOINTTEAMCOLEADERS)[1]','tinyint') AS 'TEAMLEADERAPPOINTTEAMCOLEADERS',
T.c.value('(TEAMLEADERAPPROVETEAMMEMBERS)[1]','bit') AS 'TEAMLEADERAPPROVETEAMMEMBERS',
T.c.value('(TEAMLEADEROPTIONAPPROVETEAMMEMBERS)[1]','bit') AS 'TEAMLEADEROPTIONAPPROVETEAMMEMBERS',
T.c.value('(TEAMMEMBERSLIMIT)[1]','int') AS 'TEAMMEMBERSLIMIT',
T.c.value('(TEAMNAMECHANGEAFTERREG)[1]','bit') AS 'TEAMNAMECHANGEAFTERREG',
T.c.value('(TEAMSFUNDRAISE)[1]','bit') AS 'TEAMSFUNDRAISE',
T.c.value('(TEAMSREQUESTFUNDRAISE)[1]','bit') AS 'TEAMSREQUESTFUNDRAISE'
FROM @ITEMLISTXML.nodes('/FUNDRAISINGROLES/ITEM') T(c)
)