Database Changes from Deltek Vantagepoint 4.5
Contents
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
Renamed Tables
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