GovWin Capture Management 7.6 to Deltek for Professional Services 1.0

Database Changes from Vision/Ajera CRM/GovWin Capture Management 7.6 to Deltek for Professional Services 1.0. 1

Contents. 1

Overview. 1

Major Changes. 1

New Tables. 2

Removed Tables. 3

Renamed Tables. 4

New Columns Added to Existing Tables. 4

Changes to Existing Columns. 10

Overview

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

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.

Major Changes

· In DPS, clients and vendors are no longer tracked in two separate tables. They are tracked together in the new Clendors table. The CL and VE tables that existed previously are now Views in DPS.

· All columns in the database that store WBS2- and WBS3-related values have been increased from nvarchar(7) to nvarchar(30).

New Tables

Table Name
ActivityFileLinks
CFGCommonStatusData
CFGCommonStatusDescriptions
CFGDeltekOperations
CFGRPGridColumns
CFGSalesforceMapping
CFGScreenDesignerData
CFGScreenDesignerLabels
CFGSetupStatus
CLActivity
Clendor
ClendorProjectAssoc
ClendorProjectAssocTemplate
ClientFromContacts
CustomDashboard
CustomDashboardTab
CustomDashboardTabSecurity
CustomDashpart
CustomDashpartLayout
EMActivityOccurrence
InvoiceApprover
MktCampaignClientAssoc
MktCampaignPhoto
OpportunityFromContacts
UNTable

Removed Tables

Table Name
ActivityLeads
CFGIndustryData
CFGIndustryDescriptions
CFGLeadRecStatusData
CFGLeadRecStatusDescriptions
CFGLeadSourceData
CFGLeadSourceDescriptions
CFGOpportunityTypeData
CFGOpportunityTypeDescriptions
CFGVendorStatusData
CFGVendorStatusDescriptions
CL
ClientsFromLeads
CustomProposalLead
CustomProposalLeadGraphics
DocumentsLeads
LeadCustomTabFields
LeadFileLinks
Leads
LeadsSubscr
OpportunitiesFromLeads
OpportunityVEAssoc
PRClientAssoc
PRClientAssocTemplate
VE
VEAddress
VEFileLinks
VendorAlias
VendorCustomTabFields
VendorPhoto
VEProjectAssoc
VEProjectAssocTemplate
WorkflowActivityLeads

Renamed Tables

Table Name
UN to UNUnit
IQWebSericeLog to IntegrationLog

New Columns Added to Existing Tables

