REVENUETRIBUTELETTER

Stores information pertaining to revenue records and their corresponding tribute letters.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
PROCESSDATE	datetime	yes		Date acknowledgement process was run for this letter.
ACKNOWLEDGEDATE	datetime	yes		Date letter was sent.
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.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
REVENUETRIBUTEID	uniqueidentifier		REVENUETRIBUTE.LOCALID	A foreign key to the REVENUETRIBUTE table.
CONSTITUENTID	uniqueidentifier		CONSTITUENT.LOCALID	A foreign key to the CONSTITUENT table.
TRIBUTELETTERCODEID	uniqueidentifier		TRIBUTELETTERCODE.ID	A foreign key to the TRIBUTELETTERCODE table.
TRIBUTEACKNOWLEDGEMENTPROCESSSTATUSID	uniqueidentifier	yes	TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS.ID	A foreign key to the TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS table.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_REVENUETRIBUTELETTER_DATEADDED	DATEADDED			yes
IX_REVENUETRIBUTELETTER_DATECHANGED	DATECHANGED
PK_REVENUETRIBUTELETTER	ID	yes	yes
UIX_REVENUETRIBUTELETTER_REVENUETRIBUTEID_CONSTITUENTID_TRIBUTELETTERCODEID	REVENUETRIBUTEID, CONSTITUENTID, TRIBUTELETTERCODEID	yes

Triggers

Trigger Name	Description
TR_REVENUETRIBUTELETTER_AUDIT_UPDATE
TR_REVENUETRIBUTELETTER_AUDIT_DELETE