Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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.
 REVENUETOTAL money   Default = 0 Total Revenue Goals
 REVENUEMONTHLY money   Default = 0 Monthly Revenue Goals
 REVENUEWEEKLY money   Default = 0 Weekly Revenue Goals
 REVENUEDAILY money   Default = 0 Daily Revenue Goals
 REVENUESPONSOR money   Default = 0 Sponsor Revenue Goals
 REVENUECOMPANY money   Default = 0 Company Revenue Goals
 REVENUETEAM money   Default = 0 Teams Revenue Goals
 REVENUEINDIVIDUAL money   Default = 0 Individuals Revenue Goals
 RECRUITMENTTOTAL int   Default = 0 Total Recruitment Goals
 RECRUITMENTMONTHLY int   Default = 0 Monthly Recruitment Goals
 RECRUITMENTWEEKLY int   Default = 0 Weekly Recruitment Goals
 RECRUITMENTDAILY int   Default = 0 Daily Recruitment Goals
 RECRUITMENTSPONSOR int   Default = 0 Sponsor Recruitment Goals
 RECRUITMENTCOMPANY int   Default = 0 Company Recruitment Goals
 RECRUITMENTTEAM int   Default = 0 Teams Recruitment Goals
 RECRUITMENTINDIVIDUAL int   Default = 0 Individuals Recruitment Goals
 COMMUNICATIONTOTAL int   Default = 0 Total Communication Goals
 COMMUNICATIONMONTHLY int   Default = 0 Monthly Communication Goals
 COMMUNICATIONWEEKLY int   Default = 0 Weekly Communication Goals
 COMMUNICATIONDAILY int   Default = 0 Daily Communication Goals
 COMMUNICATIONSPONSOR int   Default = 0 Sponsor Communication Goals
 COMMUNICATIONCOMPANY int   Default = 0 Company Communication Goals
 COMMUNICATIONTEAM int   Default = 0 Teams Communication Goals
 COMMUNICATIONINDIVIDUAL int   Default = 0 Individuals Communication Goals
 ISACTIVE bit   Default = 1 Is Active Flag for Event Goal
 MINIMIMUMFUNDRAISINGGOAL money   Default = 0 Minimum Fundraising Goal
 MINIMIMUMPARTICIPANTGOAL int   Default = 0 Minimum Participant Goal
 MINIMIMUMTEAMMEMBERGOAL int   Default = 0 Minimum Team Member Retention Goal
 MINIMIMUMDONORGOAL int   Default = 0 Minimum Donor Retention Goal
 MINIMIMUMNEWMEMBERGOAL int   Default = 0 Minimum New Member Recruitment Goal
 MINIMIMUMNEWDONORGOAL int   Default = 0 Minimum New Donor Recruitment Goal
 MINIMUMFUNDRAISEGOALPERMEMBER money   Default = 0 Minimum Fundraising Goal Per Team Member
 RECRUITMENTFUNDRAISINGCOACHES int   Default = 0 Recruitment Fundraising Coaches
 RECRUITMENTFITNESSCOACHES int   Default = 0 Recruitment Fitness Coashes
 RECRUITMENTDONOR int   Default = 0 Recruitment Donor Goal
 REVENUERETENTION decimal(9, 5)   Default = 0
 REVENUESPONSORRETENTION decimal(9, 5)   Default = 0
 REVENUECOMPANYRETENTION decimal(9, 5)   Default = 0
 REVENUETEAMRETENTION decimal(9, 5)   Default = 0
 REVENUEINDIVIDUALRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTFUNDRAISINGCOACHRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTFITNESSCOACHRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTSPONSORRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTCOMPANYRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTDONORRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTTEAMRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTINDIVIDUALRETENTION decimal(9, 5)   Default = 0
 REVENUEHOUSEHOLD money   Default = 0 Household Revenue Goals
 RECRUITMENTHOUSEHOLD int   Default = 0 Households Recruitment Goals
 COMMUNICATIONHOUSEHOLD int   Default = 0 Households Communication Goals
 REVENUEHOUSEHOLDRETENTION decimal(9, 5)   Default = 0
 RECRUITMENTHOUSEHOLDRETENTION decimal(9, 5)   Default = 0
 COPYSOURCEID uniqueidentifier Original copy from ID
 COPYBATCHGUID uniqueidentifier Copy batch ID
 REVENUEREGISTRATION money   Default = 0 Registration Revenue Goals
 REVENUEREGISTRATIONRETENTION decimal(9, 5)   Default = 0

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_EVENTGOAL_DATEADDED DATEADDED    
 IX_EVENTGOAL_DATECHANGED DATECHANGED      
 PK_EVENTGOAL ID  
 UIX_EVENTGOAL_EVENTID EVENTID    

Trigger Name Description
 TR_EVENTGOAL_AUDIT_UPDATE
 TR_EVENTGOAL_AUDIT_DELETE

Entity-Relationship diagram of this table