| NUMBERCOMPANIESTODISPLAY |
smallint |
|
Default = ((5)) |
Number of companies to display |
| NUMBERTEAMSTODISPLAY |
smallint |
|
Default = ((5)) |
Number of teams to display |
| NUMBERHOUSEHOLDSTODISPLAY |
smallint |
|
Default = ((5)) |
Number of households to display |
| NUMBERPARTICIPANTSTODISPLAY |
smallint |
|
Default = ((5)) |
Number of participants to display |
| PLAYEROPTIONSTITLE |
nvarchar(200) |
|
Default = '' |
Player Options Title |
| WIDTH |
smallint |
|
Default = ((0)) |
Maximum dimension width for donor wall |
| HEIGHT |
smallint |
|
Default = ((0)) |
Maximum dimension height for donor wall |
| SCROLLINGDIRECTIONCODE |
tinyint |
|
Default = 1 |
Direction of scroll (asc or desc) |
| SCROLLINGDIRECTION |
nvarchar(10) (Computed) |
yes |
CASE [SCROLLINGDIRECTIONCODE] WHEN 0 THEN N'Ascending' WHEN 1 THEN N'Descending' END |
Provides a translation for the 'SCROLLINGDIRECTIONCODE' field. |
| SPEED |
smallint |
|
Default = ((0)) |
Speed at which donor names scroll |
| 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. |
| DISPLAYCOMPANYNAME |
bit |
|
Default = 1 |
Display company name |
| DISPLAYCOMPANYPICTURE |
bit |
|
Default = 1 |
Display company picture |
| DISPLAYCOMPANYSTORY |
bit |
|
Default = 1 |
Display company story |
| DISPLAYCOMPANYTOTALRAISED |
bit |
|
Default = 1 |
Display total raised |
| DISPLAYCOMPANYFUNDRAISINGGOAL |
bit |
|
Default = 1 |
Display fundraising goal |
| DISPLAYTEAMNAME |
bit |
|
Default = 1 |
Display team name |
| DISPLAYTEAMPICTURE |
bit |
|
Default = 1 |
Display team picture |
| DISPLAYTEAMSTORY |
bit |
|
Default = 1 |
Display team story |
| DISPLAYTEAMTOTALRAISED |
bit |
|
Default = 1 |
Display total raised |
| DISPLAYTEAMFUNDRAISINGGOAL |
bit |
|
Default = 1 |
Display fundraising goal |
| DISPLAYHOUSEHOLDNAME |
bit |
|
Default = 1 |
Display household name |
| DISPLAYHOUSEHOLDPICTURE |
bit |
|
Default = 1 |
Display household picture |
| DISPLAYHOUSEHOLDSTORY |
bit |
|
Default = 1 |
Display household story |
| DISPLAYHOUSEHOLDTOTALRAISED |
bit |
|
Default = 1 |
Display total raised |
| DISPLAYHOUSEHOLDFUNDRAISINGGOAL |
bit |
|
Default = 1 |
Display fundraising goal |
| DISPLAYPARTICIPANTNAME |
bit |
|
Default = 1 |
Display participant name |
| DISPLAYPARTICIPANTPICTURE |
bit |
|
Default = 1 |
Display participant picture |
| DISPLAYPARTICIPANTSTORY |
bit |
|
Default = 1 |
Display participant story |
| DISPLAYPARTICIPANTTOTALRAISED |
bit |
|
Default = 1 |
Display total raised |
| DISPLAYPARTICIPANTFUNDRAISINGGOAL |
bit |
|
Default = 1 |
Display fundraising goal |
| DISPLAYPLAYPAUSEOPTIONS |
bit |
|
Default = 1 |
Display play and pause options |
| DISPLAYCOMPANIES |
bit |
|
Default = 1 |
Display companies |
| DISPLAYTEAMS |
bit |
|
Default = 1 |
Display teams |
| DISPLAYHOUSEHOLDS |
bit |
|
Default = 1 |
Display households |
| DISPLAYPARTICIPANTS |
bit |
|
Default = 1 |
Display participants |
| DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME |
bit |
|
Default = 1 |
Display team name in addition to fundraiser name |
| DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME |
bit |
|
Default = 1 |
Display company name in addition to fundraiser name |