Deltek Vantagepoint 2025.2 to Deltek Vantagepoint 2025.3 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
None

Removed Tables

Table Name
ApprovalActionLanguages

Renamed Tables

Table Name
None

New Columns Added to Existing Tables

 Table Name   Column Name   DataType
ApprovalActionEmails AddAttachment varchar(1) NOT NULL
ApprovalConditions ApprovalActionUID varchar(32)
ApprovalWorkflowActions Language varchar(50)
CFGMainData PayrollServicesWebhookURL varchar(500)
CFGTransCustomFields AP_Enabled varchar(1) NOT NULL
CFGTransCustomFields CD_Enabled varchar(1) NOT NULL
CFGTransCustomFields CR_Enabled varchar(1) NOT NULL
CFGTransCustomFields CV_Enabled varchar(1) NOT NULL
CFGTransCustomFields ER_Enabled varchar(1) NOT NULL
CFGTransCustomFields EX_Enabled varchar(1) NOT NULL
CFGTransCustomFields IN_Enabled varchar(1) NOT NULL
CFGTransCustomFields JE_Enabled varchar(1) NOT NULL
CFGTransCustomFields LA_Enabled varchar(1) NOT NULL
CFGTransCustomFields MI_Enabled varchar(1) NOT NULL
CFGTransCustomFields PR_Enabled varchar(1) NOT NULL
CFGTransCustomFields TS_Enabled varchar(1) NOT NULL
CFGTransCustomFields UN_Enabled varchar(1) NOT NULL
CFGTransCustomFields UP_Enabled varchar(1) NOT NULL
CustomDashboardTab  DashboardRememberFilter  varchar(1) NOT NULL
InvoiceApproval MasterPKey varchar(32)
InvoiceApprovalActions MasterPKey varchar(32)
KeyConvertWorkPROrg PostGLAdjustmentsTo varchar(1)
PNSubAssignment BaselineFinish datetime
PNSubAssignment BaselineLabBill decimal(19,4) NOT NULL
PNSubAssignment BaselineLabCost decimal(19,4) NOT NULL
PNSubAssignment BaselineLaborHrs decimal(19,4) NOT NULL
PNSubAssignment BaselineStart datetime
RPSubAssignment BaselineFinish datetime
RPSubAssignment BaselineLabBill decimal(19,4) NOT NULL
RPSubAssignment BaselineLabCost decimal(19,4) NOT NULL
RPSubAssignment BaselineLaborHrs decimal(19,4) NOT NULL
RPSubAssignment BaselineStart datetime
SavedOptionsDetail CrossHubField varchar(250)
SavedOptionsDetail CrossHubFieldType varchar(80)

 

Changes to Existing Columns

 

Table Name

Column Name

New DataType

Old DataType
BT CancelTemplate varchar(32) nvarchar(32)
BT CreditTemplate varchar(32) nvarchar(32)
BT PreInvTemplate varchar(32) nvarchar(32)
BT Template varchar(32) nvarchar(32)
CFGEMail AuthUserName nvarchar(50) nvarchar(254)
FW_EmailLog LogUser nvarchar(32) nvarchar(32) NOT NULL

Removed Columns

Table Name Column Name DataType
None    

 

Renamed Columns

Table Name

New Column Name

Old Column Name
None    

New Objects

Object Name Object Type
BatchEmployeeInUse Stored Proc
BatchFirmsInUse Stored Proc
BatchProjectInUse Stored Proc
DeleteActivitiesBatch Stored Proc
DeleteClientsBatch Stored Proc
DeleteContactsBatch Stored Proc
DeleteEmployeesBatch Stored Proc
DeleteMktCampaignsBatch Stored Proc
DeleteProjectsBatch Stored Proc
DeleteTextLibraryBatch Stored Proc
DeleteUDICDataBatch Stored Proc

 

Removed Objects

Object Name Object Type
ApprovalActionLanguagesUIDIDX
Index

 

Renamed Objects

Object Name
None