| 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) |
yes |
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 |
yes |
|
Original copy from ID |
| COPYBATCHGUID |
uniqueidentifier |
yes |
|
Copy batch ID |
| REVENUEREGISTRATION |
money |
|
Default = 0 |
Registration Revenue Goals |
| REVENUEREGISTRATIONRETENTION |
decimal(9, 5) |
|
Default = 0 |
|