Skip to content

Query: Qry Principal Project Pillar List

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

Tables Referenced

  • Qry
  • Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP
  • vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar
  • Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP
  • Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP
  • vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar
  • vwPurpleWeavePrincipalProjectPillarList
  • Qry Sum Total Replaced To Be Billed by Prin Project Pillar

Columns Selected

  • vwPurpleWeavePrincipalProjectPillarList.[Principal Project Pillar ID]
  • vwPurpleWeavePrincipalProjectPillarList.[Principal Project ID]
  • [Principal] & \
  • vwPurpleWeavePrincipalProjectPillarList.[BBBEE Pillar]
  • vwPurpleWeavePrincipalProjectPillarList.[Lump Sum Allocation]
  • vwPurpleWeavePrincipalProjectPillarList.[Number of Companies Required]
  • vwPurpleWeavePrincipalProjectPillarList.[Principal Project Status ID]
  • Status
  • Scout
  • vwPurpleWeavePrincipalProjectPillarList.[Key Account Manager]
  • vwPurpleWeavePrincipalProjectPillarList.[Solutions Architect]
  • vwPurpleWeavePrincipalProjectPillarList.[Principal Project Pillar Urgency]
  • 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])
  • vwPurpleWeavePrincipalProjectPillarList.[Amount Sponsored]
  • IIf([Lump Sum Allocation]=True,IIf([Active]=0 And [Exited]=0,0,[Amount Sponsored
  • IIf([Lump Sum Allocation]=True,0,[Amount Sponsored]-[Total Sponsorship])
  • IIf([Lump Sum Allocation]=True,0,IIf(IsNull([Total To Be Billed]),0,[Total To Be
  • vwPurpleWeavePrincipalProjectPillarList.[Date Principal Requires Packs]

SQL

SELECT vwPurpleWeavePrincipalProjectPillarList.[Principal Project Pillar ID], vwPurpleWeavePrincipalProjectPillarList.[Principal Project ID], [Principal] & \, vwPurpleWeavePrincipalProjectPillarList.[BBBEE Pillar], vwPurpleWeavePrincipalProjectPillarList.[Lump Sum Allocation], vwPurpleWeavePrincipalProjectPillarList.[Number of Companies Required], vwPurpleWeavePrincipalProjectPillarList.[Principal Project Status ID], vwPurpleWeavePrincipalProjectPillarList.Status, vwPurpleWeavePrincipalProjectPillarList.Scout, vwPurpleWeavePrincipalProjectPillarList.[Key Account Manager], vwPurpleWeavePrincipalProjectPillarList.[Solutions Architect], vwPurpleWeavePrincipalProjectPillarList.[Principal Project Pillar Urgency], 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]), vwPurpleWeavePrincipalProjectPillarList.[Amount Sponsored], IIf([Lump Sum Allocation]=True,IIf([Active]=0 And [Exited]=0,0,[Amount Sponsored, IIf([Lump Sum Allocation]=True,0,[Amount Sponsored]-[Total Sponsorship]), IIf([Lump Sum Allocation]=True,0,IIf(IsNull([Total To Be Billed]),0,[Total To Be, vwPurpleWeavePrincipalProjectPillarList.[Date Principal Requires Packs] FROM [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], [Qry Sum Total Replaced To Be Billed by Prin Project Pillar], [vwPurpleWeavePrincipalProjectPillarList], [vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar], [vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar]