Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FIXEDWIDTH tinyint   Default = 1 The total number of characters that will be used by each finder number. Unused space will be padded with zeros.
 FINDERNUMBER bigint   Default = ((1)) The next available number that will be assigned to the first record in the next activated marketing effort.
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CHECKDIGIT bit   Default = 0 Do finder numbers use a check digit?
 LAST_FINDERNUMBER bigint   Default = ((0)) The last finder number reserved before check digit is turned on.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_MKTFINDERNUMBER_DATEADDED DATEADDED    
 IX_MKTFINDERNUMBER_DATECHANGED DATECHANGED      
 PK_MKTFINDERNUMBER ID  

Trigger Name Description
 TR_MKTFINDERNUMBER_AUDIT_UPDATE
 TR_MKTFINDERNUMBER_AUDIT_DELETE