| 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) |
yes |
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) |
yes |
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 |
yes |
|
Action Item begin date |
| ENDDATE |
datetime |
yes |
|
Action Item end date |
| ISEMAILDELIVERY |
bit |
|
Default = 1 |
Email 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) |
yes |
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) |
yes |
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) |
yes |
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. |