PHONEFINDERRESUBMITPROCESS

Stores data pertaining to the PhoneFinder resubmit business process

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
NAME nvarchar(100) Default = 'PhoneFinder Resubmit Process' Name of the process
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.
DATELASTRUN datetime yes The date this process was last run

Foreign Keys

Foreign Key Field Type Null Notes Description
PHONEFINDERID uniqueidentifier PHONEFINDER.ID The ID of the PhoneFinder that this resubmit process belongs to
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_PHONEFINDERRESUBMITPROCESS_DATEADDED DATEADDED yes
IX_PHONEFINDERRESUBMITPROCESS_DATECHANGED DATECHANGED
PK_PHONEFINDERRESUBMITPROCESS ID yes yes
UC_PHONEFINDERRESUBMITPROCESS_PHONEFINDERID PHONEFINDERID yes

Triggers

Trigger Name Description
TR_PHONEFINDERRESUBMITPROCESS_AUDIT_UPDATE
TR_PHONEFINDERRESUBMITPROCESS_AUDIT_DELETE

Referenced by

Referenced by Field
PHONEFINDERRESUBMITPROCESSSTATUS PARAMETERSETID