Deltek Vantagepoint 2026.3 to Deltek Vantagepoint 2026.4 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.

New Tables

Table Name
ACCInitializationLog
ACCPeriodClosingChecklist
ACCPeriodClosingStep
ACCPeriodClosingTemplate
ACCPolicy
CFGReportServer
FW_FilesPendingPurge
FW_FilesPurgeLog
InsightLocalizedData
ProposalWorkspace
ProposalWorkspaceDocument
ProposalWorkspaceProjectRequirement
ProposalWorkspaceProjectRequirementAssignee
ProposalWorkspaceRequirement
ProposalWorkspaceRequirementAssignee
PRSummaryBudget
PRSummaryKeyMetrics
PRSummaryKeyMetricsPeriods
PRSummaryPOC

Removed Tables

Table Name
PRSummaryMain
AccountingControlCenterClosing

Renamed Tables

Table Name
None

New Columns Added to Existing Tables

Table NameColumn NameDataType
ApprovalItemHistoryApplicationIDvarchar(10) NOT NULL
CFGAPForm1099IRISCSVChunkSizeint NOT NULL
CFGGlobalSharedServicesAssistantLibURLnvarchar(255)
CFGGlobalSharedServicesTokenExchangeClientIDnvarchar(255)
CFGGlobalSharedServicesTokenExchangeProductIDnvarchar(255)
CFGGlobalSharedServicesTokenExchangeSecretNamenvarchar(255)
CFGGlobalSharedServicesTokenExchangeTenantIDnvarchar(255)
CFGResourcePlanningEnableCalcProjectPctCompleteEVAvarchar(1) NOT NULL
CFGResourcePlanningEnableUserEnteredPctCompleteEVAvarchar(1) NOT NULL
CFGResourcePlanningEnableWeightedProjectPctCompleteEVAvarchar(1) NOT NULL
CFGResourcePlanningUntBillRtMethodsmallint NOT NULL
EMCompanyNonExemptForPremiumOvertimeReportbit NOT NULL
EMCompanyRoundUpCalcRegHrsCAbit NOT NULL
EMMainBirthDatedate
ErrorStackTraceTraceIdvarchar(32)
FW_CFGSystemPRSummaryKeyMetricsLastUpdatedatetime
PNPlanUntBillRtMethodsmallint NOT NULL
PolicyDocumentLanguagevarchar(10)
PRSummaryWBSUnpostedHoursdecimal(28,4) NOT NULL
PRSummaryWBSUnpostedHoursOvtdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedHoursRegdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedHoursSpecialOvtdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborAmountdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborAmount_PCdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborBillExtdecimal(28,4) NOT NULL
PRSummaryWBSUnpostedLaborCostOvtdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborCostOvt_PCdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborCostRegdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborCostReg_PCdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborCostSpecialOvtdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborCostSpecialOvt_PCdecimal(19,4) NOT NULL
PRSummaryWBSUnpostedLaborReportingCurrencydecimal(19,4) NOT NULL
PRSummaryWBSWeightedFeeReportingCurrencydecimal(19,4) NOT NULL
RPPlanUntBillRtMethodsmallint NOT NULL
SEAccessEVAAllPlanCategoriesvarchar(1) NOT NULL
SEAllowFilePurgebit NOT NULL
tkControlPeriodIDbigint NOT NULL

 

Changes to Existing Columns

 

Table NameColumn NameNew DataTypeOld DataType
ApprovalItemApplicationIDvarchar(10) NOT NULLnvarchar(10)
CFGExportImportFileIVvarchar(4) NOT NULLchar(4) NOT NULL
CFGExportImportFileKeyvarchar(24) NOT NULLchar(24) NOT NULL
CFGScreenDesignerLabelsLabelnvarchar(2000)nvarchar(max)
CRDocumentsAssociateNewvarchar(1) NOT NULLchar(1) NOT NULL
FW_CFGLabelDataLabelNamenvarchar(50) NOT NULLvarchar(50) NOT NULL

Removed Columns

