Warehouse table: Awards

The Awards warehouse table corresponds to the A422_Award view in the CRM database.

Award 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
AwardsAmount A422_Awarda422_amount Award_0N_AmountOpportunity/Financial Aid
AwardsAwardGUID
A422_Awarda422_awardidprimary key  
AwardsAwardCategoryGUID
A422_Awarda422_rel_awardcategoryid   
AwardsAwardCategory A422_Awarda422_rel_awardcategoryidname   
AwardsAwardTypeGUID
A422_Awarda422_rel_awardtypeid   
AwardsAwardType A422_Awarda422_rel_awardtypeidname Award_0N_TypeOpportunity/Financial Aid
AwardsOpportunityGUID
A422_Awarda422_rel_opportunityid   
Awardscreatedby A422_Awardcreatedby   
Awardscreatedbyname A422_Awardcreatedbyname   
Awardscreatedonutc A422_Awardcreatedonutc   
Awardsmodifiedby A422_Awardmodifiedby   
Awardsmodifiedbyname A422_Awardmodifiedbyname   
Awardsmodifiedonutc A422_Awardmodifiedonutc FinancialAidModifiedOnOpportunity/Financial Aid
Awardsstatecode A422_Awardstatecode   
Awardsstatecodename FilteredA422_Awardstatecodename   
Awardsstatuscode A422_Awardstatuscode   
Awardsstatuscodename FilteredA422_Awardstatuscodename   

 

As of version "Stage I":

Fields which have been struck through are recommended for removal;  the fields dealing with currency conversion should be considered carefully. 

columntyperequiredextract linkagesample dataanalytics useexport use
a422_amountmoney unfiltered5000.00vw__Awards (all except oppid and date)Xport. Award_0N_Amount
a422_amount_basemoney unfiltered5000.00  
a422_awardiduniqueidentifieryesunfiltered[guid]primary keysort order
a422_namenvarchar(100) unfilteredAnu Ghimire - 10 Fall  
a422_rel_awardcategoryiduniqueidentifier unfiltered[guid]  
a422_rel_awardcategoryiddscint unfiltered0  
a422_rel_awardcategoryidnamenvarchar(100) unfilteredInstitutional merit grantfilter (various, hardcoded) 
a422_rel_awardtypeiduniqueidentifier unfiltered[guid]  
a422_rel_awardtypeiddscint unfiltered0  
a422_rel_awardtypeidnamenvarchar(100) unfilteredDean's Scholarship Xport. Award_0N_Type
a422_rel_opportunityiduniqueidentifier unfiltered[guid]join fieldjoin field
a422_rel_opportunityiddscint unfiltered0  
a422_rel_opportunityidnamenvarchar(300) unfilteredAnu Ghimire - 10 Fall  
a422_temp_awardcategoryint unfilteredNULL  
a422_temp_awardcategorynamenvarchar(255) needs filterNULL  
a422_temp_awardtypeint unfilteredNULL  
a422_temp_awardtypenamenvarchar(255) needs filterNULL  
createdbyuniqueidentifier unfiltered[guid]  
createdbydscint unfiltered0  
createdbynamenvarchar(160) unfilteredx_Pamela Hoffman  
createdondatetime needs UTC conversionFeb 12 2010 3:03PMfilter < getdate() (stub for future date filtering)
createdonutcdatetime unfilteredFeb 12 2010 8:03PMfilter < getdate() (stub for future date filtering) (proposed)filter < @Today
crm_moneyformatstringnvarchar(255) needs filterNULL  
exchangeratedecimal unfiltered1.0000000000  
importsequencenumberint unfilteredNULL  
modifiedbyuniqueidentifier unfiltered[guid]  
modifiedbydscint unfiltered0  
modifiedbynamenvarchar(160) unfilteredx_Pamela Hoffman  
modifiedondatetime needs UTC conversionFeb 12 2010 3:03PM sort order, Xport. FinancialAidModifiedOn
modifiedonutcdatetimeyesunfilteredFeb 1 2010 9:06PMprimary keysort order (proposed), Xport. FinancialAidModifiedOn (proposed)
ordint calculated field1 sort order
overriddencreatedondatetime unfilteredNULL  
overriddencreatedonutcdatetime needs filterNULL  
owneriduniqueidentifier unfiltered[guid]  
owneriddscint unfiltered0  
owneridnamenvarchar(160) unfilteredx_Pamela Hoffman  
owneridtypeint unfiltered8  
owningbusinessunituniqueidentifier unfiltered[guid]  
owninguseruniqueidentifier unfiltered[guid]  
statecodeintyesunfiltered0  
statecodenamenvarchar(255) needs filterActive  
statuscodeint unfiltered1  
statuscodenamenvarchar(255) needs filterActive  
timezoneruleversionnumberint unfilteredNULL  
transactioncurrencyiduniqueidentifier unfiltered[guid]  
transactioncurrencyiddscint unfiltered0  
transactioncurrencyidnamenvarchar(100) unfilteredUS Dollar  
utcconversiontimezonecodeint unfilteredNULL  

 


Comments