Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 INDIVIDUALSFUNDRAISE bit   Default = 1 Individuals may fundraise
 HOUSEHOLDSFUNDRAISE bit   Default = 1 Households may fundraise
 HOUSEHOLDAPPROVEBYEVENTADMIN bit   Default = 0 Households must request to fundraise
 HOUSEHOLDSJOINTEAMS bit   Default = 0 Households can join teams
 TEAMSFUNDRAISE bit   Default = 1 Teams may fundraise
 TEAMSREQUESTFUNDRAISE bit   Default = 0 New Teams must be approved by Event Admin
 TEAMNAMECHANGEAFTERREG bit   Default = 0 Team Name can be changed After Registration
 TEAMLEADERAPPOINTTEAMCOLEADERS tinyint   Default = 1 Team Leader can Appoint a number of Team Co-Leaders
 TEAMLEADERAPPROVETEAMMEMBERS bit   Default = 0 Team Leader must approve team members
 TEAMLEADEROPTIONAPPROVETEAMMEMBERS bit   Default = 1 Team Leader has the option to approve team members
 COMPANIESFUNDRAISE bit   Default = 1 Companies may fundraise
 COMPANYTEAMSAPPROVEBYEVENTADMIN bit   Default = 0 Company teams approved by event admin
 COMPANYLEADERAPPOINTCOMPANYCOLEADERS tinyint   Default = 1 Company Leader can Appoint a number of Company Co-Leaders
 COMPANYNAMECHANGEAFTERREG bit   Default = 0 Company name can be changed after registration
 COMPANYLEADERAPPROVETEAMS bit   Default = 0 Company Leader must Approve Teams
 COMPANYLEADEROPTIONAPPROVETEAMS bit   Default = 1 Company Leader has the option to approve teams
 TEAMMINIMUMGOALFLAG bit   Default = 0 Team Mimimum Goal Flag
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 HOUSEHOLDMEMBERSLIMIT int   Default = 5 Household members limit
 TEAMMEMBERSLIMIT int   Default = 50 Team members limit
 COMPANYTEAMSLIMIT int   Default = 100 Company teams limit
 COMPANYTEAMMEMBERSLIMIT int   Default = 50 Company teams members limit
 PARTICIPANTSCANREACTIVATETEAMS bit   Default = 1 Participants can re-activate teams
 FORMERTEAMCANREACTIVATETEAMSCODE tinyint   Default = 0 Choice of team activation level
 PARTICIPANTSCANREACTIVATECOMPANYTEAMS bit   Default = 1 Participants can re-activate company teams
 FORMERCOMPANYCANREACTIVATETEAMSCODE tinyint   Default = 0 Choice of company team activation level
 PARTICIPANTSCANREACTIVATEHOUSEHOLDS bit   Default = 1 Participants can re-activate households
 FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE tinyint   Default = 0 Choice of household activation level
 FORMERTEAMCANREACTIVATETEAMS nvarchar(58) (Computed) CASE [FORMERTEAMCANREACTIVATETEAMSCODE] WHEN 0 THEN N'Only former team leaders can re-activate teams' WHEN 1 THEN N'Former team leaders and team members can re-activate teams' WHEN 2 THEN N'Anyone can re-activate teams' WHEN 3 THEN N'None' END Provides a translation for the 'FORMERTEAMCANREACTIVATETEAMSCODE' field.
 FORMERCOMPANYCANREACTIVATETEAMS nvarchar(77) (Computed) CASE [FORMERCOMPANYCANREACTIVATETEAMSCODE] WHEN 0 THEN N'Only former company leaders can re-activate teams' WHEN 1 THEN N'Former company leaders and company team members can re-activate company teams' WHEN 2 THEN N'Any former company team member can re-activate a company team' WHEN 3 THEN N'None' END Provides a translation for the 'FORMERCOMPANYCANREACTIVATETEAMSCODE' field.
 FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLD nvarchar(73) (Computed) CASE [FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE] WHEN 0 THEN N'Only former household leaders can re-activate households' WHEN 1 THEN N'Former household leaders and household members can re-activate households' WHEN 2 THEN N'None' END Provides a translation for the 'FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE' field.
 HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS tinyint   Default = 1 household leader can Appoint a number of household Co-Leaders
 COPYSOURCEID uniqueidentifier Original copy from ID
 COPYBATCHGUID uniqueidentifier Copy batch ID

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier   EVENT.ID Foreign Key to Event table
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EVENTTEAMFAFCONFIG_DATEADDED DATEADDED    
 IX_EVENTTEAMFAFCONFIG_DATECHANGED DATECHANGED      
 PK_EVENTTEAMFAFCONFIG ID  
 UIX_EVENTTEAMFAFCONFIG_EVENTID EVENTID    

Trigger Name Description
 TR_EVENTTEAMFAFCONFIG_AUDIT_UPDATE
 TR_EVENTTEAMFAFCONFIG_AUDIT_DELETE

Entity-Relationship diagram of this table