| GOAL |
int |
|
Default = 0 |
PetitionGoal |
| PETITIONCOUNT |
int |
|
Default = 0 |
Current Count |
| MINCOUNT |
int |
|
Default = 0 |
Min Count to Display Signatures |
| STARTCOUNT |
int |
|
Default = 0 |
Starting Count to Display Signatures |
| SIGNATUREDISPLAY |
bit |
|
Default = 1 |
Signature Display Option |
| HIDEADVOCATEMESSAGE |
bit |
|
Default = 0 |
Hide Organization message |
| THERMOMETERDISPLAY |
bit |
|
Default = 1 |
Thermometer Display Option |
| COUNTDISPLAY |
bit |
|
Default = 1 |
Count Display Option |
| THERMOMETERTYPECODE |
tinyint |
|
Default = 0 |
Thermometer type |
| THERMOMETERPOSITIONCODE |
tinyint |
|
Default = 2 |
Thermometer alignment |
| THERMOMETERPOSITION |
nvarchar(6) (Computed) |
yes |
CASE [THERMOMETERPOSITIONCODE] WHEN 0 THEN N'Left' WHEN 1 THEN N'Right' WHEN 2 THEN N'Top' WHEN 3 THEN N'Bottom' END |
Provides a translation for the 'THERMOMETERPOSITIONCODE' field. |
| 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. |
| INCLUDEPETITIONCOUNT |
bit |
|
Default = 1 |
Include petition label and count in Thermometer |
| SIGNATUREDISPLAYLABEL |
nvarchar(200) |
|
Default = 'Signatures' |
Label name for signature display |
| THERMOMETERTYPE |
nvarchar(23) (Computed) |
yes |
CASE [THERMOMETERTYPECODE] WHEN 0 THEN N'Horizontal thermometer' WHEN 1 THEN N'Traditional thermometer' END |
Provides a translation for the 'THERMOMETERTYPECODE' field. |
| INCLUDEPETITIONDEADLINE |
bit |
|
Default = 1 |
Include petition deadline and text in Thermometer |
| DEADLINETEXT |
nvarchar(200) |
|
Default = '' |
Deadline text |
| DEADLINEDATE |
nvarchar(200) |
|
Default = '' |
Deadline date |