Database Changes from Deltek Vantagepoint 4.5

Contents

Database Changes
New Tables
Removed Tables
Renamed Tables
New Columns Added to Existing Tables
Changes to Existing Columns
Removed Columns
Renamed Columns
New Objects
Removed Objects
Renamed Objects

Database Changes

This section lists the database table and column changes included in this release.

Deltek creates the Data Dictionary 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
PlaidLog (4.5.1)

Removed Tables

Table Name
None

Renamed Tables

Table Name
None

New Columns Added to Existing Tables

Table Name Column Name Data Type
CFGBanks PlaidMetadata (4.5.1) nvarchar(max)
CustomDashboardTab DashboardRequireFilter (4.5.1) varchar(1) NOT NULL default ('N')
FW_CFGSystem ICREnabledForMobileCRM (4.5.2) varchar(1) NOT NULL default ('N')
Form1099Data FishPurchasedForResale (4.5.4) decimal(19,4) NOT NULL
billFeeDetail PhaseSeq (4.5.7) int NOT NULL
ContractDetails ContractDetail_UID (4.5.8) varchar(32) NOT NULL
ContractDetailsTemplate ContractDetail_UID (4.5.8) varchar(32) NOT NULL
Contracts Contract_UID (4.5.8) varchar(32) NOT NULL
ContractsTemplate Contract_UID (4.5.8) varchar(32) NOT NULL

Changes to Existing Columns

Table Name Column Name New DataType Old DataType
SavedReportsMain Type (4.5.3) nvarchar(255) NOT NULL nvarchar(80) NOT NULL
billFeeDetail Phase (4.5.6) int NOT NULL smallint NOT NULL

Removed Columns

Table Name Column Name Data Type
ContractDetails ContractDetailsID (4.5.8) bigint NOT NULL
ContractDetailsTemplate ContractDetailsTemplateID (4.5.8) bigint NOT NULL
Contracts ContractsID (4.5.8) bigint NOT NULL
ContractsTemplate ContractsTemplateID (4.5.8) bigint NOT NULL

Renamed Columns

Column Name New Column Name Old Column Name
None    

New Objects

Object Name Object Type
DLTK$NumWorkingDaysFlrCheck (4.5.3) Function
LoadSystemJobs (4.5.3) Stored Procedure
EMClientAssocClientIDEmployeeIDX (4.5.6) Index
ApprovalItemApplicationIDItemParent_UIDIDX (4.5.7) Index
ApprovalItemItemType_UIDIDX (4.5.7) Index

Removed Objects

Object Name Object Type
None  

Renamed Objects

Object Name
None