Deltek Vantagepoint 6.5 to Deltek Vantagepoint 7.0 Database Changes

Deltek generates this information using a live connection to the development database. Tables and columns related to features in a future release may appear in the data dictionary without descriptions, or with the phrase reserved for future use. You may also see tables and columns for features that you have not purchased or enabled.

New Tables

Table Name

AICache

CFGAIPrompts

CFGAISettings

CFGCompensationGroupsData

CFGCompensationGroupsDescriptions

CFGFeatureFlag

ClarityDashpart

PNSubAssignment

RPSubAssignment

TSAssist

Removed Tables

Table Name

None

Renamed Tables

Table Name

None

New Columns Added to Existing Tables

Table Name	Column Name	DataType
apDetail	TotalPaymentAmount	decimal(19,4) NOT NULL
billConDetail	AmountPerMile	decimal(19,4) NOT NULL
billConDetail	DistanceType	varchar(1)
billConDetail	Documents	varchar(1)
billConDetail	Miles	decimal(19,4) NOT NULL
billConDetail	Reason	nvarchar(255)
billConDetail	SuppressBill	varchar(1)
billExpDetail	AmountPerMile	decimal(19,4) NOT NULL
billExpDetail	DistanceType	varchar(1)
billExpDetail	Documents	varchar(1)
billExpDetail	Miles	decimal(19,4) NOT NULL
billExpDetail	Reason	nvarchar(255)
billExpDetail	SuppressBill	varchar(1)
billUnitDetail	Documents	varchar(1)
billUnitDetail	SuppressBill	varchar(1)
CFGBillMainData	BillingPhaseCreationEnabled	varchar(1) NOT NULL
CFGBillMainData	FeeVarIndEnabled	varchar(1) NOT NULL
CFGBillMainData	TotalFeeUpdateEnabled	varchar(1) NOT NULL
CFGTKEmployeeGroup	EnableTSAssistGroup	varchar(1) NOT NULL
CFGTKMain	DaysBeforePrompt	int NOT NULL
CFGTKMain	EnableTSAssist	varchar(1) NOT NULL
CFGTransCustomFields	Status	varchar(1) NOT NULL
FW_CFGSystem	EnableGenerativeAI	varchar(1) NOT NULL
FW_CFGSystem	GenerativeAICacheTimeout	int NOT NULL
FW_CFGSystem	TeamsTenantID	varchar(36)
FW_MasterJobs	SystemJob	varchar(1) NOT NULL
MergeTemplateDocuments	TemplateName	nvarchar(80) NOT NULL
PNBaselineLabor	SubAssignmentID	varchar(32)
PNPlan	PlanType	varchar(1) NOT NULL
PNPlan	ScenarioColor	varchar(7) NOT NULL
PNPlan	ScenarioName	nvarchar(255)
PNPlannedLabor	SubAssignmentID	varchar(32)
POPRMaster	RFQOnly	varchar(1) NOT NULL
PR	UID	varchar(32) NOT NULL
PRDefaults	UID	varchar(32) NOT NULL
PRTemplate	UID	varchar(32) NOT NULL
RPBaselineLabor	SubAssignmentID	varchar(32)
RPPlan	PlanType	varchar(1) NOT NULL
RPPlan	ScenarioColor	varchar(7) NOT NULL
RPPlan	ScenarioName	nvarchar(255)
RPPlannedLabor	SubAssignmentID	varchar(32)
SavedSelectionsMain	ListViewDisplay	varchar(1)
SavedSelectionsMain	ResultsToDisplay	varchar(1)
SE	AllowBulkUpdate	varchar(1) NOT NULL
SE	GenerativeAIFirmSummary	varchar(1) NOT NULL
SE	GenerativeAIProjectSummary	varchar(1) NOT NULL
SEUser	TwoFactorAuthSeed	nvarchar(64)

 

Changes to Existing Columns

 

Table Name	Column Name	New DataType	Old DataType
LookupXmlCache	LookupXML	varbinary	image
MergeTemplateDocuments	FileDescription	nvarchar(max)	nvarchar(1000)
SavedInvoices	InvoiceContents	varbinary	image
savedVisualizations	Tbl	varbinary NOT NULL	image NOT NULL

Removed Columns

Table Name	Column Name	DataType
PR	PlanID	varchar(32)
PRDefaults	PlanID	varchar(32)
PRTemplate	PlanID	varchar(32)
SEUser	ODBCPassword	nvarchar(255)

 

Renamed Columns

Table Name	New Column Name	Old Column Name
None

New Objects

Object Name	Object Type
CFGAIPromptsTypeSeqIDX	Index
CFGFeatureFlagNameIDX	Index
MergeTemplateDocumentsTemplateNameIDX	Index
PNSubAssignmentOtherIDX	Index
RPSubAssignmentOtherIDX	Index
sp_stRPAbsenceApprovalAddJTDAssignment	Stored Proc
sp_stRPAbsenceDeletionUpdateJTDAssignment	Stored Proc
sp_stRPRemovePlannedHoursOnAbsenceDeletion	Stored Proc

 

Removed Objects

Object Name	Object Type
UpdateCFGBillMainTrigger	Trigger

 

Renamed Objects

Object Name

None