Warehouse Table: Interests

The Interests warehouse table corresponds to the A422_Interests view in the CRM database.

Interest 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
InterestsInterestGUID A422_Interestsa422_interestidprimary key  
InterestsInterestCategoryGUID A422_Interestsa422_rel_interestcategoryid   
InterestsInterestCategory A422_Interestsa422_rel_interestcategoryidname   
InterestsInterestValueGUID A422_Interestsa422_rel_interestvalueid   
InterestsInterestValue A422_Interestsa422_rel_interestvalueidname Interest_0N_ValueOpportunity/Interests
InterestsOpportunityGUID A422_Interestsa422_rel_opportunityid   
Interestscreatedby A422_Interestscreatedby   
Interestscreatedbyname A422_Interestscreatedbyname   
Interestscreatedonutc A422_Interestscreatedonutc   
Interestsmodifiedby A422_Interestsmodifiedby   
Interestsmodifiedbyname A422_Interestsmodifiedbyname   
Interestsmodifiedonutc A422_Interestsmodifiedonutc   
Interestsstatecode A422_Interestsstatecode   
Interestsstatecodename FilteredA422_Interestsstatecodename   
Interestsstatuscode A422_Interestsstatuscode   
Interestsstatuscodename FilteredA422_Interestsstatuscodename   

 

 


 


 

 

 


 

 

 

As of version "Stage I":

Fields which have been struck through are recommended for removal. 

columntyperequiredextract linkagesample dataanalytics useexport use
a422_categorynvarchar(100) unfilteredNULL  
a422_interestiduniqueidentifieryesunfiltered[guid]primary keyorder by
a422_namenvarchar(100) unfilteredNathan Bardos - 11 Fall  
a422_rel_interestcategoryiduniqueidentifier unfiltered[guid]  
a422_rel_interestcategoryiddscint unfiltered0  
a422_rel_interestcategoryidnamenvarchar(100) unfilteredCo-curricular  
a422_rel_interestvalueiduniqueidentifier unfiltered[guid]  
a422_rel_interestvalueiddscint unfiltered0  
a422_rel_interestvalueidnamenvarchar(100) unfilteredDance team Xport. Interest_0N_Value
a422_rel_opportunityiduniqueidentifier unfiltered[guid]joinjoin
a422_rel_opportunityiddscint unfiltered0  
a422_rel_opportunityidnamenvarchar(300) unfilteredNathan Bardos - 11 Fall  
a422_temp_interestcategoryint unfilteredNULL  
a422_temp_interestcategorynamenvarchar(255) warehouse needs filterNULL  
a422_temp_interestvalueint unfilteredNULL  
a422_temp_interestvaluenamenvarchar(255) warehouse needs filterNULL  
a422_valuenvarchar(100) unfilteredNULL  
createdbyuniqueidentifier unfiltered[guid]  
createdbydscint unfiltered0  
createdbynamenvarchar(160) unfilteredC422 System  
createdondatetime warehouse needs filter or UTC functionOct 15 2009 12:00PM  
createdonutcdatetime unfilteredOct 15 2009 4:00PM filter < @Today
importsequencenumberint unfilteredNULL  
modifiedbyuniqueidentifier unfiltered[guid]  
modifiedbydscint unfiltered0  
modifiedbynamenvarchar(160) unfilteredC422 System  
modifiedondatetime warehouse needs filter or UTC functionOct 15 2009 12:00PM  
modifiedonutcdatetimeyesunfilteredOct 15 2009 4:00PMprimary keyorder by
ordint calculated field1 order by
overriddencreatedondatetime warehouse needs filter or UTC functionNULL  
overriddencreatedonutcdatetime unfilteredNULL  
owneriduniqueidentifier unfiltered[guid]  
owneriddscint unfiltered0  
owneridnamenvarchar(160) unfilteredC422 System  
owneridtypeint unfiltered8  
owningbusinessunituniqueidentifier unfiltered[guid]  
owninguseruniqueidentifier unfiltered[guid]  
statecodeintyesunfiltered0 filter = 0
statecodenamenvarchar(255) warehouse needs filterActive  
statuscodeint unfiltered1  
statuscodenamenvarchar(255) warehouse needs filterActive  

Comments