Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
REVENUETOTAL
|
money
|
false
|
|
Total Revenue Goals
|
|
REVENUEMONTHLY
|
money
|
false
|
|
Monthly Revenue Goals
|
|
REVENUEWEEKLY
|
money
|
false
|
|
Weekly Revenue Goals
|
|
REVENUEDAILY
|
money
|
false
|
|
Daily Revenue Goals
|
|
REVENUESPONSOR
|
money
|
false
|
|
Sponsor Revenue Goals
|
|
REVENUECOMPANY
|
money
|
false
|
|
Company Revenue Goals
|
|
REVENUETEAM
|
money
|
false
|
|
Teams Revenue Goals
|
|
REVENUEINDIVIDUAL
|
money
|
false
|
|
Individuals Revenue Goals
|
|
RECRUITMENTTOTAL
|
int
|
false
|
|
Total Recruitment Goals
|
|
RECRUITMENTMONTHLY
|
int
|
false
|
|
Monthly Recruitment Goals
|
|
RECRUITMENTWEEKLY
|
int
|
false
|
|
Weekly Recruitment Goals
|
|
RECRUITMENTDAILY
|
int
|
false
|
|
Daily Recruitment Goals
|
|
RECRUITMENTSPONSOR
|
int
|
false
|
|
Sponsor Recruitment Goals
|
|
RECRUITMENTCOMPANY
|
int
|
false
|
|
Company Recruitment Goals
|
|
RECRUITMENTTEAM
|
int
|
false
|
|
Teams Recruitment Goals
|
|
RECRUITMENTINDIVIDUAL
|
int
|
false
|
|
Individuals Recruitment Goals
|
|
COMMUNICATIONTOTAL
|
int
|
false
|
|
Total Communication Goals
|
|
COMMUNICATIONMONTHLY
|
int
|
false
|
|
Monthly Communication Goals
|
|
COMMUNICATIONWEEKLY
|
int
|
false
|
|
Weekly Communication Goals
|
|
COMMUNICATIONDAILY
|
int
|
false
|
|
Daily Communication Goals
|
|
COMMUNICATIONSPONSOR
|
int
|
false
|
|
Sponsor Communication Goals
|
|
COMMUNICATIONCOMPANY
|
int
|
false
|
|
Company Communication Goals
|
|
COMMUNICATIONTEAM
|
int
|
false
|
|
Teams Communication Goals
|
|
COMMUNICATIONINDIVIDUAL
|
int
|
false
|
|
Individuals Communication Goals
|
|
ISACTIVE
|
bit
|
false
|
|
Is Active Flag for Event Goal
|
|
MINIMIMUMFUNDRAISINGGOAL
|
money
|
false
|
|
Minimum Fundraising Goal
|
|
MINIMIMUMPARTICIPANTGOAL
|
int
|
false
|
|
Minimum Participant Goal
|
|
MINIMIMUMTEAMMEMBERGOAL
|
int
|
false
|
|
Minimum Team Member Retention Goal
|
|
MINIMIMUMDONORGOAL
|
int
|
false
|
|
Minimum Donor Retention Goal
|
|
MINIMIMUMNEWMEMBERGOAL
|
int
|
false
|
|
Minimum New Member Recruitment Goal
|
|
MINIMIMUMNEWDONORGOAL
|
int
|
false
|
|
Minimum New Donor Recruitment Goal
|
|
MINIMUMFUNDRAISEGOALPERMEMBER
|
money
|
false
|
|
Minimum Fundraising Goal Per Team Member
|
|
RECRUITMENTFUNDRAISINGCOACHES
|
int
|
false
|
|
Recruitment Fundraising Coaches
|
|
RECRUITMENTFITNESSCOACHES
|
int
|
false
|
|
Recruitment Fitness Coashes
|
|
RECRUITMENTDONOR
|
int
|
false
|
|
Recruitment Donor Goal
|
|
REVENUERETENTION
|
decimal(9, 5)
|
false
|
|
|
|
REVENUESPONSORRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
REVENUECOMPANYRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
REVENUETEAMRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
REVENUEINDIVIDUALRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTFUNDRAISINGCOACHRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTFITNESSCOACHRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTSPONSORRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTCOMPANYRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTDONORRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTTEAMRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTINDIVIDUALRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
REVENUEHOUSEHOLD
|
money
|
false
|
|
Household Revenue Goals
|
|
RECRUITMENTHOUSEHOLD
|
int
|
false
|
|
Households Recruitment Goals
|
|
COMMUNICATIONHOUSEHOLD
|
int
|
false
|
|
Households Communication Goals
|
|
REVENUEHOUSEHOLDRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
RECRUITMENTHOUSEHOLDRETENTION
|
decimal(9, 5)
|
false
|
|
|
|
COPYSOURCEID
|
uniqueidentifier
|
true
|
|
Original copy from ID
|
|
COPYBATCHGUID
|
uniqueidentifier
|
true
|
|
Copy batch ID
|
|
REVENUEREGISTRATION
|
money
|
false
|
|
Registration Revenue Goals
|
|
REVENUEREGISTRATIONRETENTION
|
decimal(9, 5)
|
false
|
|
|
