Skip to content

Query: Qry Report Action Log

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

Tables Referenced

  • Purple Meeting Actions
  • vwPurpleCountExitedNeedReplacementbyPrincipalProjectPillar
  • Principal Project Pillars
  • Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP
  • vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar
  • vwPurpleCountUnallocatedCompaniesbyPrincipalProjectRec
  • vwPurpleSumTotalSponsorshipbyPrincipalProjectPillar
  • Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP
  • vwPurpleCountActiveAllocatedCompaniesbyPrinProjPillar
  • vwPurpleCountExitedCompaniesbyPrincipalProjectPillar
  • vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar
  • PrincipalProjectStatus
  • Principal
  • Principal Projects
  • Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP
  • Principals

Columns Selected

  • [Principal Project Pillars].[Principal Project Pillar Urgency]
  • IIf(IsNull([Project Name]),0,[Principal] & \
  • IIf(IsNull([Project Name]),\
  • [Principal Project Pillars].[BBBEE Pillar]
  • [Principal Project Pillars].[Lump Sum Allocation]
  • [Principal Project Pillars].[Amount Sponsored]
  • IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total
  • [Amount Sponsored]-[Total Sponsorship]
  • IIf([Amount Sponsored]=0,0,[Total Sponsorship]/[Amount Sponsored])
  • DateDiff(\
  • DateDiff(\
  • [Purple Meeting Actions].[Date Completed]
  • [Purple Meeting Actions].[Date Created]
  • Priority
  • Department
  • IIf([Department]=\
  • Scout
  • [Principal Projects].[Solutions Architect]
  • Action
  • [Purple Meeting Actions].[Due Date]
  • [Principal Project Pillars].[Number of Companies Required]
  • Status
  • IIf(IsNull([Number Entrepreneurs Phase 1]),0,[Number Entrepreneurs Phase 1])
  • IIf(IsNull([Number Entrepreneurs Phase 2]),0,[Number Entrepreneurs Phase 2])
  • IIf(IsNull([Number Entrepreneurs Phase 3]),0,[Number Entrepreneurs Phase 3])
  • IIf(IsNull([Number Active Allocated Companies]),0,[Number Active Allocated Compa
  • IIf(IsNull([Number Exited Companies]),0,[Number Exited Companies])
  • IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies])
  • [Number of Companies Required]-[Active]-[Exited]-[Unallocated]
  • IIf(IsNull([Number of Replacements Needed]),0,[Number of Replacements Needed])

Where Clause

((([Purple Meeting Actions].[Date Completed]) Is Null))

Order By

[Principal Project Pillars].[Principal Project Pillar Urgency], IIf(IsNull([Project Name]),0,[Principal] & \

SQL

SELECT [Principal Project Pillars].[Principal Project Pillar Urgency], IIf(IsNull([Project Name]),0,[Principal] & \, IIf(IsNull([Project Name]),\, [Principal Project Pillars].[BBBEE Pillar], [Principal Project Pillars].[Lump Sum Allocation], [Principal Project Pillars].[Amount Sponsored], IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total, [Amount Sponsored]-[Total Sponsorship], IIf([Amount Sponsored]=0,0,[Total Sponsorship]/[Amount Sponsored]), DateDiff(\, DateDiff(\, [Purple Meeting Actions].[Date Completed], [Purple Meeting Actions].[Date Created], [Purple Meeting Actions].Priority, [Purple Meeting Actions].Department, IIf([Department]=\, [Principal Project Pillars].Scout, [Principal Projects].[Solutions Architect], [Purple Meeting Actions].Action, [Purple Meeting Actions].[Due Date], [Principal Project Pillars].[Number of Companies Required], PrincipalProjectStatus.Status, IIf(IsNull([Number Entrepreneurs Phase 1]),0,[Number Entrepreneurs Phase 1]), IIf(IsNull([Number Entrepreneurs Phase 2]),0,[Number Entrepreneurs Phase 2]), IIf(IsNull([Number Entrepreneurs Phase 3]),0,[Number Entrepreneurs Phase 3]), IIf(IsNull([Number Active Allocated Companies]),0,[Number Active Allocated Compa, IIf(IsNull([Number Exited Companies]),0,[Number Exited Companies]), IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies]), [Number of Companies Required]-[Active]-[Exited]-[Unallocated], IIf(IsNull([Number of Replacements Needed]),0,[Number of Replacements Needed]) FROM [Principal Project Pillars], [Principal Projects], [Principals], [PrincipalProjectStatus], [Purple Meeting Actions], [Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP], [Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP], [Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP], [vwPurpleCountActiveAllocatedCompaniesbyPrinProjPillar], [vwPurpleCountExitedCompaniesbyPrincipalProjectPillar], [vwPurpleCountExitedNeedReplacementbyPrincipalProjectPillar], [vwPurpleCountUnallocatedCompaniesbyPrincipalProjectRec], [vwPurpleSumTotalSponsorshipbyPrincipalProjectPillar], [vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar], [vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar] WHERE ((([Purple Meeting Actions].[Date Completed]) Is Null))