Open topic with navigation

TAXDECLARATION (4.0SP17)

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

Stores tax declaration information for each constituent.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
CONSTITUENTID	uniqueidentifier	false	CONSTITUENT.ID	The constituent to which this declaration belongs.
DECLARATIONSOURCECODEID	uniqueidentifier	true	DECLARATIONSOURCECODE.ID	The source of this declaration.
TAXSTATUSCODEID	uniqueidentifier	true	TAXSTATUSCODE.ID	The status of this declaration.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHARITYCLAIMREFERENCENUMBERID	uniqueidentifier	false	CHARITYCLAIMREFERENCENUMBER.ID	FK to CHARITYCLAIMREFERENCENUMBER
ADDRESSID	uniqueidentifier	true	ADDRESS.ID
ALIASID	uniqueidentifier	true	ALIAS.ID

Fields
Field	Field Type	Null	Notes	Description
DECLARATIONMADE	datetime	true		Date the declaration was made.
DECLARATIONSTARTS	datetime	false		Date the declaration starts.
DECLARATIONENDS	datetime	true		Date the declaration ends.
DECLARATIONINDICATORCODE	tinyint	false	0	The indicator for this declaration.
SCANNEDDOCSEXIST	bit	false	0	Indicates if scanned documents exist.
CONFIRMATIONSENT	datetime	true		Date the confirmation was sent.
CONFIRMATIONRETURNED	datetime	true		Date the confirmation was returned.
PAYSTAXCODE	tinyint	false	2	Indicates whether a constituent pays tax.
COMMENTS	nvarchar(255)	false	''	Comments for this declaration.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
DECLARATIONINDICATOR	nvarchar(8) (Computed)	true		Provides a translation for the 'DECLARATIONINDICATORCODE' field.
PAYSTAX	nvarchar(7) (Computed)	true		Provides a translation for the 'PAYSTAXCODE' field.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_TAXDECLARATION_ADDRESSID	ADDRESSID	False	False	False
IX_TAXDECLARATION_ALIASID	ALIASID	False	False	False
IX_TAXDECLARATION_CONSTITUENTID_CHARITYCLAIMREFERENCENUMBERID	CONSTITUENTID CHARITYCLAIMREFERENCENUMBERID	False	False	False
IX_TAXDECLARATION_DATEADDED	DATEADDED	False	False	True
IX_TAXDECLARATION_DATECHANGED	DATECHANGED	False	False	False
PK_TAXDECLARATION	ID	True	True	False

Triggers
Trigger Name	Description
TR_TAXDECLARATION_AUDIT_UPDATE
TR_TAXDECLARATION_AUDIT_DELETE