Table Name	Column Name	DataType
BIED	LastPSAExportDate	datetime
billFeeDetail	AddSpaceAfter	varchar(1) NOT NULL
billFeeDetail	HideDetail	varchar(1) NOT NULL
billFeeDetail	PhaseGroup	nvarchar(10)
billFeeDetail	PhaseGroupName	nvarchar(100)
billFeeDetail	PrintHeader	varchar(1) NOT NULL
billFeeDetail	PrintSubTotal	varchar(1) NOT NULL
CFGBanks	SEPAIncludeSchemaLocation	varchar(1) NOT NULL
CFGBanks	SEPAOIN	nvarchar(20)
CFGEKCategory	CategoryID	int NOT NULL
CFGEKCategory	PromotionalAccount	nvarchar(13)
CFGEKCategory	Status	varchar(1) NOT NULL
CFGEKEmployeeGroup	GroupID	int NOT NULL
CFGFormat	WBSLevelDelimiter	varchar(1) NOT NULL
CFGIntegrationWS	RoleNotification	nvarchar(20)
CFGResourcePlanning	BillGRRtMethod	smallint NOT NULL
CFGResourcePlanning	CostGRRtMethod	smallint NOT NULL
CFGResourcePlanning	TargetMultCost	decimal(19,4) NOT NULL
CFGRGMethodsData	Active	varchar(1) NOT NULL
CFGRMSettings	Amtdecimals	smallint NOT NULL
CFGRMSettings	DefaultCompany	nvarchar(14) NOT NULL
CFGSecurity	PreventUsernameAsPassword	varchar(1) NOT NULL
CFGSecurity	RepeatCount	smallint NOT NULL
CFGTKCategory	CategoryID	int NOT NULL
CFGTKEmployeeGroup	GroupID	int NOT NULL
CFGTKMain	ShowRatioQTD	varchar(1) NOT NULL
CFGTKMain	StartEndTimeBy	varchar(1) NOT NULL
CFGTKMain	TimesheetFrequency	varchar(1)
CFGTKMain	UseApprovalWorkflow	varchar(1) NOT NULL
CFGTKMain	Workflow_UID	varchar(32)
CFGVisionSystem	ActivationComplete	varchar(1) NOT NULL
CFGVisionSystem	IQNotificationRole	nvarchar(20)
CFGVisionSystem	SFApiVersion	nvarchar(25)
CFGVisionSystem	SFConsumerKey	nvarchar(255)
CFGVisionSystem	SFConsumerSecret	nvarchar(255)
CFGVisionSystem	SFEnabled	varchar(1) NOT NULL
CFGVisionSystem	SFErrorOption	varchar(1) NOT NULL
CFGVisionSystem	SFImportOption	varchar(1) NOT NULL
CFGVisionSystem	SFImportStages	nvarchar(max)
CFGVisionSystem	SFInstanceUrl	nvarchar(255)
CFGVisionSystem	SFInterval	int NOT NULL
CFGVisionSystem	SFLastUpdate	datetime
CFGVisionSystem	SFNotificationRole	nvarchar(20)
CFGVisionSystem	SFOAuthToken	nvarchar(255)
CFGVisionSystem	SFPassword	nvarchar(255)
CFGVisionSystem	SFRefreshToken	nvarchar(255)
CFGVisionSystem	SFSandbox	varchar(1) NOT NULL
CFGVisionSystem	SFScreenDesigner	varchar(1) NOT NULL
CFGVisionSystem	SFUsername	nvarchar(255)
CFGVisionSystem	SFWorkflow	varchar(1) NOT NULL
CFGVisionSystem	VatApiKey	nvarchar(255)
CFGVisionSystem	VatApiSecureInd	varchar(1) NOT NULL
CLAddress	Payment	varchar(1) NOT NULL
ClientAlias	PKey	varchar(32) NOT NULL
ClientCustomTabFields	Vendor	nvarchar(20)
ClientPhoto	PKey	int NOT NULL
Contacts	FirmAddress1	nvarchar(50)
Contacts	FirmAddress2	nvarchar(50)
Contacts	FirmAddress3	nvarchar(50)
Contacts	FirmAddress4	nvarchar(50)
Contacts	FirmBusinessFax	nvarchar(24)
Contacts	FirmBusinessFaxFormat	nvarchar(24)
Contacts	FirmBusinessPhone	nvarchar(24)
Contacts	FirmBusinessPhoneFormat	nvarchar(24)
Contacts	FirmCity	nvarchar(30)
Contacts	FirmCountry	nvarchar(2)
Contacts	FirmDescription	nvarchar(100)
Contacts	FirmPager	nvarchar(50)
Contacts	FirmState	nvarchar(10)
Contacts	FirmZip	nvarchar(10)
Contacts	Market	nvarchar(10)
Contacts	OpportunityDescription	nvarchar(255)
Contacts	Owner	nvarchar(20)
Contacts	ProfessionalSuffix	nvarchar(255)
Contacts	QualifiedStatus	nvarchar(10)
Contacts	Rating	nvarchar(10)
Contacts	SFID	nvarchar(18)
Contacts	SFLastModifiedDate	datetime
Contacts	StatusDate	datetime
Contacts	StatusReason	nvarchar(10)
Contacts	Website	nvarchar(255)
EMActivity	ReminderInd	varchar(1)
EMActivity	ReminderMinHrDay	nvarchar(10)
EMActivity	ReminderUnit	smallint
EMInitiation	KonaAccessToken	nvarchar(255)
EMInitiation	KonaRefreshToken	nvarchar(255)
EMInitiation	KonaUserID	int NOT NULL
EMInitiation	KonaUsername	nvarchar(255)
EMMain	KonaAccessToken	nvarchar(255)
EMMain	KonaRefreshToken	nvarchar(255)
EMMain	KonaUserID	int NOT NULL
EMMain	KonaUsername	nvarchar(255)
FW_Attachments	FileDescription	nvarchar(500)
FW_CFGCountryData	TaxAuthority	nvarchar(10)
FW_CFGSysConfig	LegacyLicense	varchar(1) NOT NULL
FW_CFGSystem	AjeraSync	varchar(1) NOT NULL
FW_CFGSystem	EnableLeadQualification	varchar(1) NOT NULL
FW_CFGSystem	IndustryType	nvarchar(10)
FW_CFGSystem	KonaAcctID	int NOT NULL
FW_CFGSystem	KonaNotificationRole	nvarchar(20)
FW_CFGSystem	KonaURL	nvarchar(255)
FW_CFGSystem	TwoFactorAuth	varchar(1) NOT NULL
FW_InfoCenterTabsData	HiddenFor	nvarchar(max)
FW_InfoCenterTabsData	Platform	nvarchar(5) NOT NULL
FW_UDICData	DisplayInTitle	varchar(20)
LedgerAP	LastPSAExportDate	datetime
LedgerAR	LastPSAExportDate	datetime
LedgerEX	LastPSAExportDate	datetime
LedgerMisc	LastPSAExportDate	datetime
MktCampaign	ActualRevenue	decimal(19,4) NOT NULL
MktCampaign	ExchangeRateDate	datetime
MktCampaign	PotentialRevenue	decimal(19,4) NOT NULL
Opportunity	PeriodOfPerformance	decimal(19,5) NOT NULL
Opportunity	SFID	nvarchar(18)
Opportunity	SFLastModifiedDate	datetime
Opportunity	TotalContractValue	decimal(19,5) NOT NULL
OpportunityClientAssoc	PKey	int NOT NULL
PNAssignment	HardBooked	varchar(1) NOT NULL
PNPlan	BillGRRtMethod	smallint NOT NULL
PNPlan	CostGRRtMethod	smallint NOT NULL
PNPlan	VersionID	varchar(32)
PNTask	ChargeType	varchar(1)
PNTask	ClientID	varchar(32)
PNTask	Notes	nvarchar(max)
PNTask	Org	nvarchar(30)
PNTask	ProjectType	nvarchar(10)
PNTask	ProjMgr	nvarchar(20)
PNTask	Status	varchar(1)
RPPlan	BillGRRtMethod	smallint NOT NULL
RPPlan	CostGRRtMethod	smallint NOT NULL
RPPlan	VersionID	varchar(32)
SE	SystemSetup	varchar(1) NOT NULL
SECalendar	ShowInBD	varchar(1) NOT NULL
SEUser	TwoFactorAuth	varchar(1) NOT NULL
TextLibrary	DisplayName	nvarchar(100) NOT NULL
tkBreakTime	EndDateTime	datetime
tkBreakTime	StartDateTime	datetime
tkDetail	CalEndDateTime	datetime
tkDetail	CalStartDateTime	datetime
VEAccounting	ElectronicPaymentMethodID	nvarchar(20)

