Deltek Vision project import queries

Below are sample queries that can be used when creating a custom SQL import from Deltek Vision:

Project level:

Select WBS1 as ProjectNumber, Name as ProjectName, Org as Location, ChargeType from pr
Where WBS2 = ''
And Status = 'A'

Phase level:

Select WBS1 as ParentProject, WBS2 as PhaseNumber, Name as PhaseName from pr
WHERE WBS2 <> ''
AND WBS3 = ''
AND Status = 'A'
AND WBS1 IN
(Select WBS1 from pr
Where WBS2 = ''
And Status = 'A')