Deltek Vantagepoint 2026.1 to Deltek Vantagepoint 2026.2 Database Changes

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.

NewTables

TableName
CacheInvalidationEvent
CFGInsightTypesEnabled
CFGPursuitScore
CFGPursuitScoreFactors
CustomerIntelligence
ErrorStackTrace
FirmGrid
IDRDocumentResults
IDRJobQueue
IDRSchema
InsightTypeUserSubscription
PolicyDocument
PRSummaryWBS
UserCookieConsent

NewColumns

TableName ColumnName DataType
ApprovalWorkflowActions NaturalLanguage nvarchar(max)
ApprovalWorkflowActions PolicyDocumentID int
CFGVisionSystem ReportingCurrencyCode nvarchar(3)
CFGVisionSystem ReportingCurrencyTranslationMethod varchar(1)
FW_CFGSystem EnableDelaContractManagementAgent varchar(1) NOT NULL
FW_EmailLog Response nvarchar(max)
InvoiceApproval ApprovedBy nvarchar(20)
InvoiceApproval ApprovedDate datetime
InvoiceApproval CreateDate datetime
InvoiceApproval CreateUser nvarchar(32)
MergeTemplateDocuments SelectionMode nvarchar(20)
PRSummarySub ARReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledAddOnReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledConsReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledExpReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledFeeReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledInterestReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledLabReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledOtherReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledTaxesReportingCurrency decimal(19,4) NOT NULL
PRSummarySub BilledUnitReportingCurrency decimal(19,4) NOT NULL
PRSummarySub DirectConsBillingReportingCurrency decimal(19,4) NOT NULL
PRSummarySub DirectConsCostReportingCurrency decimal(19,4) NOT NULL
PRSummarySub DirectOtherBillingReportingCurrency decimal(19,4) NOT NULL
PRSummarySub DirectOtherCostReportingCurrency decimal(19,4) NOT NULL
PRSummarySub InDirectBillingReportingCurrency decimal(19,4) NOT NULL
PRSummarySub InDirectCostReportingCurrency decimal(19,4) NOT NULL
PRSummarySub LaborBillingReportingCurrency decimal(19,4) NOT NULL
PRSummarySub LaborCostReportingCurrency decimal(19,4) NOT NULL
PRSummarySub LaborOvtAmtReportingCurrency decimal(19,4) NOT NULL
PRSummarySub LaborRegAmtReportingCurrency decimal(19,4) NOT NULL
PRSummarySub LaborSpecialOvtAmtReportingCurrency decimal(19,4) NOT NULL
PRSummarySub OverheadReportingCurrency decimal(19,4) NOT NULL
PRSummarySub ReceivedReportingCurrency decimal(19,4) NOT NULL
PRSummarySub ReimbConsBillingReportingCurrency decimal(19,4) NOT NULL
PRSummarySub ReimbConsCostReportingCurrency decimal(19,4) NOT NULL
PRSummarySub ReimbOtherBillingReportingCurrency decimal(19,4) NOT NULL
PRSummarySub ReimbOtherCostReportingCurrency decimal(19,4) NOT NULL
PRSummarySub RevenueReportingCurrency decimal(19,4) NOT NULL
PRSummarySub TotalBilledWithInterestReportingCurrency decimal(19,4) NOT NULL
PRSummarySub UnbillGainLossReportingCurrency decimal(19,4) NOT NULL
tkDetail CreateDate datetime
tkDetail CreateUser nvarchar(32)
tkDetail ModDate datetime
tkDetail ModUser nvarchar(32)
tkUnitDetail CreateDate datetime
tkUnitDetail CreateUser nvarchar(32)
tkUnitDetail ModDate datetime
tkUnitDetail ModUser nvarchar(32)

ModifiedColumns

TableName ColumnName OldDataType NewDataType
FW_CustomColumnValuesData Seq smallint NOT NULL int NOT NULL

RemovedTables

TableName
InsightCategoryUserSubscription

RemovedColumns

TableName ColumnName DataType
ItemRequestVendorDetail QuoteDate datetime
ItemRequestVendorDetail QuotePerson nvarchar(100)
ItemRequestVendorDetail QuotePrice decimal(19,4) NOT NULL
ItemRequestVendorDetail UOM nvarchar(20)

NewObjects

ParentObjectName ChildObjectName ObjectType
Clendor ClendorClientIDX Index
LedgerAR LedgerARWBS1WBS2WBS3IDX Index
PNTask PNTaskPlanIDParentOutlineNumberIDX Index
PolicyDocument PolicyDocumentFileIDIDX Index
PolicyDocument PolicyDocumentFileNameIDX Index
RPTask RPTaskPlanIDParentOutlineNumberIDX Index
buildPRSummaryWBS Stored Proc
stRPReassignTPD Stored Proc
stRPRedistribute_SubAssignment Stored Proc
stRPRedistributeChangePlannedHours_SubAssignment Stored Proc

RemovedObjects

ParentObjectName ChildObjectName ObjectType
LedgerARWBS1WBS2WBS3PeriodAutoEntryTransTypeIDX Index
PNTaskPlanIDIDX Index
RPTaskPlanIDIDX Index