Changes to Existing Columns

Table Name	Column Name	New DataType	Old DataType
ApprovalItem	AssignUSRLabel	nvarchar(255)	nvarchar(50)
ApprovalItem	AssignUSRLabelSystem	nvarchar(255)	nvarchar(50)
billConDetail	UOM	nvarchar(30)	nvarchar(20)
billExpDetail	UOM	nvarchar(30)	nvarchar(20)
CFGEmployeeTypeDescriptions	Type	varchar(1) NOT NULL	varchar(32) NOT NULL
EMProjectAssoc	Role	nvarchar(10)	nvarchar(10) NOT NULL
EMProjectAssocTemplate	Role	nvarchar(10)	nvarchar(10) NOT NULL
EMProjectAssocTemplate	WBS1	nvarchar(30) NOT NULL	varchar(32) NOT NULL
FW_CFGAttachmentCategoryData	Application	nvarchar(32) NOT NULL	nvarchar(20) NOT NULL
FW_CFGAttachmentCategoryDesc	Application	nvarchar(32) NOT NULL	nvarchar(20) NOT NULL
LD	WBS1	nvarchar(30)	nvarchar(255)
OpportunityEMAssoc	Role	nvarchar(10)	nvarchar(10) NOT NULL
PNTask	Name	nvarchar(255) NOT NULL	nvarchar(100) NOT NULL
PRAdditionalData	WBS1	nvarchar(30) NOT NULL	nvarchar(255) NOT NULL
RPAssignment	WBS1	nvarchar(30)	nvarchar(255)
RPConsultant	WBS1	nvarchar(30)	nvarchar(255)
RPExpense	WBS1	nvarchar(30)	nvarchar(255)
RPPlan	PlanNumber	nvarchar(30)	nvarchar(255)
RPPlan	WBS1	nvarchar(30)	nvarchar(255)
RPTask	Name	nvarchar(255) NOT NULL	nvarchar(100) NOT NULL
RPTask	WBS1	nvarchar(30)	nvarchar(255)
RPUnit	WBS1	nvarchar(30)	nvarchar(255)

Removed Columns

