| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 4.1 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:24 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
4 JAN-12-1994 Charlie Flint JUN-25-1994
DESCRIPTION: Inconsistent application of primary SIC to sites.
(Example - Commonwealth of Virginia)
STATUS: D&B verified 243 locs. Few were corrected.
Most were OK because 2 things done at same loc.
--------------------------------------------------------------------------------
|
| 4.2 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:24 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
7 FEB-01-1994 Van Nichols
DESCRIPTION: 2000+ names for country 521 (Netherland) have a
company name with one or more symbols (',-,'').
STATUS: D&B Europe says symbols are valid in Netherlnds.
I sent D&B non-Netherlands records to check.
--------------------------------------------------------------------------------
|
| 4.3 | Duplicate entry - See Log Item 25 | USCTR1::DEMARS | | Tue Jun 21 1994 17:25 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
8 JAN-24-1994 Van Nichols
DESCRIPTION: Single Site employee counts are greater than
Ultimate Site employee counts.
STATUS: Reported figures, not calculated.
Update cycles within a family varies.
--------------------------------------------------------------------------------
|
| 4.5 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:26 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
18 MAR-09-1994 Charlie Flint
DESCRIPTION: Process to handle companies not existing on D&B
US File. How we send them to D&B, how the record
is built for our file and sent back to us includ-
ing the DMI record, and the pricing. Done in two
phases - pre-outsourcing and during outsourcing.
STATUS: Action plan for during out-sourcing is in works.
Pre-outsourcing - 1-800-234-DUNS for investgatn.
--------------------------------------------------------------------------------
|
| 4.6 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:26 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
19 MAR-07-1994 Van Nichols
DESCRIPTION: Matching of 122,000 customer records.
Records defined as active with Revenue.
STATUS: C recs at vendor for Directory Assistance.
--------------------------------------------------------------------------------
|
| 4.7 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:26 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
20 MAR-31-1994 Jack Hamburger JUN-25-1994
DESCRIPTION: Incorrect SMSA assignments in D&B US File.
STATUS: SMSA's were incorrect & have been corrected.
--------------------------------------------------------------------------------
|
| 4.8 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:27 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
22 APR-14-1994 Jack Hamburger JUN-25-1994
DESCRIPTION: Street Addrs that do not follow Group 1 rules.
STATUS: Group 1 used to apply ZIP+4. D&B quality ctrls
should stop them. D&B Info Quality checking it.
--------------------------------------------------------------------------------
|
| 4.9 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:27 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
23 APR-28-1994 Van Nichols
DESCRIPTION: Potential inconsistent SICs ie Cumberland Farms
STATUS: This has been escalated to D&B Management.
D&B planning an automated review of family trees.
--------------------------------------------------------------------------------
|
| 4.10 | Duplicate entry - See Log Item 30 | USCTR1::DEMARS | | Tue Jun 21 1994 17:27 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
24 APR-28-1994 Jack Hamburger
DESCRIPTION: Duns #s from 122K Matching not on our D&B US File.
STATUS: D&B is investigating this.
--------------------------------------------------------------------------------
|
| 4.11 | | USCTR1::DEMARS | | Tue Jun 21 1994 17:28 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
25 APR-28-1994 Jack Hamburger
DESCRIPTION: Site Employee records total for ults not coming
close to HQ ult employee total.
Ex. Kelly Svcs HQ rec = 700K. Totalof recs = 6K.
STATUS: This has been escalated to D&B Management.
--------------------------------------------------------------------------------
|
| 4.12 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:49 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
26 APR-28-1994 Jack Hamburger JUN-25-1994
DESCRIPTION: Fortune 500 discrepancies - JE Seagram is missing.
Exxon rank & ind is for Exxon Pipeline, not Exxon
Corp. American Brands rank is wrong.
STATUS: Am. Brands & Exxon correct in June/July update.
JE Seagram should be on file. Still not there.
--------------------------------------------------------------------------------
|
| 4.13 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:50 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
27 APR-28-1994 Jack Hamburger JUN-25-1994
DESCRIPTION: Drake Beam Morin - missing site, inconsistent SIC
and incorret ult.
STATUS: NH site still not there, SICs look OK & incorrect
ult record still under review (unlinked).
--------------------------------------------------------------------------------
|
| 4.14 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:50 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
29 MAY-12-1994 Jack Hamburger
DESCRIPTION: Global File -Company Names starting with numbers?
STATUS: Sent to D&B counterpart in Europe.
--------------------------------------------------------------------------------
|
| 4.16 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:51 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
31 MAY-12-1994 Jack Hamburger
DESCRIPTION: Global File - 1)Non-alphanumeric data.
2)Spelling corrections.
3)When will D&B use proper case?
4)Inconsistent SIC - ALL countries.
STATUS: Sent to D&B European counterpart.
Received responses on #1 & 3.
--------------------------------------------------------------------------------
|
| 4.17 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:51 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
32 MAY-17-1994 Sandra Taylor
DESCRIPTION: Out-sourcing - we don't have an address, but our
PO Box was matched to D&B records with different
PO Box numbers than ours.
STATUS: I need to provide examples for Marcia.
--------------------------------------------------------------------------------
|
| 4.19 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:52 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
34 MAY-25-1994 Charlie Flint
DESCRIPTION: D&B action item taken on 3/14-15 from P4 session.
To improve & replace the Trade Tape Prog. with an
automated merger & acquisition update process to
support out-sourcing.
STATUS: D&B: Which recs store & watch? Digital: Currently
just CLF recs. SME req. for this not yet defined.
--------------------------------------------------------------------------------
|
| 4.20 | | USCTR1::DEMARS | | Wed Jun 22 1994 10:52 | 15 |
| SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
35 MAY-26-1994 Charlie Flint
DESCRIPTION: Site for Digital @ 3 Results Way has Empl Count
of 10 and Charlie as the Branch Manager.
STATUS: D&B is checking on how/who the record was entered.
--------------------------------------------------------------------------------
|
| 4.24 | | USCTR1::DEMARS | | Wed Jul 27 1994 14:05 | 33 |
| Log #: 40 Requestor: Ellen Braustein/Toni DeMars
Description: Outsourcing Project - We are not receiving the ultimate duns
numbers for Headquarter records.
Ellen Braunstein at Digital received a report from the Outsourcing
process that showed 17 records we received with a site duns,
but no ultimate duns. She asked me to check these on our warehouse
file. I found 14 of the 17 on the warehouse file containing ult
duns numbers. I looked the other 3 up on the DDA tool. DDA showed
they are headquarter records. I checked a couple I found on the
warehouse against the DDA and they displayed an ult duns.
I questioned Marcia Kubersky of D&B about this. She said they were
not passing the ult duns if the record was a headquarter. She did
not know why they were doing that, but requested they change the
program to give us the ultimates on future files. This change is
estimated to take a couple of days.
A resulting problem of this is we now have HQ records without
ultimates. I have no idea the volume of this. I spoke with Vernon
Jones on the best way to get these from D&B so the BSRF file the
outsourcing data is going into will have better quality data.
Vernon asked that D&B resend our original record along with the D&B
data as if we just sent it to them via outsourcing (same format).
This resend should be done only for the HQ records we missed
receiving an ult duns numbers for.
If you feel this change may trigger any problems/issues, please contact me
immediately.
|
| 4.25 | | USCTR1::DEMARS | | Wed Jul 27 1994 14:08 | 41 |
| Log #: 41
Description: When checking some of the changes of the ultimate duns number from
the 122K records sent to D&B, Sandra found the ultimate duns Jack
received was different than the one on DDA and in the Warehouse.
I questioned D&B on this. The answer I received is as follows:
The DDA tool and Warehouse file looks for the highest "Domestic"
ultimate duns number, which includes Canada. Therefore, a US company
owned by a Canadian company will use the Canadian ultimate duns as the
highest ult duns. The file in Lehigh Valley, however, does not include
Canada, and will, therefore, give you the highest ult in the US as the
highest "Domestic" ult duns number. For example,
Jack's report read:
.......SITE........ ........ULTM.......
CUST # COMPANY NAME OLD NEW OLD NEW
------- -------------------- --------- --------- --------- ---------
0719603 CONNECTICUT POST 001174051 001174051 242175776 609818950
The records for these numbers as Site duns in the warehouse reads:
Domestic DMI File:
SITE DUNS HQ DUNS PRNT DUNS ULT DUNS COMPANY NAME
--------- --------- --------- --------- ------------
001174051 001174051 153699822 242175776 Post Publishing Company
609818950 609818950 248231441 242175776 Thomson Newspapers Holdings De
Global DMI File:
SITE DUNS HQ_PA DUN INTL ULT COMPANY NAME
--------- --------- --------- ------------
242175776 000000000 242175776 THOMSON CORPORATION THE
We now have a situation where the ultimates between the warehouse file
and the data Jack received are different. This will also affect the AMID
rollups because D&B is now giving us a different ult duns than the one
we are using in the AMID structure. This may also affect the long term
plans of using Intl duns numbers to do Global reporting.
|
| 4.26 | | USCTR1::DEMARS | | Wed Jul 27 1994 14:08 | 36 |
|
Log #: 42 Requestor: Sue Taillon
Description: Sue Taillon's group runs an extract of the CEO Names. This extract
fails if there are more than 250 records with the same CEO Name
within a company. The one it failed on is a company called
"Meldisco". I checked our warehouse file and found:
2,945 records starting with the company name "Meldisco"
1,132 of the 2,945 have the CEO Last Name = "Robinson"
1,127 of the 1,132 have the CEO First Name = "John"
1,126 of the 1,127 have the CEO Title = "President"
The question is why do so many records for Meldisco have the same
CEO name on them? Also, does this happen with other companies on
the file?
CEO Name
----------------
Site Duns Ult Duns Company Name First Last CEO Title
--------- --------- ------------ ------- -------- ---------
799003843 001338912 Meldisco K-M John Robinson President
800172165 001338912 Meldisco K-M John Robinson President
151253648 001338912 Meldisco K-M 7th St Bell Rd AZ J Robinson President
151253952 001338912 Meldisco K-M Appache Jct AZ John Robinson President
008409484 001338912 Meldisco K-M Arkansas City KS John Robinson President
149820417 001338912 Meldisco K-M Arkansas City KS Sherial Robinson Branch Mgr
061961967 001338912 Meldisco K-M Casa Grande Ariz John Robinson President
008384521 001338912 Meldisco K-M E 21st N KS Inc John Robinson President
792992299 001338912 Meldisco K-M E Fothill Blvd CA John Robinson President
803832963 001338912 Meldisco K-M Lincoln Way E OH John Robinson President
790261812 001338912 Meldisco K-M Mayo Trail KY John Robinson President
792976029 001338912 Meldisco K-M Mojave Ca Inc John Robinson President
186002473 001338912 Meldisco K-M Northern Ave Ariz John Robinson President
798795761 001338912 Meldisco K-M Off John Robinson President
|
| 4.27 | | USCTR1::DEMARS | | Wed Jul 27 1994 14:51 | 9 |
| Log #: 43 Requestor: Sandra Taylor
Description: Outsourcing - Questions pertaining to NAB Files.
1) Matching record was not returned when an exact
match was found via DDA.
2) Only one matched record returning on multiple
records. They are not duplicates because they
have unique ID numbers.
|
| 4.28 | | USCTR1::DEMARS | | Thu Aug 04 1994 16:33 | 17 |
| LOG #: 44 REQUESTOR: Sandra Taylor
DESCRIPTION: Outsourcing - We need to understand the following:
1) What constitutes an "M" record? We are
charged for these records, correct?
2) What constitutes an "N" record? We are
not charged for these records, correct?
We were led to believe that we would not be
charged to build records on large companies,
such as Ameritech, Eastman Kodak, etc.
Why are they coded "M", and not "N"?
3) We received "M" records, but did not receive
duns data (ie Site Duns and SIC code) on them.
4) Why are personals coded as "M" records to be
built? We need to understand the process for
identifying personals.
|