Skip to content

Query: Qry Report Summarised Deferred Income

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • vwGarnetReportSumDeferredIncomeOBBalance
  • Temp Principal Projects for Finance Report
  • vwGarnetReportSumDeferredIncomeTotalSponsorshipNonGraduate
  • vwGarnetReportSumDeferredIncomeSEDSpend
  • vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship
  • vwGarnetReportSumDeferredIncomeNGSelectionFeeandBilledDate
  • Temp
  • vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement
  • vwGarnetReportSumDeferredIncomeOGBSelectionFeeandBilledDate

Columns Selected

  • [Temp Principal Projects for Finance Report].[Principal Project ID]
  • [Temp Principal Projects for Finance Report].[Principal Project]
  • [Temp Principal Projects for Finance Report].[Total Spend]
  • IIf(IsNull([OGB Total Selection Fee]),0,[OGB Total Selection Fee])+IIf(IsNull([O
  • vwGarnetReportSumDeferredIncomeOBBalance.[On P Blank Total Balance]
  • vwGarnetReportSumDeferredIncomeSEDSpend.[SED Spend]
  • vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship.[Future Yr Total Spons
  • [Total Spend]-(IIf(IsNull([On P Grad Blank Total Sponsorship]),0,[On P Grad Blan
  • vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement.[NR Total Balance]

Order By

[Temp Principal Projects for Finance Report].[Principal Project]

SQL

SELECT [Temp Principal Projects for Finance Report].[Principal Project ID], [Temp Principal Projects for Finance Report].[Principal Project], [Temp Principal Projects for Finance Report].[Total Spend], IIf(IsNull([OGB Total Selection Fee]),0,[OGB Total Selection Fee])+IIf(IsNull([O, vwGarnetReportSumDeferredIncomeOBBalance.[On P Blank Total Balance], vwGarnetReportSumDeferredIncomeSEDSpend.[SED Spend], vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship.[Future Yr Total Spons, [Total Spend]-(IIf(IsNull([On P Grad Blank Total Sponsorship]),0,[On P Grad Blan, vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement.[NR Total Balance] FROM [Temp Principal Projects for Finance Report], [vwGarnetReportSumDeferredIncomeBalanceNeedsReplacement], [vwGarnetReportSumDeferredIncomeFutureYearTotalSponsorship], [vwGarnetReportSumDeferredIncomeNGSelectionFeeandBilledDate], [vwGarnetReportSumDeferredIncomeOBBalance], [vwGarnetReportSumDeferredIncomeOGBSelectionFeeandBilledDate], [vwGarnetReportSumDeferredIncomeSEDSpend], [vwGarnetReportSumDeferredIncomeTotalSponsorshipNonGraduate]