Extract table: XStaging

This table is first present in version Stage III. It replaces the staging function of the Xport table in prior versions.

At the beginning of the extract process, the guids of all opportunities with active entry terms are extracted to this table. In addition, the guids of all opportunities with inactive entry terms which have corresponding warehoused records with active entry terms are added to this table (this allows a final update to these records).

During the extract, all tables are joined to this table in order to limit the records extracted.

After the extract, the Xport table uses this table to limit the records selected for the standard export.
Warehouse tableWarehouse columnField typeCRM viewCRM columnNotes
XStagingOpportunityGUIDuniqueidentifierOpportunityopportunityid 
XStagingPersonGUIDuniqueidentifierOpportunitycontactid
XStagingIsActivebitn/an/areflects the active or inactive state of the opportunity's entry term

Comments