This table information is designed to be used when following the steps in the Dun & Bradstreet Migration from Direct 2.0 to Direct+ topic Resource Materials section here.
The 'Copy script action' column indicates the changes that will occur once the migration script is executed.
The 'Cleanup attribute group' shows what should manually be deleted or have validity removed after the migration script has successfully been executed.
|
Outdated Direct 2.0 Attributes |
New in Direct+ |
Copy script action |
Cleanup attribute group |
Comment |
|---|---|---|---|---|
|
Single valued (calculated) |
Attribute – single valued |
|
|
|
|
DnBDomesticUltimatePrimaryName |
DnBDomesticUltimatePrimName |
<Handled in Migration Table 2> |
Deleted |
Was getting data from now outdated multivalued Data Container DnBDomesticUltimatePrimaryName. DnBOrganizationName Replaced by new attribute DnBDomesticUltimatePrimName |
|
Single valued (calculated) |
Attribute – single valued |
|
|
|
|
DnBUltimatePrimaryName |
DnBGlobalUltimatePrimName |
<Handled in Migration Table 2> |
Deleted |
Was getting data from now outdated multivalued Data Container DnBGlobalUltimatePrimaryName. DnBOrganizationName Replaced by new attribute DnBGlobalUltimatePrimName |
|
(valid on the D&B Organization) |
(valid on the Customer Organization) |
|||
|
DnBJSONMatchData |
DnBJSONMatchData |
Copied value from D&B Organization to Customer Organization. All the ‘Referenced By’ of reference type ‘D&B Organization’ |
Removed attribute validity from the D&B Organization entity |
Same attribute, but now valid on the Customer Organization entity instead of the D&B Organization entity |
|
(valid on the D&B Organization) |
(valid on the D&B Organization reference) |
|||
|
DnBMatchConfidence |
DnBMatchConfidence |
- |
Removed attribute validity from the D&B Organization entity |
Attribute is now valid instead on the 'D&B Organization' reference (the selected candidate); Attribute is still also valid on the 'D&B Organization Candidates' reference |
|
DnBBoneyardOrganizationIndicator |
- |
- |
Deleted |
Obsolete |
|
|
Data Container – multi valued DnBNumberOfEmployees |
Copied from attributes to DC |
|
|
|
DnBConsolidatedEmployeeBasis (LOV – multi valued) |
.DnBEmployeeCategory (LOV multi valued) |
- |
Deleted |
- |
|
DnBConsolidatedEmployeeFiguresDate |
.DnBEmployeeFiguresDate |
- |
Deleted |
- |
|
DnBConsolidatedEmplReliabilityText (LOV) |
.DnBReliability (LOV) |
- |
Deleted |
- |
|
DnBConsolidatedTotalEmployeeQuantity |
.DnBNumberOfEmployeesValue |
- |
Deleted |
-
|
|
- |
.DnBInformationScope (Attribute LOV) |
Set to ‘Consolidated’ (9067) |
- |
- |
|
DnBControlOwnershipDatePrecision |
- |
- |
Deleted |
Obsolete |
|
DnBDUNSSelfRequestDate |
- |
- |
Deleted |
Not part of D&B product CMPELF |
|
DnBDUNSSelfRequestIndicator |
- |
- |
Deleted |
Not part of D&B product CMPELF |
|
|
Data Container – multi valued DnBOrgFormerPrimaryName |
Copied from attribute to DC
|
|
|
|
DnBFormerOrganizationPrimaryName |
.DnBOrgFormerPrimaryNameText |
-
|
Deleted |
-
|
|
Text attribute: |
Attribute Single valued LOV, ID |
Copied from attribute text to attribute LOV (by ID). |
|
|
|
DnBFranchiseOperationType |
- |
- |
Deleted |
-
|
|
DnBFranchiseOperationTypeText |
DnBFranchiseOperation |
|
Deleted |
Converting text to LOV |
|
|
DnBNumberOfEmployees |
Copied from attribute to Data Container |
|
|
|
DnBGroupTotalEmployeeQuantity |
DnBNumberOfEmployeesValue |
Copied from attribute to Data Container |
Deleted |
- |
|
- |
.DnBInformationScope (Attribute LOV |
Set to ‘Entire Group’ (13173) |
- |
New LOV that determines the type |
|
|
DnBNumberOfEmployees |
Copied from attribute to Data Container |
|
|
|
DnBIndEntityEmployeeFiguresDate |
.DnBEmployeeFiguresDate |
- |
Deleted |
- |
|
DnBIndEntityEmployeeReliabilityText (LOV) |
.DnBReliability (LOV) |
- |
Deleted |
-
|
|
DnBIndEntityTotalEmployeeQuantity
|
.DnBNumberOfEmployeesValue |
- |
Deleted |
- |
|
- |
.DnBInformationScope (LOV) |
Set to ‘Individual’ (9066) |
- |
New LOV that determines the type |
|
LOV (DnBLegalForm) |
Attribute LOV (DnBBusinessEntity) |
Attribute and LOV changed names |
||
|
DnBLegalForm |
DnBBusinessEntity |
Copied from old LOV to new LOV |
Deleted |
- |
|
DnBNonMarketableReason |
- |
- |
Deleted |
Obsolete |
|
DnBOperatingStatusComments |
- |
- |
Deleted |
Obsolete |
|
DnBOrganizationStartYear |
- |
-
|
- |
Replaced by DnBOrganizationStartDate, but no good conversion is possible. |
|
Single valued
|
Data Container - multivalued DnBOrganizationSummary |
Copied from attribute to Data Container |
|
|
|
DnBOrganizationSummaryText |
.DnBOrganizationSummaryText (attribute – single valued) |
|
Removed validity for DnBOrganizationSummaryText on entity |
DnBOrganizationSummaryText is now valid on the data container instead of the D&B Organization entity |
|
DnBPrimarySICCategory |
- |
- |
Deleted |
Deprecated, but refer to Data Container DnBIndustryCode and response: organization.industryCodes.typeDnBCode |
|
DnBRegisteredNameIndicator |
- |
- |
Deleted |
Not part of D&B product CMPELF |
|
DnBMostSeniorPrincipal |
||||
|
DnBSeniorPrincipalName |
.DnBFullName |
Copied from attribute to multi valued Data Container |
Deleted |
- |
|
DnBSubjectScopeText |
- |
- |
Deleted |
Obsolete |
|
DnBSubjectScopeTextCode |
- |
- |
Deleted |
Obsolete |
|
DnBTotalInquiriesCount |
- |
- |
Deleted |
Obsolete |
|
DnBOperatingStatusText |
- |
- |
Deleted |
Obsolete, but refer to DnBOperatingStatus |
Additional D&B migration tables can be found in these topics: