Table to track spatial changes in the work tables
Field Name |
Caption |
Mask |
Description |
Field Type |
SPCH_ADDRESS |
|
250x |
Address |
Text |
SPCH_ASSETID |
|
|
Asset ID (WKWOASSET.AS_INV_ID, WKREQ.RQ_INFR_ID, etc) |
Long Integer |
SPCH_CATINV |
|
|
The CATINV for the asset |
Long Integer |
SPCH_DATETIME |
|
|
Date Time stamp when change was made |
Date/Time |
SPCH_GUID |
|
36x |
This field acts as an identifier for records that the spatial indexer has processed. This is used instead of a bit flag because we may want to allow multiple machines to run the spatial indexer and we want to make sure that two machines are not procesing |
Text |
SPCH_ID |
|
|
Auto ID |
Long Integer |
SPCH_LINK1 |
|
150x |
Common Id |
Text |
SPCH_LOC_ID |
|
|
Child ID (WKWOASSET.AS_ID, WKORDERLOC.WL_ID, etc) |
Long Integer |
SPCH_LOCTYPE |
|
20x |
Table name of the table containing the location data (WKWOASSET, WKORDERLOC, etc) |
Text |
SPCH_PARENTID |
|
|
Parent ID (WKORDER.WO_ID, WKROUTINE.TO_ID, or WKREQ.RQ_ID) |
Long Integer |
SPCH_PROCDTTM |
|
|
The date and time that the record was selected for processing |
Date/Time |
SPCH_SU_DESC |
|
250x |
Spatial Updater Error Message |
Text |
SPCH_SU_ERROR |
|
20x |
Spatial Updater Error Type |
Text |
SPCH_TYPE |
|
20x |
Type of Change (INSERT or UPDATE) |
Text |
SPCH_X |
|
|
X Coordinate |
Double |
SPCH_Y |
|
|
Y Coordinate |
Double |