Problem Report Spreadsheet Field Names and Descriptions

 

Not all of the error reports have a listing for each field.

 

  1. ID NUMBER – unique number that represents each error report
  2. Range: 1 - 603

  3. Submitted Date – date when the problem report was submitted
  4. Range: 19-Dec-95 - 16-Jun-98

  5. Report Type - classification type of the problem report
  6. Types: DEPENDENT

    INSTANCE

    ORIGINAL

  7. Discrepency State – current state of the problem report
  8. States: NEW

    ASSIGNED

    OPEN

    RESOLVED

    CLOSED

    DUPLICATE

    TERMINATED

  9. Assigned Date - date when the problem report was assigned
  10. Range: 10-Jan-96 - 11-May-98

  11. Opened Date - date when the problem report was opened by a team
  12. member to begin fixing the problem described in the report

    Range: 10-Jan-96 - 23-Jun-98

  13. Resolved Date - date when the problem report was resolved
  14. The problem report would be given next to the software

    team’s manager to be closed.

    Range: 10-Jan-96 - 23-Jun-98

  15. Product Name - name of the product (or the part of the system that the
  16. problem report concerns)

    Names: EI

    FP

    GL

    LA

    LB

    LC

    MS

    MT

    PT

    SC

    SM

    TC

    TF

    TZ

    ZC

  17. Closed Date - date when the problem report was closed by the software
  18. team’s manager

    Range: 10-Jan-96 - 20-Feb-98

  19. Cloned Date - date when the problem report was cloned by the software
  20. team’s manager

    Range: 6/20/96 - 6/16/98

  21. Duplicate Date - date when the problem report was duplicated by the
  22. software team’s manager

    Range: 11/29/96 - 4/4/98

  23. Terminated Date - date when the problem report was terminated by the
  24. software team’s manager

    Range: 6/14/96 - 3/4/98

  25. Document Part - part of the documentation that describes the location of the
  26. problem

    Documentation

    locations: 1 through 315

  27. Discoverer Name - name of the team member who discovered the problem
  28. Names: MCA

    MCO

    UDA

    UDE

    GEM

    MFR

    MFE

    MGO

    VGR

    MGU

    GIN

    JJO

    PJO

    WKH

    TKL

    RMA

    MMO

    JMO

    GOW

    BPA

    ARA

    JST

    VST

    DTU

    GWA

    MWI

    PRO

  29. Est fix time - estimate for the amount of effort needed to resolve the
  30. problem

    Range: 0 hours – 100 hours

  31. Est fix date - estimated date on which the problem was to have been
  32. resolved

    Range: 06-Nov-95 - 20-Dec-98

    There are also a few reports that contained the date

    00-JAN-00. This is most likely a clerical mistake.

  33. Discovery Date - date on which a team member found the problem
  34. Range: 06-Nov-95 - 19-Dec-98

  35. Total Effort - total amount of effort (or time) that was needed to resolve
  36. the problem

    Range: 0 hours– 100 hours

  37. Reproducible - indicates whether the testers could reproduce the problem
  38. Categories: NO

    SOMETIMES

    ALWAYS

    NOT APPLICABLE

  39. Phase of Origin - phase of the software development life cycle in which the
  40. problem originated

    Phases: REQUIREMENTS

    PRELIMINARY DESIGN

    DETAILED DESIGN

    CODING

    UNIT TESTING

    BOX TESTING

    INTEGRATION TESTING

    SYSTEM TESTING

    MAINTENANCE

  41. Detection Method - detection method used by the testers to find the problem
  42. Methods: AUTHOR CODE REVIEW

    CUSTOMER USE

    FUNCTIONAL TEST

    GROUP CODE REVIEW

    IN - HOUSE NORMAL USE

    INTEGRATION TEST

    INTERACTIVE TEST

    MANUAL REVIEW

    RANDOM UNPLANNED TEST

    REGRESSION TEST

    SYSTEM TEST

  43. Problem Class - classification of the problem
  44. Class: DEFECT

    ENHANCEMENT

    ERROR

  45. Solved in Version - version of the system in which the problem was solved
  46. Versions: 316

    317

    318

    319

    320

    321

    322

    323

    324

    325

    326

    327

    328

    329

    330

    331

    332

    333

    334

    335

    336

    337

    338

    339

    340

    101

    341

    342

    343

    344

    345

    346

    347

    348

    349

    350

    351

    352

    353

    354

    355

    356

    357

    358

    359

    360

    361

    362

    363

    364

    365

    366

    367

    368

    369

    370

    371

    372

    373

    374

    375

    376

    377

    378

    379

    380

    381

    382

    383

    384

    385

    386

    387

    388

    389

    390

    391

    392

    393

    394

    395

    396

    397

    398

    399

    400

    401

    402

    403

    404

    405

    406

    407

    408

    409

    410

    175

    411

    412

    413

    414

    415

    416

    417

    418

    419

    420

    421

    422

    423

    424

    425

    426

    427

    428

    429

    1000

    1001

    1002

    1003

    1004

  47. Recorded By - team member who created the error report for the problem
  48. discovered

    Names: MAZ

    MCA

    MCO

    UDA

    GEM

    MFR

    MGO

    VGR

    MGU

    GIN

    JJO

    PJO

    WKH

    TKL

    RMA

    MMO

    GOW

    BPA

    JDE

    JST

    VST

    GWA

    MWI

  49. Origin in Version - version of the system in which the problem originated
  50. Versions: 430

    431

    432

    433

    434

    BASE

    326

    435

    CODING

    436

    437

    330

    438

    332

    333

    334

    439

    440

    338

    441

    343

    344

    345

    346

    347

    348

    349

    350

    351

    352

    442

    354

    355

    357

    358

    359

    362

    363

    364

    443

    365

    366

    369

    370

    444

    371

    373

    374

    375

    376

    445

    446

    447

    448

    381

    382

    383

    384

    385

    386

    389

    449

    450

    451

    452

    453

    454

    455

    395

    456

    457

    458

    459

    460

    461

    462

    463

    464

    465

    466

    467

    468

    PRELIMINARY DESIGN

    469

    470

    193

    471

    472

    473

    474

    424

    475

    476

    1000

    1001

    1002

    1003

    1004

  51. Site - company site where the problem was found
  52. Site Name: MCI

    MRC

    RSB

    MTM

  53. Problem Origin - release in which the problem originated.
  54. Origins: BASE

    BETA TEST

    DELTA

    Many of the error reports have "NOT

    APPLICABLE" for problem origin.

  55. Fault Class - type categorization of the problem
  56. Classes: CONSTR / LIM

    DATA

    ERR – HANDLE

    INITIALISE

    INTERFACE

    LOGIC

    NON - TEST – RQ

    NONSTD

    OTHER

    PERF / EFFI

    REL / REPEAT

    REQMENT

    TEST – DEF

    TEST – STR

    USER – INT

  57. Phase Found - phase in which the problem was found
  58. Phases: REQUIREMENTS

    PRELIMINARY DESIGN

    DETAILED DESIGN

    CODING

    UNIT TESTING

    BOX TESTING

    INTEGRATION TESTING

    SYSTEM TESTING

    SYSTEM INTEGRATION

  59. Solved Date date the problem was solved
  60. Range: 06-Nov-95 - 23-Jun-98

  61. Severity severity categorization of the problem
  62. Degrees of Severity: 0 ENHANCEMENT

    1 CRITICAL

    2 MAJOR

    3 MINOR

    4 COSMETIC

  63. Priority priority categorization of the problem
  64. Priorities: EMERGENCY THIS REPORT CAN NOW BE

    CLOSED

    ROUTINE

    ROUTINE THIS REPORT CAN NOW BE CLOSED

    URGENT

    URGENT THIS REPORT CAN NOW BE CLOSED

  65. Closed By team member who closed the problem report
  66. Names: DTU

    GOW

    GWA

    JST

  67. Problem Type overall type of the problem
  68. Types: PRE

    POST

  69. Assigned To team member to which the software team’s manager
  70. assigned the problem report

    manager assigned the error report.

    Names: MCA

    JDE

    UDA

    GEM

    MFR

    JJO

    WKH

    RMA

    MMO

    GOW

    BPA

    ARA

    GWA

    MWI

    There were two error reports that had "NO NAME"

    (NNA) listed for Assigned To.

  71. Customer Impact impact the problem had on the customer
  72. Impacts: FIXED

    NONE

    NONE PARENT 03173

    NONE PARENT 03174

    NONE PARENT 04865

    NONE PARENT 04900

    NONE PARENT 05291

    NOT FIXED

    NOT FIXED 05276

    NOT FIXED 05303

    NOT FIXED 05320

    NOT FIXED 05372

    NOT FIXED 05379

    NOT FIXED 05420

    NOT FIXED 05434

    NOT FIXED CHILDREN 03352

    NOT FIXED PARENT 04167

    NOT FIXED PARENT 04510

    NOT FIXED PARENT 04735

    NOT FIXED PARENT 04744

    NOT FIXED PARENT 04761

    NOT FIXED PARENT 04789

    NOT FIXED PARENT 05291

    NOT FIXED PARENT 04434

    NOT FIXED PARENT 05274

    NOT FIXED PARENT 05493

    NOT FIXED PARENT 05605

  73. Terminated By team member who terminated the problem report
  74. Names: MMO

    GOW

    TPU

    JST

    GWA

    The fields listed below were added to the error report spreadsheet by the Design Metrics team.

  75. Action action that was taken for the problem report
  76. Actions: added fix

    assigned

    changed

    could not determine

    duplicate

    filename changes/update file reference

    MSC update

    multiple

    new

    no change

    open

    previously fixed

    SRS change

    SRS update

    terminated

    test problem

    update textual reqs.

  77. Cloned or Duplicated problem report from which the problem report was cloned
  78. or duplicated

    Clone or Duplicate: cloned 1196

    cloned 1198

    cloned 1199

    cloned 1200

    cloned 1225

    cloned 1230

    cloned 1247

    cloned 1280

    cloned 1281

    cloned 1396

    cloned 1398

    cloned 1400

    cloned 1403 and cloned 1682

    cloned 1409

    cloned 1411

    cloned 1590

    cloned 1837

    cloned 1852

    cloned 2106

    cloned 2173

    cloned 2348

    cloned 2509

    cloned 2517

    cloned 2524

    cloned 2618

    cloned 2745 and 2811

    cloned 2877

    cloned 2891

    cloned 2970

    cloned 3027

    cloned 3152

    cloned 3173 and 3174

    cloned 3192

    cloned 3224

    cloned 3858 and 3500

    cloned 3862

    cloned 3933 and 3912

    cloned 3942

    cloned 3998

    cloned 4006

    cloned 4068

    cloned 4116

    cloned 4121

    cloned 4167

    cloned 4212

    cloned 4322 and 4323

    cloned 4352

    cloned 4384 and 4385

    cloned 4397

    cloned 4440

    cloned 4473 and 4142

    cloned 4510

    cloned 4636

    cloned 4735

    cloned 4739

    cloned 4744

    cloned 4756

    cloned 4761

    cloned 4789

    cloned 4793

    cloned 4857

    cloned 4893

    cloned 4900

    cloned 4927

    cloned 4937

    cloned 4942

    cloned 5014

    cloned 5032

    cloned 5107

    cloned 5140

    cloned 5158

    cloned 5161

    cloned 5178

    cloned 5212

    cloned 5259

    cloned 5274

    cloned 5276

    cloned 5284

    cloned 5291

    cloned 5303

    cloned 5320

    cloned 5353

    cloned 5372

    cloned 5379

    cloned 5420

    cloned 5422

    cloned 5434

    cloned 5493

    cloned 5497

    cloned 5523

    cloned 5605

    cloned 5668

    cloned 5769

    duplicate 1518

    duplicate 1683

    duplicate 2748

    duplicate 2812

    duplicate 3031

    duplicate 3934

    duplicate 4433

    duplicate 4433 and cloned 4434 and 4411

    duplicate 4435

    duplicate 4741

    duplicate 4757

    duplicate 5306

    duplicate of 3177

    duplicate 4433

    listed in SDL code

  79. Other Types of Changes notes field that contains additional information
  80. about the problem report that was determined by the

    Design Metrics team

    Notes: added fix to 03195

    cosmetic change

    could not duplicate error

    future enhancement

  81. Multiples denotes whether there is more than one problem report with

the same number

This field only contains YES for four error reports.