While this table does not have a field defined as a primary key, the DEDUPJOBID field should be unique and considered a primary key.
Added in version 7.5.4
The DEDEUPJOB table stores details about the running de-duplication job.
|
|
While this table does not have a field defined as a primary key, the DEDUPJOBID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
DEDUPJOBID |
varchar(12) |
NOT NULL |
DEDUPJOB_PRIMARY (AK) |
(One) to (Many) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
|
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
|
|
|
|
ENTITYNAME |
varchar(64) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
STATUS |
varchar(255) |
NULLS |
|
|
|
|
STATUSDESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
DATA |
text |
NULLS |
|
|
|
|
RECORDCOUNT |
int |
NULLS |
|
|
|
|
DUPLICATECOUNT |
int |
NULLS |
|
|
|
|
PROCESSEDCOUNT |
int |
NULLS |
|
|
|
|
STARTDATE |
datetime |
NULLS |
|
|
|
|
COMPLETEDDATE |
datetime |
NULLS |
|
|
|
|
JOBNAME |
varchar(64) |
NULLS |
|
|
|
|
SOURCEDESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
DUPLICATESPROCESSED |
int |
NULLS |
|
|
|