|
AUG-04-1994 - D&B Log Sheet Page 1
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
OPEN ITEMS:
-------------
3 JAN-20-1994 Deb Gamba DEC-31-1994
DESCRIPTION: Low percentage of Non-U.S. globally linked for
large companies.
STATUS: WorldBase due in Sept-Dec should solve it.
--------------------------------------------------------------------------------
4 JAN-12-1994 Charlie Flint OCT-01-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.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 2
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: Van wants to do 10K & Gtr (5300 recs) within
3 weeks. Can D&B do it in that timeframe?
--------------------------------------------------------------------------------
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.
Jack will check to see if corrected.
--------------------------------------------------------------------------------
22 APR-14-1994 Jack Hamburger OCT-01-1994
DESCRIPTION: Street Addrs that do not follow Group 1 rules.
STATUS: D&B said they have corrected them.
Waiting for next file to confirm it.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 3
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
25 JAN-24-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.
Marcia to check for D&B's plan on this.
--------------------------------------------------------------------------------
26 APR-28-1994 Jack Hamburger OCT-01-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: D&B said they have corrected this.
Waiting fo next file to confirm it.
--------------------------------------------------------------------------------
27 APR-28-1994 Jack Hamburger OCT-01-1994
DESCRIPTION: Drake Beam Morin - missing site, inconsistent SIC
and incorret ult.
STATUS: NH site not there, SICs look OK & ult record still
not linked. D&B has fixed. Will show in next file.
--------------------------------------------------------------------------------
29 MAY-12-1994 Jack Hamburger
DESCRIPTION: Global File -Company Names starting with numbers?
STATUS: Sent to D&B counterpart in Europe.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 4
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
31 MAY-12-1994 Jack Hamburger DEC-31-1994
DESCRIPTION: Global File - 1)Non-alphanumeric data.
2)Spelling corrections.
3)When will D&B use proper case?
4)Inconsistent SIC - ALL countries.
STATUS: All 4 questions should be resolved with Worldbase.
--------------------------------------------------------------------------------
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: Matched because they had only one record in
their file. To be addressed further.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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 in the prcess of correcting this.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 5
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
40 JUL-26-1994 Ellen Braunstein
DESCRIPTION: Records from outsourcing returning with site duns,
but without an ultimate duns. High volume of them.
STATUS: D&B not passing ults on HQ records. D&B program-
mers changing process. Need to backfill missing.
--------------------------------------------------------------------------------
41 JUL-26-1994 Sandra Taylor
DESCRIPTION: Some ults received on 122K different from DDA &
warehouse file. Records involved companies rolling
to Canadian companies. Lehigh Vly doesn't include
Canadian ults, but the DDA & warehouse files do.
STATUS: Jack Hamburger will correct using warehouse file.
Need decision on taking Lehigh Vly ults.
--------------------------------------------------------------------------------
42 JUL-27-1994 Sue Taillon
DESCRIPTION: US DMI File - More than 250 records with the
same CEO Name for a company called "Meldisco".
STATUS: D&B is checking it out.
--------------------------------------------------------------------------------
43 JUL-27-1994 Sandra Taylor
DESCRIPTION: Outsourcing - 1) Match not returned when exact
match found on DDA. 2) Only one match returned
on multiple records, which are not duplicates
because they have unique ID numbers. Both were
on NAB files that were sent to D&B.
STATUS: D&B is investigating this.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 6
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
44 AUG-02-1994 Sandra Taylor
DESCRIPTION: Outsourcing - 1)What constitutes an "M" record?
2)What consitutes an "N" record? Charged to build
records on large companies?
3)Received "M" records without duns data & SIC?
4)Why are personals coded as "M" records?
STATUS: Marcia sent an explanation. There are still
issues/concerns around the answer.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 7
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
CLOSED ITEMS:
-------------
1 JAN-06-1994 Charlie Flint MAR-17-1994
DESCRIPTION: Top 1,000 Digital Customer Records with FY93
Revenue and without a site duns number. They
are to go through the D&B Matching program.
STATUS: Received last of reports on 3/17/94.
--------------------------------------------------------------------------------
2 JAN-21-1994 Van Nichols MAR-04-1994 MAR-01-1994
DESCRIPTION: "Hot List" Cartridge - Recreate as ASCII, Nolabel.
First cartridge came in as EBCDIC with labels.
STATUS: Received cartridge in ASCII, nolabel.
--------------------------------------------------------------------------------
5 FEB-03-1994 Van Nichols MAR-01-1994
DESCRIPTION: Duns #s received from matching our customer file
are not on the 5+ employees file. They are "Name
Brand" companies.
STATUS: Various reasons, out of business loc,
empl count N/A, employees less than 5, etc.
--------------------------------------------------------------------------------
6 JAN-25-1994 Van Nichols MAR-01-1994
DESCRIPTION: 6% of Site Duns # in CI data are not in the
Digital database. Most of the records are
major corporations.
STATUS: Various reasons, out of business loc,
empl count N/A, employees less than 5, etc.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 8
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
9 JAN-25-1994 Van Nichols APR-19-1994
DESCRIPTION: Audit report indicates 561,309 records in latest
USA/CANADA data have no zip code.
STATUS: Audit rept was checking for presence of ZIP+4.
--------------------------------------------------------------------------------
10 JAN-25-1994 Van Nichols APR-06-1994
DESCRIPTION: USA file has 141,040 records without a site
Employee count. (Audit report indicates all
records have an employe count.)
STATUS: The presence of the value '0' causes it to be
counted. Absent only counts 'blank' fields.
--------------------------------------------------------------------------------
11 JAN-25-1994 Van Nichols MAR-31-1994
DESCRIPTION: Need a Code to Title file for secondary SIC4.
STATUS: Received file on floppies.
--------------------------------------------------------------------------------
12 JAN-25-1994 Van Nichols FEB-11-1994
DESCRIPTION: CFO and MIS contact titles are incorrect.
(Contain partial numeric data.)
STATUS: D&B has corrected them.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 9
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
13 FEB-25-1994 Sandra Taylor JUN-25-1994 JUL-27-1994
DESCRIPTION: US file shows US Postal SVC with over 1,000
different ultimate duns numbers.
STATUS: There is now one ult duns, except for 6 records
w/o an ult duns which are being researched by D&B.
--------------------------------------------------------------------------------
14 FEB-25-1994 Toni DeMars MAR-04-1994 MAR-08-1994
DESCRIPTION: PC Model Cartridge recreated in ASCII, nolabel.
First cartidge arrived in EBCDIC with labels.
STATUS: I received a new cartridge in ASCII, nolabel.
--------------------------------------------------------------------------------
15 FEB-25-1994 Sandra Taylor FEB-25-1994
DESCRIPTION: Site duns # with different address (same company)
on CIC vs DDA.
STATUS: Site only changes when company bought, merged or
Out of Bus. CIC needs to update their D&B file.
--------------------------------------------------------------------------------
16 MAR-07-1994 Reg Valliere MAR-18-1994
DESCRIPTION: Change Reg's address to MSO1-1/D9, 111 Powdermill
Rd., Maynard, 01754.
STATUS: Not a data quality issue. Was given to D&B.
In future, handled separately from this log.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 10
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
17 MAR-07-1994 Van Nichols APR-15-1994
DESCRIPTION: "DUNS Market Identifier Snapshot" record under
"Accuracy", percentages appear incorrect. How
do they get these stats? Are they random spot
checked? If so, how is this different from normal
surveys?
STATUS: Each 6,000 records are randomly selected. Data
verified via phone. % of accuracy is calculated.
--------------------------------------------------------------------------------
21 APR-01-1994 Van Nichols APR-06-1994
DESCRIPTION: Could D&B run quality stats that "calculate" the
largest deltas and then re-research cases where
sites (for example) add to 1,000, but the ultimate
shows 400.
STATUS: Figures reported, not calculated. Will remain as
reported unless an investigation is requested.
--------------------------------------------------------------------------------
28 APR-28-1994 Jack Hamburger MAY-04-1994
DESCRIPTION: Incorrect Annual Revenue Amounts -
comparing to 1992 Fortune Sales.
STATUS: D&B doesn't include Rev. from co-operatives.
They report on an equity basis, not consolidated.
--------------------------------------------------------------------------------
30 APR-28-1994 Jack Hamburger JUL-27-1994
DESCRIPTION: 4100+ ults no on our Domestic file as site duns.
STATUS: D&B checked them and sent a diskette to Jack.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 11
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
33 MAY-20-1994 Jack Hamburger JUN-25-1994 JUL-27-1994
DESCRIPTION: Domestic File - Incorrect Zip Codes
STATUS: New file has Zips corrected.
--------------------------------------------------------------------------------
36 MAY-26-1994 Jack Hamburger JUL-27-1994
DESCRIPTION: He needs a floppy of Zip5 to SMSA translation.
STATUS: Jack received the diskette from Marcia.
--------------------------------------------------------------------------------
37 JUN-13-1994 Jack Hamburger JUN-27-1994 JUL-27-1994
DESCRIPTION: Hot List File - we received 94 of 194 characters.
How do we get the additional fields?
STATUS: Caused by D&B Production error. D&B has sent a
full 194 characters on another cartridge.
--------------------------------------------------------------------------------
38 JUN-13-1994 Jack Hamburger JUN-14-1994
DESCRIPTION: Incorrect Ult. duns - 6 sites rolling to Fed Govt.
STATUS: D&B confirmed they are part of the FDIC.
--------------------------------------------------------------------------------
AUG-04-1994 - D&B Log Sheet Page 12
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
39 JUN-21-1994 Charlie FLint JUL-27-1994
DESCRIPTION: Outsourcing - How will D&B handle "C/O" records?
STATUS: D&B will look at both the company name field and
the division name field.
--------------------------------------------------------------------------------
|
|
OCT-04-1994 - D&B Log Sheet Page 1
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
OPEN ITEMS:
-------------
3 JAN-20-1994 Deb Gamba DEC-31-1994
DESCRIPTION: Low percentage of Non-U.S. globally linked for
large companies.
STATUS: WorldBase due in Sept-Dec should solve it.
--------------------------------------------------------------------------------
4 JAN-12-1994 Charlie Flint NOV-01-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.
--------------------------------------------------------------------------------
7 FEB-01-1994 Van Nichols DEC-31-1994
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.
--------------------------------------------------------------------------------
19 MAR-07-1994 Van Nichols
DESCRIPTION: Matching of 122,000 customer records.
Records defined as active with Revenue.
STATUS: 10K & Gtr (5300 recs) were sent to D&B to be
researched first.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 2
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
20 MAR-31-1994 Jack Hamburger
DESCRIPTION: Incorrect SMSA assignments in D&B US File.
STATUS: SMSA's were incorrect & have been corrected.
Jack's still checking if corrected.
--------------------------------------------------------------------------------
22 APR-14-1994 Jack Hamburger NOV-01-1994
DESCRIPTION: Street Addrs that do not follow Group 1 rules.
STATUS: D&B said they have corrected them.
Waiting for next file to confirm it.
--------------------------------------------------------------------------------
23 APR-28-1994 Van Nichols
DESCRIPTION: Potential inconsistent SICs ie Cumberland Farms
(This was escalated to D&B Management.)
STATUS: Automated review of family trees. No set order.
Marcia couldn't get key words used in old program.
--------------------------------------------------------------------------------
25 JAN-24-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.
(This was escalated to D&B Management.)
STATUS: Marcia said to see Aug. 3rd memo from Chuck Benke.
Marcia will send me a copy of Chuck's memo.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 3
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
26 APR-28-1994 Jack Hamburger NOV-01-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: D&B said they have corrected this.
Waiting fo next file to confirm it.
--------------------------------------------------------------------------------
27 APR-28-1994 Jack Hamburger NOV-01-1994
DESCRIPTION: Drake Beam Morin - missing site, inconsistent SIC
and incorret ult.
STATUS: NH site not there, SICs look OK & ult record still
not linked. D&B has fixed. Will show in next file.
--------------------------------------------------------------------------------
29 MAY-12-1994 Jack Hamburger DEC-31-1994
DESCRIPTION: Global File -Company Names starting with numbers?
STATUS: Sent to D&B counterpart in Europe.
--------------------------------------------------------------------------------
31 MAY-12-1994 Jack Hamburger DEC-31-1994
DESCRIPTION: Global File - 1)Non-alphanumeric data.
2)Spelling corrections.
3)When will D&B use proper case?
4)Inconsistent SIC - ALL countries.
STATUS: All 4 questions should be resolved with Worldbase.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 4
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: Matched because they had only one record in
their file. To be addressed further.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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 in the prcess of correcting this.
--------------------------------------------------------------------------------
40 JUL-26-1994 Ellen Braunstein
DESCRIPTION: Records from outsourcing returning with site duns,
but without an ultimate duns. High volume of them.
STATUS: D&B not passing ults on HQ records. D&B program-
mers changing process. Need to backfill missing.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 5
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
41 JUL-26-1994 Sandra Taylor
DESCRIPTION: Some ults received on 122K different from DDA &
warehouse file. Records involved companies rolling
to Canadian companies. Lehigh Vly doesn't include
Canadian ults, but the DDA & warehouse files do.
STATUS: Need Digital decision on taking Lehigh Vly ults.
Worldbase to change DMI to way Lehigh Vly does it.
--------------------------------------------------------------------------------
44 AUG-02-1994 Sandra Taylor
DESCRIPTION: Outsourcing - 1)What constitutes an "M" record?
2)What consitutes an "N" record? Charged to build
records on large companies?
3)Received "M" records without duns data & SIC?
4)Why are personals coded as "M" records?
STATUS: No N records. Either researched or built.
To be addressed in contract.
--------------------------------------------------------------------------------
45 AUG-15-1994 Pat Koczwara
DESCRIPTION: Outsourcing - Not receiving daily transaction
files. Averaging 3 files per week.
STATUS: Marcia Kubersky & Eleanor Sullivan monitoring.
Needs to be addressed.
--------------------------------------------------------------------------------
46 AUG-19-1994 Jan Ketonen
DESCRIPTION: Various data content questions - See Documentation
STATUS: 7 of 8 questions have been answered/addressed.
Toni is trying to find "Denied Party" flag.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 6
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
47 AUG-23-1994 Pat Koczwara
DESCRIPTION: NBD Outsourcing - Outstanding records still not
returned.
STATUS: As of 9/28, 22 of 97 codes still outstanding.
Marcia is checking into it.
--------------------------------------------------------------------------------
48 AUG-25-1994 Charlie Flint
DESCRIPTION: What is the D&B process for assigning Zip Code?
STATUS: Received answer from Marcia. Requestor needs more
detail. Jane Lesslauer is also looking into it.
--------------------------------------------------------------------------------
50 OCT-04-1994 Charlie Flint
DESCRIPTION: Site 196778146-Eastman Kodak Savings & Loan Assoc
1) Is it owned by Eastman Kodak?
2) Should it have the SIC 3781?
STATUS:
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 7
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
CLOSED ITEMS:
-------------
1 JAN-06-1994 Charlie Flint MAR-17-1994
DESCRIPTION: Top 1,000 Digital Customer Records with FY93
Revenue and without a site duns number. They
are to go through the D&B Matching program.
STATUS: Received last of reports on 3/17/94.
--------------------------------------------------------------------------------
2 JAN-21-1994 Van Nichols MAR-04-1994 MAR-01-1994
DESCRIPTION: "Hot List" Cartridge - Recreate as ASCII, Nolabel.
First cartridge came in as EBCDIC with labels.
STATUS: Received cartridge in ASCII, nolabel.
--------------------------------------------------------------------------------
5 FEB-03-1994 Van Nichols MAR-01-1994
DESCRIPTION: Duns #s received from matching our customer file
are not on the 5+ employees file. They are "Name
Brand" companies.
STATUS: Various reasons, out of business loc,
empl count N/A, employees less than 5, etc.
--------------------------------------------------------------------------------
6 JAN-25-1994 Van Nichols MAR-01-1994
DESCRIPTION: 6% of Site Duns # in CI data are not in the
Digital database. Most of the records are
major corporations.
STATUS: Various reasons, out of business loc,
empl count N/A, employees less than 5, etc.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 8
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
9 JAN-25-1994 Van Nichols APR-19-1994
DESCRIPTION: Audit report indicates 561,309 records in latest
USA/CANADA data have no zip code.
STATUS: Audit rept was checking for presence of ZIP+4.
--------------------------------------------------------------------------------
10 JAN-25-1994 Van Nichols APR-06-1994
DESCRIPTION: USA file has 141,040 records without a site
Employee count. (Audit report indicates all
records have an employe count.)
STATUS: The presence of the value '0' causes it to be
counted. Absent only counts 'blank' fields.
--------------------------------------------------------------------------------
11 JAN-25-1994 Van Nichols MAR-31-1994
DESCRIPTION: Need a Code to Title file for secondary SIC4.
STATUS: Received file on floppies.
--------------------------------------------------------------------------------
12 JAN-25-1994 Van Nichols FEB-11-1994
DESCRIPTION: CFO and MIS contact titles are incorrect.
(Contain partial numeric data.)
STATUS: D&B has corrected them.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 9
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
13 FEB-25-1994 Sandra Taylor JUN-25-1994 JUL-27-1994
DESCRIPTION: US file shows US Postal SVC with over 1,000
different ultimate duns numbers.
STATUS: There is now one ult duns, except for 6 records
w/o an ult duns which are being researched by D&B.
--------------------------------------------------------------------------------
14 FEB-25-1994 Toni DeMars MAR-04-1994 MAR-08-1994
DESCRIPTION: PC Model Cartridge recreated in ASCII, nolabel.
First cartidge arrived in EBCDIC with labels.
STATUS: I received a new cartridge in ASCII, nolabel.
--------------------------------------------------------------------------------
15 FEB-25-1994 Sandra Taylor FEB-25-1994
DESCRIPTION: Site duns # with different address (same company)
on CIC vs DDA.
STATUS: Site only changes when company bought, merged or
Out of Bus. CIC needs to update their D&B file.
--------------------------------------------------------------------------------
16 MAR-07-1994 Reg Valliere MAR-18-1994
DESCRIPTION: Change Reg's address to MSO1-1/D9, 111 Powdermill
Rd., Maynard, 01754.
STATUS: Not a data quality issue. Was given to D&B.
In future, handled separately from this log.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 10
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
17 MAR-07-1994 Van Nichols APR-15-1994
DESCRIPTION: "DUNS Market Identifier Snapshot" record under
"Accuracy", percentages appear incorrect. How
do they get these stats? Are they random spot
checked? If so, how is this different from normal
surveys?
STATUS: Each 6,000 records are randomly selected. Data
verified via phone. % of accuracy is calculated.
--------------------------------------------------------------------------------
18 MAR-09-1994 Charlie Flint SEP-27-1994
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: There is a process in outsourcing.
--------------------------------------------------------------------------------
21 APR-01-1994 Van Nichols APR-06-1994
DESCRIPTION: Could D&B run quality stats that "calculate" the
largest deltas and then re-research cases where
sites (for example) add to 1,000, but the ultimate
shows 400.
STATUS: Figures reported, not calculated. Will remain as
reported unless an investigation is requested.
--------------------------------------------------------------------------------
28 APR-28-1994 Jack Hamburger MAY-04-1994
DESCRIPTION: Incorrect Annual Revenue Amounts -
comparing to 1992 Fortune Sales.
STATUS: D&B doesn't include Rev. from co-operatives.
They report on an equity basis, not consolidated.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 11
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
30 APR-28-1994 Jack Hamburger JUL-27-1994
DESCRIPTION: 4100+ ults no on our Domestic file as site duns.
STATUS: D&B checked them and sent a diskette to Jack.
--------------------------------------------------------------------------------
33 MAY-20-1994 Jack Hamburger JUN-25-1994 JUL-27-1994
DESCRIPTION: Domestic File - Incorrect Zip Codes
STATUS: New file has Zips corrected.
--------------------------------------------------------------------------------
36 MAY-26-1994 Jack Hamburger JUL-27-1994
DESCRIPTION: He needs a floppy of Zip5 to SMSA translation.
STATUS: Jack received the diskette from Marcia.
--------------------------------------------------------------------------------
37 JUN-13-1994 Jack Hamburger JUN-27-1994 JUL-27-1994
DESCRIPTION: Hot List File - we received 94 of 194 characters.
How do we get the additional fields?
STATUS: Caused by D&B Production error. D&B has sent a
full 194 characters on another cartridge.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 12
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
38 JUN-13-1994 Jack Hamburger JUN-14-1994
DESCRIPTION: Incorrect Ult. duns - 6 sites rolling to Fed Govt.
STATUS: D&B confirmed they are part of the FDIC.
--------------------------------------------------------------------------------
39 JUN-21-1994 Charlie FLint JUL-27-1994
DESCRIPTION: Outsourcing - How will D&B handle "C/O" records?
STATUS: D&B will look at both the company name field and
the division name field.
--------------------------------------------------------------------------------
42 JUL-27-1994 Sue Taillon SEP-26-1994
DESCRIPTION: US DMI File - More than 250 records with the
same CEO Name for a company called "Meldisco".
STATUS: This case was legitimate due to the structure
of the company.
--------------------------------------------------------------------------------
43 JUL-27-1994 Sandra Taylor SEP-26-1994
DESCRIPTION: Outsourcing - 1) Match not returned when exact
match found on DDA. 2) Only one match returned
on multiple records, which are not duplicates
because they have unique ID numbers. Both were
on NAB files that were sent to D&B.
STATUS: Sent multiple times, will receive multiple times.
--------------------------------------------------------------------------------
OCT-04-1994 - D&B Log Sheet Page 13
SCHED ACTUAL
CLOSED CLOSED
LOG#| LOG DATE | REQUESTOR | DATE | DATE |
--------------------------------------------------------------------------------
49 SEP-08-1994 Sandra Taylor SEP-27-1994
DESCRIPTION: NBD Outsourcing - Receiving records back more than
once when only one was sent. Data is sometimes
different on records coming back.
STATUS: Processed a file twice, not sure if it was sent
twice. Dup - 1 Br, 1 HQ operate out of same loc.
--------------------------------------------------------------------------------
|