d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
58539  05-JAN-05 694997  NEC MONITOR               FL/BD     28-FEB-05 COMPLETED      PER EVENT         54   24   30
58568  07-JAN-05 698755  SUN MS: GDM-20E20         FL/TD/DT  12-JAN-05 COMPLETED      TRADITIONAL/BAS    5    0    5
58616  13-JAN-05 808394  DELL: 1901FP              FL/AD     01-FEB-05 COMPLETED      PER EVENT         19    0   19
58626  14-JAN-05 810095  INFORTREND: ESA16F-G1A2   FL/CD/RUN 02-FEB-05 COMPLETED      PER EVENT         19    0   19
58630  14-JAN-05 810241  DELL: DIM-8100-1400       FL/PD     10-FEB-05 COMPLETED      PER EVENT         27   24    3
58687  25-JAN-05 825442  SUN MS: 140               FL/PD     18-FEB-05 COMPLETED      PER EVENT         24   12   12
58691  25-JAN-05 825827  NEC MONITOR               FL/PD     15-FEB-05 COMPLETED      PER EVENT         21    0   21
58734  31-JAN-05 834865  SUN MS: ENT4500           EXP/CDF   24-FEB-05 COMPLETED      TRADITIONAL/PRE   24   20    4
58750  02-FEB-05 838305  VIEWSONIC MONITOR         UNIV/UCD  08-MAR-05 COMPLETED      PER EVENT         34    0   34
58780  04-FEB-05 842163  DRIVE,DISK                EXP/CDF   02-MAR-05 COMPLETED      PER EVENT         26    0   26
58811  09-FEB-05 848857  VIEWSONIC MONITOR         FL/ES     02-MAR-05 COMPLETED      PER EVENT         21    0   21
58812  09-FEB-05 848860  POLYWELL: SRV-D-P3-1400-4 FL/CD     04-MAR-05 COMPLETED      PER EVENT         23    0   23
58825  10-FEB-05 851445  ACECOMP: 2*X-2800-1U-RM   FL/CD/CMS 03-MAR-05 COMPLETED      PER EVENT         21   11   10
58858  16-FEB-05 862434  MICRON MILL-MAX 400       FL/PD     08-MAR-05 COMPLETED      PER EVENT         20   18    2
58904  22-FEB-05 869877  POLYWELL: SRV-D-P3-1400-4 FL/CD     15-MAR-05 COMPLETED      PER EVENT         21   10   11
58918  23-FEB-05 872392  HP: C4267A                FL/PD     09-MAR-05 COMPLETED      TRADITIONAL/BAS   14    0   14
59049  14-MAR-05 898630  ASA: D-X-3060-1U-RM       FL/PD     05-APR-05 COMPLETED      PER EVENT         22    0   22
59068  15-MAR-05 900948  POLYWELL: SRV-D-P3-1400-4 FL/CD     05-APR-05 COMPLETED      PER EVENT         21    0   21
59098  18-MAR-05 906631  IBM: 2897-54U             FL/CD     06-APR-05 COMPLETED      PER EVENT         19    0   19
59161  28-MAR-05 918528  VIEWSONIC MONITOR         FL/CD/CMS 18-APR-05 COMPLETED      PER EVENT         21    0   21
59162  28-MAR-05 918536  VIEWSONIC MONITOR         FL/CD/CMS 05-MAY-05 COMPLETED      PER EVENT         38    0   38
59204  04-APR-05 929911  HP: C8522A                FL/BD     22-APR-05 COMPLETED      PER EVENT         18   14    4
59208  04-APR-05 930455  HP: C4267A                FL/PD     08-APR-05 COMPLETED      TRADITIONAL/BAS    4    1    3
59213  05-APR-05 932505  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   25-APR-05 COMPLETED      PER EVENT         20    0   20
59231  06-APR-05 935394  POLYWELL: SRV-D-P3-1400-4 FL/CD     28-APR-05 COMPLETED      PER EVENT         21    0   21
59244  07-APR-05 936470  XEROX: 8400/DX            FL/PD     19-APR-05 COMPLETED      TRADITIONAL/BAS   12    7    5
59288  13-APR-05 944930  ACECOMP: 2*X-2800-1U-RM   FL/CD/CMS 03-MAY-05 COMPLETED      PER EVENT         20    8   12
59289  13-APR-05 944960  ACECOMP: ATHLON-1800+-MT  FL/CD     12-MAY-05 COMPLETED      PER EVENT         29    7   22
59304  15-APR-05 948397  DELL: LAT-CPX-J750        FL/CD/CDO 04-MAY-05 COMPLETED      PER EVENT         19    0   19
59307  15-APR-05 949120  HP: C4267A                FL/PD     22-APR-05 COMPLETED      TRADITIONAL/BAS    7    0    7
59345  20-APR-05 954595  CONCENT: 2*X-2080-4U-RM   FL/CD/EAG 13-MAY-05 COMPLETED      PER EVENT         23   12   11
59402  27-APR-05 971191  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   25-MAY-05 COMPLETED      PER EVENT         28   14   14
59458  05-MAY-05 983271  TEK: Z840/DX              FL/CD     10-MAY-05 COMPLETED      TRADITIONAL/BAS    5    0    5
59479  09-MAY-05 990846  CONCENT: 2*X-2400-1U-RM   FL/CD     01-JUN-05 COMPLETED      PER EVENT         23   16    7
59514  11-MAY-05 996118  DELL POWEREDGE SERVER     UNIV/UNM  31-MAY-05 COMPLETED      PER EVENT         19    8   11
59525  12-MAY-05 998462  DELL: LATITUDE-X300       FL/DI     02-JUN-05 COMPLETED      PER EVENT         20    8   12
59487  25-APR-05 005746  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   20-MAY-05 COMPLETED      PER EVENT          2    0    2
59488  29-APR-05 005762  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   18-MAY-05 COMPLETED      PER EVENT          0    0    0
59489  09-MAY-05 005790  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   31-MAY-05 COMPLETED      PER EVENT         13    0   13
59628  23-MAY-05 014650  ETRNLGRF: D-P3-1260-2U-RM EXP/CDF   24-JUN-05 COMPLETED      PER EVENT         31    9   22
59647  25-MAY-05 017260  SUN MS: GDM-20D10         FL/TD/DT  31-MAY-05 COMPLETED      TRADITIONAL/BAS    6    0    6
59665  26-MAY-05 018947  ATIPA: TY2518-1U-D-1.26G  EXP/CDF   24-JUN-05 COMPLETED      PER EVENT         29   21    8
59804  10-JUN-05 039489  XEROX: 8200/N             FL/PD     14-JUN-05 COMPLETED      TRADITIONAL/BAS    4    2    2
59849  15-JUN-05 046943  TEK: Z840/DX              FL/CD     20-JUN-05 COMPLETED      TRADITIONAL/BAS    5    1    4
59862  16-JUN-05 048176  TEK: Z850/DX              EXP/CDF   20-JUN-05 COMPLETED      TRADITIONAL/BAS    4    1    3
59933  23-JUN-05 058598  SUN MS STOREDGE A1000     FL/CD/CEP 29-JUN-05 COMPLETED      TRADITIONAL/PRI    6    0    6
59937  23-JUN-05 059522  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   12-JUL-05 COMPLETED      PER EVENT         19   14    5
60234  28-JUL-05 116860  TEKTRONIX Z850DX COLOR PR EXP/CDF   03-AUG-05 COMPLETED      TRADITIONAL/BAS    6    0    6
60235  28-JUL-05 116893  TEK: Z850/DX              FL/PD     03-AUG-05 COMPLETED      TRADITIONAL/BAS    6    0    6
60238  28-JUL-05 117135  XEROX: 6200DP             FL/ES     02-AUG-05 COMPLETED      TRADITIONAL/BAS    5    0    5
60306  03-AUG-05 126203  SUN MS: 600-6923-01       FL/CD     09-AUG-05 COMPLETED      TRADITIONAL/BAS    6    0    6
60313  03-AUG-05 127003  ASA: SRV-D-P3-1400-4U-RM  FL/CD     26-AUG-05 COMPLETED      PER EVENT         23   19    4
60329  05-AUG-05 130094  TEK: Z850/DP              FL/ES     09-AUG-05 COMPLETED      TRADITIONAL/BAS    4    0    4
60367  10-AUG-05 136375  HP: C4216A                FL/CD     15-AUG-05 COMPLETED      TRADITIONAL/BAS    5    0    5
60387  11-AUG-05 139083  TEK: Z850/DX              EXP/CDF   16-AUG-05 COMPLETED      TRADITIONAL/BAS    5    0    5
60442  17-AUG-05 148089  TEK: Z850/DX              EXP/CDF   22-AUG-05 COMPLETED      TRADITIONAL/BAS    5    0    5
60487  23-AUG-05 157262  DELL PRECISION WORKSTATIO UNIV/CIN  14-SEP-05 COMPLETED      PER EVENT         22   12   10
60722  15-SEP-05 193579  HP: C4267A                FL/PD     19-SEP-05 COMPLETED      TRADITIONAL/BAS    4    0    4
60734  16-SEP-05 195518  XEROX: 8200/N             EXP/D0    21-SEP-05 COMPLETED      TRADITIONAL/BAS    5    0    5
60746  16-SEP-05 196806  ASA: D-X-3060-1U-RM       FL/CD/RUN 13-OCT-05 COMPLETED      NORMAL            27   23    4
60782  21-SEP-05 202454  WESTERNSCI: 2*X-2.4G-1U-R FL/CD/CSS 28-OCT-05 COMPLETED      PER EVENT         37   20   17
61044  21-OCT-05 252986  HP: C4267A                EXP/D0    25-OCT-05 COMPLETED      TRADITIONAL/BAS    4    0    4
61046  21-OCT-05 253142  SUN MS: 600-6514-01       FL/CD/CEP 26-OCT-05 COMPLETED      TRADITIONAL/BAS    5    2    3
61052  24-OCT-05 255270  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   11-NOV-05 COMPLETED      NORMAL            18    6   12
61082  26-OCT-05 259351  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   14-NOV-05 COMPLETED      NORMAL            19   15    4
61164  02-NOV-05 270126  SUN MS: GDM-17E10         FL/TD/DT  07-NOV-05 COMPLETED      TRADITIONAL/BAS    5    3    2
61165  02-NOV-05 270149  SUN MS: S20               FL/TD/DT  08-NOV-05 COMPLETED      TRADITIONAL/BAS    6    4    2

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
61183  03-NOV-05 272963  XEROX: 8200/N             EXP/D0    08-NOV-05 COMPLETED      TRADITIONAL/BAS    4    0    4
61184  04-NOV-05 272991  TEK: Z850/DX              EXP/CDF   14-NOV-05 COMPLETED      TRADITIONAL/BAS   10    0   10
61302  16-NOV-05 290423  SUN MS: S20               FL/TD/DT  23-NOV-05 COMPLETED      TRADITIONAL/BAS    7    2    5
61436  06-DEC-05 320567  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 22-DEC-05 COMPLETED      NORMAL            16    8    8
61541  21-DEC-05 348091  ASA: D-X-3060-8TB-5U      EXP/D0    03-JAN-06 COMPLETED      NORMAL            13   11    2
61577  03-JAN-06 359803  HP: C3167A                FL/BS     03-JAN-06 COMPLETED      PER EVENT          0    0    0
61579  03-JAN-06 360430  APPLE: A1085              FL/CD/CMS 04-JAN-06 COMPLETED      PER EVENT          1    0    1
61580  03-JAN-06 360503  SUN MS: 595-5544-01       FL/CD     04-JAN-06 COMPLETED      TRADITIONAL/PRE    1    0    1
61581  03-JAN-06 360516  SUN MS: 600-6514-01       FL/CD/CSS 04-JAN-06 COMPLETED      TRADITIONAL/PRE    1    0    1
61582  03-JAN-06 360520  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 04-JAN-06 COMPLETED      NORMAL             1    0    1
61587  03-JAN-06 361072  SUN MS: S5                FL/TD     04-JAN-06 COMPLETED      PER EVENT          1    0    1
61591  03-JAN-06 361403  HP: C4267A                FL/PD     04-JAN-06 COMPLETED      TRADITIONAL/BAS    1    0    1
61593  03-JAN-06 361468  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    12-JAN-06 COMPLETED      NORMAL             9    0    9
61597  04-JAN-06 362900  ATIPA: 2*X-2.66G-1U-RM    FL/CD/CSS 06-JAN-06 COMPLETED      NORMAL             2    0    2
61598  04-JAN-06 363103  XEROX: 860/N              FL/AD     05-JAN-06 COMPLETED      PER EVENT          1    0    1
61602  04-JAN-06 363464  HP: C4267A                FL/BS     11-JAN-06 COMPLETED      PER EVENT          7    1    6
61604  04-JAN-06 363534  HP LASERJET               FL/ES     05-JAN-06 COMPLETED      PER EVENT          1    0    1
61605  04-JAN-06 363714  HP: Q2434A                FL/LS     05-JAN-06 COMPLETED      PER EVENT          1    0    1
61610  05-JAN-06 365386  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    06-JAN-06 COMPLETED      NORMAL             1    0    1
61611  05-JAN-06 365597  INFORTREND: ESA16F-G1A2   FL/CD/CMS 10-JAN-06 COMPLETED      PER EVENT          5    0    5
61639  09-JAN-06 370396  DELL: LAT-X300-1200       FL/CD     13-JAN-06 COMPLETED      PER EVENT          4    1    3
61643  10-JAN-06 372026  SUN MS: 600-6514-01       FL/CD/CEP 10-JAN-06 COMPLETED      TRADITIONAL/BAS    0    0    0
61642  10-JAN-06 372081  HP: C4267A                FL/PD     12-JAN-06 COMPLETED      TRADITIONAL/BAS    2    0    2
61644  10-JAN-06 372232  COMPAQ: EVO               FL/CD     18-JAN-06 COMPLETED      PER EVENT          8    0    8
61645  10-JAN-06 370679  ASA: D-X-2800-24*250G(6TB EXP/CDF   11-JAN-06 COMPLETED      NORMAL             1    0    1
61646  10-JAN-06 372751  HP: C4121A                FL/FE     13-JAN-06 COMPLETED      PER EVENT          3    0    3
61648  10-JAN-06 372971  INFORTREND: ESA16F-G1A2   FL/CD/CMS 13-JAN-06 COMPLETED      PER EVENT          3    0    3
61653  11-JAN-06 374254  TEK: Z360                 FL/PD     18-JAN-06 COMPLETED      PER EVENT          7    5    2
61663  12-JAN-06 375811  SOYATA CPU BOX            UNIV/URO  13-JAN-06 COMPLETED      PER EVENT          1    0    1
61680  12-JAN-06 376723  HP: C7061A                FL/ES     13-JAN-06 COMPLETED      PER EVENT          1    0    1
61681  12-JAN-06 376789  DELL: LAT-C610-1200       FL/LS     18-JAN-06 COMPLETED      PER EVENT          6    0    6
61682  12-JAN-06 376818  HP LASERJET               FL/ES     17-JAN-06 COMPLETED      PER EVENT          5    1    4
61684  13-JAN-06 377690  TEK: Z850/DP              EXP/CDF   07-FEB-06 COMPLETED      TRADITIONAL/BAS   25    1   24
61685  13-JAN-06 378037  KOI CPU BOX               FL/PD     01-FEB-06 COMPLETED      PER EVENT         19   12    7
61689  12-JAN-06 378317  APPLE: A1085              FL/CD/CMS 18-JAN-06 COMPLETED      PER EVENT          5    1    4
61690  13-JAN-06 378577  HP: C4216A                FL/AD     17-JAN-06 COMPLETED      PER EVENT          4    0    4
61692  13-JAN-06 378669  HP: C4267A                FL/AD     19-JAN-06 COMPLETED      PER EVENT          6    0    6
61694  13-JAN-06 379336  DELL: LATITUDE-C640       FL/PD     19-JAN-06 COMPLETED      PER EVENT          6    0    6
61695  13-JAN-06 379341  DELL: XPS-R400            FL/PD     24-JAN-06 COMPLETED      PER EVENT         11    7    4
61703  17-JAN-06 385179  DELL: XPS-R400            FL/PD     17-JAN-06 COMPLETED      PER EVENT          0    0    0
61704  17-JAN-06 385386  DELL: LAT-D610-1600       FL/PD     20-JAN-06 COMPLETED      PER EVENT          3    1    2
61705  17-JAN-06 385625  ASA: D-X-2800-24*250G(6TB EXP/CDF   17-JAN-06 COMPLETED      NORMAL             0    0    0
61708  17-JAN-06 385865  NEXSAN: ATABEAST 42*400   FL/CD/REX 24-JAN-06 COMPLETED      PER EVENT          7    2    5
61709  17-JAN-06 385900  NEXSAN: ATABEAST 42*400   FL/CD     24-JAN-06 COMPLETED      PER EVENT          7    0    7
61710  17-JAN-06 385942  ASA: D-X-3000-24*250G(6TB FL/CD     18-JAN-06 COMPLETED      NORMAL             1    0    1
61711  17-JAN-06 385985  CONCENT: 2*X-3060-6TB-5U- FL/CD     03-FEB-06 COMPLETED      PER EVENT         17   15    2
61712  17-JAN-06 386011  CONCENT: 2*X-2400-1U-RM   FL/CD     03-FEB-06 COMPLETED      PER EVENT         17   15    2
61719  17-JAN-06 387289  DELL DIMENSION SERIES     FL/TD     20-JAN-06 COMPLETED      PER EVENT          2    0    2
61720  18-JAN-06 387326  HP: C4267A                FL/PD     18-JAN-06 COMPLETED      TRADITIONAL/BAS    0    0    0
61721  17-JAN-06 387415  ASA: D-X-3060-8TB-5U      EXP/D0    18-JAN-06 COMPLETED      NORMAL             0    0    0
61722  18-JAN-06 387433  DELL OPTIPLEX GX150       FL/CD     25-JAN-06 COMPLETED      PER EVENT          7    0    7
61723  18-JAN-06 387490  SONY: PCG-FX220K          FL/PD     26-JAN-06 COMPLETED      PER EVENT          8    1    7
61725  18-JAN-06 387801  MICRON: SE440BX-PII400-MT FL/ES     23-JAN-06 COMPLETED      PER EVENT          5    0    5
61724  18-JAN-06 387783  HP: C4089A                FL/PD     19-JAN-06 COMPLETED      PER EVENT          1    0    1
61726  18-JAN-06 387851  DELL: INSP-8100           FL/PD     20-JAN-06 COMPLETED      PER EVENT          2    0    2
61727  18-JAN-06 387979  DELL: LAT-X300-1200       FL/PD     30-JAN-06 COMPLETED      PER EVENT         12    8    4
61732  19-JAN-06 389810  HP: C2009A                FL/CD     20-JAN-06 COMPLETED      PER EVENT          1    0    1
61735  19-JAN-06 390752  APPLE POWERMAC G5         FL/CD     17-FEB-06 COMPLETED      PER EVENT         29   13   16
61741  20-JAN-06 391705  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    23-JAN-06 COMPLETED      NORMAL             3    0    3
61742  20-JAN-06 391712  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    23-JAN-06 COMPLETED      NORMAL             3    0    3
61743  20-JAN-06 391719  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    23-JAN-06 COMPLETED      NORMAL             3    0    3
61746  20-JAN-06 392136  ASA: D-X-2800-24*250G(6TB EXP/CDF   20-JAN-06 COMPLETED      NORMAL             0    0    0
61748  20-JAN-06 392988  DELL: GX240-2000-MT       FL/PD     23-JAN-06 COMPLETED      PER EVENT          3    0    3
61751  20-JAN-06 394274  MICRON: AL440LX-PII300-MT FL/ES     23-JAN-06 COMPLETED      PER EVENT          0    0    0
61755  23-JAN-06 394590  SUN MS: 602-1676-01       EXP/CDF   23-JAN-06 COMPLETED      TRADITIONAL/PRE    0    0    0
61756  23-JAN-06 394649  ASA: D-X-3060-1U-RM       EXP/D0    23-JAN-06 COMPLETED      NORMAL             0    0    0
61757  23-JAN-06 394677  ASA: D-X-3060-8TB-5U      EXP/D0    23-JAN-06 COMPLETED      NORMAL             0    0    0

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
61760  23-JAN-06 395178  DELL: LATITUDE-D810       FL/CD/CSS 30-JAN-06 COMPLETED      PER EVENT          7    0    7
61759  23-JAN-06 395211  HP: Q2434A                FL/CD/CCF 26-JAN-06 COMPLETED      PER EVENT          3    0    3
61761  23-JAN-06 395238  TEK: Z850/DP              FL/CD     25-JAN-06 COMPLETED      PER EVENT          2    0    2
61763  23-JAN-06 395349  HP LASERJET               FL/PD     24-JAN-06 COMPLETED      PER EVENT          1    0    1
61764  23-JAN-06 395594  DELL: LATITUDE-D410       FL/DI     10-FEB-06 COMPLETED      PER EVENT         18   13    5
61766  23-JAN-06 395611  DELL: LAT-X300-1200       FL/DI     27-JAN-06 COMPLETED      PER EVENT          4    0    4
61771  23-JAN-06 396993  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 24-JAN-06 COMPLETED      NORMAL             0    0    0
61775  24-JAN-06 397770  HP: C3167A                FL/BS     26-JAN-06 COMPLETED      PER EVENT          2    0    2
61777  24-JAN-06 397810  DELL: PPX                 FL/CD     08-FEB-06 COMPLETED      PER EVENT         15   10    5
61797  26-JAN-06 401403  HP: C3167A                FL/BS     26-JAN-06 COMPLETED      PER EVENT          0    0    0
61798  26-JAN-06 401501  HP: C8052A-ABA            FL/DI     31-JAN-06 COMPLETED      PER EVENT          5    0    5
61801  26-JAN-06 402136  HP: C2009A                FL/CD     02-FEB-06 COMPLETED      PER EVENT          7    0    7
61803  26-JAN-06 402869  HP: C2009A                FL/BS     27-JAN-06 COMPLETED      PER EVENT          0    0    0
61804  27-JAN-06 403271  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   31-JAN-06 COMPLETED      PER EVENT          4    0    4
61805  27-JAN-06 403389  DELL: LATITUDE-C640       FL/AD     03-FEB-06 COMPLETED      PER EVENT          7    6    1
61806  27-JAN-06 403425  HP: C2009A                FL/CD     31-JAN-06 COMPLETED      PER EVENT          4    3    1
61807  27-JAN-06 403521  DELL: LATITUDE-D600       FL/PD     01-FEB-06 COMPLETED      PER EVENT          5    0    5
61809  27-JAN-06 403546  DELL: GX280-3200          FL/PD     01-FEB-06 COMPLETED      PER EVENT          5    0    5
61814  27-JAN-06 404072  DELL LATITUDE LAPTOP      EXP/D0    30-JAN-06 COMPLETED      PER EVENT          3    0    3
61817  30-JAN-06 405806  SUN MS: 595-5544-01       FL/CD/CEP 31-JAN-06 COMPLETED      TRADITIONAL/BAS    1    0    1
61818  30-JAN-06 406350  DELL: LATITUDE-D600       FL/AD     01-FEB-06 COMPLETED      PER EVENT          2    0    2
61826  31-JAN-06 408469  HP: C7099A                FL/CD/CSS 31-JAN-06 COMPLETED      PER EVENT          0    0    0
61827  31-JAN-06 408642  DELL: GX260-2000-SF       FL/LS/TD  09-FEB-06 COMPLETED      PER EVENT          9    3    6
61828  31-JAN-06 408684  SUN MS: 595-5544-01       FL/CD/CEP 01-FEB-06 COMPLETED      TRADITIONAL/BAS    1    0    1
61830  31-JAN-06 408854  HP: C3167A                FL/PD     31-JAN-06 COMPLETED      PER EVENT          0    0    0
61832  31-JAN-06 409085  DELL: INSP-5150-3060      UNIV/UF   03-FEB-06 COMPLETED      PER EVENT          3    0    3
61833  31-JAN-06 409149  DELL: DIM-4600            FL/LS     07-FEB-06 COMPLETED      PER EVENT          7    0    7
61838  01-FEB-06 409896  SYSTEMAX: ATHLON-1000-MT  FL/PD     03-FEB-06 COMPLETED      PER EVENT          2    0    2
61837  01-FEB-06 409721  DELL: LAT-D800-1700       FL/ES     10-FEB-06 COMPLETED      PER EVENT          9    0    9
61839  01-FEB-06 409935  SUN MS: ENT420R           FL/CD/CEP 08-FEB-06 COMPLETED      TRADITIONAL/PRI    7    5    2
61842  01-FEB-06 410118  HP: C2011A                FL/LS     03-FEB-06 COMPLETED      PER EVENT          2    0    2
61844  01-FEB-06 410526  DELL DIMENSION SERIES     FL/PD     02-FEB-06 COMPLETED      PER EVENT          1    0    1
61846  02-FEB-06 411956  INFORTREND: ESA16F-G1A2   FL/CD/CMS 03-FEB-06 COMPLETED      PER EVENT          1    0    1
61848  02-FEB-06 412040  INFORTREND: ESA16F-G1A2   FL/CD/CMS 08-FEB-06 COMPLETED      PER EVENT          6    0    6
61857  02-FEB-06 412798  POLYWELL: SRV-D-P3-1400-4 FL/CD     03-FEB-06 COMPLETED      PER EVENT          1    0    1
61864  03-FEB-06 413797  TOSH: PP3500U-002GF4      FL/AD     14-FEB-06 COMPLETED      PER EVENT         11    7    4
61867  03-FEB-06 414530  TEK: Z350                 FL/CD/CSS 10-FEB-06 COMPLETED      PER EVENT          7    0    7
61872  06-FEB-06 415979  DELL: LAT-X300-1200       FL/PD     07-FEB-06 COMPLETED      PER EVENT          1    0    1
61873  06-FEB-06 416134  HP: C3167A                FL/BS     06-FEB-06 COMPLETED      PER EVENT          0    0    0
61874  06-FEB-06 416336  DELL: PREC370N-3200       FL/CD     08-FEB-06 COMPLETED      PER EVENT          2    0    2
61875  06-FEB-06 416528  HP: C4267A                FL/PD     08-FEB-06 COMPLETED      TRADITIONAL/BAS    2    0    2
61877  06-FEB-06 416837  ASA: D-X-3060-1U-RM       FL/CD     07-FEB-06 COMPLETED      NORMAL             1    0    1
61886  07-FEB-06 420167  XEROX: 8200/N             EXP/D0    09-FEB-06 COMPLETED      TRADITIONAL/BAS    2    0    2
61887  07-FEB-06 420232  HP: C4267A                FL/PD     09-FEB-06 COMPLETED      TRADITIONAL/BAS    2    0    2
61890  08-FEB-06 421851                            FL/CD     27-FEB-06 COMPLETED      PER EVENT         19    0   19
61891  08-FEB-06 422456  ASA: D-X-3060-1U-RM       FL/CD     08-FEB-06 COMPLETED      PER EVENT          0    0    0
61910  09-FEB-06 423833  DELL: LAT-C800-1000       FL/TD     09-FEB-06 COMPLETED      PER EVENT          0    0    0
61914  09-FEB-06 424763  DELL: LATITUDE-D810       FL/PD     13-FEB-06 COMPLETED      PER EVENT          4    1    3
61932  13-FEB-06 428403  SUN MS: 602-1676-01       EXP/CDF   13-FEB-06 COMPLETED      TRADITIONAL/PRE    0    0    0
61935  10-FEB-06 429588  DELL: LATITUDE-D410       FL/DI     02-MAR-06 COMPLETED      PER EVENT         17   11    6
61936  13-FEB-06 429805  INFORTREND: ESA16F-G1A2   FL/CD     17-FEB-06 COMPLETED      PER EVENT          4    0    4
61937  13-FEB-06 429834  XEROX: 6250/DP            FL/PD     14-FEB-06 COMPLETED      PER EVENT          1    0    1
61940  13-FEB-06 429924  DELL: LAT-C800-1000       FL/TD     15-FEB-06 COMPLETED      PER EVENT          2    0    2
61943  14-FEB-06 431120  PLUSDATA: P2-266-DT       FL/CD/CSS 14-FEB-06 COMPLETED      PER EVENT          0    0    0
61946  14-FEB-06 431929  HP: C3167A                FL/FE     14-FEB-06 COMPLETED      PER EVENT          0    0    0
61947  14-FEB-06 432023  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    16-FEB-06 COMPLETED      NORMAL             2    0    2
61949  14-FEB-06 432100  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    15-FEB-06 COMPLETED      NORMAL             1    0    1
61950  14-FEB-06 432162  HP LASERJET               FL/PD     15-FEB-06 COMPLETED      PER EVENT          1    0    1
61951  14-FEB-06 432180  ASA: D-X-3060-8TB-5U      FL/CD     15-FEB-06 COMPLETED      NORMAL             1    0    1
61953  14-FEB-06 432963  NEXSAN: ATABEAST 42*400   FL/CD/REX 21-FEB-06 COMPLETED      PER EVENT          6    0    6
61954  14-FEB-06 433025  NEXSAN: ATABEAST 42*400   FL/CD/REX 21-FEB-06 COMPLETED      PER EVENT          6    0    6
61956  14-FEB-06 433146  DELL: LATITUDE-D410       FL/DI     23-FEB-06 COMPLETED      PER EVENT          8    3    5
61958  15-FEB-06 433247  ASA: SRV-D-P3-1400-4U-RM  FL/CD     23-FEB-06 COMPLETED      PER EVENT          8    6    2
61959  15-FEB-06 434056  DELL: INSP-9100-2800      FL/CD/CCF 20-FEB-06 COMPLETED      PER EVENT          5    0    5
61961  15-FEB-06 435017  DELL: LAT-C800-1000       FL/TD     20-FEB-06 COMPLETED      PER EVENT          4    0    4
61964  16-FEB-06 435931  HP: Q2434A                FL/CD     20-FEB-06 COMPLETED      PER EVENT          4    0    4
61966  16-FEB-06 436032  HP CPU BOX                FL/PD     21-FEB-06 COMPLETED      PER EVENT          5    4    1

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
61968  16-FEB-06 436037  ASA: 7.6TB-5U-RM          FL/CD     01-MAR-06 COMPLETED      PER EVENT         13    0   13
61970  17-FEB-06 437931  DELL POWEREDGE 2850       FL/CD/CSS 09-MAR-06 COMPLETED      PER EVENT         20    0   20
61971  17-FEB-06 438429  HP: Q2434A                FL/PD     22-FEB-06 COMPLETED      PER EVENT          5    0    5
61981  20-FEB-06 440993  HP: C3167A                FL/BS     23-FEB-06 COMPLETED      PER EVENT          3    0    3
61982  20-FEB-06 441043  INFORTREND: ESA16F-G1A2   FL/CD/CMS 24-FEB-06 COMPLETED      PER EVENT          4    0    4
61991  21-FEB-06 443466  APPLE POWERMAC G5         FL/CD     22-FEB-06 COMPLETED      PER EVENT          1    0    1
61992  21-FEB-06 443986  DELL: LAT-D600-1600       FL/CD/CCF 24-FEB-06 COMPLETED      PER EVENT          3    0    3
61994  21-FEB-06 444171  NEXSAN: ATABEAST 42*400   FL/CD/REX 21-FEB-06 COMPLETED      PER EVENT          0    0    0
61996  22-FEB-06 446020  HP: C2011A                FL/PD     22-FEB-06 COMPLETED      PER EVENT          0    0    0
61998  22-FEB-06 446675  ASA: D-X-3000-24*250G(6TB FL/CD     23-FEB-06 COMPLETED      NORMAL             1    0    1
61999  22-FEB-06 446766  DELL: LATITUDE-C640       FL/AD     01-MAR-06 COMPLETED      PER EVENT          7    0    7
62000  22-FEB-06 446835  ASA: D-X-3000-24*250G(6TB FL/CD     23-FEB-06 COMPLETED      NORMAL             1    0    1
62011  23-FEB-06 448628  WESTERN DIGITAL DRIVES    FL/CD     06-MAR-06 COMPLETED      PER EVENT         11    0   11
62017  24-FEB-06 450110  DELL: 3200MP              FL/PD     01-MAR-06 COMPLETED      PER EVENT          5    3    2
62018  24-FEB-06 450285  INFORTREND: ESA16F-G1A2   FL/CD/CMS 09-MAR-06 COMPLETED      PER EVENT         13    0   13
62019  24-FEB-06 450388  DELL: DIM-9100-840        FL/TD     02-MAR-06 COMPLETED      PER EVENT          6    1    5
62022  24-FEB-06 450724  HP: C2009A                FL/DI     27-FEB-06 COMPLETED      PER EVENT          3    0    3
62023  24-FEB-06 452536  INFORTREND: ESA16F-G1A2   FL/CD/CMS 03-MAR-06 COMPLETED      PER EVENT          4    0    4
62025  25-FEB-06 452645  SUN MS: 380-0462-01       FL/CD/CSS 27-FEB-06 COMPLETED      TRADITIONAL/PRI    0    0    0
62026  24-FEB-06 452798  DELL: LATITUDE-X300       FL/DI     09-MAR-06 COMPLETED      PER EVENT         10    7    3
62029  24-FEB-06 453157  LEXMARK: X-83             FL/BS     03-MAR-06 COMPLETED      PER EVENT          4    3    1
62033  27-FEB-06 453238  DELL: LATITUDE-C640       FL/LS     27-FEB-06 COMPLETED      PER EVENT          0    0    0
62034  27-FEB-06 453431  DELL: LATITUDE-D800       FL/PD     01-MAR-06 COMPLETED      PER EVENT          2    0    2
62035  27-FEB-06 453557  ATIPA: 2*X-2.66G-1U-RM    FL/CD/CSS 03-MAR-06 COMPLETED      NORMAL             4    0    4
62036  27-FEB-06 453629  HP: C4267A                FL/PD     03-MAR-06 COMPLETED      PER EVENT          4    0    4
62037  27-FEB-06 453811  HP: C4267A                FL/PD     28-FEB-06 COMPLETED      PER EVENT          1    0    1
62038  27-FEB-06 453962  SUN MS: 600-6923-01       FL/CD/CSS 28-FEB-06 COMPLETED      TRADITIONAL/PRE    1    0    1
62040  27-FEB-06 454253  HP: C3167A                FL/ES     28-FEB-06 COMPLETED      PER EVENT          1    0    1
62045  27-FEB-06 457084  DELL: LAT-D610-2000       FL/PD     03-MAR-06 COMPLETED      PER EVENT          3    0    3
62051  28-FEB-06 457638  HP: C4267A                FL/PD     28-FEB-06 COMPLETED      PER EVENT          0    0    0
62052  28-FEB-06 457647  SUN MS: 600-7243-01       FL/CD/CSS 02-MAR-06 COMPLETED      TRADITIONAL/PRE    2    0    2
62053  27-FEB-06 458026  APPLE POWERBOOK G4        FL/CD     17-MAR-06 COMPLETED      PER EVENT         17   14    3
62058  28-FEB-06 461720  DELL: LATITUDE-C800       FL/CD     02-MAR-06 COMPLETED      PER EVENT          1    0    1
62060  01-MAR-06 461915  DELL: GX270-2660          FL/CD     08-MAR-06 COMPLETED      PER EVENT          7    0    7
62065  01-MAR-06 463071  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    21-APR-06 COMPLETED      NORMAL            51    0   51
62064  01-MAR-06 463093  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    02-MAR-06 COMPLETED      NORMAL             1    0    1
62070  02-MAR-06 464158  SUN MS: 602-2636-03       FL/CD     02-MAR-06 COMPLETED      PER EVENT          0    0    0
62071  02-MAR-06 464341  HP: C2009A                FL/DI     03-MAR-06 COMPLETED      PER EVENT          1    0    1
62072  02-MAR-06 464596  HP: Q2428A                FL/CD     03-MAR-06 COMPLETED      PER EVENT          1    0    1
62078  02-MAR-06 464894  ASA: D-X-3060-1U-RM       FL/CD     27-MAR-06 COMPLETED      PER EVENT         25    0   25
62086  02-MAR-06 465195  HP: C3167A                FL/AD     06-MAR-06 COMPLETED      PER EVENT          4    0    4
62091  02-MAR-06 466134  HP: Q2434A                FL/LS     06-MAR-06 COMPLETED      PER EVENT          3    0    3
62092  02-MAR-06 466371  WESTERNSCI: 2*X-2.4G-1U-R FL/CD/CSS 06-APR-06 COMPLETED      PER EVENT         34    0   34
62093  03-MAR-06 466634  HP: C4267A                FL/PD     03-MAR-06 COMPLETED      TRADITIONAL/BAS    0    0    0
62103  03-MAR-06 467489  HP: Q3943A#ABA            FL/ES     06-MAR-06 COMPLETED      PER EVENT          3    0    3
62107  06-MAR-06 469271  DELL: PE2650-X-2800       FL/CD/CSS 08-MAR-06 COMPLETED      PER EVENT          2    0    2
62113  06-MAR-06 470238  SUN MS: 600-5828-03       FL/AD     07-MAR-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62117  06-MAR-06 470796  ATIPA: AS2469NG-1U2200+   FL/CD     07-MAR-06 COMPLETED      PER EVENT          1    0    1
62119  06-MAR-06 471520  ATIPA: AS2469NG-1U2200+   FL/CD     07-MAR-06 COMPLETED      PER EVENT          0    0    0
62122  07-MAR-06 471589  HP: C4087A                FL/PD     10-MAR-06 COMPLETED      PER EVENT          3    0    3
62123  07-MAR-06 471676  APPLE IBOOK G4            FL/PD     10-MAR-06 COMPLETED      PER EVENT          3    1    2
62128  07-MAR-06 472097  HP: C4267A                FL/PD     07-MAR-06 COMPLETED      TRADITIONAL/BAS    0    0    0
62129  07-MAR-06 472216  DELL: LATITUDE-D410       FL/PD     15-MAR-06 COMPLETED      PER EVENT          8    0    8
62130  07-MAR-06 472573  ACECOMP: P4-2000-MT       FL/AD     10-MAR-06 COMPLETED      PER EVENT          3    0    3
62132  07-MAR-06 473680  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   08-MAR-06 COMPLETED      PER EVENT          0    0    0
62133  07-MAR-06 473760  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   08-MAR-06 COMPLETED      PER EVENT          0    0    0
62135  08-MAR-06 473876  TEK: Z850/DP              FL/CD     10-MAR-06 COMPLETED      PER EVENT          2    0    2
62136  08-MAR-06 473924  SUN MS: 602-1676-01       EXP/CDF   09-MAR-06 COMPLETED      TRADITIONAL/PRE    1    0    1
62138  08-MAR-06 474253  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    08-MAR-06 COMPLETED      NORMAL             0    0    0
62139  09-MAR-06 475720  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    17-MAR-06 COMPLETED      NORMAL             8    0    8
62140  09-MAR-06 475745  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    09-MAR-06 COMPLETED      NORMAL             0    0    0
62143  09-MAR-06 476988  HP: C4267A                FL/PD     13-MAR-06 COMPLETED      TRADITIONAL/BAS    4    0    4
62148  09-MAR-06 477192  HP LASERJET               FL/AD     23-MAR-06 COMPLETED      PER EVENT         14    0   14
62156  10-MAR-06 478846  SUN MS: 602-1676-01       EXP/CDF   10-MAR-06 COMPLETED      TRADITIONAL/PRE    0    0    0
62160  10-MAR-06 479035  ASA: D-X-3000-24*250G(6TB FL/CD     10-MAR-06 COMPLETED      NORMAL             0    0    0
62162  10-MAR-06 479368  DELL OPTIPLEX GX270       FL/PD     15-MAR-06 COMPLETED      PER EVENT          5    0    5
62163  10-MAR-06 479411  DELL OPTIPLEX GX270       FL/PD     14-MAR-06 COMPLETED      PER EVENT          4    0    4

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
62171  13-MAR-06 484049  DELL: OPTI GX240-1500     FL/CD/CSS 15-MAR-06 COMPLETED      PER EVENT          2    0    2
62174  13-MAR-06 484366  HP: C4267A                FL/PD     16-MAR-06 COMPLETED      TRADITIONAL/BAS    3    0    3
62175  13-MAR-06 492214  XEROX: 8200/N             FL/PD     16-MAR-06 COMPLETED      TRADITIONAL/BAS    3    0    3
62176  13-MAR-06 484660  SONY: VGN-S170B14         EXP/CDF   17-MAR-06 COMPLETED      PER EVENT          4    0    4
62178  13-MAR-06 485056  DELL: DIM-8400-3600       FL/PD     17-MAR-06 COMPLETED      PER EVENT          4    0    4
62179  13-MAR-06 485128  INFORTREND: ESA16F-G1A2   FL/CD/CMS 28-MAR-06 COMPLETED      PER EVENT         15    0   15
62180  13-MAR-06 485163  APPLE POWERBOOK G4        FL/AD     29-MAR-06 COMPLETED      PER EVENT         16   10    6
62181  13-MAR-06 486358  ATIPA: TS-2468-1U-2000+-X FL/CD     14-MAR-06 COMPLETED      PER EVENT          0    0    0
62186  14-MAR-06 489585  DELL: INSP-9100-2800      FL/CD/CCF 16-MAR-06 COMPLETED      PER EVENT          2    0    2
62191  14-MAR-06 491377  ATIPA: TS-2468-1U-2000+-X EXP/CDF   15-MAR-06 COMPLETED      PER EVENT          0    0    0
62193  15-MAR-06 491552  ATIPA: AS2469NG-1U2200+   FL/CD     17-MAR-06 COMPLETED      PER EVENT          2    0    2
62200  15-MAR-06 491850  DELL: LAT-D610-2000       FL/CD/CDO 17-MAR-06 COMPLETED      PER EVENT          2    0    2
62201  15-MAR-06 491970  HP: C4216A                FL/CD     15-MAR-06 COMPLETED      TRADITIONAL/BAS    0    0    0
62202  15-MAR-06 492091  DELL: DIM-4600-2600       FL/CD/CSS 20-MAR-06 COMPLETED      PER EVENT          5    0    5
62203  15-MAR-06 492206  HP: C4267A                FL/PD     21-MAR-06 COMPLETED      PER EVENT          6    0    6
62204  15-MAR-06 492399  HP: C4267A                FL/PD     16-MAR-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62205  15-MAR-06 492567  ATIPA: TYS2468-1U2*MP2000 FL/CD     17-MAR-06 COMPLETED      PER EVENT          2    0    2
62208  16-MAR-06 493643  HP: C8547A                FL/FE     17-MAR-06 COMPLETED      PER EVENT          1    0    1
62210  16-MAR-06 493834  DELL: GX260-2000-SF       FL/BS     21-MAR-06 COMPLETED      PER EVENT          5    0    5
62215  16-MAR-06 494473  DELL OPTIPLEX GX620       FL/PD     21-MAR-06 COMPLETED      PER EVENT          5    0    5
62217  16-MAR-06 494769  ASA: D-X-3060-1U-RM       FL/CD     17-MAR-06 COMPLETED      NORMAL             1    0    1
62221  17-MAR-06 495510  DELL: LATITUDE-D600       FL/AD     29-MAR-06 COMPLETED      PER EVENT         12    3    9
62223  17-MAR-06 495766  TEK: Z360                 FL/LS     20-MAR-06 COMPLETED      PER EVENT          3    0    3
62225  16-MAR-06 495979  SUN MS: 600-6514-01       FL/CD/CEP 23-MAR-06 COMPLETED      TRADITIONAL/BAS    6    5    1
62227  17-MAR-06 496007  HP: C4267A                FL/PD     21-MAR-06 COMPLETED      PER EVENT          4    0    4
62230  17-MAR-06 496102  INFORTREND: ESA16F-G1A2   FL/CD/CMS 24-MAR-06 COMPLETED      PER EVENT          7    0    7
62233  17-MAR-06 496506  DELL: LAT-X200-933        FL/CD     20-MAR-06 COMPLETED      PER EVENT          3    0    3
62234  17-MAR-06 496561  HP: C3167A                FL/PD     20-MAR-06 COMPLETED      PER EVENT          3    0    3
62235  20-MAR-06 498026  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    25-APR-06 COMPLETED      NORMAL            36    0   36
62237  20-MAR-06 498498  DELL: DIM-8400-3600       FL/PD     20-MAR-06 COMPLETED      PER EVENT          0    0    0
62238  20-MAR-06 498581  DELL: PE4400-P3X-733      FL/CD/CCF 21-MAR-06 COMPLETED      TRADITIONAL/PRE    1    0    1
62241  20-MAR-06 499406  ASA: D-X-3060-1U-RM       FL/CD     21-MAR-06 COMPLETED      NORMAL             1    0    1
62242  20-MAR-06 499444  HP: C4267A                FL/PD     24-MAR-06 COMPLETED      TRADITIONAL/BAS    4    0    4
62243  20-MAR-06 499481  INFORTREND: ESA16F-G1A2   FL/CD/CMS 28-MAR-06 COMPLETED      PER EVENT          8    0    8
62246  21-MAR-06 500564  APPLE: IMAC G5            FL/PD     30-MAR-06 COMPLETED      PER EVENT          9    8    1
62247  21-MAR-06 500953  HP: C4267A                FL/PD     21-MAR-06 COMPLETED      PER EVENT          0    0    0
62255  22-MAR-06 504001  HP: C4087A                FL/PD     27-MAR-06 COMPLETED      PER EVENT          5    0    5
62257  22-MAR-06 504292  HP: C3167A                FL/ES     22-MAR-06 COMPLETED      PER EVENT          0    0    0
62259  22-MAR-06 504617  XEROX: 6250/DP            FL/PD     24-MAR-06 COMPLETED      PER EVENT          2    0    2
62260  22-MAR-06 504703  HP: C4267A                FL/PD     28-MAR-06 COMPLETED      PER EVENT          6    0    6
62261  22-MAR-06 504959  HP: C4120A                FL/PD     24-MAR-06 COMPLETED      PER EVENT          2    0    2
62262  23-MAR-06 507498  ASA: D-X-3200-2U-RM       FL/CD/REX 30-MAR-06 COMPLETED      NORMAL             7    0    7
62263  23-MAR-06 507532  INFORTREND: ESA16F-G1A2   FL/CD/CMS 27-MAR-06 COMPLETED      PER EVENT          4    0    4
62264  23-MAR-06 507563  INFORTREND: ESA16F-G1A2   FL/CD/CMS 27-MAR-06 COMPLETED      PER EVENT          4    0    4
62267  23-MAR-06  509204 ASA: D-X-3200-2U-RM       FL/CD/REX 24-MAR-06 COMPLETED      NORMAL             0    0    0
62270  24-MAR-06 509614  ASA: D-X-3060-1U-RM       FL/CD     24-MAR-06 COMPLETED      NORMAL             0    0    0
62274  27-MAR-06 513099  RACKSAVR: D-ATHMP-2000+-4 FL/CD     27-MAR-06 COMPLETED      TRADITIONAL/PRE    0    0    0
62276  27-MAR-06 513894  ACECOMP: P4-2800-DT       FL/CD     31-MAR-06 COMPLETED      PER EVENT          4    0    4
62278  27-MAR-06 514034  DELL: LATITUDE-D600       FL/AD     28-MAR-06 COMPLETED      PER EVENT          1    0    1
62283  28-MAR-06 515396  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    28-MAR-06 COMPLETED      NORMAL             0    0    0
62286  28-MAR-06 515957  ASA: D-X-3060-1U-RM       FL/PD     11-APR-06 COMPLETED      NORMAL            14    0   14
62287  28-MAR-06 516439  DELL: PPX                 FL/CD     29-MAR-06 COMPLETED      PER EVENT          1    0    1
62291  29-MAR-06 517431  DELL: LATITUDE-D800       FL/CD     30-MAR-06 COMPLETED      PER EVENT          1    0    1
62292  29-MAR-06 517461  TEK: Z840/DX              FL/CD     03-APR-06 COMPLETED      TRADITIONAL/BAS    5    0    5
62297  29-MAR-06 518010  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    03-APR-06 COMPLETED      NORMAL             5    0    5
62298  29-MAR-06 518139  DELL: 486P/25             UNIV/OXF  10-APR-06 COMPLETED      PER EVENT         12    0   12
62305  30-MAR-06 519546  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    30-MAR-06 COMPLETED      NORMAL             0    0    0
62317  31-MAR-06 521779  INFORTREND: ESA16F-G1A2   FL/CD/CMS 04-APR-06 COMPLETED      PER EVENT          4    0    4
62318  31-MAR-06 521845  HP: C3167A                FL/PD     31-MAR-06 COMPLETED      PER EVENT          0    0    0
62325  03-APR-06 524329  DELL: DIM-4600            FL/PD     03-APR-06 COMPLETED      PER EVENT          0    0    0
62326  03-APR-06 524578  DELL OPTIPLEX GX270       FL/DI     05-APR-06 COMPLETED      PER EVENT          2    0    2
62327  03-APR-06 524603  DELL OPTIPLEX GX270       FL/DI     05-APR-06 COMPLETED      PER EVENT          2    0    2
62328  03-APR-06 524702  DELL: OPTI GX240-1500     FL/CD/CSS 07-APR-06 COMPLETED      PER EVENT          4    0    4
62334  03-APR-06 524894  DELL OPTIPLEX GX260       FL/PD     05-APR-06 COMPLETED      PER EVENT          2    0    2
62335  03-APR-06 525058  MICRON MILL-MAX GS133-733 FL/PD     03-APR-06 COMPLETED      PER EVENT          0    0    0
62337  03-APR-06 525216  SUN MS: S5FX1-70-32-P44   FL/TD     04-APR-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62341  03-APR-06 525432  HP: C8547A                FL/FE     04-APR-06 COMPLETED      PER EVENT          1    0    1

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
62343  03-APR-06 525516  DELL: PREC360N-3200       FL/CD     06-APR-06 COMPLETED      PER EVENT          3    0    3
62351  04-APR-06 526591  HP: C4267A                FL/PD     12-APR-06 COMPLETED      TRADITIONAL/BAS    8    0    8
62353  04-APR-06 526637  SAMSUNG: 191N             FL/PD     07-APR-06 COMPLETED      PER EVENT          3    0    3
62355  04-APR-06 526955  DELL: GX240-2000-MT       FL/CD/CSS 05-APR-06 COMPLETED      PER EVENT          1    0    1
62357  04-APR-06 527055  ASA: D-X-3200-2U-RM       FL/CD/REX 05-APR-06 COMPLETED      NORMAL             1    0    1
62373  05-APR-06 529357  DELL: PREC330             FL/FE     10-APR-06 COMPLETED      PER EVENT          5    0    5
62374  05-APR-06 529378  DELL: OPTIPLEX SX270      FL/ES     13-APR-06 COMPLETED      PER EVENT          8    1    7
62386  07-APR-06 534057  HP: C4267A                FL/LS     10-APR-06 COMPLETED      PER EVENT          3    0    3
62387  10-APR-06 536096  ASA: SRV-D-P3-1400-4U-RM  FL/CD     12-APR-06 COMPLETED      PER EVENT          2    0    2
62389  10-APR-06 536340  HP: Q2434A                FL/CD     12-APR-06 COMPLETED      PER EVENT          2    0    2
62390  10-APR-06 536386  HP: C3167A                FL/PD     10-APR-06 COMPLETED      PER EVENT          0    0    0
62393  11-APR-06 538121  XEROX: 8400/N             FL/PD/CDF 12-APR-06 COMPLETED      PER EVENT          1    0    1
62394  11-APR-06 538264  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    11-APR-06 COMPLETED      NORMAL             0    0    0
62395  11-APR-06 538446  DELL OPTIPLEX GX270       FL/PD     13-APR-06 COMPLETED      PER EVENT          2    0    2
62397  11-APR-06 538770  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    12-APR-06 COMPLETED      NORMAL             1    0    1
62398  11-APR-06 539063  DELL: LAT-X200-933        FL/CD     13-APR-06 COMPLETED      PER EVENT          2    0    2
62405  12-APR-06 540253  DELL: INSP-8100           FL/PD     17-APR-06 COMPLETED      PER EVENT          5    0    5
62408  12-APR-06 540683  DELL OPTIPLEX GX270       FL/PD     14-APR-06 COMPLETED      PER EVENT          2    0    2
62409  12-APR-06 540819  HP: C4267A                FL/CD/CSS 12-APR-06 COMPLETED      PER EVENT          0    0    0
62412  12-APR-06 541390  TOSH: LAPTOP              FL/PD     13-APR-06 COMPLETED      PER EVENT          1    0    1
62415  13-APR-06 542809  TEK: Z840/DX              FL/CD/CDO 14-APR-06 COMPLETED      PER EVENT          1    0    1
62419  13-APR-06 543711  DELL OPTIPLEX GX240       FL/DI     19-APR-06 COMPLETED      PER EVENT          6    2    4
62421  13-APR-06 543779  INFORTREND: ESA16F-G1A2   FL/CD     19-APR-06 COMPLETED      PER EVENT          6    0    6
62422  13-APR-06 543824  INFORTREND: ESA16F-G1A2   FL/CD     24-APR-06 COMPLETED      PER EVENT         11    0   11
62424  13-APR-06 543861  DELL: PREC360N-3200       FL/CD/CDO 19-APR-06 COMPLETED      PER EVENT          6    0    6
62439  14-APR-06 547003  INFORTREND: ESA16F-G1A2   FL/CD/CMS 24-APR-06 COMPLETED      PER EVENT          7    0    7
62443  17-APR-06 547316  DELL: DIM-4100-1000       FL/LS/TD  17-APR-06 COMPLETED      PER EVENT          0    0    0
62444  17-APR-06 547486  SYSTEMAX: P4-2930-MT      EXP/D0    19-APR-06 COMPLETED      PER EVENT          2    0    2
62455  18-APR-06 549224  DELL: LATITUDE-D810       FL/FE     20-APR-06 COMPLETED      PER EVENT          2    0    2
62460  18-APR-06 550417  HP: C4267A                FL/PD     20-APR-06 COMPLETED      TRADITIONAL/BAS    2    0    2
62462  18-APR-06 550533  XEROX: 860/N              FL/PD/EP/ 24-APR-06 COMPLETED      PER EVENT          6    5    1
62463  18-APR-06 550638  XEROX: 8200/N             EXP/D0    18-APR-06 COMPLETED      TRADITIONAL/BAS    0    0    0
62465  18-APR-06 550759  XEROX: 8400/N             FL/PD     20-APR-06 COMPLETED      PER EVENT          2    0    2
62468  18-APR-06 550906  ASA: D-X-3060-1U-RM       FL/CD     08-MAY-06 COMPLETED      NORMAL            20    0   20
62469  18-APR-06 550886  ASA: D-X-3060-1U-RM       FL/CD     08-MAY-06 COMPLETED      PER EVENT         20    0   20
62471  18-APR-06 550959  HP: C3167A                FL/AD     19-APR-06 COMPLETED      PER EVENT          1    0    1
62472  19-APR-06 551560  HP: C4267A                FL/PD     20-APR-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62477  19-APR-06 552310  HP: C3167A                FL/PD     19-APR-06 COMPLETED      PER EVENT          0    0    0
62479  19-APR-06 553553  ASA: D-X-3000-24*250G(6TB FL/CD     20-APR-06 COMPLETED      NORMAL             0    0    0
62480  20-APR-06 554253  DELL: 2001FP              FL/CD/CCF 26-APR-06 COMPLETED      PER EVENT          6    0    6
62485  20-APR-06 556061  APPLE POWERBOOK G4        FL/PD     25-APR-06 COMPLETED      PER EVENT          4    0    4
62487  21-APR-06 556732  DELL: PE2650-DX-2800      FL/CD/CEP 02-MAY-06 COMPLETED      PER EVENT         11    0   11
62488  21-APR-06 556767  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    24-APR-06 COMPLETED      NORMAL             3    0    3
62492  24-APR-06 558166  DELL: PE2650-DX-2400      FL/CD     27-APR-06 COMPLETED      PER EVENT          3    0    3
62493  24-APR-06 558422  HP: C4267A                EXP/CDF   24-APR-06 COMPLETED      PER EVENT          0    0    0
62496  24-APR-06 558652  CONCENT: 2*X-2800-5TB-5U  FL/CD/EAG 17-MAY-06 COMPLETED      PER EVENT         23    0   23
62501  24-APR-06 558942  HP: C4267A                EXP/D0    24-APR-06 COMPLETED      TRADITIONAL/BAS    0    0    0
62502  24-APR-06 558954  HP: C3167A                FL/AD     28-APR-06 COMPLETED      PER EVENT          4    0    4
62505  24-APR-06 559295  ASA: D-X-3060-8TB-5U      FL/CD     25-APR-06 COMPLETED      NORMAL             1    0    1
62506  24-APR-06 559604  ASA: D-X-3060-2U-RM       FL/CD/CMS 28-APR-06 COMPLETED      NORMAL             4    0    4
62508  24-APR-06 559703  DELL: LATITUDE-C640       FL/AD     28-APR-06 COMPLETED      PER EVENT          4    3    1
62512  24-APR-06 561066  ASA: D-X-3060-8TB-5U      FL/CD     25-APR-06 COMPLETED      NORMAL             0    0    0
62513  25-APR-06 561246  HP: C4267A                EXP/CDF   25-APR-06 COMPLETED      PER EVENT          0    0    0
62514  25-APR-06 561367  ASA: D-X-3060-1U-RM       FL/CD     25-APR-06 COMPLETED      NORMAL             0    0    0
62517  25-APR-06 561676  HP: C4216A                FL/CD     25-APR-06 COMPLETED      PER EVENT          0    0    0
62519  25-APR-06 562072  TEK: Z850/DX              FL/CD     25-APR-06 COMPLETED      PER EVENT          0    0    0
62520  25-APR-06 562088  DELL: PE2650-DX-2400      FL/CD     28-APR-06 COMPLETED      PER EVENT          3    0    3
62522  25-APR-06 563073  INFORTREND: ESA16F-G1A2   FL/CD/CMS 01-MAY-06 COMPLETED      PER EVENT          5    0    5
62523  25-APR-06 563136  INFORTREND: ESA16F-G1A2   FL/CD/CMS 01-MAY-06 COMPLETED      PER EVENT          5    0    5
62529  26-APR-06 563797  DELL: LATITUDE-D800       UNIV/FRS  28-APR-06 COMPLETED      PER EVENT          2    0    2
62530  26-APR-06 563965  SUN MS: 595-5544-01       FL/CD/CEP 27-APR-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62535  27-APR-06 565953  XEROX: 8200/N             EXP/D0    27-APR-06 COMPLETED      NORMAL             0    0    0
62536  27-APR-06 566015  SUN MS: 380-0692-04       FL/CD/CCF 27-APR-06 COMPLETED      TRADITIONAL/PRI    0    0    0
62539  27-APR-06 566045  SUN MS: 380-0692-04       FL/CD/CCF 27-APR-06 COMPLETED      TRADITIONAL/PRI    0    0    0
62541  27-APR-06 566595  SUN MS: SUNBLADE 1500     FL/AD     27-APR-06 COMPLETED      PER EVENT          0    0    0
62542  27-APR-06 566905  XEROX: 6200DP             FL/ES     01-MAY-06 COMPLETED      TRADITIONAL/BAS    4    0    4
62549  01-MAY-06 570966  ASA: D-X-3060-8TB-5U      FL/CD     01-MAY-06 COMPLETED      NORMAL             0    0    0

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
62551  01-MAY-06 571622  DELL: PREC450             FL/PD     05-MAY-06 COMPLETED      PER EVENT          4    0    4
62555  01-MAY-06 571958  SUN MS: ENT450            FL/AD     02-MAY-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62561  02-MAY-06 572965  INFORTREND: ESA16F-G1A2   FL/CD     05-MAY-06 COMPLETED      PER EVENT          3    0    3
62562  02-MAY-06 573194  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    02-MAY-06 COMPLETED      NORMAL             0    0    0
62563  02-MAY-06 573379  INFORTREND: ESA16F-G1A2   FL/CD/CMS 05-MAY-06 COMPLETED      PER EVENT          3    0    3
62565  02-MAY-06 573743  ASA: D-X-3060-2U-RM       FL/CD/CMS 23-MAY-06 COMPLETED      PER EVENT         21    0   21
62567  02-MAY-06 573902  DELL: LATITUDE-D600       FL/CD     05-MAY-06 COMPLETED      PER EVENT          3    0    3
62571  02-MAY-06 574100  DELL: GX280-3400          FL/PD     05-MAY-06 COMPLETED      PER EVENT          3    0    3
62574  02-MAY-06 574615  POLYWELL: 2*X-3.06G-4U-RM FL/CD     10-MAY-06 COMPLETED      PER EVENT          7    0    7
62576  03-MAY-06 574736  APPLE POWERMAC G5         FL/PD     10-MAY-06 COMPLETED      PER EVENT          7    2    5
62585  02-MAY-06 574962  POLYWELL: PLY-935X8       EXP/E898/ 10-MAY-06 COMPLETED      PER EVENT          7    0    7
62590  03-MAY-06 575234  SUN MS: ENT420R           FL/CD/CEP 05-MAY-06 COMPLETED      TRADITIONAL/PRI    2    0    2
62593  03-MAY-06 575512  HP: C2009A                FL/CD     03-MAY-06 COMPLETED      PER EVENT          0    0    0
62601  03-MAY-06 576014  DELL OPTIPLEX GX270       FL/PD     08-MAY-06 COMPLETED      PER EVENT          5    0    5
62610  04-MAY-06 577094  DELL OPTIPLEX GX400       EXP/CDF   10-MAY-06 COMPLETED      PER EVENT          6    0    6
62617  05-MAY-06 578823  HP: C4216A                FL/AD     08-MAY-06 COMPLETED      PER EVENT          3    0    3
62618  05-MAY-06 578798  APPLE POWERBOOK G4        INFN, PIS 09-MAY-06 COMPLETED      PER EVENT          4    0    4
62619  05-MAY-06 579012  DELL: LATITUDE-LS         FL/PD     08-MAY-06 COMPLETED      PER EVENT          3    2    1
62620  05-MAY-06 579035  DELL: LATITUDE-C640       FL/AD     10-MAY-06 COMPLETED      PER EVENT          5    0    5
62621  05-MAY-06 579791  INFORTREND: ESA16F-G1A2   FL/CD/CMS 11-MAY-06 COMPLETED      PER EVENT          6    0    6
62622  08-MAY-06 581129  ACECOMP: P4-2000-MT       FL/AD     12-MAY-06 COMPLETED      PER EVENT          4    0    4
62623  07-MAY-06 581181  DELL: LAT-X300-1200       FL/CD/CCF 10-MAY-06 COMPLETED      PER EVENT          2    0    2
62635  08-MAY-06 581974  ASA: D-X-3060-24*250G(6TB FL/CD     08-MAY-06 COMPLETED      PER EVENT          0    0    0
62636  08-MAY-06 582023  ASA: D-X-3000-24*250G(6TB FL/CD     08-MAY-06 COMPLETED      NORMAL             0    0    0
62638  08-MAY-06 582561  ASA: D-X-3060-1U-RM       FL/PD     16-MAY-06 COMPLETED      PER EVENT          8    0    8
62643  08-MAY-06 583993  DELL: LAT-D610-2000       FL/CD/CDO 12-MAY-06 COMPLETED      PER EVENT          3    0    3
62645  09-MAY-06 584143  ASA: D-X-3060-8TB-5U      FL/CD     09-MAY-06 COMPLETED      NORMAL             0    0    0
62647  09-MAY-06 584356  ASA CPU BOX               EXP/CDF   23-MAY-06 COMPLETED      PER EVENT         14    6    8
62648  09-MAY-06 584931  HP: C3167A                FL/CD     11-MAY-06 COMPLETED      PER EVENT          2    0    2
62653  10-MAY-06 586029  DELL: PE2650-DX-2800      FL/PD     12-MAY-06 COMPLETED      PER EVENT          2    0    2
62662  10-MAY-06 587097  ATIPA: D-ATHL-MP2000-2U-R UNIV      12-MAY-06 COMPLETED      PER EVENT          2    0    2
62664  10-MAY-06 587233  DELL: DIM-4100-1000       UNIV      19-MAY-06 COMPLETED      PER EVENT          9    7    2
62678  11-MAY-06 588940  DELL PRECISION WORKSTATIO UNIV/COL  19-MAY-06 COMPLETED      PER EVENT          8    0    8
62680  11-MAY-06 589201  XEROX: 6250/DP            FL/PD     17-MAY-06 COMPLETED      PER EVENT          6    0    6
62683  11-MAY-06 589603  DELL: PREC670             FL/TD     22-MAY-06 COMPLETED      PER EVENT         11    3    8
62684  11-MAY-06 589694  INFORTREND: ESA16F-G1A2   FL/CD/CMS 23-MAY-06 COMPLETED      PER EVENT         12    0   12
62685  11-MAY-06 589741  SUN MS: ENT450            FL/AD     15-MAY-06 COMPLETED      TRADITIONAL/BAS    4    0    4
62691  12-MAY-06 591160  ATIPA: D-P3-1000-2U-RM    FL/CD     15-MAY-06 COMPLETED      PER EVENT          3    2    1
62692  12-MAY-06 591495  POLYWELL: PLY-935X8       EXP/E898/ 18-MAY-06 COMPLETED      PER EVENT          6    0    6
62696  15-MAY-06 593328  HP: C4267A                FL/PD     18-MAY-06 COMPLETED      TRADITIONAL/BAS    3    0    3
62699  15-MAY-06 594069  ASA: D-X-3200-2U-RM       FL/CD/REX 23-MAY-06 COMPLETED      NORMAL             8    0    8
62700  15-MAY-06 594192  DELL PRECISION WORKSTATIO FL/TD     17-MAY-06 COMPLETED      PER EVENT          2    0    2
62704  15-MAY-06 596075  INFORTREND: ESA16F-G1A2   FL/CD/CMS 19-MAY-06 COMPLETED      PER EVENT          3    0    3
62705  16-MAY-06 596574  HP: C3167A                FL/CD     16-MAY-06 COMPLETED      PER EVENT          0    0    0
62707  16-MAY-06 596790  INFORTREND: ESA16F-G1A2   FL/CD/CMS 19-MAY-06 COMPLETED      PER EVENT          3    0    3
62708  16-MAY-06 596827  INFORTREND: ESA16F-G1A2   FL/CD/CMS 23-MAY-06 COMPLETED      PER EVENT          7    3    4
62710  16-MAY-06 596984  DELL: INSP-600M-1400      FL/CD/CEP 18-MAY-06 COMPLETED      PER EVENT          2    0    2
62711  16-MAY-06 597183  HP: C3142A                FL/AD     18-MAY-06 COMPLETED      PER EVENT          2    0    2
62715  17-MAY-06 598217  HP: F2087-KT              EXP/E881/ 01-JUN-06 COMPLETED      PER EVENT         15    7    8
62717  17-MAY-06 598553  HP: Q5409A#ABA            FL/PD     24-MAY-06 COMPLETED      PER EVENT          7    0    7
62719  17-MAY-06 599161  HP: C4267A                FL/PD     19-MAY-06 COMPLETED      TRADITIONAL/BAS    2    0    2
62720  17-MAY-06 599366  HP: C4267A                EXP/D0    18-MAY-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62730  18-MAY-06 602116  ASA: D-X-2400-16*200G(3.2 FL/CD     19-MAY-06 COMPLETED      PER EVENT          1    0    1
62731  18-MAY-06 602612  ASA: D-X-3000-24*250G(6TB FL/CD     19-MAY-06 COMPLETED      NORMAL             0    0    0
62740  19-MAY-06 603606  DELL: PREC330             FL/FE     23-MAY-06 COMPLETED      PER EVENT          4    0    4
62742  19-MAY-06 603697  XEROX PHASER PRINTER      FL/PD     24-MAY-06 COMPLETED      PER EVENT          5    2    3
62743  19-MAY-06 603766  ACECOMP: 2*X-2400-1U-RM   FL/CD/CSS 22-MAY-06 COMPLETED      PER EVENT          3    0    3
62745  22-MAY-06 605479  SUN MS: ENT450            FL/AD     24-MAY-06 COMPLETED      TRADITIONAL/BAS    2    0    2
62747  19-MAY-06 605800  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 25-MAY-06 COMPLETED      NORMAL             3    0    3
62750  22-MAY-06 606675  ACECOMP: 2280DXR2IF       FL/CD/CMS 06-JUN-06 COMPLETED      PER EVENT         15    5   10
62751  22-MAY-06 606727  SUN MS: 602-1676-01       EXP/CDF   23-MAY-06 COMPLETED      TRADITIONAL/PRE    1    0    1
62752  22-MAY-06 606738  ASA: D-X-3060-8TB-5U      FL/CD     30-MAY-06 COMPLETED      NORMAL             8    0    8
62753  22-MAY-06 606759  ASA: D-X-3060-8TB-5U      FL/CD     30-MAY-06 COMPLETED      NORMAL             8    0    8
62754  23-MAY-06 609045  SUN MS: 602-1676-01       EXP/CDF   23-MAY-06 COMPLETED      TRADITIONAL/PRE    0    0    0
62755  22-MAY-06 609198  POLYWELL: SRV-D-P3-1400-4 FL/CD     24-MAY-06 COMPLETED      PER EVENT          1    0    1
62756  23-MAY-06 609447  DELL OPTIPLEX GX270       FL/PD     25-MAY-06 COMPLETED      PER EVENT          2    0    2
62768  24-MAY-06 612003  DELL: 5100CN              FL/DI     24-MAY-06 COMPLETED      PER EVENT          0    0    0

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
62775  25-MAY-06 614429  XEROX: 8200/N             EXP/D0    26-MAY-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62778  26-MAY-06 615267  DELL: PREC670             FL/CD     30-MAY-06 COMPLETED      PER EVENT          4    0    4
62779  26-MAY-06 615653  DELL: 1901FP              FL/CD     02-JUN-06 COMPLETED      PER EVENT          7    0    7
62780  26-MAY-06 615840  DELL: PREC360N            FL/FE     30-MAY-06 COMPLETED      PER EVENT          4    0    4
62784  29-MAY-06 618485  DELL: DIM-3000-3000       EXP/CDF   31-MAY-06 COMPLETED      PER EVENT          1    0    1
62791  30-MAY-06 619193  ASA: D-X-3060-8TB-5U      FL/CD     08-JUN-06 COMPLETED      NORMAL             9    0    9
62792  30-MAY-06 619208  ASA: D-X-3060-8TB-5U      FL/CD     08-JUN-06 COMPLETED      NORMAL             9    0    9
62794  30-MAY-06 619449  POLYWELL: 2*X-3.06G-4U-RM FL/CD     31-MAY-06 COMPLETED      PER EVENT          1    0    1
62795  30-MAY-06 619486  POLYWELL: SRV-D-P3-1400-4 FL/CD     05-JUN-06 COMPLETED      PER EVENT          6    0    6
62796  30-MAY-06 621459  ASA: D-X-3200-2U-RM       FL/CD/REX 31-MAY-06 COMPLETED      NORMAL             0    0    0
62801  31-MAY-06 622157  APPLE: A1138              FL/CD/EAG 07-JUN-06 COMPLETED      PER EVENT          7    4    3
62806  31-MAY-06 624311  APPLE POWERMAC            FL/CD     26-JUN-06 COMPLETED      PER EVENT         25    0   25
62807  01-JUN-06 624360  DELL: PREC340             FL/FE     02-JUN-06 COMPLETED      PER EVENT          1    0    1
62808  01-JUN-06 624387  HP: C4111A                FL/PD     06-JUN-06 COMPLETED      PER EVENT          5    0    5
62809  01-JUN-06 624742  APPLE: A1046              FL/CD/CCF 28-JUN-06 COMPLETED      PER EVENT         27    0   27
62814  01-JUN-06 626873  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62815  01-JUN-06 626890  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62816  01-JUN-06 626961  HP: C7063A                FL/ES     02-JUN-06 COMPLETED      PER EVENT          0    0    0
62817  01-JUN-06 626905  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62818  01-JUN-06 626920  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62819  01-JUN-06 626931  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62820  01-JUN-06 626943  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62821  01-JUN-06 626959  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62822  01-JUN-06 626983  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62823  01-JUN-06 626989  ASA: D-X-2800-RM-1U       EXP/D0    05-JUN-06 COMPLETED      NORMAL             3    0    3
62825  02-JUN-06 627124  DELL OPTIPLEX GX270       FL/PD     06-JUN-06 COMPLETED      PER EVENT          4    0    4
62828  02-JUN-06 627407  DELL: INSP-9300           FL/CD     07-JUN-06 COMPLETED      PER EVENT          5    0    5
62834  02-JUN-06 627587  TOSH: LAPTOP              FL/PD     06-JUN-06 COMPLETED      PER EVENT          4    1    3
62836  02-JUN-06 627691  DELL: LATITUDE-D810       FL/CD/CDO 06-JUN-06 COMPLETED      PER EVENT          4    0    4
62835  02-JUN-06 627665  ASA: D-X-3060-8TB-5U      EXP/D0    21-JUN-06 COMPLETED      NORMAL            19    0   19
62837  02-JUN-06 627686  ASA: D-X-3060-8TB-5U      EXP/D0    08-JUN-06 COMPLETED      NORMAL             6    0    6
62838  02-JUN-06 627979  ASA: D-X-3060-1U-RM       FL/CD     20-JUN-06 COMPLETED      NORMAL            18    0   18
62842  05-JUN-06 630066  HP LASERJET               FL/PD     07-JUN-06 COMPLETED      PER EVENT          2    0    2
62856  05-JUN-06 631698  ACECOMP: 2280DXR2IF       FL/CD/CMS 12-JUN-06 COMPLETED      PER EVENT          6    0    6
62859  06-JUN-06 632577  HP: C3167A                FL/AD     16-JUN-06 COMPLETED      PER EVENT         10    0   10
62860  06-JUN-06 632722  DELL: PE2850-DX-3000      FL/CD/CSS 09-JUN-06 COMPLETED      PER EVENT          3    0    3
62861  06-JUN-06 633751  HP: C4087A                EXP/CDF   07-JUN-06 COMPLETED      PER EVENT          0    0    0
62862  06-JUN-06 633774  ACECOMP: 2280DXR2IF       FL/CD/CMS 22-JUN-06 COMPLETED      PER EVENT         15    0   15
62863  06-JUN-06 633769  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    07-JUN-06 COMPLETED      NORMAL             0    0    0
62865  07-JUN-06 634067  SUN MS: 602-2426-02       FL/CD/CSS 07-JUN-06 COMPLETED      TRADITIONAL/PRE    0    0    0
62867  07-JUN-06 634369  DELL: LAT-C600-1000       FL/DI     09-JUN-06 COMPLETED      PER EVENT          2    0    2
62868  07-JUN-06 634434  DELL: 3100CN              FL/DI     15-JUN-06 COMPLETED      PER EVENT          8    0    8
62869  07-JUN-06 634744  HP: C4267A                FL/PD     08-JUN-06 COMPLETED      TRADITIONAL/BAS    1    0    1
62870  07-JUN-06 634996  DELL: LAT-D600-1400       FL/CD     09-JUN-06 COMPLETED      PER EVENT          2    0    2
62874  08-JUN-06 636745  SUN MS: 602-2360-03       FL/CD/CSS 12-JUN-06 COMPLETED      PER EVENT          4    0    4
62876  08-JUN-06 636815  ATIPA: TSDS2-2U1.26GX2    FL/CD     13-JUN-06 COMPLETED      PER EVENT          5    0    5
62878  08-JUN-06 637153  ASA: SRV-D-P3-1400-4U-RM  EXP/CDF   09-JUN-06 COMPLETED      PER EVENT          1    0    1
62879  08-JUN-06 637462  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    09-JUN-06 COMPLETED      NORMAL             1    0    1
62880  08-JUN-06 637703  ACMEMICRO: 2*X-2.66G-1URM FL/CD     20-JUN-06 COMPLETED      PER EVENT         12    6    6
62881  08-JUN-06 637723  ASA: D-X-3060-8TB-5U      FL/CD     14-JUN-06 COMPLETED      NORMAL             6    0    6
62886  09-JUN-06 639255  ASA: D-X-3060-8TB-5U      FL/CD     21-JUN-06 COMPLETED      NORMAL            12    0   12
62888  09-JUN-06 641436  TEK: Z850                 FL/CD     13-JUN-06 COMPLETED      PER EVENT          4    3    1
62891  09-JUN-06 641206  INFORTREND: ESA16F-G1A2   FL/CD/CMS 22-JUN-06 COMPLETED      PER EVENT         10    0   10
62892  09-JUN-06 641254  INFORTREND: ESA16F-G1A2   FL/CD/CMS 15-JUN-06 COMPLETED      PER EVENT          3    0    3
62893  12-JUN-06 641374  DELL OPTIPLEX GX270       FL/PD     14-JUN-06 COMPLETED      PER EVENT          2    0    2
62896  12-JUN-06 641999  HP: C4087A                EXP/CDF   20-JUN-06 COMPLETED      PER EVENT          8    0    8
62915  14-JUN-06 646481  ASA: D-X-3060-8TB-5U      FL/CD     23-JUN-06 COMPLETED      NORMAL             9    0    9
62917  14-JUN-06 646532  ASA: D-X-3060-8TB-5U      FL/CD     23-JUN-06 COMPLETED      NORMAL             9    0    9
62920  14-JUN-06 646587  ASA: D-X-3060-8TB-5U      FL/CD     23-JUN-06 COMPLETED      NORMAL             9    0    9
62925  15-JUN-06 647661  DELL: PREC470             FL/LS     19-JUN-06 COMPLETED      PER EVENT          4    2    2
62929  15-JUN-06 648390  DELL: DIM-4600-3060       FL/CD/CSS 26-JUN-06 COMPLETED      PER EVENT         11    0   11
62933  15-JUN-06 648582  DELL: LAT-D600-1400       FL/CD     23-JUN-06 COMPLETED      PER EVENT          8    5    3
62938  15-JUN-06 649171  DELL: LATITUDE-D600       FL/CD/CDO 20-JUN-06 COMPLETED      PER EVENT          4    0    4
62947  16-JUN-06 649719  DELL: PREC370N-3200       FL/CD     19-JUN-06 COMPLETED      PER EVENT          3    0    3
62944  16-JUN-06 649849  APPLE: IMAC G5            FL/PD     28-JUN-06 COMPLETED      PER EVENT         12    0   12
62949  16-JUN-06 649924  HP: C4267A                FL/PD     20-JUN-06 COMPLETED      TRADITIONAL/BAS    4    0    4
62952  16-JUN-06 651710  DELL: LAT-D610-1600       FL/CD     21-JUN-06 COMPLETED      PER EVENT          2    0    2

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
62958  19-JUN-06 652320  HP LASERJET               FL/PD     19-JUN-06 COMPLETED      PER EVENT          0    0    0
62966  19-JUN-06 654268  INFORTREND: ESA16F-G1A2   FL/CD/CMS 11-JUL-06 COMPLETED      PER EVENT         21   18    3
62975  20-JUN-06 655007  DELL: LAT-D600-1400       FL/CD     23-JUN-06 COMPLETED      PER EVENT          3    0    3
62980  21-JUN-06 656680  DELL: DIM-4700            FL/ES     23-JUN-06 COMPLETED      PER EVENT          2    0    2
62981  21-JUN-06 656917  HP: C4089A                FL/PD     22-JUN-06 COMPLETED      PER EVENT          1    0    1
62982  21-JUN-06 656984  DELL: LATITUDE-D800       FL/FE     23-JUN-06 COMPLETED      PER EVENT          2    0    2
62984  21-JUN-06 657137  DELL OPTIPLEX GX280       FL/CD     27-JUN-06 COMPLETED      PER EVENT          6    0    6
62986  22-JUN-06 658585  INFORTREND: ESA16F-G1A2   FL/CD     10-JUL-06 COMPLETED      PER EVENT         18   15    3
62987  22-JUN-06 658607  DELL: INSP-9100-2800      FL/CD/CCF 26-JUN-06 COMPLETED      PER EVENT          4    0    4
62994  22-JUN-06 660045  DELL: PE2650-DX-2400      FL/CD     27-JUN-06 COMPLETED      PER EVENT          4    0    4
62995  22-JUN-06 660370  HP: C8521A                FL/PD     28-JUN-06 COMPLETED      PER EVENT          5    0    5
62996  22-JUN-06 660496  SYSTEMAX: SOLIS-ST14      FL/PD     26-JUN-06 COMPLETED      PER EVENT          3    0    3
62997  23-JUN-06 660516  INFORTREND: ESA16F-G1A2   FL/CD/CMS 28-JUN-06 COMPLETED      PER EVENT          5    0    5
63000  26-JUN-06 663282  HP: C4267A                FL/LS     29-JUN-06 COMPLETED      PER EVENT          3    0    3
63001  26-JUN-06 663898  ASA: D-X-3000-24*250G(6TB EXP/CDF   27-JUN-06 COMPLETED      NORMAL             1    0    1
63007  27-JUN-06 666292  XEROX: 8500/DN            FL/PD     19-JUL-06 COMPLETED      PER EVENT         22   15    7
63017  28-JUN-06 669240  HP: C3167A                FL/ES     30-JUN-06 COMPLETED      PER EVENT          2    0    2
63018  28-JUN-06 669259  ASA: D-X-3000-24*250G(6TB FL/CD     28-JUN-06 COMPLETED      NORMAL             0    0    0
63019  28-JUN-06 669289  ASA: D-X-3000-24*250G(6TB FL/CD     28-JUN-06 COMPLETED      NORMAL             0    0    0
63020  28-JUN-06 669617  DELL OPTIPLEX GX270       INFN, PIS 05-JUL-06 COMPLETED      PER EVENT          7    0    7
63026  29-JUN-06 671102  ASA: D-X-3000-24*250G(6TB FL/CD     06-JUL-06 COMPLETED      NORMAL             7    1    6
63028  29-JUN-06 671256  DELL: LATITUDE-D600       FL/CD/CDO 10-JUL-06 COMPLETED      PER EVENT         11    4    7
63029  29-JUN-06 671304  TEK: Z850/DP              FL/CD/CMS 30-JUN-06 COMPLETED      PER EVENT          1    0    1
63035  30-JUN-06 673015  HP: Q1860A                FL/LS     05-JUL-06 COMPLETED      PER EVENT          5    2    3
63036  30-JUN-06 673144  ACECOMP: P4-2600-MT       FL/CD     25-JUL-06 COMPLETED      PER EVENT         25   17    8
63040  03-JUL-06 674874  ASA: D-X-3000-24*250G(6TB FL/CD     03-JUL-06 COMPLETED      NORMAL             0    0    0
63042  03-JUL-06 674904  SUN MS: ENT450            EXP/CDF   05-JUL-06 COMPLETED      TRADITIONAL/BAS    2    0    2
63052  05-JUL-06 677112  ACECOMP: ATHLON-1800+-MT  FL/CD     14-JUL-06 COMPLETED      PER EVENT          9    5    4
63055  06-JUL-06 678746  DELL: PREC380N-3000       FL/PD     10-JUL-06 COMPLETED      PER EVENT          4    0    4
63060  06-JUL-06 679212  ASA: D-X-3000-24*250G(6TB FL/CD     06-JUL-06 COMPLETED      NORMAL             0    0    0
63061  06-JUL-06 679248  DELL: PREC670             FL/TD     07-JUL-06 COMPLETED      PER EVENT          1    0    1
63064  06-JUL-06 679407  HP: C4267A                FL/PD     07-JUL-06 COMPLETED      TRADITIONAL/BAS    1    0    1
63072  07-JUL-06 681127  ASA: D-X-3000-24*250G(6TB FL/CD     07-JUL-06 COMPLETED      NORMAL             0    0    0
63073  07-JUL-06 681182  INFORTREND: ESA16F-G1A2   FL/CD/CMS 14-JUL-06 COMPLETED      PER EVENT          7    0    7
63080  10-JUL-06 683807  ASA: D-X-3060-8TB-5U      FL/CD     10-JUL-06 COMPLETED      NORMAL             0    0    0
63081  10-JUL-06 684367  PC-CLONE: P4-1500-MT      FL/CD     13-JUL-06 COMPLETED      PER EVENT          3    3    0
63083  11-JUL-06 687578  ASA: D-X-3060-1U-RM       FL/CD     11-JUL-06 COMPLETED      PER EVENT          0    0    0
63088  12-JUL-06 689570  HP: C4267A                EXP/D0    14-JUL-06 COMPLETED      TRADITIONAL/BAS    2    0    2
63090  12-JUL-06 689870  DELL: PREC670             FL/TD     17-JUL-06 COMPLETED      PER EVENT          5    3    2
63092  12-JUL-06 690328  INFORTREND: ESA16F-G1A2   FL/CD     14-JUL-06 COMPLETED      PER EVENT          2    0    2
63098  13-JUL-06 691832  DELL: LATITUDE-D600       FL/PD     18-JUL-06 COMPLETED      PER EVENT          5    3    2
63099  13-JUL-06 691865  DELL: LATITUDE-D810       FL/FE     13-JUL-06 COMPLETED      PER EVENT          0    0    0
63102  13-JUL-06 692520  DELL: LAT-C800-1000       FL/PD     18-JUL-06 COMPLETED      PER EVENT          5    0    5
63104  13-JUL-06 692614  DELL: LATITUDE-D610       FL/PD     19-JUL-06 COMPLETED      PER EVENT          6    1    5
63108  13-JUL-06 693343  DELL: PREC610             UNIV/JNH  18-JUL-06 COMPLETED      PER EVENT          4    0    4
63109  14-JUL-06 693547  ATIPA: D-ATHL-MP2000-1U-R UNIV/PAD  24-JUL-06 COMPLETED      PER EVENT         10    6    4
63110  14-JUL-06 694241  HP: C4086A                FL/PD     17-JUL-06 COMPLETED      PER EVENT          3    0    3
63112  14-JUL-06 694541  DELL: LATITUDE-C600       FL/PD     19-JUL-06 COMPLETED      PER EVENT          5    0    5
63120  17-JUL-06 696389  HP: NX9008                FL/PD     18-JUL-06 COMPLETED      PER EVENT          1    0    1
63121  17-JUL-06 696474  ASA: D-X-3000-24*250G(6TB FL/CD     17-JUL-06 COMPLETED      NORMAL             0    0    0
63123  14-JUL-06 696579  APPLE POWERBOOK G4        FL/CD     25-JUL-06 COMPLETED      PER EVENT          8    5    3
63125  17-JUL-06 696951  APPLE POWERBOOK G4        FL/PD     18-JUL-06 COMPLETED      PER EVENT          1    0    1
63126  17-JUL-06 697260  APPLE: IMAC G5            FL/PD     25-JUL-06 COMPLETED      PER EVENT          8    5    3
63127  17-JUL-06 697316  DELL OPTIPLEX GX280       FL/PD     18-JUL-06 COMPLETED      PER EVENT          1    0    1
63128  17-JUL-06 697439  DELL: OPTI GX240-1500     FL/AD     21-JUL-06 COMPLETED      PER EVENT          4    0    4
63132  17-JUL-06 697509  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 18-JUL-06 COMPLETED      NORMAL             1    0    1
63133  17-JUL-06 697535  DELL: LATITUDE-D500       FL/PD     20-JUL-06 COMPLETED      PER EVENT          3    0    3
63137  18-JUL-06 698625  XEROX PHASER PRINTER      FL/PD     19-JUL-06 COMPLETED      PER EVENT          1    0    1
63138  18-JUL-06 698864  DELL: LAT-X300-1200       FL/CD/CMS 27-JUL-06 COMPLETED      PER EVENT          9    2    7
63139  18-JUL-06 698883  DELL: PREC50              FL/PD     25-JUL-06 COMPLETED      PER EVENT          7    1    6
63144  19-JUL-06 801170  SUN MS: ENT4500           FL/CD/CSS 20-JUL-06 COMPLETED      TRADITIONAL/PRE    1    0    1
63149  19-JUL-06 801740  PC-CLONE                  UNIV/DUK  24-JUL-06 COMPLETED      PER EVENT          5    0    5
63152  20-JUL-06 802923  APPLE POWERBOOK G4        FL/PD     03-AUG-06 COMPLETED      PER EVENT         14    7    7
63154  20-JUL-06 803383  APPLE POWERBOOK G4        FL/CD     20-JUL-06 COMPLETED      PER EVENT          0    0    0
63156  20-JUL-06 803642  XEROX PHASER PRINTER      FL/PD     21-JUL-06 COMPLETED      PER EVENT          1    0    1
63160  20-JUL-06 804486  ASA: D-X-3060-8TB-5U      FL/CD     21-JUL-06 COMPLETED      NORMAL             0    0    0
63161  21-JUL-06 804506  APPLE POWERBOOK G4        FL/PD     25-JUL-06 COMPLETED      PER EVENT          4    0    4

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
63162  21-JUL-06 806987  HP: C2009A                FL/BS     24-JUL-06 COMPLETED      PER EVENT          3    0    3
63163  21-JUL-06 805076  GATEWAY: 700X             FL/PD     21-JUL-06 COMPLETED      NORMAL             0    0    0
63169  24-JUL-06 807398  INFORTREND: ESA16F-G1A2   FL/CD     27-JUL-06 COMPLETED      PER EVENT          3    0    3
63171  24-JUL-06 807519  HP: Q2428A                FL/PD     27-JUL-06 COMPLETED      PER EVENT          3    0    3
63172  24-JUL-06 808019  XEROX: 8200/N             EXP/D0    24-JUL-06 COMPLETED      TRADITIONAL/BAS    0    0    0
63180  25-JUL-06 809916  DELL CPU BOX              EXP/D0    27-JUL-06 COMPLETED      PER EVENT          2    0    2
63181  25-JUL-06 810170  HP: C4267A                FL/PD     25-JUL-06 COMPLETED      PER EVENT          0    0    0
63177  24-JUL-06 810220  DELL PRECISION WORKSTATIO FL/PD     28-JUL-06 COMPLETED      PER EVENT          3    0    3
63182  25-JUL-06 810475  SUN MS: ENT450            FL/AD     26-JUL-06 COMPLETED      PER EVENT          1    0    1
63183  25-JUL-06 810545  DELL: PPX                 FL/CD     26-JUL-06 COMPLETED      PER EVENT          1    0    1
63193  25-JUL-06 810679  DELL: DIM-4700            FL/ES     28-JUL-06 COMPLETED      PER EVENT          3    0    3
63195  25-JUL-06 812366  ASA: D-X-3000-24*250G(6TB EXP/CDF   26-JUL-06 COMPLETED      NORMAL             0    0    0
63200  26-JUL-06 812890  HP: C8521A                FL/PD     27-JUL-06 COMPLETED      PER EVENT          1    0    1
63203  26-JUL-06 813425  ASA: D-X-3000-24*250G(6TB FL/CD     27-JUL-06 COMPLETED      NORMAL             1    0    1
63205  27-JUL-06 814658  HP: C7099A                FL/FE     27-JUL-06 COMPLETED      PER EVENT          0    0    0
63209  27-JUL-06 815376  DELL: PE4400-D-P3X-1000   UNIV/HARV 03-AUG-06 COMPLETED      PER EVENT          7    0    7
63212  27-JUL-06 815577  HP: C3167A                FL/PD     28-JUL-06 COMPLETED      PER EVENT          1    0    1
63214  28-JUL-06 816105  DELL: PE4400-P3X-733      FL/CD     09-AUG-06 COMPLETED      TRADITIONAL/PRE   12   11    1
63222  31-JUL-06 819305  ASA: D-X-3000-24*250G(6TB EXP/CDF   04-AUG-06 COMPLETED      PER EVENT          4    0    4
63223  31-JUL-06 819341  ASA: D-X-3000-24*250G(6TB EXP/CDF   31-JUL-06 COMPLETED      NORMAL             0    0    0
63226  31-JUL-06 819456  SUN MS: 602-2262-01       FL/CD     01-AUG-06 COMPLETED      TRADITIONAL/PRE    1    0    1
63227  31-JUL-06 819472  DELL: LAT-D400-1700       FL/CD     02-AUG-06 COMPLETED      PER EVENT          2    0    2
63231  01-AUG-06 821401  DELL OPTIPLEX GX270       FL/PD     03-AUG-06 COMPLETED      PER EVENT          2    0    2
63234  01-AUG-06 822105  ASA: D-X-3000-24*250G(6TB EXP/CDF   11-AUG-06 COMPLETED      NORMAL            10    0   10
63235  01-AUG-06 822187  ASA: D-X-3000-24*250G(6TB FL/CD     04-AUG-06 COMPLETED      NORMAL             3    0    3
63236  01-AUG-06 822498  HITACHI: CMP4201U         FL/CD     29-AUG-06 COMPLETED      PER EVENT         28    0   28
63242  02-AUG-06 823844  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    02-AUG-06 COMPLETED      NORMAL             0    0    0
63243  02-AUG-06 823877  DELL POWEREDGE 4600       FL/PD     04-AUG-06 COMPLETED      PER EVENT          2    0    2
63254  04-AUG-06 828756  ASA: D-X-3000-24*250G(6TB EXP/CDF   11-AUG-06 COMPLETED      PER EVENT          7    0    7
63256  04-AUG-06 828842  HP: C4267A                FL/LS     10-AUG-06 COMPLETED      PER EVENT          6    0    6
63259  07-AUG-06 833249  ASA: D-X-2000-1.3TB       UNIV/URO  21-AUG-06 COMPLETED      PER EVENT         14    1   13
63260  07-AUG-06 833677  ASA: D-X-3000-24*250G(6TB EXP/CDF   11-AUG-06 COMPLETED      NORMAL             4    0    4
63272  08-AUG-06 835227  INFORTREND: ESA16F-G1A2   FL/CD/CMS 09-AUG-06 COMPLETED      PER EVENT          1    0    1
63276  04-AUG-06 835705  DELL: LAT-X200-933        FL/CD     18-AUG-06 COMPLETED      PER EVENT         10    0   10
63289  09-AUG-06 837579  DELL: LATITUDE-D620       FL/DI     11-AUG-06 COMPLETED      PER EVENT          2    1    1
63297  10-AUG-06 839928  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    11-AUG-06 COMPLETED      NORMAL             1    0    1
63313  11-AUG-06 841611  ASA: D-X-3060-1U-RM       FL/CD     17-AUG-06 COMPLETED      NORMAL             6    0    6
63314  10-AUG-06 841675  HP: C7099A                FL/CD/CSS 11-AUG-06 COMPLETED      PER EVENT          0    0    0
63322  14-AUG-06 844359  PC-CLONE                  EXP/CDF   14-AUG-06 COMPLETED      PER EVENT          0    0    0
63323  14-AUG-06 844654  ASA: D-X-3000-24*250G(6TB EXP/CDF   14-AUG-06 COMPLETED      NORMAL             0    0    0
63325  14-AUG-06 844897  ASA: D-X-3000-24*250G(6TB EXP/CDF   18-AUG-06 COMPLETED      NORMAL             4    0    4
63327  14-AUG-06 844923  ASA: D-X-3000-24*250G(6TB EXP/CDF   15-AUG-06 COMPLETED      NORMAL             1    0    1
63331  14-AUG-06 845190  HP LASERJET               FL/AD     22-AUG-06 COMPLETED      PER EVENT          8    0    8
63335  15-AUG-06 846214  ASA: D-X-3000-24*250G(6TB EXP/CDF   16-AUG-06 COMPLETED      NORMAL             1    0    1
63336  15-AUG-06 846326  ASA: D-X-3060-1U-RM       EXP/D0    15-AUG-06 COMPLETED      NORMAL             0    0    0
63338  15-AUG-06 846886  HP: C4267A                FL/BS     17-AUG-06 COMPLETED      PER EVENT          2    0    2
63340  15-AUG-06 847072  INFORTREND: ESA16F-G1A2   FL/CD/CMS 23-AUG-06 COMPLETED      PER EVENT          8    0    8
63345  16-AUG-06 848356  ASA: D-X-3000-24*250G(6TB EXP/CDF   18-AUG-06 COMPLETED      NORMAL             2    0    2
63346  16-AUG-06 848562  DELL: LAT-X300-1200       FL/CD/CMS 18-AUG-06 COMPLETED      PER EVENT          2    0    2
63347  16-AUG-06 848793  HP: C3142A                FL/AD     17-AUG-06 COMPLETED      PER EVENT          1    0    1
63348  16-AUG-06 848841  HP: C3917A                FL/AD     18-AUG-06 COMPLETED      PER EVENT          2    0    2
63356  16-AUG-06 849839  DELL: LAT-X300-1200       FL/DI     21-AUG-06 COMPLETED      PER EVENT          4    0    4
63358  17-AUG-06 850028  ASA: D-X-3060-8TB-5U      EXP/D0    18-AUG-06 COMPLETED      NORMAL             1    0    1
63361  17-AUG-06 850584  SUN MS: E450-REFURB       FL/AD     18-AUG-06 COMPLETED      TRADITIONAL/BAS    1    0    1
63367  18-AUG-06 852659  INFORTREND: ESA16F-G1A2   FL/CD/CMS 22-AUG-06 COMPLETED      PER EVENT          4    0    4
63377  21-AUG-06 854497  HP: C2011A                FL/CD     25-AUG-06 COMPLETED      PER EVENT          4    0    4
63379  21-AUG-06 854602  HP: Q3723A#ABA            FL/PD     21-AUG-06 COMPLETED      PER EVENT          0    0    0
63380  21-AUG-06 854836  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 06-SEP-06 COMPLETED      NORMAL            16    0   16
63381  21-AUG-06 854844  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 06-SEP-06 COMPLETED      NORMAL            16    0   16
63382  21-AUG-06 854879  DELL LATITUDE LAPTOP      FL/PD     25-AUG-06 COMPLETED      PER EVENT          4    1    3
63383  21-AUG-06 854929  INFORTREND: ESA16F-G1A2   EXP/D0    23-AUG-06 COMPLETED      PER EVENT          2    0    2
63385  21-AUG-06 855063  ETRNLGRF: D-P3-1300-ST    EXP/D0    28-AUG-06 COMPLETED      PER EVENT          7    0    7
63386  21-AUG-06 855149  POLYWELL: PLY-935X8       EXP/E898/ 22-AUG-06 COMPLETED      PER EVENT          1    0    1
63387  21-AUG-06 855206  APPLE POWERBOOK G4        FL/AD     07-SEP-06 COMPLETED      PER EVENT         17    0   17
63392  22-AUG-06 856301  NEXSAN: SATABLADE-8*250G  FL/CD/CCF 24-AUG-06 COMPLETED      PER EVENT          2    0    2
63402  23-AUG-06 858220  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 06-SEP-06 COMPLETED      NORMAL            14    0   14
63403  23-AUG-06 858298  POLYWELL: PLY-935X8       EXP/E898/ 23-AUG-06 COMPLETED      PER EVENT          0    0    0

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
63404  23-AUG-06 858316  DELL: LATITUDE-X300       FL/DI     24-AUG-06 COMPLETED      PER EVENT          1    0    1
63406  23-AUG-06 858746  SONY: VAIO LAPTOP         FL/CD     01-SEP-06 COMPLETED      PER EVENT          9    0    9
63410  24-AUG-06 859923  ASA: D-X-3000-24*250G(6TB EXP/CDF   24-AUG-06 COMPLETED      NORMAL             0    0    0
63414  24-AUG-06 861812  SUN MS: E450-REFURB       FL/AD     25-AUG-06 COMPLETED      TRADITIONAL/BAS    0    0    0
63418  25-AUG-06 862387  ASA: D-X-2000-1.3TB       UNIV/RTH  07-SEP-06 COMPLETED      PER EVENT         13    0   13
63420  25-AUG-06 862479  SONY: VGN-TX670P/B        FL/PD     04-OCT-06 COMPLETED      PER EVENT         40    6   34
63432  28-AUG-06 865228  APPLE: A1046              FL/CD/CCF 01-SEP-06 COMPLETED      PER EVENT          4    0    4
63433  28-AUG-06 865435  HP: C3167A                FL/AD     28-AUG-06 COMPLETED      PER EVENT          0    0    0
63435  28-AUG-06 865754  POLYWELL: PLY-935X8       FL/CD     29-AUG-06 COMPLETED      PER EVENT          1    0    1
63439  28-AUG-06 865886  DELL: PREC370N            FL/FE     31-AUG-06 COMPLETED      PER EVENT          3    0    3
63440  28-AUG-06 865909  ATIPA: 2*X-2.66G-1U-RM    FL/CD     29-AUG-06 COMPLETED      NORMAL             1    0    1
63448  29-AUG-06 867232  INFORTREND: ESA16F-G1A2   FL/CD     01-SEP-06 COMPLETED      PER EVENT          3    0    3
63450  29-AUG-06 867391  HP: C8520A                FL/BS     13-SEP-06 COMPLETED      PER EVENT         15    0   15
63453  29-AUG-06 867924  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 01-SEP-06 COMPLETED      NORMAL             3    0    3
63454  29-AUG-06 868019  POLYWELL: PLY-935X8       FL/CD     15-SEP-06 COMPLETED      PER EVENT         17    0   17
63455  29-AUG-06 868091  ASA: D-X-3000-24*250G(6TB EXP/CDF   30-AUG-06 COMPLETED      NORMAL             1    0    1
63456  29-AUG-06 868133  ASA: D-X-3000-24*250G(6TB EXP/CDF   30-AUG-06 COMPLETED      PER EVENT          1    0    1
63457  29-AUG-06 868230  ASA: D-X-3000-24*250G(6TB EXP/CDF   30-AUG-06 COMPLETED      NORMAL             1    0    1
63463  30-AUG-06 869691  ATIPA: 2*X-2.66G-1U-RM    FL/CD/CSS 11-OCT-06 COMPLETED      NORMAL            42    0   42
63467  30-AUG-06 870510  HP LASERJET               FL/PD     25-SEP-06 COMPLETED      PER EVENT         26    0   26
63471  31-AUG-06 872019  ASA: D-X-3000-24*250G(6TB EXP/CDF   05-SEP-06 COMPLETED      NORMAL             5    0    5
63472  31-AUG-06 872303  THINKCOMP: D-X-3060-2U-RM FL/CD/CMS 08-SEP-06 COMPLETED      PER EVENT          8    0    8
63473  31-AUG-06 872418  POLYWELL: 2*X-3.06G-4U-RM FL/PD     11-SEP-06 COMPLETED      PER EVENT         11    0   11
63482  01-SEP-06 873615  TOSHIBA CPU BOX           FL/PD     13-SEP-06 COMPLETED      PER EVENT         12    0   12
63484  01-SEP-06 874264  HP: C4216A                FL/CD     05-SEP-06 COMPLETED      TRADITIONAL/BAS    4    0    4
63485  01-SEP-06 874279  DELL: LAT-LS-400          FL/PD     06-SEP-06 COMPLETED      PER EVENT          5    0    5
63489  01-SEP-06 876009  HP: C4094A                FL/LS     05-SEP-06 COMPLETED      PER EVENT          0    0    0
63495  05-SEP-06 877131  ASA: D-AMD-MT             UNIV      12-SEP-06 COMPLETED      PER EVENT          7    0    7
63496  05-SEP-06 876694  DELL: PREC470             FL/PD     07-SEP-06 COMPLETED      PER EVENT          2    0    2
63500  05-SEP-06 877103  XEROX: 255ST              FL/LS     07-SEP-06 COMPLETED      PER EVENT          2    0    2
63513  07-SEP-06 882399  XEROX PHASER PRINTER      FL/PD     11-SEP-06 COMPLETED      PER EVENT          4    0    4
63516  07-SEP-06 882871  INFORTREND: ESA16F-G1A2   FL/CD/CMS 15-SEP-06 COMPLETED      PER EVENT          8    0    8
63521  07-SEP-06 886772  ASA: D-X-3000-24*250G(6TB EXP/CDF   08-SEP-06 COMPLETED      NORMAL             0    0    0
63523  08-SEP-06 887057  HP: C7099A                FL/FE     08-SEP-06 COMPLETED      PER EVENT          0    0    0
63536  11-SEP-06 889683  DELL OPTIPLEX GX270       FL/PD     12-SEP-06 COMPLETED      PER EVENT          1    0    1
63554  12-SEP-06 891693  DELL: POWERVAULT 220S     FL/CD     13-SEP-06 COMPLETED      PER EVENT          1    0    1
63560  12-SEP-06 892506  INFORTREND: ESA16F-G1A2   FL/CD/CMS 19-SEP-06 COMPLETED      PER EVENT          7    0    7
63562  13-SEP-06 893324  INFORTREND: ESA16F-G1A2   FL/CD     14-SEP-06 COMPLETED      PER EVENT          1    0    1
63563  13-SEP-06 893365  HP: C4087A                FL/PD     15-SEP-06 COMPLETED      PER EVENT          2    0    2
63565  13-SEP-06 893822  DELL: LAT-X300-1200       FL/CD     18-SEP-06 COMPLETED      PER EVENT          5    0    5
63565  13-SEP-06 893822  DELL: LAT-X300-1200       FL/CD     18-SEP-06 COMPLETED      PER EVENT          5    0    5
63572  14-SEP-06 896707  ANGSTROM: 2*X-2.6G-1U-RM  FL/CD     14-SEP-06 COMPLETED      NORMAL             0    0    0
63577  14-SEP-06 897216  ASA: D-X-3060-1U-RM       EXP/D0    15-SEP-06 COMPLETED      NORMAL             1    0    1
63578  14-SEP-06 897324  HP: C7099A                FL/FE     15-SEP-06 COMPLETED      PER EVENT          1    0    1
63579  14-SEP-06 897447  GATEWAY: E6100            FL/TD     19-SEP-06 COMPLETED      PER EVENT          5    0    5
63580  14-SEP-06 897456  GATEWAY CPU BOX           FL/TD     19-SEP-06 COMPLETED      PER EVENT          5    0    5
63581  14-SEP-06 897768  HP: C7099A                FL/FE     15-SEP-06 COMPLETED      PER EVENT          1    0    1
63582  14-SEP-06 897810  HP: C3167A                FL/AD     22-SEP-06 COMPLETED      PER EVENT          8    2    6
63587  15-SEP-06 898877  HP: C4267A                FL/PD     19-SEP-06 COMPLETED      TRADITIONAL/BAS    4    0    4
63588  15-SEP-06 898927  DELL: LATITUDE-D810       FL/FE     20-SEP-06 COMPLETED      PER EVENT          5    0    5
63590  15-SEP-06 899539  XEROX PHASER PRINTER      FL/PD     19-SEP-06 COMPLETED      PER EVENT          4    0    4
63592  18-SEP-06 901516  APPLE POWERBOOK G4        FL/CD     28-SEP-06 COMPLETED      PER EVENT         10    6    4
63595  18-SEP-06 902301  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    19-SEP-06 COMPLETED      NORMAL             1    0    1
63603  19-SEP-06 903802  INFORTREND: ESA16F-G1A2   FL/CD/CMS 13-OCT-06 COMPLETED      PER EVENT         24    0   24
63605  19-SEP-06 904103  HP: C4267A                FL/PD     20-SEP-06 COMPLETED      PER EVENT          1    0    1
63608  19-SEP-06 905387  POLYWELL:524SATA          FL/CD     20-SEP-06 COMPLETED      PER EVENT          0    0    0
63610  20-SEP-06 906002  ASA: D-X-3060-8TB-5U      EXP/D0    20-SEP-06 COMPLETED      NORMAL             0    0    0
63611  20-SEP-06 906590  INFORTREND: ESA16F-G1A2   FL/CD/CMS 25-SEP-06 COMPLETED      PER EVENT          5    0    5
63614  20-SEP-06 907458  DELL: LAT-X300-1200       FL/CD     26-SEP-06 COMPLETED      PER EVENT          5    0    5
63619  21-SEP-06 909273  ASA: D-X-3400-RM          FL/PD     22-SEP-06 COMPLETED      NORMAL             0    0    0
63628  25-SEP-06 912314  SUN MS: 602-1676-01       EXP/CDF   26-SEP-06 COMPLETED      TRADITIONAL/PRE    1    0    1
63629  22-SEP-06 912350  APPLE: A1083              FL/CD     11-OCT-06 COMPLETED      PER EVENT         16    0   16
63630  25-SEP-06 912455  INFORTREND: ESA16F-G1A2   FL/CD     28-SEP-06 COMPLETED      PER EVENT          3    0    3
63631  25-SEP-06 912576  SUN MS: 140               FL/TD     02-OCT-06 COMPLETED      TRADITIONAL/BAS    7    0    7
63635  26-SEP-06 914112  APPLE POWERMAC G5         FL/FE     10-NOV-06 COMPLETED      PER EVENT         45    0   45
63636  25-SEP-06 914178  DELL: 2001FP              FL/FE     28-SEP-06 COMPLETED      PER EVENT          2    0    2
63643  27-SEP-06 916422  DELL: PREC380N            FL/FE     28-SEP-06 COMPLETED      PER EVENT          1    0    1

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
63644  27-SEP-06 916443  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    29-SEP-06 COMPLETED      NORMAL             2    0    2
63645  27-SEP-06 916767  INFORTREND: ESA16F-G1A2   FL/CD/CMS 03-OCT-06 COMPLETED      PER EVENT          6    0    6
63646  27-SEP-06 916774  INFORTREND: ESA16F-G1A2   FL/CD/CMS 03-OCT-06 COMPLETED      PER EVENT          6    0    6
63648  27-SEP-06 916987  ZZYZX: RR-1422-LVD        EXP/CDF   29-SEP-06 COMPLETED      TRADITIONAL/BAS    2    0    2
63649  27-SEP-06 916993  INFORTREND: ESA16F-G1A2   FL/CD/CMS 03-OCT-06 COMPLETED      PER EVENT          6    0    6
63652  27-SEP-06 917701  POLYWELL:524SATA          FL/CD/REX 16-OCT-06 COMPLETED      PER EVENT         19    0   19
63653  27-SEP-06 917722  POLYWELL:524SATA          FL/CD     02-OCT-06 COMPLETED      PER EVENT          5    0    5
63654  27-SEP-06 917767  DELL: GX240-2000-MT       FL/CD     04-OCT-06 COMPLETED      PER EVENT          7    0    7
63656  27-SEP-06 919069  ASA: D-X-3060-8TB-5U      EXP/D0    03-OCT-06 COMPLETED      NORMAL             5    0    5
63657  27-SEP-06 919071  ASA: D-X-3000-24*250G(6TB EXP/CDF   28-SEP-06 COMPLETED      NORMAL             0    0    0
63658  28-SEP-06 919079  POLYWELL: PLY-935X8       FL/CD     28-SEP-06 COMPLETED      PER EVENT          0    0    0
63661  28-SEP-06 919085  ASA CPU BOX               FL/PD     24-OCT-06 COMPLETED      NORMAL            26    5   21
63666  28-SEP-06 919877  HP LASERJET               FL/CD     12-OCT-06 COMPLETED      PER EVENT         14    9    5
63667  28-SEP-06 920640  DELL OPTIPLEX             FL/DI     04-OCT-06 COMPLETED      PER EVENT          5    0    5
63669  29-SEP-06 921416  APPLE POWERBOOK G4        FL/PD     11-OCT-06 COMPLETED      PER EVENT         12    0   12
63670  29-SEP-06 921770  INFORTREND: ESA16F-G1A2   FL/CD     05-OCT-06 COMPLETED      PER EVENT          6    1    5
63677  02-OCT-06 923383  INFORTREND: ESA16F-G1A2   FL/CD     05-OCT-06 COMPLETED      PER EVENT          3    1    2
63678  02-OCT-06 923425  DELL: LATITUDE-D600       FL/AD     10-OCT-06 COMPLETED      PER EVENT          8    0    8
63680  02-OCT-06 924347  SUN MS: GDM-20E20         FL/TD     04-OCT-06 COMPLETED      TRADITIONAL/BAS    2    0    2
63686  03-OCT-06 926392  XEROX PHASER PRINTER      FL/PD     18-OCT-06 COMPLETED      PER EVENT         15    0   15
63690  04-OCT-06 927498  DELL: LAT-D610-2000       FL/CD/CDO 06-OCT-06 COMPLETED      PER EVENT          2    0    2
63692  04-OCT-06 928204  APPLE: A1010              FL/CD/CMS 05-OCT-06 COMPLETED      PER EVENT          1    0    1
63695  05-OCT-06 929297  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    05-OCT-06 COMPLETED      NORMAL             0    0    0
63696  05-OCT-06 929364  HP: C3142A                FL/AD     19-OCT-06 COMPLETED      PER EVENT         14   13    1
63699  05-OCT-06 929891  HP: C4267A                FL/PD     06-OCT-06 COMPLETED      TRADITIONAL/BAS    1    0    1
63700  05-OCT-06 930393  HP: C6455A                FL/CD     06-OCT-06 COMPLETED      PER EVENT          1    0    1
63715  09-OCT-06 934036  SUN MS: 595-4722-03       FL/CD/CSS 11-OCT-06 COMPLETED      TRADITIONAL/PRE    2    0    2
63716  09-OCT-06 934283  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    10-OCT-06 COMPLETED      NORMAL             1    0    1
63717  09-OCT-06 934389  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    11-OCT-06 COMPLETED      NORMAL             2    0    2
63718  09-OCT-06 934582  HP: C4267A                FL/PD     11-OCT-06 COMPLETED      PER EVENT          2    1    1
63719  09-OCT-06 935058  INFORTREND: ESA16F-G1A2   FL/CD/CMS 20-OCT-06 COMPLETED      PER EVENT         10    0   10
63720  09-OCT-06 935069  INFORTREND: ESA16F-G1A2   FL/CD/CMS 13-OCT-06 COMPLETED      PER EVENT          3    0    3
63724  10-OCT-06 935258  DELL: LATITUDE-D610       FL/PD     17-OCT-06 COMPLETED      PER EVENT          7    1    6
63730  10-OCT-06 935758  ASA: D-X-3060-1U-RM       FL/CD     01-JAN-07 COMPLETED      PER EVENT         83   77    6
63731  10-OCT-06 935774  APPLE POWERBOOK G4        FL/CD     17-OCT-06 COMPLETED      PER EVENT          7    0    7
63732  10-OCT-06 935819  SUN MS: ENT4500           EXP/D0    11-OCT-06 COMPLETED      TRADITIONAL/BAS    1    0    1
63744  11-OCT-06 937350  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    17-OCT-06 COMPLETED      NORMAL             6    0    6
63748  11-OCT-06 941456  ATIPA: 2*X-2.66G-1U-RM    FL/CD/CSS 20-OCT-06 COMPLETED      PER EVENT          9    3    6
63750  11-OCT-06 938401  DELL: LATITUDE-D600       FL/PD     19-OCT-06 COMPLETED      PER EVENT          8    0    8
63751  11-OCT-06 938410  CONCENT: 2*X-2800-5TB-5U  FL/CD/EAG 20-DEC-06 COMPLETED      PER EVENT         70    0   70
63752  11-OCT-06 938425  ASA: D-X-3000-24*250G(6TB FL/CD     12-OCT-06 COMPLETED      NORMAL             1    0    1
63761  12-OCT-06 939892  SUN MS: 600-7297-01       FL/CD/CSS 16-OCT-06 COMPLETED      TRADITIONAL/BAS    4    0    4
63762  12-OCT-06 939952  HP: C4267A                FL/PD     13-OCT-06 COMPLETED      PER EVENT          1    0    1
63764  12-OCT-06 940571  APPLE: IMAC G5            FL/AD     16-OCT-06 COMPLETED      PER EVENT          4    3    1
63769  13-OCT-06 942027  POLYWELL: SRV-D-P3-1400-4 FL/CD     16-OCT-06 COMPLETED      PER EVENT          3    0    3
63770  13-OCT-06 942047  ASA: D-X-3060-1U-RM       FL/PD     23-OCT-06 COMPLETED      NORMAL            10    0   10
63771  13-OCT-06 942543  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    16-OCT-06 COMPLETED      NORMAL             3    0    3
63774  16-OCT-06 944027  DELL: GX240-2000-MT       FL/CD     17-OCT-06 COMPLETED      PER EVENT          1    0    1
63780  16-OCT-06 945514  APPLE POWERBOOK G4        FL/PD     20-OCT-06 COMPLETED      PER EVENT          4    1    3
63781  16-OCT-06 946338  XEROX PHASER PRINTER      FL/PD     03-NOV-06 COMPLETED      PER EVENT         17    0   17
63782  17-OCT-06 947426  KOI: 2*X-2660-1U-RM       EXP/D0    31-OCT-06 COMPLETED      NORMAL            14    0   14
63784  17-OCT-06 947679  ACER: AL1916AB            FL/PD     02-NOV-06 COMPLETED      PER EVENT         16    0   16
63790  18-OCT-06 948781  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 01-JAN-07 COMPLETED      PER EVENT         75   63   12
63795  18-OCT-06 949396  MICRON CLIENTPRO CN       FL/PD     30-OCT-06 COMPLETED      PER EVENT         12    6    6
63796  18-OCT-06 949425  XEROX: 8550/DP            FL/PD     20-OCT-06 COMPLETED      PER EVENT          2    0    2
63801  18-OCT-06 949620  POLYWELL: D-X-3.2G-24*400 FL/CD     27-OCT-06 COMPLETED      PER EVENT          9    0    9
63807  19-OCT-06 950520  PENGUIN: TEMPEST 2100     FL/PD     26-OCT-06 COMPLETED      PER EVENT          7    3    4
63809  19-OCT-06 950657  HP: C4267A                EXP/D0    19-OCT-06 COMPLETED      TRADITIONAL/BAS    0    0    0
63810  19-OCT-06 950699  RACKSAVR: ATHMP-2000+-4U- FL/CD/CEP 20-OCT-06 COMPLETED      TRADITIONAL/PRE    1    0    1
63811  19-OCT-06 950981  DELL: POWERVAULT 132T     FL/TD     24-OCT-06 COMPLETED      PER EVENT          5    0    5
63813  20-OCT-06 952135  RACKSAVR: ATHMP-2000+-4U- FL/CD/CEP 20-OCT-06 COMPLETED      TRADITIONAL/PRE    0    0    0
63819  20-OCT-06 952451  ASA: D-X-3000-24*250G(6TB FL/CD     20-OCT-06 COMPLETED      NORMAL             0    0    0
63820  20-OCT-06 952853  GATEWAY: PROFILE 4MX      FL/CD/CEP 26-OCT-06 COMPLETED      PER EVENT          6    1    5
63835  23-OCT-06 954680  SUN MS: 600-6514-01       FL/CD     23-OCT-06 COMPLETED      TRADITIONAL/PRE    0    0    0
63836  23-OCT-06 956563  SUN MS: 600-6514-01       FL/CD     24-OCT-06 COMPLETED      TRADITIONAL/PRE    1    0    1
63837  23-OCT-06 956585  DELL: XPS                 FL/PD     27-OCT-06 COMPLETED      PER EVENT          4    0    4
63841  24-OCT-06 957843  XEROX: 6200DP             FL/PD     24-OCT-06 COMPLETED      PER EVENT          0    0    0

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
63843  24-OCT-06 958636  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    31-OCT-06 COMPLETED      NORMAL             7    0    7
63844  24-OCT-06 958720  APPLE POWERBOOK G4        FL/PD     30-OCT-06 COMPLETED      PER EVENT          6    5    1
63848  24-OCT-06 959494  ASA: D-X-3000-24*250G(6TB FL/CD     25-OCT-06 COMPLETED      NORMAL             0    0    0
63851  25-OCT-06 960120  XEROX: 8500/DN            FL/AD     26-OCT-06 COMPLETED      PER EVENT          1    0    1
63852  25-OCT-06 960357  POLYWELL:524SATA          FL/CD/REX 30-OCT-06 COMPLETED      PER EVENT          5    0    5
63854  25-OCT-06 960624  XEROX: 8400/N             FL/AD     26-OCT-06 COMPLETED      PER EVENT          1    0    1
63856  25-OCT-06 960705  HP: C4267A                FL/PD     26-OCT-06 COMPLETED      TRADITIONAL/BAS    1    0    1
63857  25-OCT-06 960726  APPLE: A1106              FL/PD     15-NOV-06 COMPLETED      PER EVENT         21    4   17
63863  26-OCT-06 961760  ASA: D-X-3060-8TB-5U      FL/CD     26-OCT-06 COMPLETED      NORMAL             0    0    0
63864  26-OCT-06 962281  SUN MS: ENT450            EXP/CDF   30-OCT-06 COMPLETED      TRADITIONAL/BAS    4    0    4
63867  26-OCT-06 962566  APPLE MAC BOOK            FL/PD     27-OCT-06 COMPLETED      PER EVENT          1    0    1
63869  27-OCT-06 963585  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    02-NOV-06 COMPLETED      NORMAL             6    0    6
63872  27-OCT-06 964166  XEROX: 8200/N             EXP/D0    31-OCT-06 COMPLETED      TRADITIONAL/BAS    4    0    4
63874  30-OCT-06 965908  ASA: D-X-3060-1U-RM       FL/CD     20-NOV-06 COMPLETED      NORMAL            21    0   21
63877  30-OCT-06 966296  DELL: LATITUDE-D600       FL/AD     01-NOV-06 COMPLETED      PER EVENT          2    0    2
63879  30-OCT-06 967323  ASA: D-X-2800-24*250G(6TB EXP/CDF   31-OCT-06 COMPLETED      NORMAL             1    0    1
63881  31-OCT-06 968143  SUN MS: 602-1676-01       EXP/CDF   03-NOV-06 COMPLETED      TRADITIONAL/PRE    3    2    1
63883  31-OCT-06 969045  HP: C4216A                FL/AD     01-NOV-06 COMPLETED      PER EVENT          1    0    1
63887  01-NOV-06 970196  DELL: LAT-D820-2160       FL/PD     08-NOV-06 COMPLETED      PER EVENT          7    0    7
63888  01-NOV-06 970630  DELL: GX280-3200          FL/PD     06-NOV-06 COMPLETED      PER EVENT          5    0    5
63892  01-NOV-06 972053  DELL: LATITUDE-C640       FL/CD     09-NOV-06 COMPLETED      PER EVENT          7    0    7
63894  02-NOV-06 972193  DELL: PREC380N            FL/FE     07-NOV-06 COMPLETED      PER EVENT          5    0    5
63895  02-NOV-06 972288  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 13-NOV-06 COMPLETED      NORMAL            11    5    6
63896  02-NOV-06 972635  INFORTREND: ESA16F-G1A2   FL/CD/CMS 08-NOV-06 COMPLETED      PER EVENT          6    0    6
63897  02-NOV-06 972702  GATEWAY: M275XL           FL/PD     19-DEC-06 COMPLETED      PER EVENT         47   22   25
63902  02-NOV-06 974039  DELL: GX260-2000-SF       FL/LS     08-NOV-06 COMPLETED      PER EVENT          6    0    6
63905  03-NOV-06 974112  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    03-NOV-06 COMPLETED      NORMAL             0    0    0
63910  03-NOV-06 974699  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    08-NOV-06 COMPLETED      NORMAL             5    0    5
63911  06-NOV-06 976655  NEXSAN: ATABEAST 42*400   FL/CD/REX 15-NOV-06 COMPLETED      PER EVENT          9    0    9
63919  06-NOV-06 977759  HP: C4267A                FL/PD     08-NOV-06 COMPLETED      PER EVENT          2    0    2
63923  07-NOV-06 979143  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    08-NOV-06 COMPLETED      NORMAL             1    0    1
63931  08-NOV-06 981131  PENGUIN: TEMPEST 2100     FL/PD     09-NOV-06 COMPLETED      PER EVENT          1    0    1
63932  08-NOV-06 981204  DELL OPTIPLEX GX280       FL/CD/CCF 16-NOV-06 COMPLETED      PER EVENT          8    2    6
63937  08-NOV-06 981386  ASA: D-X-3060-1U-RM       FL/CD     17-NOV-06 COMPLETED      NORMAL             9    0    9
63938  08-NOV-06 981407  ASA: D-X-3060-1U-RM       FL/CD     17-NOV-06 COMPLETED      NORMAL             9    0    9
63942  08-NOV-06 982011  INFORTREND: ESA16F-G1A2   FL/CD/CMS 14-NOV-06 COMPLETED      PER EVENT          6    0    6
63947  09-NOV-06 983282  GATEWAY: E6100            FL/TD     14-NOV-06 COMPLETED      PER EVENT          5    0    5
63955  10-NOV-06 984924  HP: C4267A                FL/PD     13-NOV-06 COMPLETED      TRADITIONAL/BAS    3    0    3
63960  13-NOV-06 987079  DELL: PREC670-3000        FL/CD/CEP 22-NOV-06 COMPLETED      PER EVENT          9    0    9
63965  13-NOV-06 987522  DELL: PREC670             FL/PD     17-NOV-06 COMPLETED      PER EVENT          4    1    3
63966  13-NOV-06 987569  DELL: GX240-2000-MT       FL/PD     20-NOV-06 COMPLETED      PER EVENT          7    0    7
63970  14-NOV-06 989468  SUN MS: 602-1676-01       EXP/CDF   16-NOV-06 COMPLETED      TRADITIONAL/PRE    2    0    2
63972  14-NOV-06 989825  HP: C4267A                FL/PD     20-NOV-06 COMPLETED      PER EVENT          6    0    6
63973  14-NOV-06 989909  HP: C8547A                FL/FE     15-NOV-06 COMPLETED      PER EVENT          1    0    1
63975  14-NOV-06 989977  HP: C3167A                FL/FE     20-NOV-06 COMPLETED      PER EVENT          6    0    6
63976  14-NOV-06 990609  ASA: D-X-3000-24*250G(6TB EXP/CDF   15-NOV-06 COMPLETED      PER EVENT          1    0    1
63983  15-NOV-06 993678  DELL PRECISION WORKSTATIO FL/PD     21-NOV-06 COMPLETED      PER EVENT          5    0    5
63984  16-NOV-06 994030  DELL: LATITUDE-D610       FL/AD     16-NOV-06 COMPLETED      PER EVENT          0    0    0
63985  16-NOV-06 994270  PC-CLONE                  FL/PD     17-NOV-06 COMPLETED      PER EVENT          1    0    1
63986  16-NOV-06 994358  ACECOMP: 2*X-2800-1U-RM   FL/CD/CMS 22-NOV-06 COMPLETED      PER EVENT          6    0    6
63987  16-NOV-06 994395  DELL: PREC340             FL/FE     21-NOV-06 COMPLETED      PER EVENT          5    0    5
63989  16-NOV-06 995028  HP LASERJET               FL/AD     17-NOV-06 COMPLETED      PER EVENT          1    0    1
63999  20-NOV-06 000911  ASA: D-X-3060-8TB-5U      FL/CD     21-NOV-06 COMPLETED      NORMAL             1    0    1
64000  20-NOV-06 001044  DELL: LATITUDE-D810       FL/CD     28-NOV-06 COMPLETED      PER EVENT          8    0    8
64006  21-NOV-06 002251  HP: C4267A                FL/PD     21-NOV-06 COMPLETED      TRADITIONAL/BAS    0    0    0
64014  21-NOV-06 003639  SYSTEMAX: ATHLON-1000-MT  FL/PD     22-NOV-06 COMPLETED      PER EVENT          0    0    0
64016  22-NOV-06 003880  NEXSAN: ATABEAST 42*400   FL/CD/REX 05-DEC-06 COMPLETED      PER EVENT         13    0   13
64022  27-NOV-06 007810  APPLE: A1150-1830         FL/CD     12-DEC-06 COMPLETED      PER EVENT         15    7    8
64026  27-NOV-06 007983  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    27-NOV-06 COMPLETED      NORMAL             0    0    0
64027  27-NOV-06 008052  APPLE POWERBOOK G4        FL/PD     07-DEC-06 COMPLETED      PER EVENT         10    3    7
64031  27-NOV-06 008361  DELL: LATITUDE-C640       FL/AD     28-NOV-06 COMPLETED      PER EVENT          1    0    1
64036  28-NOV-06 009662  HP: Q5409A#ABA            FL/PD     30-NOV-06 COMPLETED      PER EVENT          2    0    2
64037  28-NOV-06 010796  XEROX: 8200/N             EXP/D0    29-NOV-06 COMPLETED      TRADITIONAL/BAS    1    0    1
64038  29-NOV-06 011529  DELL: LATITUDE-D600       FL/PD     04-DEC-06 COMPLETED      PER EVENT          5    0    5
64043  29-NOV-06 012277  DELL OPTIPLEX GX280       FL/PD     04-DEC-06 COMPLETED      PER EVENT          5    0    5
64044  29-NOV-06 012643  XEROX: 6250/DP            FL/CD     06-DEC-06 COMPLETED      PER EVENT          7    2    5
64045  29-NOV-06 012967  INFORTREND: ESA16F-G1A2   FL/CD/CMS 30-NOV-06 COMPLETED      PER EVENT          1    0    1

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
64052  30-NOV-06 013788  SUN MS: ENT4500           EXP/D0    30-NOV-06 COMPLETED      TRADITIONAL/BAS    0    0    0
64053  30-NOV-06 015665  MICRON MILL-MAX GS133-733 FL/PD     11-DEC-06 COMPLETED      PER EVENT         11    0   11
64059  01-DEC-06 017558  HP: C4267A                FL/PD     04-DEC-06 COMPLETED      TRADITIONAL/BAS    3    0    3
64066  04-DEC-06 019912  HP: C3167A                FL/BS     05-DEC-06 COMPLETED      PER EVENT          1    0    1
64067  04-DEC-06 020246  POLYWELL CPU BOX          FL/CD     08-DEC-06 COMPLETED      PER EVENT          4    0    4
64069  04-DEC-06 020497  DELL: LAT-D410-1730       FL/CD/AMR 08-DEC-06 COMPLETED      PER EVENT          4    0    4
64072  04-DEC-06 020932  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    05-DEC-06 COMPLETED      PER EVENT          1    0    1
64080  04-DEC-06 023440  DELL LATITUDE LAPTOP      FL/PD     05-DEC-06 COMPLETED      PER EVENT PRIOR    0    0    0
64086  06-DEC-06 025041  HP: C4267A                FL/PD     11-DEC-06 COMPLETED      PER EVENT          5    0    5
64088  06-DEC-06 025301  DELL: DIM-4600            FL/ES     11-DEC-06 COMPLETED      PER EVENT          5    0    5
64097  08-DEC-06 029163  CYCLADES: ACS48-1         FL/CD     08-DEC-06 COMPLETED      PER EVENT PRIOR    0    0    0
64098  08-DEC-06 029212  ASA: D-X-3060-8TB-5U      FL/CD     08-DEC-06 COMPLETED      NORMAL             0    0    0
64099  08-DEC-06 029775  HP: C3167A                FL/PD     11-DEC-06 COMPLETED      PER EVENT          3    2    1
64101  08-DEC-06 029831  SUN MS: E450-REFURB       FL/AD     11-DEC-06 COMPLETED      TRADITIONAL/BAS    3    0    3
64100  08-DEC-06 029826  SUN MS: 140               FL/TD     14-DEC-06 COMPLETED      TRADITIONAL/BAS    6    0    6
64103  08-DEC-06 030578  ASA: D-X-3060-8TB-5U      FL/CD     01-JAN-07 COMPLETED      PER EVENT         24   16    8
64107  11-DEC-06 032301  HP: C3167A                FL/CD     12-DEC-06 COMPLETED      PER EVENT          1    0    1
64108  11-DEC-06 032323  HP: C7099A                FL/CD     11-DEC-06 COMPLETED      PER EVENT          0    0    0
64109  11-DEC-06 032357  POLYWELL: 2*X-3.06G-4U-RM FL/PD     19-DEC-06 COMPLETED      PER EVENT          8    0    8
64110  11-DEC-06 032501                            FL/CD/CCF 12-DEC-06 COMPLETED      PER EVENT          1    0    1
64117  12-DEC-06 034251  INFORTREND: ESA16F-G1A2   FL/CD     22-JAN-07 COMPLETED      PER EVENT         41    0   41
64118  12-DEC-06 034362  XEROX: 8200/N             EXP/D0    14-DEC-06 COMPLETED      TRADITIONAL/BAS    2    0    2
64120  12-DEC-06 034492  HP LASERJET               FL/BS     15-DEC-06 COMPLETED      PER EVENT          3    0    3
64123  13-DEC-06 036419  INFORTREND: ESA16F-G1A2   FL/CD/CMS 19-DEC-06 COMPLETED      PER EVENT          6    0    6
64124  13-DEC-06 036462  ACECOMP: P4-2000-MT       FL/CD/CEP 14-DEC-06 COMPLETED      PER EVENT          1    0    1
64125  13-DEC-06 036495  ACECOMP: D-ATHLON-1800+-F EXP/D0    15-DEC-06 COMPLETED      PER EVENT          2    0    2
64129  13-DEC-06 037203  TOSH: LAPTOP              FL/PD     18-DEC-06 COMPLETED      PER EVENT          5    0    5
64134  14-DEC-06 038704  HP: C4267A                FL/PD     15-DEC-06 COMPLETED      PER EVENT          1    0    1
64137  15-DEC-06 040068  VIEWSON: VX800            EXP/D0    19-DEC-06 COMPLETED      PER EVENT          4    0    4
64138  15-DEC-06 040090  SUN MS: 140               FL/TD     18-DEC-06 COMPLETED      TRADITIONAL/BAS    3    0    3
64142  18-DEC-06 042164  SUN MS: 600-7243-01       FL/CD/CSS 18-DEC-06 COMPLETED      TRADITIONAL/PRE    0    0    0
64150  19-DEC-06 044966  APPLE: MAC PRO            FL/LS     05-JAN-07 COMPLETED      PER EVENT         17    2   15
64152  19-DEC-06 045303  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 24-JAN-07 COMPLETED      NORMAL            36    9   27
64166  27-DEC-06 053087  HP: C3142A                FL/AD     02-JAN-07 COMPLETED      PER EVENT          6    0    6
64167  27-DEC-06 055079  ASA: 12*500-3U-RM         FL/CD/REX 16-JAN-07 COMPLETED      PER EVENT         19    0   19
64168  27-DEC-06 055103  ASA: 12*500-3U-RM         FL/CD/REX 12-JAN-07 COMPLETED      PER EVENT         15    0   15
64169  27-DEC-06 055117  ASA: 12*500-3U-RM         FL/CD/REX 12-JAN-07 COMPLETED      PER EVENT         15    0   15
64170  28-DEC-06 055211  ANGSTROM: 2*X-2.4G-1U-RM  FL/CD/CMS 02-JAN-07 COMPLETED      PER EVENT          5    3    2
64174  02-JAN-07 059055  DELL: LATITUDE-D610       FL/AD     05-JAN-07 COMPLETED      PER EVENT          3    0    3
64176  02-JAN-07 060097  DELL: LATITUDE-C610       FL/AD     03-JAN-07 COMPLETED      PER EVENT          1    0    1
64180  03-JAN-07 061474  MONITOR                   FL/LS     06-FEB-07 COMPLETED      PER EVENT         34    0   34
64185  04-JAN-07 064337  DELL LATITUDE LAPTOP      FL/PD     05-JAN-07 COMPLETED      PER EVENT          1    0    1
64188  05-JAN-07 065372  DELL: LAT-LS-400          FL/PD     09-JAN-07 COMPLETED      PER EVENT          4    0    4
64195  05-JAN-07 065894  DELL: LAT-D600-2000       FL/CD     09-JAN-07 COMPLETED      PER EVENT          4    0    4
64197  05-JAN-07 065922  DELL PRECISION WORKSTATIO FL/PD     11-JAN-07 COMPLETED      PER EVENT          6    2    4
64198  05-JAN-07 066179  INFORTREND: ESA16F-G1A2   FL/CD/CMS 11-JAN-07 COMPLETED      PER EVENT          6    0    6
64200  05-JAN-07 066581  APPLE POWERBOOK G4        FL/PD     22-JAN-07 COMPLETED      PER EVENT         17   13    4
64201  15-DEC-06 032357  POLYWELL: 2*X-3.06G-4U-RM FL/CD/CSS 08-JAN-07 COMPLETED      NORMAL             0    0    0
64205  08-JAN-07 068489  INFORTREND: ESA16FR1211M2 FL/CD/CSS 11-JAN-07 COMPLETED      PER EVENT          3    0    3
63923  07-NOV-06  097914 ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    09-JAN-07 COMPLETED      NORMAL             0    0    0
64208  09-JAN-07 071749  HP: C4267A                FL/PD     12-JAN-07 COMPLETED      PER EVENT          3    0    3
64209  09-JAN-07 071880  DELL: INSP-9100           FL/CD/CEP 12-JAN-07 COMPLETED      PER EVENT          3    1    2
64211  09-JAN-07 072137  DELL: LATITUDE-D800       FL/FE     09-JAN-07 COMPLETED      PER EVENT          0    0    0
64212  09-JAN-07 072182  HP: Q2434A                FL/FE     12-JAN-07 COMPLETED      PER EVENT          3    2    1
64215  10-JAN-07 073501  SUN MS: SUNFIRE V210      FL/CD/CSS 10-JAN-07 COMPLETED      TRADITIONAL/PRE    0    0    0
64218  10-JAN-07 074174  ACECOMP: P4-2600-MT       FL/CD     16-JAN-07 COMPLETED      PER EVENT          6    0    6
64228  11-JAN-07 076946  INFORTREND: ESA16F-R1A2   FL/CD/CSS 16-JAN-07 COMPLETED      PER EVENT          5    0    5
64229  11-JAN-07 077653  INFORTREND: ESA16F-G1A2   FL/CD/CMS 16-JAN-07 COMPLETED      PER EVENT          5    0    5
64230  11-JAN-07 077715  DELL: DIM-4600            FL/ES     17-JAN-07 COMPLETED      PER EVENT          6    0    6
64237  12-JAN-07 079295  INFORTREND: ESA16F-G1A2   FL/CD/CMS 18-JAN-07 COMPLETED      PER EVENT          6    0    6
64240  16-JAN-07 083307  PC-CLONE: P4              FL/PD     26-JAN-07 COMPLETED      PER EVENT         10    0   10
64241  16-JAN-07 083367  POLYWELL: 2*X-3.06G-4U-RM FL/CD     22-JAN-07 COMPLETED      PER EVENT          6    0    6
64243  16-JAN-07 083650  DELL: LATITUDE-D800       FL/CD     25-JAN-07 COMPLETED      PER EVENT          9    5    4
64246  17-JAN-07 085906  HP: Q2434A                FL/FE     19-JAN-07 COMPLETED      PER EVENT          2    0    2
64247  17-JAN-07 085935  HP: C3167A                FL/PD     22-JAN-07 COMPLETED      PER EVENT          5    1    4
64249  15-JAN-07 086096  CYCLADES: ACS48-1         FL/CD/REX 19-JAN-07 COMPLETED      PER EVENT          2    0    2
64252  17-JAN-07 086596  XEROX: 8400/N             FL/PD     18-JAN-07 COMPLETED      PER EVENT          1    0    1

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
64255  18-JAN-07 087959  SUN MS: 602-2394-02       FL/CD/CSS 18-JAN-07 COMPLETED      TRADITIONAL/PRE    0    0    0
64257  18-JAN-07 088112  NEXSAN: SATABEAST 42*500  FL/CD/REX 22-JAN-07 COMPLETED      PER EVENT          4    2    2
64260  18-JAN-07 088597  SUN MS: ENT4500           EXP/D0    18-JAN-07 COMPLETED      TRADITIONAL/BAS    0    0    0
64266  19-JAN-07 090554  POLYWELL: 2*X-2.4G-3.8T-5 FL/CD     01-FEB-07 COMPLETED      PER EVENT         13    0   13
64267  19-JAN-07 090832  XEROX: 8400/N             FL/PD     24-JAN-07 COMPLETED      PER EVENT          5    0    5
64273  22-JAN-07 094825  ATIPA CPU BOX             FL/CD     24-JAN-07 COMPLETED      PER EVENT          2    0    2
64274  22-JAN-07 094837  PC-CLONE                  FL/PD     26-JAN-07 COMPLETED      PER EVENT          4    0    4
64277  22-JAN-07 094994  ASA: D-X-2800-24*250G(6TB EXP/CDF   22-JAN-07 COMPLETED      PER EVENT          0    0    0
64280  23-JAN-07 096888  XEROX PHASER PRINTER      FL/PD     25-JAN-07 COMPLETED      PER EVENT          2    0    2
64282  24-JAN-07 098761  DELL: LATITUDE-D600       FL/CD     25-JAN-07 COMPLETED      PER EVENT          1    0    1
64283  24-JAN-07 098898  DELL: PREC370N            FL/CD     26-JAN-07 COMPLETED      PER EVENT          2    0    2
64286  25-JAN-07 101134  ASA: 8*500-3U-RM          FL/CD/REX 05-FEB-07 COMPLETED      NORMAL            11    3    8
64287  25-JAN-07 101437  DELL: LATITUDE-C640       FL/AD     31-JAN-07 COMPLETED      PER EVENT          6    0    6
64290  25-JAN-07 102351  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 29-JAN-07 COMPLETED      PER EVENT          3    0    3
64291  25-JAN-07 102453  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 05-FEB-07 COMPLETED      NORMAL            10    0   10
64295  29-JAN-07 105192  HP: C4253A                FL/PD     29-JAN-07 COMPLETED      PER EVENT PRIOR    0    0    0
64305  29-JAN-07 107103  IBM: 2668-93U             FL/CD/EAG 30-JAN-07 COMPLETED      PER EVENT          0    0    0
64307  30-JAN-07 107400  HP LASERJET               FL/DI     30-JAN-07 COMPLETED      PER EVENT          0    0    0
64308  30-JAN-07 107444  ATIPA: D-ATHL-MP2000-1U-R UNIV/PAV  01-FEB-07 COMPLETED      PER EVENT          2    0    2
64310  30-JAN-07 107966  HP: C4267A                FL/FE     02-FEB-07 COMPLETED      PER EVENT          3    0    3
64311  30-JAN-07 107984  HP: C8547A                FL/FE     31-JAN-07 COMPLETED      PER EVENT          1    0    1
64312  30-JAN-07 108009  HP: C7097A                FL/FE     08-FEB-07 COMPLETED      PER EVENT          9    0    9
64313  30-JAN-07 108050  HP: C3167A                FL/FE     02-FEB-07 COMPLETED      PER EVENT          3    0    3
64314  30-JAN-07 108071  HP: C4216A                FL/FE     31-JAN-07 COMPLETED      PER EVENT          1    0    1
64315  30-JAN-07 108153  HP: C4111A                FL/FE     01-FEB-07 COMPLETED      PER EVENT          2    0    2
64316  30-JAN-07 108213  HP: C7097A                FL/FE     01-FEB-07 COMPLETED      PER EVENT          2    0    2
64317  30-JAN-07 108255  HP: C4121A                FL/FE     01-FEB-07 COMPLETED      PER EVENT          2    0    2
64318  30-JAN-07 108455  ASA: SRV-D-P3-1400-4U-RM  FL/CD/CCF 31-JAN-07 COMPLETED      PER EVENT          1    0    1
64323  31-JAN-07 109797  SUN MS: ENT450            EXP/CDF   01-FEB-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64353  02-FEB-07 114367  DELL POWEREDGE SERVER     FL/PD     07-FEB-07 COMPLETED      PER EVENT          5    0    5
64354  31-JAN-07 114554  XEROX: 6350/DP            FL/CD/CSS 02-FEB-07 COMPLETED      PER EVENT          0    0    0
64355  02-FEB-07 114586  HP: C4267A                FL/PD     09-FEB-07 COMPLETED      PER EVENT          7    4    3
64361  05-FEB-07 121911  DELL: LATITUDE-D600       FL/CD     08-FEB-07 COMPLETED      PER EVENT          3    0    3
64363  05-FEB-07 122465  DELL: LATITUDE-D600       FL/AD     09-FEB-07 COMPLETED      PER EVENT          4    0    4
64364  05-FEB-07 122635  ASA: 12*500-3U-RM         FL/CD/REX 23-FEB-07 COMPLETED      NORMAL            18    0   18
64372  06-FEB-07 123990  XEROX PHASER PRINTER      FL/PD     07-FEB-07 COMPLETED      PER EVENT          1    0    1
64374  06-FEB-07 124084  DELL: DIM-4600-3060       FL/CD     09-FEB-07 COMPLETED      PER EVENT          3    0    3
64378  06-FEB-07 124754  APPLE: A1068              FL/PD     19-FEB-07 COMPLETED      PER EVENT         13    0   13
64379  06-FEB-07 124768  APPLE: A1068              FL/PD     19-FEB-07 COMPLETED      PER EVENT         13    0   13
64380  06-FEB-07 124787  APPLE: A1068              FL/PD     16-FEB-07 COMPLETED      PER EVENT         10    0   10
64381  06-FEB-07 124814  APPLE: A1068              FL/PD     16-FEB-07 COMPLETED      PER EVENT         10    0   10
64382  06-FEB-07 124827  APPLE: A1068              FL/PD     16-FEB-07 COMPLETED      PER EVENT         10    0   10
64383  06-FEB-07 124872  APPLE: A1068              FL/PD     20-FEB-07 COMPLETED      PER EVENT         14    0   14
64384  06-FEB-07 124880  APPLE: A1068              FL/PD     19-FEB-07 COMPLETED      PER EVENT         13    0   13
64385  06-FEB-07 124895  APPLE: A1068              FL/PD     19-FEB-07 COMPLETED      PER EVENT         13    0   13
64386  06-FEB-07 124905  APPLE: A1068              FL/PD     16-FEB-07 COMPLETED      PER EVENT         10    0   10
64387  06-FEB-07 124909  APPLE: A1068              FL/PD     19-FEB-07 COMPLETED      PER EVENT         13    0   13
64388  06-FEB-07 124921  APPLE: A1068              FL/PD     20-FEB-07 COMPLETED      PER EVENT         14    0   14
64389  06-FEB-07 124933  APPLE: A1068              FL/PD     14-FEB-07 COMPLETED      PER EVENT          8    0    8
64390  06-FEB-07 124944  APPLE: A1068              FL/PD     16-FEB-07 COMPLETED      PER EVENT         10    0   10
64391  06-FEB-07 124949  APPLE: A1068              FL/PD     19-FEB-07 COMPLETED      PER EVENT         13    0   13
64392  06-FEB-07 125222  XEROX: 8200/N             EXP/D0    08-FEB-07 COMPLETED      TRADITIONAL/BAS    2    0    2
64397  07-FEB-07 126267  DELL: LATITUDE-C640       FL/CD     12-FEB-07 COMPLETED      PER EVENT          5    0    5
64398  07-FEB-07 126425  DELL: LAT-C840-2400       FL/CD/CDO 12-FEB-07 COMPLETED      PER EVENT          5    0    5
64404  08-FEB-07 128177  SUN MS: E450-REFURB       FL/AD     09-FEB-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64406  08-FEB-07 128311  DELL OPTIPLEX GX270       FL/CD/CSS 12-FEB-07 COMPLETED      PER EVENT          4    0    4
64412  08-FEB-07 129188  DELL: DIM-4600-3060       FL/CD/CSS 16-FEB-07 COMPLETED      PER EVENT          8    0    8
64414  08-FEB-07 129308  DELL: 5100CN              FL/CD/CSS 14-FEB-07 COMPLETED      PER EVENT          6    0    6
64418  08-FEB-07 130368  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 02-MAR-07 COMPLETED      NORMAL            21    6   15
64420  09-FEB-07 130474  XEROX: 8550/DX            EXP/CDF   15-FEB-07 COMPLETED      PER EVENT          6    0    6
64421  09-FEB-07 130602  HP: C3167A                FL/BS     12-FEB-07 COMPLETED      PER EVENT          3    0    3
64422  09-FEB-07 130650  HP: C4267A                FL/PD     07-MAR-07 COMPLETED      PER EVENT         26    0   26
64423  09-FEB-07 130764  HP LASERJET               FL/BS     15-FEB-07 COMPLETED      PER EVENT          6    0    6
64424  09-FEB-07 131193  INFORTREND: ESA16F-G1A2   FL/CD/CMS 15-FEB-07 COMPLETED      PER EVENT          6    0    6
64428  12-FEB-07 133201  HP: C7063A                FL/BS     14-FEB-07 COMPLETED      PER EVENT          2    0    2
64430  12-FEB-07 134741  APPLE IBOOK               FL/LS     14-FEB-07 COMPLETED      PER EVENT          2    0    2
64433  12-FEB-07 135267  DELL: PREC380N            FL/FE     15-FEB-07 COMPLETED      PER EVENT          3    0    3

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
64435  12-FEB-07 136065  APPLE POWERBOOK G4        FL/CD     20-FEB-07 COMPLETED      PER EVENT          7    0    7
64438  13-FEB-07 136442  INFORTREND: ESA16F-G1A2   FL/CD/CMS 19-FEB-07 COMPLETED      PER EVENT          6    4    2
64439  13-FEB-07 136632  ASA: D-X-3060-8TB-5U      FL/CD     19-FEB-07 COMPLETED      NORMAL             6    0    6
64440  13-FEB-07 136880  HP: C4111A                FL/CD/CSS 15-FEB-07 COMPLETED      PER EVENT          2    0    2
64444  14-FEB-07 138403  DELL: LAT-D420-1060       FL/CD/CCF 16-FEB-07 COMPLETED      PER EVENT          2    0    2
64447  14-FEB-07 139133  DELL LATITUDE LAPTOP      FL/PD     16-FEB-07 COMPLETED      PER EVENT          2    0    2
64448  14-FEB-07 139229  DELL: LATITUDE-D600       FL/PD     16-FEB-07 COMPLETED      PER EVENT          2    0    2
64449  14-FEB-07 139320  INFORTREND: ESA16F-R1A2   FL/CD/CSS 20-FEB-07 COMPLETED      PER EVENT          6    0    6
64451  15-FEB-07 140167  DELL PRECISION WORKSTATIO FL/DI     26-FEB-07 COMPLETED      PER EVENT         11    0   11
64461  15-FEB-07 145353  DELL PRECISION WORKSTATIO FL/PD     23-FEB-07 COMPLETED      PER EVENT          7    0    7
64462  16-FEB-07 145444  ACECOMP: P4-2000-MT       FL/CD     20-FEB-07 COMPLETED      PER EVENT          4    0    4
64466  16-FEB-07 147843  DELL: LATITUDE-D810       FL/CD     21-FEB-07 COMPLETED      PER EVENT          2    0    2
64468  19-FEB-07 148389  APPLE POWERMAC G5         FL/FE     13-MAR-07 COMPLETED      PER EVENT         22   16    6
64469  19-FEB-07 148747  DELL: PE2850-DX           EXP/CDF   13-MAR-07 COMPLETED      PER EVENT PRIOR   22    0   22
64483  20-FEB-07 149234  HP: C3167A                FL/LS     26-FEB-07 COMPLETED      PER EVENT          6    0    6
64484  19-FEB-07 149257  ASA: D-X-3060-8TB-5U      FL/CD     26-FEB-07 COMPLETED      NORMAL             6    0    6
64485  19-FEB-07 149292  HP LASERJET               FL/BS     26-FEB-07 COMPLETED      PER EVENT          6    0    6
64488  19-FEB-07 149523  INFORTREND: ESA16FR1211M2 FL/CD/CSS 22-FEB-07 COMPLETED      PER EVENT          2    0    2
64491  20-FEB-07 149794  XEROX PHASER PRINTER      FL/PD     26-FEB-07 COMPLETED      PER EVENT          6    0    6
64493  20-FEB-07 149900  APPLE MAC BOOK            FL/DI     29-MAR-07 COMPLETED      PER EVENT         37   12   25
64495  19-FEB-07 150075  HP: C2011A                FL/CD     21-FEB-07 COMPLETED      PER EVENT          1    0    1
64497  20-FEB-07 150252  ASA: D-X-3060-1U-RM       FL/CD     21-FEB-07 COMPLETED      NORMAL             1    0    1
64499  20-FEB-07 150759  IBM THINKPAD R40          FL/PD     08-MAR-07 COMPLETED      PER EVENT         16    0   16
64500  20-FEB-07 151950  ACECOMP: 2280DXR2IF       FL/CD/CMS 23-FEB-07 COMPLETED      PER EVENT          2    0    2
64501  21-FEB-07 152025  DELL: XPS-M170-2000       FL/CD/REX 27-FEB-07 COMPLETED      PER EVENT          6    0    6
64503  21-FEB-07 152310  ASA: 12*500-3U-RM         FL/CD/REX 15-MAR-07 COMPLETED      NORMAL            22   15    7
64504  21-FEB-07 152365  ASA: 12*500-3U-RM         FL/CD/REX 15-MAR-07 COMPLETED      NORMAL            22   15    7
64508  21-FEB-07 153289  DELL: 1905FP              FL/PD/EED 28-FEB-07 COMPLETED      PER EVENT          7    0    7
64509  21-FEB-07 153313  DELL: 1905FP              FL/PD     28-FEB-07 COMPLETED      PER EVENT          7    0    7
64510  21-FEB-07 153358  SUN MS: ENT450            EXP/CDF   06-MAR-07 COMPLETED      TRADITIONAL/BAS   13    9    4
64514  22-FEB-07 155338  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    23-FEB-07 COMPLETED      PER EVENT          1    0    1
64515  22-FEB-07 155360  ACECOMP: ATHLON-1800+-MT  FL/CD/CSS 01-MAR-07 COMPLETED      PER EVENT          7    0    7
64518  22-FEB-07 156078  SYSTEMAX: ATHLON-1300-MT  FL/PD     27-FEB-07 COMPLETED      PER EVENT          5    0    5
64523  23-FEB-07 158044  DELL: LAT-X300-1200       FL/PD     20-MAR-07 COMPLETED      PER EVENT         25   15   10
64524  23-FEB-07 158334  IBM THINKPAD R40          FL/PD     27-FEB-07 COMPLETED      PER EVENT          4    0    4
64527  23-FEB-07 158666  HITECH: D-P3-500-MT       FL/CD     26-FEB-07 COMPLETED      PER EVENT          3    0    3
64528  23-FEB-07 159044  ASA: D-X-3060-1U-RM       FL/CD     26-FEB-07 COMPLETED      NORMAL             3    0    3
64531  23-FEB-07 161794  HP: C4111A                FL/PD     01-MAR-07 COMPLETED      PER EVENT          3    0    3
64533  26-FEB-07 162395  DELL PRECISION WORKSTATIO FL/PD     02-MAR-07 COMPLETED      PER EVENT          4    0    4
64535  26-FEB-07 162543  INFORTREND: ESA16F-G1A2   FL/CD/CMS 01-MAR-07 COMPLETED      PER EVENT          3    0    3
64538  26-FEB-07 163021  XEROX PHASER PRINTER      FL/PD     26-MAR-07 COMPLETED      PER EVENT         28    5   23
64544  27-FEB-07 164781  DELL: LAT-D600-1600       FL/CD/CEP 06-MAR-07 COMPLETED      PER EVENT          7    0    7
64545  27-FEB-07 164856  HP: C4267A                FL/PD     01-MAR-07 COMPLETED      TRADITIONAL/BAS    2    0    2
64546  27-FEB-07 165098  INFORTREND: ESA16F-G1A2   FL/CD/CMS 02-MAR-07 COMPLETED      PER EVENT          3    0    3
64547  28-FEB-07 166657  DELL: LATITUDE-D810       FL/CD     06-MAR-07 COMPLETED      PER EVENT          6    0    6
64554  01-MAR-07 168874  DELL: XPS-M170-2000       FL/CD     06-MAR-07 COMPLETED      PER EVENT          5    0    5
64555  01-MAR-07 169021  EXABYTE: EXB-8505XL       FL/CD/CCF 02-MAR-07 COMPLETED      PER EVENT          1    0    1
64557  01-MAR-07 169307  HP: C7099A                FL/FE     13-MAR-07 COMPLETED      PER EVENT         12    8    4
64558  01-MAR-07 169711  DELL: DIM-4600            FL/LS     07-MAR-07 COMPLETED      PER EVENT          6    2    4
64560  02-MAR-07 171137  DELL INSPIRON LAPTOP      UNIV      12-MAR-07 COMPLETED      PER EVENT         10    3    7
64564  02-MAR-07 171516  APPLE: MACBOOK PRO        FL/PD     09-MAR-07 COMPLETED      PER EVENT          7    0    7
64565  02-MAR-07 171706  DELL MONITOR              FL/PD     08-MAR-07 COMPLETED      PER EVENT          6    0    6
64572  05-MAR-07 175231  NEXSAN: SATABEAST 42*500  FL/CD/REX 08-MAR-07 COMPLETED      PER EVENT          3    0    3
64574  06-MAR-07 176595  IBM: 8687-3RX             FL/CD/CSS 09-MAR-07 COMPLETED      TRADITIONAL/PRE    3    0    3
64579  06-MAR-07 177780  XEROX: 8400/N             FL/PD     09-MAR-07 COMPLETED      PER EVENT          3    0    3
64595  07-MAR-07 178735  ASA: D-X-3060-1U-RM       FL/CD     07-MAR-07 COMPLETED      NORMAL             0    0    0
64598  07-MAR-07 178818  APPLE POWERBOOK G4        FL/PD     09-MAR-07 COMPLETED      PER EVENT          2    1    1
64616  07-MAR-07 179912  DELL POWEREDGE SERVER     FL/PD     22-MAR-07 COMPLETED      PER EVENT         15    9    6
64620  08-MAR-07 180571  DELL: LATITUDE-D600       FL/CD/CSS 14-MAR-07 COMPLETED      PER EVENT          6    0    6
64621  08-MAR-07 180633  APPLE: A1150-1830         FL/CD/CSS 23-MAR-07 COMPLETED      PER EVENT         15    0   15
64622  08-MAR-07 181212  HP: C4121A                FL/AD     14-MAR-07 COMPLETED      PER EVENT          6    0    6
64632  09-MAR-07 183500  ASA: D-X-3060-8TB-5U      FL/CD     19-MAR-07 COMPLETED      NORMAL            10    0   10
64636  09-MAR-07 183966  ASA: D-X-3060-8TB-5U      FL/CD/REX 16-MAR-07 COMPLETED      NORMAL             7    0    7
64637  09-MAR-07 184005  ASA: D-X-3060-8TB-5U      FL/CD/REX 16-MAR-07 COMPLETED      NORMAL             7    0    7
64641  10-MAR-07 185700  HP: C4267A                FL/LS     20-MAR-07 COMPLETED      PER EVENT          8    4    4
64642  12-MAR-07 185852  DELL: LAT-C800-850        FL/AD     12-MAR-07 COMPLETED      PER EVENT          0    0    0
64644  12-MAR-07 185996  IBM: 8687-3RX             FL/CD/CSS 23-MAR-07 COMPLETED      TRADITIONAL/PRI   11    0   11

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
64645  12-MAR-07 186252  DELL: PREC670-3000        FL/CD/CEP 19-MAR-07 COMPLETED      PER EVENT PRIOR    7    0    7
64646  12-MAR-07 186561  INFORTREND: ESA16F-G1A2   FL/CD/CMS 16-MAR-07 COMPLETED      PER EVENT          4    0    4
64647  12-MAR-07 186583  DELL: PREC380N            FL/FE     16-MAR-07 COMPLETED      PER EVENT          4    0    4
64654  13-MAR-07 187682  XEROX PHASER PRINTER      FL/AD     16-MAR-07 COMPLETED      PER EVENT          3    1    2
64659  14-MAR-07 190301  INFORTREND: ESA16F-R1A2   FL/CD/CSS 16-MAR-07 COMPLETED      PER EVENT          2    0    2
64662  14-MAR-07 190669  DELL: LATITUDE-D810       FL/CD     19-MAR-07 COMPLETED      PER EVENT          5    0    5
64668  14-MAR-07 192188  DELL: LATITUDE-D820       FL/PD     16-MAR-07 COMPLETED      PER EVENT          1    0    1
64671  15-MAR-07 192398  ASA: D-X-3000-MT          FL/CD/CCF 29-MAR-07 COMPLETED      NORMAL            14    0   14
64672  15-MAR-07 192833  ASA: 8*500-3U-RM          FL/CD/REX 05-APR-07 COMPLETED      NORMAL            21    0   21
64674  15-MAR-07 193383  DELL: XPS-T500-MT         FL/CD     22-MAR-07 COMPLETED      PER EVENT          7    4    3
64676  16-MAR-07 194591  DELL OPTIPLEX GX280       FL/PD     22-MAR-07 COMPLETED      PER EVENT          6    0    6
64677  16-MAR-07 194723  APPLE POWERBOOK G4        FL/PD     21-MAR-07 COMPLETED      PER EVENT          5    0    5
64682  19-MAR-07 197411  ASA: D-X-3060-1U-RM       FL/CD     20-MAR-07 COMPLETED      NORMAL             1    0    1
64683  19-MAR-07 197604  INFORTREND: ESA16F-R1A2   FL/CD/CSS 22-MAR-07 COMPLETED      PER EVENT          3    0    3
64686  19-MAR-07 197705  DELL: SML-4               FL/CD     22-MAR-07 COMPLETED      PER EVENT          3    0    3
64687  19-MAR-07 197746  DELL OPTIPLEX GX280       FL/PD     21-MAR-07 COMPLETED      PER EVENT          2    0    2
64695  20-MAR-07 200007  DELL DIMENSION SERIES     FL/LS     22-MAR-07 COMPLETED      PER EVENT          2    0    2
64696  20-MAR-07 200161  DELL: LAT-X300-1200       FL/CD/CSS 02-APR-07 COMPLETED      PER EVENT         13    4    9
64697  20-MAR-07 200445  ASA: D-X-3060-8TB-5U      FL/CD     29-MAR-07 COMPLETED      NORMAL             9    0    9
64698  20-MAR-07 200567  XEROX PHASER PRINTER      FL/AD     22-MAR-07 COMPLETED      PER EVENT          2    0    2
64703  21-MAR-07 201529  XEROX: 8200/DP            FL/AD     21-MAR-07 COMPLETED      PER EVENT          0    0    0
64704  21-MAR-07 201557  SUN MS: E450-REFURB       FL/AD     22-MAR-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64705  21-MAR-07 201806  XEROX: 8200/N             EXP/D0    23-MAR-07 COMPLETED      TRADITIONAL/BAS    2    0    2
64708  21-MAR-07 202267  ASA: D-OPT270DC-1U-RM     FL/CD/CMS 02-APR-07 COMPLETED      NORMAL            12    0   12
64710  21-MAR-07 203526  POLYWELL: PLY-935X8       EXP/E898/ 29-MAR-07 COMPLETED      PER EVENT          7    0    7
64713  21-MAR-07 203714  DELL: PREC670             FL/PD     27-MAR-07 COMPLETED      PER EVENT          5    0    5
64720  22-MAR-07 204850  DELL: LATITUDE-X300       FL/DI     02-APR-07 COMPLETED      PER EVENT         11    3    8
64725  23-MAR-07 206296  TOSH: LAPTOP              UNIV/BROW 19-APR-07 COMPLETED      PER EVENT         27   10   17
64732  26-MAR-07 208208  HP: C4087A                FL/PD     26-MAR-07 COMPLETED      PER EVENT          0    0    0
64735  26-MAR-07 208516  DELL: LATITUDE-D620-2000  FL/CD     02-APR-07 COMPLETED      PER EVENT          7    6    1
64737  26-MAR-07 209438  SUN MS: 602-2636-03       FL/CD     05-APR-07 COMPLETED      PER EVENT         10    0   10
64738  26-MAR-07 209467  NEXSAN: ATABEAST 42*400   FL/CD     05-APR-07 COMPLETED      PER EVENT         10    6    4
64762  29-MAR-07 215082  XEROX PHASER PRINTER      FL/AD     29-MAR-07 COMPLETED      PER EVENT          0    0    0
64766  29-MAR-07 215312  HP: C3167A                FL/AD     29-MAR-07 COMPLETED      PER EVENT          0    0    0
64769  30-MAR-07 217175  ACECOMP: P4-1700          FL/AD     30-MAR-07 COMPLETED      PER EVENT          0    0    0
64773  30-MAR-07 217596  XEROX PHASER PRINTER      FL/AD     30-MAR-07 COMPLETED      PER EVENT          0    0    0
64775  30-MAR-07 217704  SUN MS: 600-6514-01       FL/CD     04-APR-07 COMPLETED      TRADITIONAL/BAS    5    0    5
64777  30-MAR-07 218071  HP: C3167A                FL/AD     04-APR-07 COMPLETED      PER EVENT          5    0    5
64793  02-APR-07 219559  DELL: LATITUDE-D800       FL/FE     06-APR-07 COMPLETED      NORMAL             4    0    4
64795  02-APR-07 219783  MONARCH: 4*OPT-4U-RM      FL/PD     16-APR-07 COMPLETED      PER EVENT         14    7    7
64796  02-APR-07 219809  THINKCOMP: D-X-3200-2U-RM FL/CD     06-APR-07 COMPLETED      PER EVENT          4    0    4
64801  02-APR-07 221643  CONCENT: 2*X-3060-6TB-5U- FL/CD     25-APR-07 COMPLETED      PER EVENT         22    0   22
64808  03-APR-07 221909  HP: C4267A                FL/PD     04-APR-07 COMPLETED      PER EVENT          1    0    1
64818  04-APR-07 223760  DELL: LATITUDE-D610       FL/PD     06-APR-07 COMPLETED      PER EVENT          2    0    2
64822  04-APR-07 224237  DELL: LATITUDE-D810       FL/CD     06-APR-07 COMPLETED      PER EVENT          2    0    2
64829  05-APR-07 225486  DEC ALPHASERVER 4100      EXP/E832/ 06-APR-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64830  05-APR-07 225512  POLYWELL: D-P3-RAID       FL/CD     10-APR-07 COMPLETED      PER EVENT          5    0    5
64831  05-APR-07 230585  XEROX PHASER PRINTER      FL/AD     13-APR-07 COMPLETED      PER EVENT          8    0    8
64835  06-APR-07 227473  ACECOMP: ATHLON-1200-MT   FL/CD     09-APR-07 COMPLETED      PER EVENT          3    0    3
64836  06-APR-07 227522  SUN MS: E450-REFURB       FL/AD     10-APR-07 COMPLETED      TRADITIONAL/BAS    4    0    4
64839  06-APR-07 228046  SUN MS: ENT420R           FL/CD     09-APR-07 COMPLETED      TRADITIONAL/PRI    3    0    3
64846  09-APR-07 229916  ASA: D-X-2800-RM-2U       FL/CD     19-APR-07 COMPLETED      NORMAL            10    9    1
64847  09-APR-07 230136  DELL: PREC380N-3200       FL/CD     11-APR-07 COMPLETED      PER EVENT          2    0    2
64848  09-APR-07 230425  HP: C4216A                FL/CD     09-APR-07 COMPLETED      PER EVENT          0    0    0
64849  09-APR-07 230811  THINKCOMP: D-X-3200-2U-RM FL/CD     13-APR-07 COMPLETED      PER EVENT          4    0    4
64851  09-APR-07 230951  SUN MS: E450-REFURB       FL/AD     12-APR-07 COMPLETED      TRADITIONAL/BAS    3    0    3
64852  09-APR-07 231084  HP LASERJET               FL/DI     13-APR-07 COMPLETED      PER EVENT          4    0    4
64853  09-APR-07 231102  ASA: 12*500-3U-RM         FL/CD     20-APR-07 COMPLETED      NORMAL            11    0   11
64857  10-APR-07 232160  INFORTREND: ESA16F-R1A2   FL/CD     12-APR-07 COMPLETED      PER EVENT          2    0    2
64859  10-APR-07 232606  HP: C3167A                FL/LS     12-APR-07 COMPLETED      PER EVENT          2    0    2
64861  10-APR-07 232637  ASA: 12*500-3U-RM         FL/CD     20-APR-07 COMPLETED      NORMAL            10    0   10
64862  10-APR-07 232709  HP: C2009A                FL/FI     11-APR-07 COMPLETED      PER EVENT          1    0    1
64864  10-APR-07 232935  KOI: P4-2600-MT           EXP/D0    12-APR-07 COMPLETED      PER EVENT          2    1    1
64870  11-APR-07 234887  HP: C4087A                FL/PD     12-APR-07 COMPLETED      PER EVENT          1    0    1
64871  11-APR-07 234998  ASA: D-X-3060-8TB-5U      FL/CD     25-APR-07 COMPLETED      NORMAL            14    6    8
64876  12-APR-07 237595  MICRON CLIENTPRO          FL/PD     13-APR-07 COMPLETED      PER EVENT          1    0    1
64884  13-APR-07 239134  DELL: LATITUDE-D620       FL/DI     18-APR-07 COMPLETED      PER EVENT          5    0    5

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
64885  13-APR-07 240371  DELL: PE2650-DX-2400      FL/CD/CMS 17-APR-07 COMPLETED      PER EVENT          4    0    4
64886  13-APR-07 241788  THINKCOMP: D-X-3200-2U-RM FL/CD     30-APR-07 COMPLETED      PER EVENT         14    0   14
64889  16-APR-07 241849  DELL: GX620-3000-MT       FL/CD     17-APR-07 COMPLETED      PER EVENT PRIOR    1    0    1
64890  16-APR-07 241907  DELL: LATITUDE-D410       FL/DI     18-APR-07 COMPLETED      PER EVENT          2    0    2
64893  16-APR-07 242083  HP: C4267A                FL/PD     17-APR-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64901  17-APR-07 243831  HP: C8521A                FL/PD     17-APR-07 COMPLETED      PER EVENT          0    0    0
64902  17-APR-07 244021  ASA: D-X-3060-1U-RM       FL/CD     17-APR-07 COMPLETED      NORMAL             0    0    0
64903  17-APR-07 244271  THINKCOMP: D-X-3200-2U-RM FL/CD     30-APR-07 COMPLETED      PER EVENT         13    0   13
64904  17-APR-07 244975  XEROX: 8550/DP            FL/PD     23-APR-07 COMPLETED      PER EVENT          6    0    6
64907  18-APR-07 247125  DELL: PREC340             FL/FE     19-APR-07 COMPLETED      PER EVENT          1    0    1
64908  18-APR-07 247308  HP LASERJET               FL/DI     19-APR-07 COMPLETED      PER EVENT          1    0    1
64910  18-APR-07 247492  THINKCOMP: D-X-3200-2U-RM FL/CD     17-MAY-07 COMPLETED      PER EVENT         29    0   29
64911  18-APR-07 247531  THINKCOMP: D-X-3200-2U-RM FL/CD     30-APR-07 COMPLETED      PER EVENT         12    0   12
64914  19-APR-07 248890  DELL: LATITUDE-D410       FL/DI     26-APR-07 COMPLETED      PER EVENT          7    0    7
64915  19-APR-07 248917  ASA: D-X-3060-1U-RM       FL/CD     19-APR-07 COMPLETED      NORMAL             0    0    0
64916  19-APR-07 249257  XEROX: 8500/DN            FL/ES     24-APR-07 COMPLETED      PER EVENT          5    0    5
64917  19-APR-07 249317  DELL PRECISION WORKSTATIO FL/PD     26-APR-07 COMPLETED      PER EVENT          7    0    7
64919  19-APR-07 250028  DELL: DIM-4100-933        FL/ES     24-APR-07 COMPLETED      PER EVENT          5    0    5
64926  20-APR-07 251728  HP: C9661A                FL/CD     23-APR-07 COMPLETED      PER EVENT          3    0    3
64932  23-APR-07 254189  DELL: INSP-8600           FL/PD/CMS 27-APR-07 COMPLETED      PER EVENT          4    2    2
64935  23-APR-07 255334  TOSH: LAPTOP              FL/CD     27-APR-07 COMPLETED      PER EVENT          4    2    2
64940  24-APR-07 257367  XEROX: 8550/DP            FL/CD     01-MAY-07 COMPLETED      PER EVENT          7    0    7
64947  24-APR-07 258295  KOI: P4-3000-MT           FL/CD/CMS 25-APR-07 COMPLETED      TRADITIONAL/BAS    0    0    0
64950  24-APR-07 258317  ASA: D-X-3060-1U-RM       FL/CD     01-MAY-07 COMPLETED      NORMAL             6    0    6
64951  24-APR-07 258377  ASA: D-X-3060-1U-RM       FL/CD     01-MAY-07 COMPLETED      NORMAL             6    0    6
64952  24-APR-07 258388  ASA: D-X-3060-1U-RM       FL/CD     01-MAY-07 COMPLETED      PER EVENT          6    0    6
64953  24-APR-07 258458  THINKCOMP: D-X-3200-2U-RM FL/CD     01-JUN-07 COMPLETED      PER EVENT         37   16   21
64956  25-APR-07 258619  SUN MS: ENT4500           EXP/D0    26-APR-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64959  25-APR-07 259452  CONCENT: 2*X-2800-5TB-5U  FL/CD/SCP 01-JUN-07 COMPLETED      PER EVENT         37   25   12
64960  25-APR-07 259491  INFORTREND: ESA16F-G1A2   FL/CD/CMS 01-MAY-07 COMPLETED      PER EVENT          6    0    6
64961  25-APR-07 259528  THINKCOMP: D-X-3200-2U-RM FL/CD     01-JUN-07 COMPLETED      PER EVENT         37   15   22
64962  25-APR-07 259555  DEC: DA-292FD-AA          EXP/E832/ 26-APR-07 COMPLETED      TRADITIONAL/BAS    1    0    1
64966  26-APR-07 260285  HP: C4216A                FL/FE     26-APR-07 COMPLETED      PER EVENT          0    0    0
64970  26-APR-07 261298  SUN MS: GDM-20D10         FL/TD     02-MAY-07 COMPLETED      TRADITIONAL/BAS    6    0    6
64980  30-APR-07 265237  DELL: PREC370N            FL/CD     01-MAY-07 COMPLETED      PER EVENT          1    0    1
64984  30-APR-07 265478  ASA: D-X-3060-1U-RM       FL/CD     04-MAY-07 COMPLETED      NORMAL             4    0    4
64990  30-APR-07 265936  IBM: 2647-AEU             FL/PD     04-MAY-07 COMPLETED      PER EVENT          4    0    4
64991  30-APR-07 266018  ASA: D-X-3060-8TB-5U      FL/CD     04-MAY-07 COMPLETED      NORMAL             4    0    4
64993  30-APR-07 266149  HP: C3167A                FL/AD     01-MAY-07 COMPLETED      PER EVENT          1    0    1
64994  30-APR-07 266188  XEROX: 6250/DP            FL/AD     02-MAY-07 COMPLETED      PER EVENT          2    0    2
65000  01-MAY-07 267310  SUN MS: 600-6514-01       FL/CD     03-MAY-07 COMPLETED      TRADITIONAL/BAS    2    2   -0
65004  01-MAY-07 268147  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 02-MAY-07 COMPLETED      NORMAL             1    0    1
65009  02-MAY-07 269226  DELL: LAT-D420-1060       FL/CD     04-MAY-07 COMPLETED      PER EVENT          2    0    2
65012  02-MAY-07 269610  THINKCOMP: D-X-3200-2U-RM FL/CD     01-JUN-07 COMPLETED      PER EVENT         30   15   15
65013  02-MAY-07 270150  KOI: P4-2600-MT           FL/CD     04-MAY-07 COMPLETED      PER EVENT          2    0    2
65014  02-MAY-07 269834  SONY: VAIO LAPTOP         FL/CD     07-MAY-07 COMPLETED      PER EVENT          5    4    1
65015  02-MAY-07 270172  DELL: LATITUDE-D810       FL/CD     03-MAY-07 COMPLETED      PER EVENT          1    0    1
65016  02-MAY-07 270245  SAMSUNG MONITOR           FL/PD     14-MAY-07 COMPLETED      PER EVENT         12    0   12
65021  03-MAY-07 271730  INFORTREND: ESA16F-G1A2   FL/CD/CMS 07-MAY-07 COMPLETED      PER EVENT          4    0    4
65023  03-MAY-07 272357  ATIPA: D-P3-1000-2U-RM    FL/CD     15-MAY-07 COMPLETED      PER EVENT         12    6    6
65027  04-MAY-07 273881  DELL OPTIPLEX             FL/PD     07-MAY-07 COMPLETED      PER EVENT          3    0    3
65031  07-MAY-07 275985  DELL: LAT-D500-1400       FL/CD     08-MAY-07 COMPLETED      PER EVENT          1    0    1
65035  07-MAY-07 276423  DELL: INSP-5160           FL/PD     08-MAY-07 COMPLETED      PER EVENT          1    0    1
65041  08-MAY-07 277660  XEROX: 8550/DX            FL/PD/CDF 10-MAY-07 COMPLETED      PER EVENT          2    0    2
65044  08-MAY-07 278135  VALINUX: STARTX MP        FL/CD     09-MAY-07 COMPLETED      PER EVENT          1    0    1
65051  09-MAY-07 281089  SUN MS: NETRA X1          FL/CD     31-MAY-07 COMPLETED      PER EVENT         22    1   21
65054  10-MAY-07 281842  PC-CLONE                  FL/BS     10-MAY-07 COMPLETED      PER EVENT PRIOR    0    0    0
65056  10-MAY-07 282809  THINKCOMP: D-X-3060-2U-RM FL/CD/CMS 29-MAY-07 COMPLETED      PER EVENT         19    5   14
65059  11-MAY-07 283928  DELL: PREC670-3000        FL/CD     18-MAY-07 COMPLETED      PER EVENT          7    0    7
65063  11-MAY-07 284970  XEROX PHASER PRINTER      FL/AD     16-MAY-07 COMPLETED      PER EVENT          5    0    5
65070  14-MAY-07 287008  DELL: PREC380N-3600       FL/CD     13-JUN-07 COMPLETED      PER EVENT         30    8   22
65076  15-MAY-07 289344  THINKCOMP: D-X-3200-2U-RM FL/CD     29-MAY-07 COMPLETED      PER EVENT         14    0   14
65077  15-MAY-07 289404  THINKCOMP: D-X-3200-2U-RM FL/CD     01-JUN-07 COMPLETED      PER EVENT         17    0   17
65078  15-MAY-07 289439  DELL: DIM-3000-3000       EXP/CDF   18-MAY-07 COMPLETED      PER EVENT          3    0    3
65081  16-MAY-07 290550  HP: Q3943A#ABA            FL/BS     23-MAY-07 COMPLETED      PER EVENT          7    0    7
65084  16-MAY-07 290870  HP: C7063A                FL/BS     17-MAY-07 COMPLETED      PER EVENT          1    0    1
65088  17-MAY-07 292366  ASA: D-X-3600-2U-RM       FL/CD     23-MAY-07 COMPLETED      NORMAL             6    0    6

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65090  17-MAY-07 292645  MICRON MILL-MAX 400       FL/BS     18-MAY-07 COMPLETED      PER EVENT          1    0    1
65091  17-MAY-07 292706  HP: C4121A                FL/AD     17-MAY-07 COMPLETED      PER EVENT          0    0    0
65099  18-MAY-07 294600  HP: C8547A                FL/FE     21-MAY-07 COMPLETED      PER EVENT          3    0    3
65102  21-MAY-07 296895  ACECOMP: P4-2600-MT       FL/CD     21-MAY-07 COMPLETED      PER EVENT          0    0    0
65105  22-MAY-07 298738  DELL: PREC380N-3600       FL/CD     25-MAY-07 COMPLETED      PER EVENT          3    0    3
65109  23-MAY-07 301875  DELL PRECISION WORKSTATIO FL/PD     30-MAY-07 COMPLETED      PER EVENT          7    5    2
65111  24-MAY-07 302678  DELL: LAT-D420-1060       FL/CD     06-JUN-07 COMPLETED      PER EVENT         13    7    6
65112  24-MAY-07 302849  DELL OPTIPLEX GX260       FL/PD     01-JUN-07 COMPLETED      PER EVENT          8    7    1
65113  24-MAY-07 302968  HP: C8547A                FL/FE     25-MAY-07 COMPLETED      PER EVENT          1    0    1
65116  24-MAY-07 303721  NEXSAN: SATABLADE-8*250G  FL/CD     30-MAY-07 COMPLETED      PER EVENT          6    0    6
65119  24-MAY-07 304596  HP: C4267A                EXP/D0    30-MAY-07 COMPLETED      TRADITIONAL/BAS    5    0    5
65122  25-MAY-07 304904  ASA: D-X-3060-1U-RM       FL/CD     25-MAY-07 COMPLETED      NORMAL             0    0    0
65123  25-MAY-07 305140  DELL: PREC380N-2800       FL/CD     01-JUN-07 COMPLETED      PER EVENT          7    0    7
65124  25-MAY-07 305161  DELL: PREC380N-2800       FL/CD     01-JUN-07 COMPLETED      PER EVENT          7    0    7
65126  25-MAY-07 306932  HP: C8547A                FL/FE     29-MAY-07 COMPLETED      PER EVENT          0    0    0
65129  29-MAY-07 307245  HP: C4216A                FL/CD     29-MAY-07 COMPLETED      PER EVENT          0    0    0
65137  30-MAY-07 309383  POLYWELL CPU BOX          UNIV      06-JUN-07 COMPLETED      PER EVENT          7    0    7
65148  01-JUN-07 312926  DELL: LAT-C840-1600       FL/CD     04-JUN-07 COMPLETED      PER EVENT          3    0    3
65149  01-JUN-07 312985  DELL: LAT-D600-1600       FL/CD     05-JUN-07 COMPLETED      PER EVENT          4    0    4
65151  01-JUN-07 315076  INFORTREND: ESA16FR1211M2 FL/CD     05-JUN-07 COMPLETED      PER EVENT          4    0    4
65152  01-JUN-07 313471  NEXSAN: SATABOY-14*500G   FL/CD     11-JUN-07 COMPLETED      PER EVENT         10    0   10
65154  01-JUN-07 313785  DEC ALPHASERVER 4100      EXP/E832/ 06-JUN-07 COMPLETED      TRADITIONAL/BAS    5    0    5
65155  04-JUN-07 315266  ASA: D-X-2800-RM-2U       FL/CD     11-JUN-07 COMPLETED      NORMAL             7    0    7
65156  04-JUN-07 315408  DELL: LATITUDE-D800       FL/CD     08-JUN-07 COMPLETED      PER EVENT          4    0    4
65158  04-JUN-07 315555  XEROX: 6200DP             FL/PD     04-JUN-07 COMPLETED      PER EVENT          0    0    0
65160  04-JUN-07 316878  HP: C3167A                FL/AD     05-JUN-07 COMPLETED      PER EVENT          0    0    0
65161  04-JUN-07 316914  INFORTREND: ESA16F-R1A2   FL/CD     08-JUN-07 COMPLETED      PER EVENT          3    0    3
65164  05-JUN-07 317543  HP LASERJET 4000SE        FL/ES     06-JUN-07 COMPLETED      PER EVENT          1    0    1
65165  05-JUN-07 317559  HP: Q2434A                FL/CD     06-JUN-07 COMPLETED      PER EVENT          1    0    1
65167  05-JUN-07 317626  DELL: LATITUDE-D820       FL/CD     07-JUN-07 COMPLETED      PER EVENT          2    0    2
65169  05-JUN-07 317906  DELL: DIM-4500            FL/ES     08-JUN-07 COMPLETED      PER EVENT          3    0    3
65170  05-JUN-07 318047  XEROX: 8550/DP            FL/CD     11-JUN-07 COMPLETED      PER EVENT          6    0    6
65173  06-JUN-07 319328  XEROX: 8400/N             FL/PD     07-JUN-07 COMPLETED      PER EVENT          1    0    1
65176  06-JUN-07 320137  SUN MS: 602-2844-01       FL/CD     06-SEP-07 COMPLETED      TRADITIONAL/BAS   92   14   78
65178  07-JUN-07 321023  DELL: GX270-2800          FL/PD     12-JUN-07 COMPLETED      PER EVENT          5    0    5
65180  07-JUN-07 322013  SAMSUNG MONITOR           FL/PD     18-JUN-07 COMPLETED      PER EVENT         11    0   11
65181  07-JUN-07 322170  MONITOR                   FL/CD     12-JUN-07 COMPLETED      PER EVENT          5    0    5
65182  08-JUN-07 323073  DELL: SML-4               FL/CD     14-JUN-07 COMPLETED      TRADITIONAL/BAS    6    0    6
65184  11-JUN-07 325370  DELL: LATITUDE-D410       FL/DI     22-JUN-07 COMPLETED      PER EVENT         11    0   11
65188  11-JUN-07 325994  XEROX PHASER PRINTER      FL/PD     13-JUN-07 COMPLETED      PER EVENT          2    0    2
65189  11-JUN-07 326062  SONY: VAIO LAPTOP         FL/CD     14-JUN-07 COMPLETED      PER EVENT          3    2    1
65192  12-JUN-07 327212  DELL: LATITUDE-D820       FL/CD     13-JUN-07 COMPLETED      PER EVENT          1    0    1
65200  12-JUN-07 328765  XEROX PHASER PRINTER      FL/PD     15-JUN-07 COMPLETED      PER EVENT          2    0    2
65201  13-JUN-07 329114  HP: C4267A                FL/PD     14-JUN-07 COMPLETED      TRADITIONAL/BAS    1    0    1
65202  13-JUN-07 329141  DELL: LATITUDE-D410       FL/DI     15-JUN-07 COMPLETED      PER EVENT          2    0    2
65215  13-JUN-07 330513  ASA: D-X-3060-8TB-4U      FL/CD     14-JUN-07 COMPLETED      NORMAL             0    0    0
65216  13-JUN-07 330539  ASA: D-X-3060-8TB-4U      FL/CD     19-JUN-07 COMPLETED      NORMAL             5    0    5
65218  13-JUN-07 330793  ASA: D-X-3060-8TB-4U      FL/CD     19-JUN-07 COMPLETED      NORMAL             5    0    5
65222  13-JUN-07 331112  DELL: OPTIPLEX SX270-2260 FL/CD     19-JUN-07 COMPLETED      PER EVENT          5    0    5
65223  14-JUN-07 331185  ASA: D-X-3060-1U-RM       FL/CD     20-JUN-07 COMPLETED      NORMAL             6    0    6
65224  14-JUN-07 331196  ASA: D-X-3600-2U-RM       FL/CD     20-JUN-07 COMPLETED      NORMAL             6    0    6
65225  14-JUN-07 331472  PC-CLONE: D-P3            EXP/CDF   19-JUN-07 COMPLETED      PER EVENT          5    0    5
65226  14-JUN-07 331571  APPLE POWERBOOK G4        FL/CD     25-JUL-07 COMPLETED      PER EVENT         41    6   35
65231  15-JUN-07 333192  GATEWAY CPU BOX           FL/AD     21-JUN-07 COMPLETED      PER EVENT          6    0    6
65232  18-JUN-07 335843  INFORTREND: ESA16F-G1A2   FL/CD/CMS 21-JUN-07 COMPLETED      PER EVENT          3    0    3
65233  18-JUN-07 335966  MONARCH: 4*OPT-4U-RM      FL/CD     25-JUN-07 COMPLETED      PER EVENT          7    6    1
65234  18-JUN-07 336073  ASA: D-X-2800-RM-2U       FL/CD     14-AUG-07 COMPLETED      NORMAL            57    0   57
65236  18-JUN-07 336249  ASA: D-X-3600-2U-RM       FL/CD     27-JUN-07 COMPLETED      NORMAL             9    0    9
65241  18-JUN-07 337709  INFORTREND: ESA16F-G1A2   FL/CD/CMS 27-JUN-07 COMPLETED      PER EVENT          8    0    8
65243  19-JUN-07 338777  ASA: D-X-3060-2U-RM       FL/CD/CMS 22-JUN-07 COMPLETED      PER EVENT          2    1    1
65247  20-JUN-07 339081  ASA: D-X-3060-1U-RM       FL/CD     26-JUN-07 COMPLETED      NORMAL             6    0    6
65251  20-JUN-07 339745  DELL: SML-4               FL/CD     26-JUN-07 COMPLETED      TRADITIONAL/BAS    6    0    6
65253  20-JUN-07 341096  DELL: XPS                 FL/PD     25-JUN-07 COMPLETED      PER EVENT          4    0    4
65254  21-JUN-07 341362  SUN MS: 602-2426-02       FL/CD     25-JUN-07 COMPLETED      TRADITIONAL/PRE    4    0    4
65255  21-JUN-07 341667  APPLE: M7952LL/A          FL/PD     22-JUN-07 COMPLETED      PER EVENT          1    0    1
65256  21-JUN-07 341663  XEROX: 8200/N             EXP/D0    25-JUN-07 COMPLETED      TRADITIONAL/BAS    4    0    4
65264  22-JUN-07 342992  XEROX PHASER PRINTER      FL/PD     20-JUL-07 COMPLETED      PER EVENT         28    0   28

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65265  22-JUN-07 343211  NEXSAN: ATABEAST 42*400   FL/CD     26-JUN-07 COMPLETED      PER EVENT          4    0    4
65267  22-JUN-07 343259  ASA: D-X-3600-2U-RM       FL/CD     27-JUN-07 COMPLETED      NORMAL             5    0    5
65268  22-JUN-07 343581  IBM: 2373-3HU             FL/CD     02-JUL-07 COMPLETED      PER EVENT         10    1    9
65270  22-JUN-07 343787  APPLE IMAC                FL/LS     28-JUN-07 COMPLETED      PER EVENT          6    0    6
65272  25-JUN-07 345520  SUN MS: 600-7243-01       FL/CD     26-JUN-07 COMPLETED      TRADITIONAL/PRE    1    0    1
65273  25-JUN-07 345650  DELL: LATITUDE-D620-2000  FL/CD     24-JUL-07 COMPLETED      PER EVENT         29    8   21
65274  25-JUN-07 345968  DELL: LATITUDE-X300       FL/CD     06-JUL-07 COMPLETED      PER EVENT         11    0   11
65276  25-JUN-07 346184  HP: C3167A                FL/CD     28-JUN-07 COMPLETED      PER EVENT          3    0    3
65277  25-JUN-07 346211  DELL: LATITUDE-D820       FL/PD     27-JUN-07 COMPLETED      PER EVENT          2    0    2
65279  25-JUN-07 346361  DELL: PREC370N            FL/FE     27-JUN-07 COMPLETED      PER EVENT          2    0    2
65280  25-JUN-07 346428  APPLE MAC BOOK            FL/PD     29-JUN-07 COMPLETED      PER EVENT          4    1    3
65281  25-JUN-07 346472  DELL: LATITUDE-D800       FL/CD     27-JUN-07 COMPLETED      PER EVENT          2    0    2
65288  26-JUN-07 348411  HP: C4267A                FL/PD     06-JUL-07 COMPLETED      PER EVENT         10    4    6
65293  27-JUN-07 349479  HP LASERJET               FL/BS     02-JUL-07 COMPLETED      PER EVENT          5    0    5
65298  27-JUN-07 349865  APPLE: A1150-2000         FL/CD     29-JUN-07 COMPLETED      PER EVENT          2    0    2
65303  28-JUN-07 351226  DELL CPU BOX              FL/PD/CDF 05-JUL-07 COMPLETED      PER EVENT          7    0    7
65304  28-JUN-07 351714  ASA: D-X-3060-1U-RM       FL/CD     29-JUN-07 COMPLETED      NORMAL             1    0    1
65305  28-JUN-07 351760  HP: Q2434A                FL/BS     09-JUL-07 COMPLETED      PER EVENT         11    7    4
65307  29-JUN-07 352542  DELL: 2405FP              FL/CD     09-JUL-07 COMPLETED      PER EVENT         10    0   10
65312  29-JUN-07 353066  HEWLETT PACKARD DISK DRIV FL/CD     10-JUL-07 COMPLETED      PER EVENT         11    0   11
65313  29-JUN-07 353194  DELL: LATITUDE-D820       FL/PD     03-JUL-07 COMPLETED      PER EVENT          4    0    4
65315  29-JUN-07 353335  DELL: INSP-5150           FL/PD     02-JUL-07 COMPLETED      NORMAL             3    0    3
65320  02-JUL-07 356112  DELL: LATITUDE-D620       FL/AD     05-JUL-07 COMPLETED      PER EVENT          3    0    3
65321  02-JUL-07 356291  DELL PRECISION WORKSTATIO FL/TD     03-JUL-07 COMPLETED      PER EVENT          1    0    1
65324  02-JUL-07 357013  HP: C4267A                FL/PD     05-JUL-07 COMPLETED      TRADITIONAL/BAS    3    0    3
65331  03-JUL-07 358302  DELL: LAT-D610-2000       FL/CD     11-JUL-07 COMPLETED      PER EVENT          8    3    5
65332  03-JUL-07 358463  HP: C3167A                FL/CD     10-JUL-07 COMPLETED      PER EVENT          7    0    7
65334  03-JUL-07 360290  ASA: D-X-3600-2U-RM       FL/CD     23-JUL-07 COMPLETED      NORMAL            18    5   13
65338  05-JUL-07 360842  HP: C4267A                EXP/D0    09-JUL-07 COMPLETED      TRADITIONAL/BAS    4    0    4
65339  05-JUL-07 361142  ASA: 8*500-3U-RM          FL/CD     11-JUL-07 COMPLETED      NORMAL             6    0    6
65340  05-JUL-07 361193  TEK: Z850/DX              FL/PD     06-JUL-07 COMPLETED      PER EVENT          1    0    1
65349  09-JUL-07 364962  HP: C4267A                FL/PD     10-JUL-07 COMPLETED      PER EVENT          1    0    1
65351  09-JUL-07 365052  HP: C4253A                FL/BS     13-JUL-07 COMPLETED      PER EVENT          4    0    4
65352  09-JUL-07 365109  DELL: OPTI GX240-1500     FL/CD     09-JUL-07 COMPLETED      PER EVENT          0    0    0
65359  10-JUL-07 367194  APPLE: A1150-2000         FL/CD     13-JUL-07 COMPLETED      PER EVENT          3    0    3
65360  10-JUL-07 367262  ETRNLGRF: D-P3-1300-ST    FL/CD     12-JUL-07 COMPLETED      PER EVENT          2    0    2
65361  10-JUL-07 367365  XEROX: 6200DP             FL/PD     12-JUL-07 COMPLETED      PER EVENT          2    0    2
65368  11-JUL-07 370009  ACER: AL1914              FL/CD     17-JUL-07 COMPLETED      PER EVENT          5    0    5
65370  11-JUL-07 370215  ASA: D-X-3200-2U-RM       FL/CD     19-JUL-07 COMPLETED      NORMAL             7    0    7
65376  12-JUL-07 370608  XEROX: 8500/DN            FL/PD     17-JUL-07 COMPLETED      PER EVENT          5    0    5
65377  12-JUL-07 370851  ASA: 7.6TB-5U-RM          FL/CD     19-JUL-07 COMPLETED      NORMAL             7    2    5
65378  12-JUL-07 371118  IBM THINKPAD              FL/CD     20-JUL-07 COMPLETED      PER EVENT          8    4    4
65380  13-JUL-07 372594  DELL: LATITUDE-C640       FL/CD     20-JUL-07 COMPLETED      PER EVENT          7    4    3
65391  16-JUL-07 374788  SUN MS: STOREDGE 3510     FL/AD     18-JUL-07 COMPLETED      TRADITIONAL/PRI    2    0    2
65392  16-JUL-07 374834  ASA: D-X-2800-RM-2U       FL/CD     19-JUL-07 COMPLETED      NORMAL             3    0    3
65393  16-JUL-07 374865  ASA: D-X-2800-RM-2U       FL/CD     19-JUL-07 COMPLETED      NORMAL             3    0    3
65398  16-JUL-07 376827  DELL: DIM-8200            FL/PD     18-JUL-07 COMPLETED      PER EVENT          1    0    1
65399  16-JUL-07 377147  HP: C7063A                FL/ES     01-AUG-07 COMPLETED      PER EVENT         15    0   15
65401  17-JUL-07 377235  ASA: D-X-3060-8TB-4U      FL/CD     20-JUL-07 COMPLETED      NORMAL             3    0    3
65404  17-JUL-07 378114  DELL: PREC670             LAB/KEK   24-JUL-07 COMPLETED      PER EVENT          7    4    3
65405  17-JUL-07 378191  ATIPA: R11-D-P3-1000-1U-R FL/CD     19-JUL-07 COMPLETED      PER EVENT          2    0    2
65406  17-JUL-07 378238  APPLE: MA254LL/A          FL/LS     26-JUL-07 COMPLETED      PER EVENT          9    0    9
65409  18-JUL-07 379378  DELL: PREC670             FL/TD     28-AUG-07 COMPLETED      PER EVENT         41    0   41
65413  18-JUL-07 379857  DELL: LAT-D600-1400       FL/CD     20-JUL-07 COMPLETED      PER EVENT          2    0    2
65414  18-JUL-07 379888  NEXSAN: ATABEAST 42*400   FL/CD     25-JUL-07 COMPLETED      PER EVENT          7    0    7
65418  18-JUL-07 380362  XEROX: 8200/N             EXP/D0    20-JUL-07 COMPLETED      TRADITIONAL/BAS    2    0    2
65421  19-JUL-07 381080  SUN MS: STOREDGE 3510     FL/AD     20-JUL-07 COMPLETED      TRADITIONAL/PRI    1    0    1
65423  19-JUL-07 381314  APPLE: A1211-2160         FL/CD/SCF 26-JUL-07 COMPLETED      PER EVENT          7    0    7
65427  19-JUL-07 381793  DELL: PREC340             FL/FE     27-JUL-07 COMPLETED      PER EVENT          8    5    3
65428  19-JUL-07 381823  SUN MS: ENT4500           FL/CD     24-JUL-07 COMPLETED      TRADITIONAL/PRE    5    3    2
65435  20-JUL-07 383099  DELL: LATITUDE-D620-2000  FL/CD     03-AUG-07 COMPLETED      PER EVENT         14    0   14
65436  20-JUL-07 383119  SUN MS: 602-2426-02       FL/CD     24-JUL-07 COMPLETED      TRADITIONAL/PRE    4    2    2
65438  20-JUL-07 383691  SUN MS: ENT450            FL/AD     23-JUL-07 COMPLETED      TRADITIONAL/BAS    3    0    3
65444  23-JUL-07 386014  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 15-AUG-07 COMPLETED      NORMAL            23    5   18
65446  23-JUL-07 386279  DELL: PREC340-2400        FL/CD     31-JUL-07 COMPLETED      PER EVENT          8    0    8
65449  23-JUL-07 387568  ASA: 7.6TB-5U-RM          FL/CD     26-JUL-07 COMPLETED      NORMAL             2    0    2
65450  24-JUL-07 387646  SUN MS: 602-2426-02       FL/CD     27-JUL-07 COMPLETED      TRADITIONAL/PRE    3    0    3

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65455  24-JUL-07 387898  ASA: D-X-3600-2U-RM       FL/CD     01-AUG-07 COMPLETED      NORMAL             8    0    8
65465  25-JUL-07 390199  APPLE: MAC PRO            FL/ES     31-JUL-07 COMPLETED      PER EVENT          6    0    6
65467  25-JUL-07 390542  SUN MS: SUNFIRE V210      FL/CD     27-JUL-07 COMPLETED      TRADITIONAL/PRE    2    0    2
65469  25-JUL-07 390621  GATEWAY: 450XL            FL/CD     02-AUG-07 COMPLETED      PER EVENT          8    0    8
65474  26-JUL-07 391950  DELL POWEREDGE 4400       FL/TD     31-JUL-07 COMPLETED      PER EVENT          5    0    5
65482  27-JUL-07 393881  DELL: 2001FP              FL/FE     03-AUG-07 COMPLETED      PER EVENT          7    0    7
65483  27-JUL-07 393937  ASA: D-OPT265DC-1U-RM     FL/CMS    08-AUG-07 COMPLETED      NORMAL            12    0   12
65485  27-JUL-07 394001  ACECOMP CPU BOX           FL/AD     09-AUG-07 COMPLETED      PER EVENT         13    0   13
65486  30-JUL-07 395677  KINGSTON: DS500-SR/B      FL/CD     06-AUG-07 COMPLETED      PER EVENT          7    0    7
65490  31-JUL-07 397799  HP: C7099A                FL/FE     01-AUG-07 COMPLETED      PER EVENT          1    0    1
65491  30-JUL-07 397828  CONCENT: 2*X-2400-1U-RM   FL/CD     31-JUL-07 COMPLETED      PER EVENT          0    0    0
65499  01-AUG-07 401022  XEROX: 8200/N             EXP/D0    02-AUG-07 COMPLETED      TRADITIONAL/BAS    1    0    1
65501  01-AUG-07 401762  HP: C3167A                FL/FE     02-AUG-07 COMPLETED      PER EVENT          0    0    0
65502  01-AUG-07 401790  ASA: D-X-3060-1U-RM       FL/CD     03-AUG-07 COMPLETED      NORMAL             1    0    1
65504  02-AUG-07 402088  HP: C7099A                FL/FE     07-AUG-07 COMPLETED      PER EVENT          5    0    5
65506  02-AUG-07 402394  HP LASERJET               FL/LS     08-AUG-07 COMPLETED      PER EVENT          6    0    6
65508  02-AUG-07 402722  DELL: PREC510-D-P4-1500   FL/PD     09-AUG-07 COMPLETED      PER EVENT          7    1    6
65510  02-AUG-07 402916  TEK: Z850/DX              FL/PD     07-AUG-07 COMPLETED      PER EVENT          5    0    5
65519  03-AUG-07 404476  HP: C4087A                FL/CD     08-AUG-07 COMPLETED      PER EVENT          5    0    5
65522  06-AUG-07 406103  SUN MS: STOREDGE 3510     FL/AD     06-AUG-07 COMPLETED      TRADITIONAL/PRI    0    0    0
65524  06-AUG-07 406388  ACECOMP: ATHLON-1800+-MT  FL/CD     07-AUG-07 COMPLETED      PER EVENT          1    0    1
65526  06-AUG-07 406436  DELL POWEREDGE SERVER     FL/PD     10-AUG-07 COMPLETED      PER EVENT          4    1    3
65533  07-AUG-07 407509  SUN MS: 600-7882-01       FL/CD     07-AUG-07 COMPLETED      TRADITIONAL/PRE    0    0    0
65538  06-AUG-07 407625  NEXSAN: ATABEAST 42*400   FL/CD     16-AUG-07 COMPLETED      PER EVENT          9    0    9
65541  06-AUG-07 407894  DELL: OPTIPLEX SX270      FL/ES     13-AUG-07 COMPLETED      PER EVENT          6    0    6
65543  07-AUG-07 407987  NEXSAN: ATABEAST 42*400   FL/CD     16-AUG-07 COMPLETED      PER EVENT          9    0    9
65545  07-AUG-07 408631  DELL: LATITUDE-X200       FL/DI     17-AUG-07 COMPLETED      PER EVENT         10    0   10
65546  07-AUG-07 408659  ASA: SRV-D-P3-1400-4U-RM  FL/CD     15-AUG-07 COMPLETED      PER EVENT          8    0    8
65553  08-AUG-07 410509  IBM THINKPAD              FL/PD     14-AUG-07 COMPLETED      PER EVENT          6    0    6
65554  08-AUG-07 410588  DELL: DIM-8200            FL/PD     15-AUG-07 COMPLETED      PER EVENT          7    0    7
65555  08-AUG-07 410625  ASA: D-OPT265DC-1U-RM     FL/CD     17-AUG-07 COMPLETED      NORMAL             9    0    9
65557  08-AUG-07 410729  HP: C4086A                EXP/D0    12-SEP-07 COMPLETED      PER EVENT         35    0   35
65558  09-AUG-07 411535  APPLE POWERBOOK G4        FL/CD     20-AUG-07 COMPLETED      PER EVENT         11    0   11
65559  09-AUG-07 411621  HP LASERJET               FL/FE     13-AUG-07 COMPLETED      PER EVENT          4    0    4
65560  09-AUG-07 411657  XEROX: 8400/N             FL/PD     20-AUG-07 COMPLETED      PER EVENT         11    0   11
65567  09-AUG-07 412099  DELL: LATITUDE-D820       FL/PD     14-AUG-07 COMPLETED      PER EVENT          5    0    5
65568  09-AUG-07 412166  DELL: PREC340             FL/PD     14-AUG-07 COMPLETED      PER EVENT          5    4    1
65569  09-AUG-07 412205  HP: C2009A                FL/FI     17-AUG-07 COMPLETED      PER EVENT          8    0    8
65579  10-AUG-07 413605  ASA: D-X-3060-1U-RM       FL/CD     13-AUG-07 COMPLETED      NORMAL             3    0    3
65580  10-AUG-07 413641  ASA: D-X-3060-1U-RM       FL/CD     13-AUG-07 COMPLETED      NORMAL             3    0    3
65585  13-AUG-07 415960  HP: C7099A                FL/FE     16-AUG-07 COMPLETED      PER EVENT          3    0    3
65594  15-AUG-07 419566  INFORTREND: ESA16F-G1A2   FL/CD     16-AUG-07 COMPLETED      PER EVENT          1    0    1
65596  15-AUG-07 419650  DELL: LATITUDE-D600       FL/PD     16-AUG-07 COMPLETED      PER EVENT          1    0    1
65599  15-AUG-07 420062  ASA: D-X-3060-1U-RM       FL/CD     16-AUG-07 COMPLETED      NORMAL             1    0    1
65604  16-AUG-07 421360  DELL: 2407WFPB            FL/ES     22-AUG-07 COMPLETED      PER EVENT          6    4    2
65605  16-AUG-07 421260  XEROX: 8550/DX            EXP/CDF   21-AUG-07 COMPLETED      PER EVENT          5    0    5
65611  16-AUG-07 421712  DELL: DIM-8200            FL/PD     17-AUG-07 COMPLETED      PER EVENT          1    0    1
65612  16-AUG-07 421816  ASA: D-OPT265DC-1U-RM     FL/CD     17-AUG-07 COMPLETED      NORMAL             1    0    1
65613  17-AUG-07 422920  DELL: DIM-4600-3000       FL/CD     21-AUG-07 COMPLETED      PER EVENT          4    0    4
65616  17-AUG-07 423054  ASA: D-OPT265DC-1U-RM     FL/CD     20-AUG-07 COMPLETED      PER EVENT          3    0    3
65617  17-AUG-07 423294  DELL OPTIPLEX GX280       FL/PD     21-AUG-07 COMPLETED      PER EVENT          4    0    4
65620  20-AUG-07 424717  HP: C4111A                FL/CD     20-AUG-07 COMPLETED      PER EVENT PRIOR    0    0    0
65622  20-AUG-07 425286  SUN MS: 595-5544-01       FL/CD     21-AUG-07 COMPLETED      TRADITIONAL/BAS    1    0    1
65623  20-AUG-07 425349  HP: C2011A                FL/DI     24-AUG-07 COMPLETED      PER EVENT          4    0    4
65624  20-AUG-07 425377  ACECOMP CPU BOX           FL/AD     28-AUG-07 COMPLETED      PER EVENT          8    7    1
65625  20-AUG-07 425541  GATEWAY: 450XL            FL/PD     22-AUG-07 COMPLETED      PER EVENT          2    0    2
65627  20-AUG-07 425616  DELL: LATITUDE-D800       FL/PD     22-AUG-07 COMPLETED      PER EVENT          2    0    2
65630  21-AUG-07 427456  APPLE POWERBOOK G4        FL/TD     07-SEP-07 COMPLETED      PER EVENT         17   15    2
65635  22-AUG-07 428966  NEXSAN: ATABEAST 42*400   FL/CD     28-AUG-07 COMPLETED      PER EVENT          6    0    6
65636  22-AUG-07 428986  APPLE POWERBOOK G4        FL/CD     23-AUG-07 COMPLETED      PER EVENT          1    0    1
65637  22-AUG-07 429111  DEC ALPHASERVER 4100      EXP/E832/ 22-AUG-07 COMPLETED      TRADITIONAL/BAS    0    0    0
65639  22-AUG-07 429250  APPLE: MACBOOK PRO        FL/PD     07-SEP-07 COMPLETED      PER EVENT         16   14    2
65646  23-AUG-07 430778  ASA: D-X-3060-8TB-4U      FL/CD     27-AUG-07 COMPLETED      NORMAL             4    0    4
65659  24-AUG-07 434495  DELL: LATITUDE-D810       FL/FE     31-AUG-07 COMPLETED      PER EVENT          4    0    4
65661  27-AUG-07 434598  GATEWAY: 450XL            FL/PD     28-AUG-07 COMPLETED      PER EVENT          1    0    1
65667  28-AUG-07 436428                            FL/PD     10-SEP-07 COMPLETED      PER EVENT         13   12    1
65668  28-AUG-07 436806  SUN MS: S20               FL/TD     31-AUG-07 COMPLETED      TRADITIONAL/BAS    3    0    3

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65669  28-AUG-07 436906  NEXSAN: ATABEAST 42*400   FL/CD     04-SEP-07 COMPLETED      PER EVENT          7    0    7
65670  28-AUG-07 437019  ASA: D-OPT265DC-1U-RM     FL/CD/SCF 30-AUG-07 COMPLETED      NORMAL             2    0    2
65676  29-AUG-07 438672  DELL DIMENSION SERIES     FL/PD     31-AUG-07 COMPLETED      PER EVENT          2    0    2
65677  29-AUG-07 438687  THINKCOMP: D-X-3200-2U-RM FL/CD     11-SEP-07 COMPLETED      PER EVENT         13    0   13
65680  29-AUG-07 440968  HP: C4267A                FL/LS     07-SEP-07 COMPLETED      PER EVENT          8    0    8
65683  30-AUG-07 441495  DELL: LATITUDE-D620-2160  FL/PD     07-SEP-07 COMPLETED      PER EVENT          8    0    8
65686  31-AUG-07 443185  HP PRINTER                FL/LS     05-SEP-07 COMPLETED      PER EVENT          5    0    5
65687  31-AUG-07 443190  ASA: D-X-3060-1U-RM       FL/CD     06-SEP-07 COMPLETED      NORMAL             6    0    6
65690  31-AUG-07 443579  DELL: LATITUDE-D800       FL/CD     10-SEP-07 COMPLETED      PER EVENT         10    0   10
65692  04-SEP-07 445211  DELL LATITUDE LAPTOP      FL/PD     07-SEP-07 COMPLETED      PER EVENT          3    0    3
65693  04-SEP-07 445263  DELL: LATITUDE-D810       FL/CD     06-SEP-07 COMPLETED      PER EVENT          2    0    2
65697  04-SEP-07 445710  DELL: LATITUDE-D620-2000  FL/BS     07-SEP-07 COMPLETED      PER EVENT          3    0    3
65699  04-SEP-07 445847  NEXSAN: SATABEAST 42*500  FL/CD     06-SEP-07 COMPLETED      PER EVENT          2    0    2
65700  04-SEP-07 446067  ASA: D-OPT265DC-1U-RM     FL/CD/SCF 02-OCT-07 COMPLETED      NORMAL            28    8   20
65701  04-SEP-07 446136  HP: C3167A                FL/FE     12-SEP-07 COMPLETED      PER EVENT          8    0    8
65703  04-SEP-07 446212  IBM CPU BOX               UNIV      14-SEP-07 COMPLETED      PER EVENT         10    0   10
65719  06-SEP-07 448852  DELL: LAT-D420-1060       FL/CD     06-SEP-07 COMPLETED      PER EVENT          0    0    0
65722  06-SEP-07 449189  ASA: D-X-2800-RM-2U       FL/CD     11-SEP-07 COMPLETED      NORMAL             5    0    5
65723  06-SEP-07 449224  SUN MS: S20               FL/TD     18-SEP-07 COMPLETED      TRADITIONAL/BAS   12    0   12
65724  06-SEP-07 449393  SUN MS: 600-6899-04       FL/CD     07-SEP-07 COMPLETED      TRADITIONAL/BAS    1    0    1
65726  07-SEP-07 450722  ASA: D-X-3060-8TB-4U      FL/CD     07-SEP-07 COMPLETED      NORMAL             0    0    0
65728  07-SEP-07 451191  HP: C7099A                FL/FE     10-SEP-07 COMPLETED      PER EVENT          3    0    3
65740  10-SEP-07 454776  SUN MS: ENT4500           EXP/CDF   18-SEP-07 COMPLETED      TRADITIONAL/BAS    7    6    1
65742  11-SEP-07 454894  DELL LATITUDE LAPTOP      FL/PD     17-SEP-07 COMPLETED      PER EVENT          6    3    3
65743  11-SEP-07 455689  DELL: DIM-4600-2600       FL/CD     14-SEP-07 COMPLETED      PER EVENT          3    0    3
65745  12-SEP-07 457351  SUN MS: GDM-20E20         FL/TD     28-SEP-07 COMPLETED      TRADITIONAL/BAS   16    0   16
65752  13-SEP-07 459101  SUN MS: S5                FL/TD     17-SEP-07 COMPLETED      TRADITIONAL/BAS    4    0    4
65763  17-SEP-07 462762  MONITOR                   FL/CD     02-OCT-07 COMPLETED      PER EVENT         15    0   15
65767  17-SEP-07 463545  NEXSAN: G1F-42100HDRG     FL/CD/SCF 21-SEP-07 COMPLETED      PER EVENT          4    0    4
65770  18-SEP-07 464825  DELL: LATITUDE-D610       FL/PD     21-SEP-07 COMPLETED      PER EVENT          3    0    3
65771  18-SEP-07 464881  DELL: LAT-X300-1200       FL/DI     19-SEP-07 COMPLETED      PER EVENT PRIOR    1    0    1
65785  19-SEP-07 466931  DELL: PREC340             FL/FE     28-SEP-07 COMPLETED      PER EVENT          9    5    4
65786  19-SEP-07 466953  DELL: PREC340             FL/FE     28-SEP-07 COMPLETED      PER EVENT          9    3    6
65787  19-SEP-07 467435  ASA: D-X-3060-1U-RM       FL/CD     26-SEP-07 COMPLETED      NORMAL             7    0    7
65789  20-SEP-07 469272  DELL: LATITUDE-X300       FL/CD     21-SEP-07 COMPLETED      PER EVENT          1    0    1
65790  20-SEP-07 469394  ETRNLGRF: P4-1700-MT      FL/CD     20-SEP-07 COMPLETED      PER EVENT          0    0    0
65791  20-SEP-07 469508  IBM THINKPAD R40          FL/PD     02-OCT-07 COMPLETED      PER EVENT         12    9    3
65797  20-SEP-07 471384  DELL: LATITUDE-D800       FL/CD     26-SEP-07 COMPLETED      PER EVENT          5    2    3
65801  21-SEP-07 471766  ASA: D-X-3060-8TB-4U      FL/CD     21-SEP-07 COMPLETED      NORMAL             0    0    0
65808  24-SEP-07 474151  IBM: 2373-3HU             FL/CD     02-OCT-07 COMPLETED      PER EVENT          8    3    5
65809  24-SEP-07 474203  DELL OPTIPLEX GX270       FL/CD     26-SEP-07 COMPLETED      PER EVENT          2    0    2
65810  24-SEP-07 474238  DELL: DIM-9100            FL/TD     27-SEP-07 COMPLETED      PER EVENT          3    0    3
65811  24-SEP-07 475438  APPLE: MACBOOK PRO        FL/TD     09-OCT-07 COMPLETED      PER EVENT         15    9    6
65813  24-SEP-07 475825  KOI: P4-3000-2U-RM        FL/CD     04-OCT-07 COMPLETED      PER EVENT         10    0   10
65817  25-SEP-07 477409  HP LASERJET               FL/BS     25-SEP-07 COMPLETED      PER EVENT          0    0    0
65824  26-SEP-07 478922  DELL: PREC380N            FL/FE     03-OCT-07 COMPLETED      PER EVENT          7    5    2
65829  27-SEP-07 480256  DELL POWEREDGE 1950       FL/CD     27-SEP-07 COMPLETED      PER EVENT          0    0    0
65830  27-SEP-07 480276  DELL PRECISION WORKSTATIO FL/DI     03-OCT-07 COMPLETED      PER EVENT          6    1    5
65833  28-SEP-07 482099  DELL: LATITUDE-D630       FL/DI     28-SEP-07 COMPLETED      PER EVENT          0    0    0
65838  28-SEP-07 482819  HP: C8547A                FL/FE     01-OCT-07 COMPLETED      PER EVENT          3    0    3
65860  02-OCT-07 486346  DELL: DIM-3000-2660       EXP/CDF   05-OCT-07 COMPLETED      PER EVENT          3    0    3
65862  02-OCT-07 486450  HP: C4267A                FL/PD     03-OCT-07 COMPLETED      PER EVENT          1    0    1
65864  02-OCT-07 486532  ASA: D-X-3600-2U-RM       FL/CD     09-OCT-07 COMPLETED      NORMAL             7    7    0
65872  03-OCT-07 488320  DELL: LAT-X300-738        FL/PD     05-OCT-07 COMPLETED      NORMAL             2    0    2
65873  03-OCT-07 488487  TEK: Z850/DX              FL/PD     08-OCT-07 COMPLETED      PER EVENT          5    0    5
65874  03-OCT-07 488544  ASA: D-X-3600-2U-RM       FL/CD     10-OCT-07 COMPLETED      NORMAL             7    0    7
65875  03-OCT-07 488563  DELL OPTIPLEX GX240       FL/PD     04-OCT-07 COMPLETED      PER EVENT          1    0    1
65884  04-OCT-07 489968  DELL: LAT-D600-1600       FL/PD     05-OCT-07 COMPLETED      PER EVENT          1    0    1
65893  05-OCT-07 491665  DELL: LATITUDE-D610       FL/PD     12-OCT-07 COMPLETED      NORMAL             7    0    7
65894  05-OCT-07 491736  XEROX: 8200/N             EXP/D0    05-OCT-07 COMPLETED      TRADITIONAL/BAS    0    0    0
65896  05-OCT-07 491870  XEROX PHASER PRINTER      FL/PD     10-OCT-07 COMPLETED      PER EVENT          5    0    5
65899  05-OCT-07 491933  ASA: D-X-3600-2U-RM       FL/CD     10-OCT-07 COMPLETED      NORMAL             5    0    5
65900  05-OCT-07 492133  HP: Q3728A                FL/ES     11-OCT-07 COMPLETED      PER EVENT          6    4    2
65904  08-OCT-07 493751  HP: C4267A                FL/PD     10-OCT-07 COMPLETED      PER EVENT          2    0    2
65905  08-OCT-07 493803  XEROX: 8400/DX            EXP/CDF   11-OCT-07 COMPLETED      TRADITIONAL/BAS    3    0    3
65906  08-OCT-07 493884  SUN MS: 600-6514-01       FL/CD     11-OCT-07 COMPLETED      TRADITIONAL/PRE    3    0    3
65907  08-OCT-07 493925  DELL: PE8450-8*P3X-700    FL/CD     11-OCT-07 COMPLETED      PER EVENT          3    1    2

d1_sla_qa.sql                        ALL Closed Jobs with adjusted times for SLA                           24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65908  08-OCT-07 494386  DELL: LAT-X300-738        FL/PD     11-OCT-07 COMPLETED      PER EVENT          3    0    3
65914  09-OCT-07 495270  ASA: D-X-3600-2U-RM       FL/CD     10-OCT-07 COMPLETED      NORMAL             1    0    1
65934  09-OCT-07 496487  ASA: D-X-3600-2U-RM       FL/CD     11-OCT-07 COMPLETED      NORMAL             2    0    2
65943  10-OCT-07 498320  HP: C4111A                FL/CD     16-OCT-07 COMPLETED      PER EVENT          6    0    6
65946  10-OCT-07 498319  DELL OPTIPLEX             FL/BS     15-OCT-07 COMPLETED      PER EVENT          5    0    5
65947  10-OCT-07 498339  DELL: LATITUDE-D620       FL/CD     18-OCT-07 COMPLETED      PER EVENT          8    0    8
65948  11-OCT-07 499568  HP: C4216A                FL/CD     15-OCT-07 COMPLETED      PER EVENT          4    0    4
65950  11-OCT-07 499736  HP: C8521A                FL/PD     12-OCT-07 COMPLETED      PER EVENT          1    0    1
65956  12-OCT-07 501176  ASA: 7.6TB-5U-RM          FL/CD     18-OCT-07 COMPLETED      NORMAL             6    0    6
65959  12-OCT-07 501416  NEXSAN: SATABLADE-8*250G  FL/CD     16-OCT-07 COMPLETED      PER EVENT          4    0    4
65964  15-OCT-07 503854  DELL: DIM-4400            UNIV/UA   18-OCT-07 COMPLETED      PER EVENT          3    0    3
65965  15-OCT-07 503993  XEROX: 8200/N             EXP/D0    18-OCT-07 COMPLETED      TRADITIONAL/BAS    3    0    3
65969  16-OCT-07 504910  DELL: OPTIPLEX 745        FL/WR/TD  19-OCT-07 COMPLETED      PER EVENT          3    0    3
65975  16-OCT-07 505536  HP: Q3943A#ABA            FL/DI     17-OCT-07 COMPLETED      PER EVENT          1    0    1
65976  16-OCT-07 505862  ASA: D-OPT265DC-1U-RM     FL/CD     22-OCT-07 COMPLETED      NORMAL             6    0    6
65980  17-OCT-07 506585  DELL: LAT-D630-T7500      FL/CD     22-OCT-07 COMPLETED      PER EVENT          5    0    5
65981  17-OCT-07 506613  ASA: D-X-3060-8TB-4U      FL/CD     17-OCT-07 COMPLETED      NORMAL             0    0    0
65989  17-OCT-07 507318  HP: C4267A                EXP/D0    18-OCT-07 COMPLETED      TRADITIONAL/BAS    1    0    1
66002  19-OCT-07 511701  HP: Q2434A                FL/FE     22-OCT-07 COMPLETED      PER EVENT          0    0    0

1493 rows selected.


d1_sla_qa.sql                  Any Closed Jobs since June 1, 2005 that exceed 18 days                      24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65700  04-SEP-07 446067  ASA: D-OPT265DC-1U-RM     FL/CD/SCF 02-OCT-07 COMPLETED      NORMAL            28    8   20
65557  08-AUG-07 410729  HP: C4086A                EXP/D0    12-SEP-07 COMPLETED      PER EVENT         35    0   35
65176  06-JUN-07 320137  SUN MS: 602-2844-01       FL/CD     06-SEP-07 COMPLETED      TRADITIONAL/BAS   92   14   78
65409  18-JUL-07 379378  DELL: PREC670             FL/TD     28-AUG-07 COMPLETED      PER EVENT         41    0   41
65234  18-JUN-07 336073  ASA: D-X-2800-RM-2U       FL/CD     14-AUG-07 COMPLETED      NORMAL            57    0   57
65226  14-JUN-07 331571  APPLE POWERBOOK G4        FL/CD     25-JUL-07 COMPLETED      PER EVENT         41    6   35
65273  25-JUN-07 345650  DELL: LATITUDE-D620-2000  FL/CD     24-JUL-07 COMPLETED      PER EVENT         29    8   21
65264  22-JUN-07 342992  XEROX PHASER PRINTER      FL/PD     20-JUL-07 COMPLETED      PER EVENT         28    0   28
65070  14-MAY-07 287008  DELL: PREC380N-3600       FL/CD     13-JUN-07 COMPLETED      PER EVENT         30    8   22
64961  25-APR-07 259528  THINKCOMP: D-X-3200-2U-RM FL/CD     01-JUN-07 COMPLETED      PER EVENT         37   15   22
64953  24-APR-07 258458  THINKCOMP: D-X-3200-2U-RM FL/CD     01-JUN-07 COMPLETED      PER EVENT         37   16   21
65051  09-MAY-07 281089  SUN MS: NETRA X1          FL/CD     31-MAY-07 COMPLETED      PER EVENT         22    1   21
64910  18-APR-07 247492  THINKCOMP: D-X-3200-2U-RM FL/CD     17-MAY-07 COMPLETED      PER EVENT         29    0   29
64801  02-APR-07 221643  CONCENT: 2*X-3060-6TB-5U- FL/CD     25-APR-07 COMPLETED      PER EVENT         22    0   22
64672  15-MAR-07 192833  ASA: 8*500-3U-RM          FL/CD/REX 05-APR-07 COMPLETED      NORMAL            21    0   21
64493  20-FEB-07 149900  APPLE MAC BOOK            FL/DI     29-MAR-07 COMPLETED      PER EVENT         37   12   25
64538  26-FEB-07 163021  XEROX PHASER PRINTER      FL/PD     26-MAR-07 COMPLETED      PER EVENT         28    5   23
64469  19-FEB-07 148747  DELL: PE2850-DX           EXP/CDF   13-MAR-07 COMPLETED      PER EVENT PRIOR   22    0   22
64422  09-FEB-07 130650  HP: C4267A                FL/PD     07-MAR-07 COMPLETED      PER EVENT         26    0   26
64180  03-JAN-07 061474  MONITOR                   FL/LS     06-FEB-07 COMPLETED      PER EVENT         34    0   34
64152  19-DEC-06 045303  ASA: D-OPT265DC-1U-RM     FL/CD/CMS 24-JAN-07 COMPLETED      NORMAL            36    9   27
64117  12-DEC-06 034251  INFORTREND: ESA16F-G1A2   FL/CD     22-JAN-07 COMPLETED      PER EVENT         41    0   41
64167  27-DEC-06 055079  ASA: 12*500-3U-RM         FL/CD/REX 16-JAN-07 COMPLETED      PER EVENT         19    0   19
63751  11-OCT-06 938410  CONCENT: 2*X-2800-5TB-5U  FL/CD/EAG 20-DEC-06 COMPLETED      PER EVENT         70    0   70
63897  02-NOV-06 972702  GATEWAY: M275XL           FL/PD     19-DEC-06 COMPLETED      PER EVENT         47   22   25
63874  30-OCT-06 965908  ASA: D-X-3060-1U-RM       FL/CD     20-NOV-06 COMPLETED      NORMAL            21    0   21
63635  26-SEP-06 914112  APPLE POWERMAC G5         FL/FE     10-NOV-06 COMPLETED      PER EVENT         45    0   45
63661  28-SEP-06 919085  ASA CPU BOX               FL/PD     24-OCT-06 COMPLETED      NORMAL            26    5   21
63652  27-SEP-06 917701  POLYWELL:524SATA          FL/CD/REX 16-OCT-06 COMPLETED      PER EVENT         19    0   19
63603  19-SEP-06 903802  INFORTREND: ESA16F-G1A2   FL/CD/CMS 13-OCT-06 COMPLETED      PER EVENT         24    0   24
63463  30-AUG-06 869691  ATIPA: 2*X-2.66G-1U-RM    FL/CD/CSS 11-OCT-06 COMPLETED      NORMAL            42    0   42
63420  25-AUG-06 862479  SONY: VGN-TX670P/B        FL/PD     04-OCT-06 COMPLETED      PER EVENT         40    6   34
63467  30-AUG-06 870510  HP LASERJET               FL/PD     25-SEP-06 COMPLETED      PER EVENT         26    0   26
63236  01-AUG-06 822498  HITACHI: CMP4201U         FL/CD     29-AUG-06 COMPLETED      PER EVENT         28    0   28
62809  01-JUN-06 624742  APPLE: A1046              FL/CD/CCF 28-JUN-06 COMPLETED      PER EVENT         27    0   27
62806  31-MAY-06 624311  APPLE POWERMAC            FL/CD     26-JUN-06 COMPLETED      PER EVENT         25    0   25
62835  02-JUN-06 627665  ASA: D-X-3060-8TB-5U      EXP/D0    21-JUN-06 COMPLETED      NORMAL            19    0   19
62565  02-MAY-06 573743  ASA: D-X-3060-2U-RM       FL/CD/CMS 23-MAY-06 COMPLETED      PER EVENT         21    0   21
62496  24-APR-06 558652  CONCENT: 2*X-2800-5TB-5U  FL/CD/EAG 17-MAY-06 COMPLETED      PER EVENT         23    0   23
62469  18-APR-06 550886  ASA: D-X-3060-1U-RM       FL/CD     08-MAY-06 COMPLETED      PER EVENT         20    0   20
62468  18-APR-06 550906  ASA: D-X-3060-1U-RM       FL/CD     08-MAY-06 COMPLETED      NORMAL            20    0   20
62235  20-MAR-06 498026  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    25-APR-06 COMPLETED      NORMAL            36    0   36
62065  01-MAR-06 463071  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    21-APR-06 COMPLETED      NORMAL            51    0   51
62092  02-MAR-06 466371  WESTERNSCI: 2*X-2.4G-1U-R FL/CD/CSS 06-APR-06 COMPLETED      PER EVENT         34    0   34
62078  02-MAR-06 464894  ASA: D-X-3060-1U-RM       FL/CD     27-MAR-06 COMPLETED      PER EVENT         25    0   25
61970  17-FEB-06 437931  DELL POWEREDGE 2850       FL/CD/CSS 09-MAR-06 COMPLETED      PER EVENT         20    0   20
61890  08-FEB-06 421851                            FL/CD     27-FEB-06 COMPLETED      PER EVENT         19    0   19
61684  13-JAN-06 377690  TEK: Z850/DP              EXP/CDF   07-FEB-06 COMPLETED      TRADITIONAL/BAS   25    1   24
61158  02-NOV-05 269552  ASA: D-X-3060-8TB-5U      FL/CD     22-NOV-05 COMPLETED      NORMAL            20    0   20
59919  22-JUN-05 057126  ANGSTROM: 2*X-2.6G-1U-RM  EXP/D0    12-JUL-05 COMPLETED      NORMAL            20    0   20
59880  17-JUN-05 050715  ATIPA: TYS2468-1U2*MP2000 FL/CD     06-JUL-05 COMPLETED      NORMAL            19    0   19
59879  17-JUN-05 050704  ATIPA: TYS2468-1U2*MP2000 FL/CD     06-JUL-05 COMPLETED      NORMAL            19    0   19
59881  17-JUN-05 050722  ATIPA: D-ATHL-MP2000-2U-R FL/CD     06-JUL-05 COMPLETED      NORMAL            19    0   19
59813  10-JUN-05 040321  ATIPA: D-ATHL-MP2000-2U-R EXP/D0    01-JUL-05 COMPLETED      PER EVENT         21    0   21
59809  10-JUN-05 040145  ATIPA: D-ATHL-MP2000-2U-R EXP/D0    01-JUL-05 COMPLETED      PER EVENT         21    0   21
59810  10-JUN-05 040224  ATIPA: D-ATHL-MP2000-2U-R EXP/D0    01-JUL-05 COMPLETED      PER EVENT         21    0   21
59666  26-MAY-05 018973  ATIPA: D-ATHL-MP2000-2U-R EXP/D0    01-JUL-05 COMPLETED      PER EVENT         36    0   36
59628  23-MAY-05 014650  ETRNLGRF: D-P3-1260-2U-RM EXP/CDF   24-JUN-05 COMPLETED      PER EVENT         31    9   22
59644  25-MAY-05 016967  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   17-JUN-05 COMPLETED      PER EVENT         23    0   23
59670  26-MAY-05 020103  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   15-JUN-05 COMPLETED      PER EVENT         19    0   19
59638  24-MAY-05 015613  ATIPA: D-ATHL-MP2000-2U-R EXP/D0    14-JUN-05 COMPLETED      PER EVENT         21    0   21
59532  13-MAY-05 998962  ATIPA: TYS2468-1U2*MP2000 EXP/CDF   14-JUN-05 COMPLETED      PER EVENT         32    0   32
59574  18-MAY-05 005887  ATIPA: TYS2468-1U2*MP2000 FL/CD/CMS 13-JUN-05 COMPLETED      PER EVENT         26    0   26

63 rows selected.


d1_sla_qa.sql             Any Traditional Closed Jobs since Dec 31, 2004 that exceed 4 days                24-OCT-07
                    days1 = total number of days; days2 = adjustment; days3 = adjusted total days                   
                                                                                                                    
Fermi# Req Date  Vend#   Model                     Group     Job Date  Job Status     JTYPE           Days Days Days
------ --------- ------- ------------------------- --------- --------- -------------- --------------- ---- ---- ----
65745  12-SEP-07 457351  SUN MS: GDM-20E20         FL/TD     28-SEP-07 COMPLETED      TRADITIONAL/BAS   16    0   16
65723  06-SEP-07 449224  SUN MS: S20               FL/TD     18-SEP-07 COMPLETED      TRADITIONAL/BAS   12    0   12
65176  06-JUN-07 320137  SUN MS: 602-2844-01       FL/CD     06-SEP-07 COMPLETED      TRADITIONAL/BAS   92   14   78
65251  20-JUN-07 339745  DELL: SML-4               FL/CD     26-JUN-07 COMPLETED      TRADITIONAL/BAS    6    0    6
65182  08-JUN-07 323073  DELL: SML-4               FL/CD     14-JUN-07 COMPLETED      TRADITIONAL/BAS    6    0    6
65154  01-JUN-07 313785  DEC ALPHASERVER 4100      EXP/E832/ 06-JUN-07 COMPLETED      TRADITIONAL/BAS    5    0    5
64970  26-APR-07 261298  SUN MS: GDM-20D10         FL/TD     02-MAY-07 COMPLETED      TRADITIONAL/BAS    6    0    6
64836  06-APR-07 227522  SUN MS: E450-REFURB       FL/AD     10-APR-07 COMPLETED      TRADITIONAL/BAS    4    0    4
64775  30-MAR-07 217704  SUN MS: 600-6514-01       FL/CD     04-APR-07 COMPLETED      TRADITIONAL/BAS    5    0    5
64644  12-MAR-07 185996  IBM: 8687-3RX             FL/CD/CSS 23-MAR-07 COMPLETED      TRADITIONAL/PRI   11    0   11
64510  21-FEB-07 153358  SUN MS: ENT450            EXP/CDF   06-MAR-07 COMPLETED      TRADITIONAL/BAS   13    9    4
64100  08-DEC-06 029826  SUN MS: 140               FL/TD     14-DEC-06 COMPLETED      TRADITIONAL/BAS    6    0    6
63631  25-SEP-06 912576  SUN MS: 140               FL/TD     02-OCT-06 COMPLETED      TRADITIONAL/BAS    7    0    7
61302  16-NOV-05 290423  SUN MS: S20               FL/TD/DT  23-NOV-05 COMPLETED      TRADITIONAL/BAS    7    2    5
60306  03-AUG-05 126203  SUN MS: 600-6923-01       FL/CD     09-AUG-05 COMPLETED      TRADITIONAL/BAS    6    0    6
59933  23-JUN-05 058598  SUN MS STOREDGE A1000     FL/CD/CEP 29-JUN-05 COMPLETED      TRADITIONAL/PRI    6    0    6
59647  25-MAY-05 017260  SUN MS: GDM-20D10         FL/TD/DT  31-MAY-05 COMPLETED      TRADITIONAL/BAS    6    0    6
58568  07-JAN-05 698755  SUN MS: GDM-20E20         FL/TD/DT  12-JAN-05 COMPLETED      TRADITIONAL/BAS    5    0    5

18 rows selected.