Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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) 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) 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) 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

Foreign Key Field Type Null Notes Description
 ACTIONITEMID uniqueidentifier   ACTION_ITEM.ID ActionItemID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_ACTIONITEMPETITION_DATEADDED DATEADDED    
 IX_ACTIONITEMPETITION_DATECHANGED DATECHANGED      
 PK_ACTIONITEMPETITION ID  
 UIX_ACTIONITEMPETITION_ACTIONITEMID ACTIONITEMID    

Trigger Name Description
 TR_ACTIONITEMPETITION_AUDIT_UPDATE
 TR_ACTIONITEMPETITION_AUDIT_DELETE

Entity-Relationship diagram of this table