Marketing Campaigns - Project Table Formats (MktCampaignProjectAssoc)

Follow DPS specifications for preparing a file containing marketing campaign-project associations.

Field Name	Data Type	Length	Notes
CampaignID	varchar	32	Internal reference number for the marketing campaign record; primary key; must exist in MktCampaign
WBS1	varchar	30	Project number; primary key; must exist in PR
WBS2	varchar	7	Phase number; primary key; must exist in PR
WBS3	varchar	7	Task number; primary key; must exist in PR