CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS

Serves as a join table to the BUSINESSPROCESSSTATUS table for the CURRENCYEXCHANGERATEDOWNLOADPROCESS table.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
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
ID uniqueidentifier BUSINESSPROCESSSTATUS.ID Primary Key.
PARAMETERSETID uniqueidentifier CURRENCYEXCHANGERATEDOWNLOADPROCESS.ID FK to CURRENCYEXCHANGERATEDOWNLOADPROCESS
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS_DATEADDED DATEADDED yes
IX_CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS_DATECHANGED DATECHANGED
PK_CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS ID yes yes

Triggers

Trigger Name Description
TR_CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS_DELETE
TR_CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS_AUDIT_UPDATE
TR_CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS_AUDIT_DELETE