Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(250)   Default = '' The name of the Action Item
 SYNOPSIS nvarchar(4000)   Default = '' Brief description of action item
 DESCRIPTION nvarchar(max)   Default = '' Full Description of action item
 TYPECODE tinyint   Default = 0 Action Item Type
 TYPE nvarchar(8) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Action' WHEN 1 THEN N'Petition' END Provides a translation for the 'TYPECODE' field.
 STATUSCODE tinyint   Default = 0 Action Item Status
 STATUS nvarchar(8) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Preview' WHEN 1 THEN N'Live' WHEN 2 THEN N'Results' WHEN 3 THEN N'Inactive' END Provides a translation for the 'STATUSCODE' field.
 TOPICCODE tinyint   Default = 11 Action Item Topic
 STARTDATE datetime Action Item begin date
 ENDDATE datetime Action Item end date
 ISEMAILDELIVERY bit   Default = 1 Eamil delivery option
 ISFAXDELIVERY bit   Default = 0 Fax delivery option
 ISLETTERDELIVERY bit   Default = 0 Letter delivery option
 ISDELIVERYNONE bit   Default = 0 No delivery option
 ISFAXBACKUPFOREMAILSENABLED bit   Default = 1 Indicates whether fax backup enabled for emails
 ISEMAILBACKUPFORFAXENABLED bit   Default = 0 Indicates whether email backup enabled for fax
 TARGETOPTIONCODE tinyint   Default = 0 Target selection options
 TARGETOPTION nvarchar(8) (Computed) CASE [TARGETOPTIONCODE] WHEN 0 THEN N'Basic' WHEN 1 THEN N'Advanced' END Provides a translation for the 'TARGETOPTIONCODE' field.
 TARGETDATABASE nvarchar(100)   Default = '' Target database Selection list
 CONFIRMATIONTEXT nvarchar(max)   Default = '' Confirmation for the Action
 RESULTTEXT nvarchar(max)   Default = '' Text that displays instead of action item when the action item has a status of Results
 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.
 ISTOPOSTALCODEDEPENDENT bit   Default = 1 Is To recipients depend on postal code
 ISCCPOSTALCODEDEPENDENT bit   Default = 1 Is CC recipients depend on postal code
 SCHEDULEACTIVATION bit   Default = 1 Schedule Activation
 ISTODMADEPENDENT bit   Default = 1 Is To recipients depend on DMA
 ISCCDMADEPENDENT bit   Default = 1 Is CC recipients depend on DMA
 OWNERID int   Default = 1 Action item owner ID
 TOPIC nvarchar(15) (Computed) CASE [TOPICCODE] WHEN 0 THEN N'Abortion' WHEN 1 THEN N'Budget' WHEN 2 THEN N'Defense' WHEN 3 THEN N'Drugs' WHEN 4 THEN N'Education' WHEN 5 THEN N'Environment' WHEN 6 THEN N'Foreign Affairs' WHEN 7 THEN N'Health Care' WHEN 8 THEN N'Human Rights' WHEN 9 THEN N'Labor' WHEN 10 THEN N'Law/Judicial' WHEN 11 THEN N'Other' WHEN 12 THEN N'Taxes' WHEN 13 THEN N'Technology' WHEN 14 THEN N'Veterans' WHEN 15 THEN N'Welfare' END Provides a translation for the 'TOPICCODE' field.

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

Index Name Field(s) Unique Primary Clustered
 IX_ACTION_ITEM_DATEADDED DATEADDED    
 IX_ACTION_ITEM_DATECHANGED DATECHANGED      
 PK_ACTION_ITEM ID  
 UIX_ACTION_ITEM_NAME NAME    

Trigger Name Description
 TR_ACTION_ITEM_AUDIT_UPDATE
 TR_ACTION_ITEM_AUDIT_DELETE

Referenced by Field
 ACTIONCENTER ACTIONITEMID
 ACTIONITEM_TARGET ACTIONITEMID
 ACTIONITEMFOLDER ACTIONITEMID
 ACTIONITEMIMAGE ACTIONITEMID
 ACTIONITEMMEDIATARGET ACTIONITEMID
 ACTIONITEMMESSAGETEXT ACTIONITEMID
 ACTIONITEMPART ACTIONITEMID
 ACTIONITEMPETITION ACTIONITEMID
 ADVOCACYACTIVITY ACTIONITEMID
 ADVOCACYLOG ACTIONITEMID
 ADVOCACYPETITION ACTIONITEMID

Entity-Relationship diagram of this table