Table NameColumn NameDataType
CFGEMailPrefixEmailSendervarchar(1) NOT NULL
CFGGlobalSharedServicesRegisterURLnvarchar(255) NOT NULL
CFGPursuitScorePursuitScoreEnabledbit NOT NULL
FW_CFGSystemAccountingControlCenterEffectivePeriodint
FW_CFGSystemEnableAccountingControlCenterchar(1) NOT NULL
FW_CFGSystemOpenIDMetadatanvarchar(max)
PRSummaryMainARdecimal(19,4) NOT NULL
PRSummaryMainARBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainARProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainBilleddecimal(19,4) NOT NULL
PRSummaryMainBilledAddOndecimal(19,4) NOT NULL
PRSummaryMainBilledConsdecimal(19,4) NOT NULL
PRSummaryMainBilledExpdecimal(19,4) NOT NULL
PRSummaryMainBilledFeedecimal(19,4) NOT NULL
PRSummaryMainBilledInterestdecimal(19,4) NOT NULL
PRSummaryMainBilledLabdecimal(19,4) NOT NULL
PRSummaryMainBilledOtherdecimal(19,4) NOT NULL
PRSummaryMainBilledTaxesdecimal(19,4) NOT NULL
PRSummaryMainBilledUnitdecimal(19,4) NOT NULL
PRSummaryMainChargeTypevarchar(1) NOT NULL
PRSummaryMainGrossMargindecimal(19,4) NOT NULL
PRSummaryMainGrossMarginBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainGrossMarginProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainLaborBillingdecimal(19,4) NOT NULL
PRSummaryMainLaborCostdecimal(19,4) NOT NULL
PRSummaryMainLaborCostBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainLaborCostProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainModDatedatetime
PRSummaryMainModUsernvarchar(32)
PRSummaryMainNetRevenueBillingdecimal(19,4) NOT NULL
PRSummaryMainNetRevenueCostdecimal(19,4) NOT NULL
PRSummaryMainNetRevenueCostBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainNetRevenueCostProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainOverheaddecimal(19,4) NOT NULL
PRSummaryMainOverheadProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainPeriodint NOT NULL
PRSummaryMainProfitBillingdecimal(19,4) NOT NULL
PRSummaryMainProfitCostLessOHdecimal(19,4) NOT NULL
PRSummaryMainProfitCostLessOHBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainProfitCostLessOHProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainReceiveddecimal(19,4) NOT NULL
PRSummaryMainReceivedBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainReceivedProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainRevenuedecimal(19,4) NOT NULL
PRSummaryMainRevenueBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainRevenueProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainSpentBillingdecimal(19,4) NOT NULL
PRSummaryMainSpentCostLessOHdecimal(19,4) NOT NULL
PRSummaryMainSpentCostLessOHBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainSpentCostLessOHProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainTotalBilledWithInterestdecimal(19,4) NOT NULL
PRSummaryMainTotalBilledWithInterestBillingCurrencydecimal(19,4) NOT NULL
PRSummaryMainTotalBilledWithInterestProjectCurrencydecimal(19,4) NOT NULL
PRSummaryMainUnbilleddecimal(19,4) NOT NULL
PRSummaryMainWBS1nvarchar(30) NOT NULL
PRSummaryMainWBS2nvarchar(30) NOT NULL
PRSummaryMainWBS3nvarchar(30) NOT NULL

 

Renamed Columns

Table NameNew Column NameOld Column Name
None  

New Objects

