Deltek Vantagepoint 2025.3 to Deltek Vantagepoint 2025.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.

NewTables

TableName
APInvoiceCustomFields
CFGQueryTimeout
EquipmentPhoto
FW_FilesRag
UserPlanSelections

NewColumns

TableName ColumnName DataType
BT ApprovalWorkflow varchar(32)
BTDefaults ApprovalWorkflow varchar(32)
CFGApprovalType ItemTypeUpgraded bit NOT NULL
CFGBanks PlaidExpirationDate datetime
CFGBanks PlaidRegion varchar(2)
CFGBanksFeedNotification PlaidTokenExpiryNotificationSentDate datetime
CFGPYMain OtherPays smallint NOT NULL
CustomDashpartCalculation ResultType varchar(20) NOT NULL
FW_DetailJobs Cancellable bit NOT NULL
InvoiceApproval Amount decimal(19,4) NOT NULL
InvoiceApproval SubmittedBy varchar(32)
InvoiceApproval SubmittedDate datetime
InvoiceApproval SubStatus varchar(10)
PNPlan BaselineCreateDate datetime
RPPlan BaselineCreateDate datetime
SE AccessAllPlanTypes varchar(1) NOT NULL
SE AccessPlanSummary varchar(1) NOT NULL

RemovedTables

TableName
FW_PerfManagement
FW_Workbook
FW_WorkbookFilters

RemovedColumns

TableName ColumnName
FW_CFGSystem WAADClientID
FW_CFGSystem WAADServerClientID
FW_CFGSystem WAADServerClientSecret
FW_CFGSystem WAADTenant

NewObjects

ParentObjectName ChildObjectName ObjectType
apDetail ApDetailEquipIdIDX Index
ApprovalItem ApprovalItemItemTypeUIDIsClosedIDX Index
billInvMaster billInvMasterBillWBS1IDX Index
billInvMaster billInvMasterbyGroupWBS1IDX Index
BT BTApprovalWorkflowIDX Index
BTDefaults BTDefaultsApprovalWorkflowIDX Index
EmployeeRealizationDetailWk EmployeeRealizationDetailWkMainWBS1IDX Index
EmployeeRealizationDetailWk EmployeeRealizationDetailWkWBS1WBS2WBS3IDX Index
InvoiceApproval InvoiceApprovalMasterPKeyIDX Index
InvoiceApprovalActions InvoiceApprovalActionsMasterPkeyIDX Index
LedgerAP LedgerAPWBS1WBS2WBS3ProjectCostTranstypeIDX Index
LedgerEX LedgerEXWBS1WBS2WBS3PeriodPostseqPkeyIDX Index
LedgerMisc LedgerMiscWBS1WBS2WBS3PeriodPostseqPkeyIDX Index
PODetail PODetailPoDetailPKeyIDX Index
PODetail PODetailPODetailPKeyMasterPKeyCOPKeyIDX Index
tkDetail TkDetailWBS1WBS2WBS3EndDateEmployeeEmployeeCompanyIDX Index
tsDetail tsDetailWBS1WBS2WBS3BatchEmployeePkeyIDX Index
UserActivity UserActivityUserIDIDX Index
UserPlanSelections UserPlanSelectionsUserIDWBS1PlanIDIDX Index
VO VOVendorVoucherCompanyIDX Index
AddCubeJobAlertNotification Stored Proc
DeleteEquipment Stored Proc
KeyConvertDisablePlanningPhaseTask Stored Proc
KeyConvertPlanMergingWBS2 Stored Proc
KeyConvertPlanMergingWBS3 Stored Proc
sp_stRPFixDuplicateAssignments Stored Proc
sp_stRPFixTPDOnlyOnWBSLevel Stored Proc
stRPHandleExpConLaborCodeLevelChange Stored Proc
stRPMergeDependenciesIfNoAssignmentsOrDeps Stored Proc
stRPMergeNonLivePlanToLivePlan Stored Proc
stRPUpdateBaselineData Stored Proc

RemovedObjects

ParentObjectName ChildObjectName ObjectType
stRP$tabProjOrgChangeInfo Function
LedgerAP LedgerAPWBS1WBS2WBS3IDX Index
LedgerEX LedgerEXWBS1WBS2WBS3IDX Index
LedgerMisc LedgerMiscWBS1WBS2WBS3IDX Index
PODetail PODetailMPCIDX Index
tkDetail tkDetailWBS1IDX Index
buildPRSummaryMainNew Stored Proc
buildPRSummarySubNew Stored Proc
buildPRSummaryWBSListNew Stored Proc
stRPCreatePlanFromOpportunity Stored Proc
PNRemoveExpConTrigger Trigger