Warehouse table: FinAidProfile

Draws from CRM view Opportunity.  All fields are present in the unfiltered view.

FinAidProfile  records are joined to parent records by the OpportunityGUID. 

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

 

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
FinAidProfile_LocalAdjGrossIncomemoneyOpportunitya422_fa_AdjGrossIncome   
FinAidProfile_LocalFederalNeedmoneyOpportunitya422_fa_FederalNeed   
FinAidProfile_LocalFedFamilyContmoneyOpportunitya422_fa_FedFamilyCont   
FinAidProfile_LocalFedParentContmoneyOpportunitya422_fa_FedParentCont   
FinAidProfile_LocalFedStudentContmoneyOpportunitya422_fa_FedStudentCont   
FinAidProfile_LocalInstFamilyContmoneyOpportunitya422_fa_InstFamilyCont   
FinAidProfile_LocalInstitutionalNeedmoneyOpportunitya422_fa_InstitutionalNeed   
FinAidProfile_LocalInstParentContmoneyOpportunitya422_fa_InstParentCont   
FinAidProfile_LocalInstStudentContmoneyOpportunitya422_fa_InstStudentCont   
FinAidProfile_LocalOpportunityGUIDuniqueidentifierOpportunityopportunityid   
FinAidProfile_LocalTotalAwardmoneyOpportunitya422_fa_TotalAward   
FinAidProfile_LocalTotalBudgetmoneyOpportunitya422_fa_TotalBudget   
FinAidProfileEffectiveDatedate





Comments