C<nnnn>IMACStagingQueue

<< Click to Display Table of Contents >>

Navigation:  Modules > Asset Management > Integrating with Other Asset Management Systems > Tables in the View >

C<nnnn>IMACStagingQueue

The IMAC Staging Queue table is the collection point of all data coming from all catch points.  Each catch point is assigned a number, which you will find in the cpNo column.  At any given time, one record per asset per catch point will exist in the IMAC Staging Queue table.  Each catch point is designed to source different information, so a record in the staging table may have only a few of the possible columns populated.  Periodically, an automated job called Consolidate runs on the MIE to pull the information from the staging table into the main repository.

There are many columns in the staging table and most are easily discernible by their names.

Catch Points

Catch points vary from customer to customer, however some are typically present in a solution.  Most are numbered uniquely, however a few are assigned a static number that will not vary.  The following catch points have been assigned the following static cpNo values:

Catch Point

cpNo

ASN Processor

-1

WTR utility

-2

Feedback channel (used to feed back changes to various values that were made via the master repository.)

-3

Auto-harvest (items automatically harvested by Consolidate)

-4

Disposals

-5

Workstation Data Assistant auto-discovery

-6