Warehouse table: StatusChange

Draws from CRM view A422_OpportunityStatusChange.

Status Change records are joined to parent records by the OpportunityGUID. 

 

This table is made available to clients via the Advanced Export.

 

This table represents the "Stage II" versioning of the warehouse.  For the stage I version, see below.


Warehouse tableWarehouse columnField typeCRM viewCRM columnNotesStandard Export nameCRM tab
StatusChangeChangeDateUTC A422_OpportunityStatusChangea422_changedateutc   
StatusChangeOpportunityGUID A422_OpportunityStatusChangea422_opportunityid   
StatusChangeStatusChangeGUID A422_OpportunityStatusChangea422_opportunitystatuschangeidprimary key  
StatusChangeCurrentCategoryGUID A422_OpportunityStatusChangea422_rel_curoppstatcatid   
StatusChangeCurrentCategory A422_OpportunityStatusChangea422_rel_curoppstatcatidname   
StatusChangeCurrentValueGUID A422_OpportunityStatusChangea422_rel_curoppstatvalid   
StatusChangeCurrentValue A422_OpportunityStatusChangea422_rel_curoppstatvalidname   
StatusChangeOriginalCategoryGUID A422_OpportunityStatusChangea422_rel_origoppstatcatid   
StatusChangeOriginalCategory A422_OpportunityStatusChangea422_rel_origoppstatcatidname   
StatusChangeOriginalValueGUID A422_OpportunityStatusChangea422_rel_origoppstatvalid   
StatusChangeOriginalValue A422_OpportunityStatusChangea422_rel_origoppstatvalidname   
StatusChangecategory_order A422_dom_oppstatuscategorya422_displayorder   
StatusChangecreatedby A422_OpportunityStatusChangecreatedby   
StatusChangecreatedbyname A422_OpportunityStatusChangecreatedbyname   
StatusChangecreatedonutc A422_OpportunityStatusChangecreatedonutc   
StatusChangemodifiedby A422_OpportunityStatusChangemodifiedby   
StatusChangemodifiedbyname A422_OpportunityStatusChangemodifiedbyname   
StatusChangemodifiedonutc A422_OpportunityStatusChangemodifiedonutc   
StatusChangestatecode A422_OpportunityStatusChangestatecode   
StatusChangestatecodename FilteredA422_OpportunityStatusChangestatecodename   
StatusChangestatuscode A422_OpportunityStatusChangestatuscode   
StatusChangestatuscodename FilteredA422_OpportunityStatusChangestatuscodename   

 

 

 


 

 

As of version "Stage I":

Fields which have been struck through are recommended for removal (or, in the case of the changedby fields, remaining unwarehoused).

columntyperequiredextract linkagesample dataanalytics useexport use
a422_changedatedatetime needs UTC conversionJul 14 2006 12:00AMsort order / all _Date fields in vw__StatusChange  
a422_changedateutcdatetime unfilteredJul 14 2006 4:00AMsort order (proposed) /all _Date fields in vw__StatusChange (proposed) 
a422_changedbyiduniqueidentifier not warehoused[guid]  
a422_changedbyiddscint not warehousedNULL  
a422_changedbyidnamenvarchar(160) not warehousedNULL  
a422_changedbyidyominamenvarchar(160) not warehousedNULL  
a422_currentstatusnvarchar(100) unfilteredApp: Incomplete  
a422_currentstatuscategorynvarchar(100) unfilteredApplicant: Incomplete  
a422_namenvarchar(100) unfilteredRebecca Norcross - 09 Fall  
a422_opportunityiduniqueidentifier unfiltered[guid]join 
a422_opportunityiddscint unfiltered0  
a422_opportunityidnamenvarchar(300) unfilteredRebecca Norcross - 09 Fall  
a422_opportunitystatuschangeiduniqueidentifieryesunfiltered[guid]primary key 
a422_originalstatusnvarchar(100) unfilteredInquiry  
a422_originalstatuscategorynvarchar(100) unfilteredInquiry  
a422_rel_curoppstatcatiduniqueidentifier unfiltered[guid]  
a422_rel_curoppstatcatiddscint unfiltered0  
a422_rel_curoppstatcatidnamenvarchar(100) unfilteredApplicant: Incompletefilter = various hardcoded values / vw__StatusChange. App_Status_Cat  
a422_rel_curoppstatvaliduniqueidentifier unfiltered[guid]  
a422_rel_curoppstatvaliddscint unfiltered0  
a422_rel_curoppstatvalidnamenvarchar(100) unfilteredDeposit: Paidvw__StatusChange. App_Status_Value 
a422_rel_origoppstatcatiduniqueidentifier unfiltered[guid]  
a422_rel_origoppstatcatiddscint unfiltered0  
a422_rel_origoppstatcatidnamenvarchar(100) unfilteredDeposit  
a422_rel_origoppstatvaliduniqueidentifier unfiltered[guid]  
a422_rel_origoppstatvaliddscint unfiltered0  
a422_rel_origoppstatvalidnamenvarchar(100) unfilteredDeposit: Paid  
category_orderint warehouse gets data from a different CRM view8  
createdbyuniqueidentifier unfiltered[guid]  
createdbydscint unfiltered0  
createdbynamenvarchar(160) unfilteredC422 System  
createdondatetime needs UTC conversionNov 9 2008 2:00PMsort order 
createdonutcdatetime unfilteredNov 9 2008 7:00PMsort order (proposed) / filter < @Today 
importsequencenumberint unfilteredNULL  
modifiedbyuniqueidentifier unfiltered[guid]  
modifiedbydscint unfiltered0  
modifiedbynamenvarchar(160) unfilteredC422 Admin  
modifiedondatetime needs UTC conversionJan 9 2009 1:34PM  
modifiedonutcdatetime unfilteredJan 9 2009 6:34PM  
overriddencreatedondatetime needs UTC conversionNULL  
overriddencreatedonutcdatetime unfilteredNULL  
owneriduniqueidentifier unfiltered[guid]  
owneriddscint unfiltered0  
owneridnamenvarchar(160) unfilteredAlan Hill  
owneridtypeint unfiltered8  
owningbusinessunituniqueidentifier unfiltered[guid]  
owninguseruniqueidentifier unfiltered[guid]  
statecodeintyesunfiltered0  
statecodenamenvarchar(255) needs filterActive  
statuscodeint unfiltered1  
statuscodenamenvarchar(255) needs filterActive  
Comments