Object NameObject Type
IsRCSIEnabledFunction
ACCInitializationLogPeriodIDCompanyIDXIndex
ACCPeriodClosingChecklistFiscalPeriodIDXIndex
ACCPeriodClosingStepChecklistIDSortOrderIDXIndex
ACCPeriodClosingTemplateProcessIDXIndex
APApprovalDocumentsFileIDXIndex
APApprovalMasterStatusIDXIndex
APDocumentsDetailFileIDIDXIndex
ApprovalItemApplicationIDItemParentUIDIDXIndex
ApprovalItemApplicationLookupIDXIndex
ApprovalItemDashboardIDXIndex
ApprovalItemParentWorkflowIDXIndex
CFGReportServerServerURLIDXIndex
ClendorVendorVendorINDIDXIndex
crControlCompanyIDXIndex
CreditCardTransactionTransTypeIDXIndex
EKDocumentsMasterPKeyFileIDIDXIndex
EMCompanyStatusIDXIndex
EMCompanyStatusReadyforProcessingIDXIndex
FW_FilesPurgeLogPurgeDateIDXIndex
FW_MasterJobsProcessStatusIDXIndex
InsightLocalizedDataInsightIDLanguageIDXIndex
LDEmployeePeriodChargeTypeIDXIndex
LedgerARReportIDXIndex
PNConsultantWBS1WBS2WBS3IDXIndex
PNExpenseWBS1WBS2WBS3IDXIndex
PNPlanPlanIDIDXIndex
POCOMasterRPIDXIndex
POMasterStatusIDXIndex
PRChargeTypeWBS2WBS3IDXIndex
PRClientIDBillingClientIDIDXIndex
PROrgNameIDXIndex
PRWBS1RevTypeIDXIndex
PRWBS2WBS3AvailableForCRMIDXIndex
PRWBS2WBS3StatusIDXIndex
PRWBS2WBS3WBS1IDXIndex
ProposalWorkspaceDocumentAnalysisStatusIsDeletedIDXIndex
ProposalWorkspaceDocumentFileIDIDXIndex
ProposalWorkspaceDocumentProposalWorkspaceIDIsDeletedCreateDateIDXIndex
ProposalWorkspaceRequirementAssigneeEmployeeIDIDXIndex
PRSummaryKeyMetricsActivePeriodIDXIndex
PRSummaryKeyMetricsCompanyActivePeriodIDXIndex
RPConsultantWBS1WBS2WBS3IDXIndex
RPExpenseWBS1WBS2WBS3IDXIndex
SEUserRefreshTokenUsernameAPIRefreshTokenExpiresIDXIndex
tkControlPeriodIDIDXIndex
tkDetailEmployeeEmployeeCompanyEndDateIDXIndex
tkMasterEndDateEmployeeCompanyEmployeeIDXIndex
tkMasterMasterPKeyIDXIndex
BuildPRSummaryBudgetStored Proc
BuildPRSummaryKeyMetricsStored Proc
BuildPRSummaryPOCStored Proc
PromotePRSummaryKeyMetricsPeriodStored Proc
SyncPRSummaryKeyMetricsPeriodsStored Proc
PRSummaryMainView

 

Removed Objects

Object NameObject Type
ApprovalItemApplicationIDApprovalLevelItemParent_UIDIDXIndex
ApprovalItemApplicationIDItemParent_UIDIDXIndex
ApprovalItemApplicationIDItemParentApprovalLevelIDXIndex
ApprovalItemApplicationKeyItemParentUIDIDXIndex
ApprovalItemAssignUSR_IDItemParent_UIDIDXIndex
ApprovalItemItemParent_UIDAssignUSR_IDIDXIndex
ApprovalItemItemParent_UIDIDXIndex
ApprovalItemItemParent_UIDItemLinkIDXIndex
ApprovalItemItemParentParentWorkflowStepIDXIndex
ApprovalItemItemTypeUIDIsClosedIDXIndex
ClendorVendorIDXIndex
EKDocumentsFileIDMasterPKeyIDXIndex
LDEmployeeIDXIndex
LDTransDateIDXIndex
LedgerARAccountIDXIndex
LedgerARWBS1AccountIDXIndex
LedgerEXAccountIDXIndex
LedgerMiscAccountIDXIndex
LedgerMiscWBS1AccountIDXIndex
POCOMasterRP1IDXIndex
POMasterVendorIDXIndex
PRClientIDCLAddressContactIDIDXIndex
PROpportunityIDIDXIndex
PROrgIDXIndex
PRPrincipalIDXIndex
RPConsultantWBS1WBS2WBS3AccountVendorIDXIndex
RPExpenseWBS1WBS2WBS3AccountVendorIDXIndex
tkDetailEndDateEmployeeEmployeeCompanySeqTransDateIDXIndex
tkMasterEndDateEmployeeEmployeeCompanyIDXIndex
VOPaidPeriodIDXIndex
ApplyReadUncommittedIfNoRCSIStored Proc
buildPRSummaryMainStored Proc

 

Renamed Objects

Object Name
None