Table Name	Column Name	DataType
EMInitiation	TKAdminApproval	varchar(1) NOT NULL
EMMain	TKAdminApproval	varchar(1) NOT NULL
EMTKGroups	AllowApproval	varchar(1) NOT NULL
FW_CFGSystem	ApprovedByPrincipalTK	varchar(1) NOT NULL
FW_CFGSystem	ApprovedByProjectManagerTK	varchar(1) NOT NULL
FW_CFGSystem	ApprovedBySupervisorTK	varchar(1) NOT NULL
FW_CFGSystem	DefaultOverheadTK	varchar(1) NOT NULL
FW_CFGSystem	DefaultPromotionalTK	varchar(1) NOT NULL
FW_CFGSystem	DefaultRegularTK	varchar(1) NOT NULL
FW_CFGSystem	LineItemApprovalTK	varchar(1) NOT NULL
FW_CFGSystem	NavigatorURL	nvarchar(255)
FW_CFGSystem	RequireLineItemApprToPostTK	varchar(1) NOT NULL
FW_CFGSystem	SupportPassword	nvarchar(100)
FW_CFGSystem	SupportUsername	nvarchar(100)
SEUser	KonaAccessToken	nvarchar(255)
SEUser	KonaPassword	nvarchar(255)
SEUser	KonaRefreshToken	nvarchar(255)
SEUser	KonaUsername	nvarchar(255)

Renamed Columns

Object Name	Object Type
None

New Objects

Object Name	Object Type
stRP$DiffBaseline	Function
stRP$DiffBaselinePlanned	Function
stRP$DiffPlanned	Function
stRP$MultiCompanyConfig	Function
stRP$tabCalendarMultiScales	Function
stRP$tabConsultant	Function
stRP$tabContract	Function
stRP$tabDecimals	Function
stRP$tabExpense	Function
stRP$tabLabor	Function
stRP$tabParseRowID	Function
stRP$tabPlanDecimals	Function
CreateReportCampaignCurrencyTable	Stored Proc
DeleteFirm	Stored Proc
LoadActivationDefaults	Stored Proc
LoadIndustryDefaultsAE	Stored Proc
LoadIndustryDefaultsConsult	Stored Proc
LoadIndustryDefaultsMarCom	Stored Proc
stCopyPlan	Stored Proc
stRPAddJTDAssignment	Stored Proc
stRPAddJTDConsultant	Stored Proc
stRPAddJTDExpense	Stored Proc
stRPChangeDuration	Stored Proc
stRPCleanDupOutlineNo	Stored Proc
stRPConvertDRPtoDeltekPS	Stored Proc
stRPConvertIAccessToDeltekPS	Stored Proc
stRPConvertVisionPlantoDeltekPS_Simple	Stored Proc
stRPCreatePlanForAll_PR_Opp	Stored Proc
stRPCreatePlanFromOpportunity	Stored Proc
stRPCreatePlanFromProj	Stored Proc
stRPCreatePNPlanFromRPPlan	Stored Proc
stRPDelAssignment	Stored Proc
stRPDelAssignmentForPlan	Stored Proc
stRPDelAssignmentForTaskID	Stored Proc
stRPDelConsultant	Stored Proc
stRPDeleteAllVisionPlans	Stored Proc
stRPDelExpense	Stored Proc
stRPDelPlan	Stored Proc
stRPDelTask	Stored Proc
stRPExtendDateSpan	Stored Proc
stRPPublish	Stored Proc
stRPReCalcPlan	Stored Proc
stRPRefreshRates	Stored Proc
stRPReorderOutlineNumber	Stored Proc
stRPRevert	Stored Proc
stRPSaveBaseline	Stored Proc
stRPShiftAssigment	Stored Proc
stRPShiftDates	Stored Proc
stRPShiftTasks	Stored Proc
stRPSpreadPlannedConAmt	Stored Proc
stRPSpreadPlannedExpAmt	Stored Proc
stRPSpreadPlannedHrs	Stored Proc
stRPSyncMultiplePR_Plan	Stored Proc
stRPSyncWBSStructure	Stored Proc
stRPUpdateVersionID	Stored Proc
stRPSyncOpportunityTrigger	Trigger
stRPSyncProjectTrigger	Trigger
AllEMActivities	View
CFGCommonStatus	View
CFGPasswordPolicy	View
CFGScreenDesigner	View
CL (replaces CL Table)	View
OpportunityVEAssoc	View
PRClientAssoc	View
PRClientAssocTemplate	View
UN	View
VE (replaces VE Table)	View
VEAddress	View
VEFileLinks	View
VendorAlias	View
VendorCustomTabFields	View
VendorPhoto	View
VEProjectAssoc	View
VEProjectAssocTemplate	View

Removed Objects

Object Name	Object Type
None

Renamed Objects

Object Name	Object Type
None