Database Changes from Deltek Vantagepoint 3.0

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
ApprovalErrorLog (3.0.2)
AuthorizationLog (3.0.3)

Removed Tables

Table Name
None

Renamed Tables

Table Name
None

New Columns Added to Existing Tables

Table Name

Column Name

Data Type

CFGBillTaxesVATGridNumber RecoverTaxAmtGridNo (3.0.2) int NOT NULL
CFGEKMain LogFixApprovalErrorsEnabled (3.0.2) varchar(1) NOT NULL
CFGTKMain LogFixApprovalErrorsEnabled (3.0.2) varchar(1) NOT NULL
DataSource IsDefault (3.0.2) varchar(1) NOT NULL
EMCompany FormW4Deductions (3.0.2) decimal(19,4) NOT NULL
EMCompany FormW4Dependents (3.0.2) smallint NOT NULL
EMCompany FormW4DependentsOther (3.0.2) smallint NOT NULL
EMCompany FormW4OtherIncome (3.0.2) decimal(19,4) NOT NULL
EMCompany FormW4OtherTaxCredit (3.0.2) decimal(19,4) NOT NULL
EMCompany FormW4Step2 (3.0.2) varchar(1) NOT NULL
EMCompany FormW4Version (3.0.2) smallint NOT NULL
EMPayrollWithholding FormW4Deductions (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholding FormW4Dependents (3.0.2) smallint NOT NULL
EMPayrollWithholding FormW4DependentsAmount (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholding FormW4DependentsOther (3.0.2) smallint NOT NULL
EMPayrollWithholding FormW4DependentsOtherAmount (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholding FormW4OtherIncome (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholding FormW4OtherTaxCredit (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholding FormW4Step2 (3.0.2) varchar(1) NOT NULL
EMPayrollWithholding FormW4Version (3.0.2) smallint NOT NULL
EMPayrollWithholdingDetail FormW4Deductions (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholdingDetail FormW4Dependents (3.0.2) smallint NOT NULL
EMPayrollWithholdingDetail FormW4DependentsAmount (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholdingDetail FormW4DependentsOther (3.0.2) smallint NOT NULL
EMPayrollWithholdingDetail FormW4DependentsOtherAmount (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholdingDetail FormW4OtherIncome (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholdingDetail FormW4OtherTaxCredit (3.0.2) decimal(19,4) NOT NULL
EMPayrollWithholdingDetail FormW4Step2 (3.0.2) varchar(1) NOT NULL
EMPayrollWithholdingDetail FormW4Version (3.0.2) smallint NOT NULL
PYChecksW FormW4Deductions (3.0.2) decimal(19,4) NOT NULL
PYChecksW FormW4Dependents (3.0.2) smallint NOT NULL
PYChecksW FormW4DependentsAmount (3.0.2) decimal(19,4) NOT NULL
PYChecksW FormW4DependentsOther (3.0.2) smallint NOT NULL
PYChecksW FormW4DependentsOtherAmount (3.0.2) decimal(19,4) NOT NULL
PYChecksW FormW4OtherIncome (3.0.2) decimal(19,4) NOT NULL
PYChecksW FormW4OtherTaxCredit (3.0.2) decimal(19,4) NOT NULL
PYChecksW FormW4Step2 (3.0.2) varchar(1) NOT NULL
PYChecksW FormW4Version (3.0.2) smallint NOT NULL
TaxReporting RecoverTaxAmt (3.0.2) decimal(19,4) NOT NULL

Changes to Existing Columns

Table Name

Column Name

New DataType

Old DataType

FW_Attachments (3.0.2) CategoryCode nvarchar(15) nvarchar(10)

Removed Columns

Table Name

Column Name

Data Type

FW_CFGSystem (3.0.2) WorkflowLogLength int NOT NULL

Renamed Columns

Column Name New Column Name Old Column Name
None    

New Objects

Object Name

Object Type

CFGSalesforceMappingPK (3.0.1) Primary Key
CLAddressClientIDAddressIDX (3.0.3) Index
ContactsContactIDIDX (3.0.3) Index
EMCompanyEmployeeEmployeeCompanyIDX (3.0.3) Index
EMMainEmployeeIDX (3.0.3) Index
OrganizationOrgIDX (3.0.3) Index
PNPlanWBS1IDX (3.0.3) Index
PNTaskWBS1ParentOutlineNumberIDX (3.0.3) Index
PRWBS1WBS2WBS3IDX (3.0.3) Index
PRContactAssocWBS1ContactIDRoleIDX (3.0.3) Index
SEUserEmployeeIDX (3.0.3) Index

Removed Objects

Object Name Object Type
None  

Renamed Objects

Object Name
ClendorClientIDNameParentIDIDX (ClendorClientIDParentIDIDX) (3.0.3)
ClendorProjectAssocWBS1WBS2WBS3ClientIDIDX (ClendorProjectAssocWBSIDX) (3.0.3)