Work Order Management Module

Work orders associated with a CSR complaints

Environment Department of Environmental Protection (DEP) Dataset 4fvw-nn9c 8 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
185886300
Svc Request Number: 185886300 • Workorder Number: 843035759 • Workorder Activity Code: WA06A
Svc Request Number
185886300
Workorder Number
843035759
Workorder Activity Code
WA06A
Workorder Activity Description
SHUT TAP/WET CON. /NON-COMP.
Workorder Started
2015-05-14T18:20:00.000
Workorder Completed
2015-05-14T22:30:00.000
Workorder Added
2015-03-02T08:51:14.000
Time Stamp
2015-05-20T00:45:09.000
185661520
Svc Request Number: 185661520 • Workorder Number: 842994606 • Workorder Activity Code: SMRTV
Svc Request Number
185661520
Workorder Number
842994606
Workorder Activity Code
SMRTV
Workorder Activity Description
REEL TV SEWER HOUSE CONNECTION
Workorder Added
2014-11-20T11:38:18.000
Time Stamp
2016-02-03T00:45:02.000
185734406
Svc Request Number: 185734406 • Workorder Number: 843133733 • Workorder Activity Code: SMRTV
Svc Request Number
185734406
Workorder Number
843133733
Workorder Activity Code
SMRTV
Workorder Activity Description
REEL TV SEWER HOUSE CONNECTION
Workorder Started
2015-09-13T09:55:00.000
Workorder Completed
2015-09-13T10:30:00.000
Workorder Added
2015-09-14T16:13:50.000
Time Stamp
2015-09-15T00:45:10.000
185979705
Svc Request Number: 185979705 • Workorder Number: 843110729 • Workorder Activity Code: WL3D
Svc Request Number
185979705
Workorder Number
843110729
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-07-27T15:15:00.000
Workorder Completed
2015-08-02T14:45:00.000
Workorder Added
2015-07-27T18:48:00.000
Time Stamp
2015-08-22T00:45:28.000
185979537
Svc Request Number: 185979537 • Workorder Number: 843114191 • Workorder Activity Code: SA12F
Svc Request Number
185979537
Workorder Number
843114191
Workorder Activity Code
SA12F
Workorder Activity Description
APPLY COLD PATCH
Workorder Started
2015-08-11T02:30:00.000
Workorder Completed
2015-08-11T03:00:00.000
Workorder Added
2015-08-07T11:56:37.000
Time Stamp
2015-08-13T00:45:08.000
185888637
Svc Request Number: 185888637 • Workorder Number: 843039237 • Workorder Activity Code: SA24
Svc Request Number
185888637
Workorder Number
843039237
Workorder Activity Code
SA24
Workorder Activity Description
REPAIR BASIN-MAJOR
Workorder Started
2004-01-20T16:00:00.000
Workorder Completed
2015-05-14T22:00:00.000
Workorder Added
2015-03-13T10:45:56.000
Time Stamp
2015-05-19T00:45:07.000
185812564
Svc Request Number: 185812564 • Workorder Number: 842964025 • Workorder Activity Code: SA24
Svc Request Number
185812564
Workorder Number
842964025
Workorder Activity Code
SA24
Workorder Activity Description
REPAIR BASIN-MAJOR
Workorder Started
2015-09-01T08:00:00.000
Workorder Completed
2015-09-01T11:00:00.000
Workorder Added
2014-09-16T12:38:53.000
Time Stamp
2015-09-04T00:45:11.000
185953762
Svc Request Number: 185953762 • Workorder Number: 843104317 • Workorder Activity Code: SA26
Svc Request Number
185953762
Workorder Number
843104317
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2016-01-04T16:30:00.000
Workorder Completed
2016-01-04T19:00:00.000
Workorder Added
2015-07-06T17:56:49.000
Time Stamp
2016-01-19T00:45:01.000
185837091
Svc Request Number: 185837091 • Workorder Number: 843086597 • Workorder Activity Code: WA12I
Svc Request Number
185837091
Workorder Number
843086597
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-21T11:40:00.000
Workorder Completed
2015-07-21T11:51:00.000
Workorder Added
2014-11-08T12:15:11.000
Time Stamp
2015-07-23T00:45:09.000
185884982
Svc Request Number: 185884982 • Workorder Number: 843027445 • Workorder Activity Code: SCCP
Svc Request Number
185884982
Workorder Number
843027445
Workorder Activity Code
SCCP
Workorder Activity Description
RESET CURB PIECE
Workorder Started
2015-05-11T11:00:00.000
Workorder Completed
2015-05-11T11:30:00.000
Workorder Added
2015-02-19T12:34:35.000
Time Stamp
2015-05-25T00:45:09.000
185970468
Svc Request Number: 185970468 • Workorder Number: 843107586 • Workorder Activity Code: WA05
Svc Request Number
185970468
Workorder Number
843107586
Workorder Activity Code
WA05
Workorder Activity Description
REPAIR OPERATIVE HYDRANT
Workorder Started
2015-10-01T10:00:00.000
Workorder Completed
2015-10-01T10:30:00.000
Workorder Added
2015-07-16T13:39:09.000
Time Stamp
2015-10-07T00:45:09.000
185889882
Svc Request Number: 185889882 • Workorder Number: 843052191 • Workorder Activity Code: SGS
Svc Request Number
185889882
Workorder Number
843052191
Workorder Activity Code
SGS
Workorder Activity Description
GUNITE SEWER
Workorder Started
2015-04-27T00:00:00.000
Workorder Completed
2015-05-15T00:00:00.000
Workorder Added
2015-04-16T09:12:48.000
Time Stamp
2015-06-26T00:45:06.000
185820848
Svc Request Number: 185820848 • Workorder Number: 843083351 • Workorder Activity Code: WA12I
Svc Request Number
185820848
Workorder Number
843083351
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-14T10:20:00.000
Workorder Completed
2015-07-14T10:45:00.000
Workorder Added
2014-09-27T13:20:14.000
Time Stamp
2015-07-16T00:45:12.000
185799468
Svc Request Number: 185799468 • Workorder Number: 842945328 • Workorder Activity Code: SA23
Svc Request Number
185799468
Workorder Number
842945328
Workorder Activity Code
SA23
Workorder Activity Description
REPAIR BASIN-MINOR
Workorder Completed
2015-07-12T00:00:00.000
Workorder Added
2014-08-13T12:42:57.000
Time Stamp
2015-07-15T00:45:06.000
185923135
Svc Request Number: 185923135 • Workorder Number: 843089431 • Workorder Activity Code: SCC
Svc Request Number
185923135
Workorder Number
843089431
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-05-22T12:35:00.000
Workorder Completed
2015-05-26T14:00:00.000
Workorder Added
2015-06-12T10:59:13.000
Time Stamp
2015-06-13T00:45:09.000
185923135
Svc Request Number: 185923135 • Workorder Number: 843089432 • Workorder Activity Code: SCC
Svc Request Number
185923135
Workorder Number
843089432
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-05-22T12:35:00.000
Workorder Completed
2015-05-26T14:00:00.000
Workorder Added
2015-06-12T10:59:13.000
Time Stamp
2015-06-13T00:45:09.000
185053843
Svc Request Number: 185053843 • Workorder Number: 842130304 • Workorder Activity Code: SA25
Svc Request Number
185053843
Workorder Number
842130304
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Completed
2017-02-18T12:06:00.000
Workorder Added
2010-08-20T15:58:10.000
Time Stamp
2017-02-19T00:45:02.000
185034435
Svc Request Number: 185034435 • Workorder Number: 842090157 • Workorder Activity Code: SA25
Svc Request Number
185034435
Workorder Number
842090157
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2010-06-16T10:16:45.000
Time Stamp
2015-10-01T00:45:07.000
185052267
Svc Request Number: 185052267 • Workorder Number: 842093108 • Workorder Activity Code: SA25
Svc Request Number
185052267
Workorder Number
842093108
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Started
2012-06-03T12:55:00.000
Workorder Added
2010-06-23T10:17:45.000
Time Stamp
2015-10-01T00:45:07.000
185052284
Svc Request Number: 185052284 • Workorder Number: 842091221 • Workorder Activity Code: SA25
Svc Request Number
185052284
Workorder Number
842091221
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2010-06-18T13:46:45.000
Time Stamp
2015-10-01T00:45:07.000
185766648
Svc Request Number: 185766648 • Workorder Number: 842989001 • Workorder Activity Code: SGS
Svc Request Number
185766648
Workorder Number
842989001
Workorder Activity Code
SGS
Workorder Activity Description
GUNITE SEWER
Workorder Started
2015-05-04T00:00:00.000
Workorder Completed
2015-05-15T00:00:00.000
Workorder Added
2014-11-07T10:44:30.000
Time Stamp
2015-06-26T00:45:06.000
185736914
Svc Request Number: 185736914 • Workorder Number: 842888887 • Workorder Activity Code: WA09
Svc Request Number
185736914
Workorder Number
842888887
Workorder Activity Code
WA09
Workorder Activity Description
REPAIR VALVE- NOTE SIZE
Workorder Started
2015-05-28T17:58:00.000
Workorder Completed
2015-05-28T17:58:00.000
Workorder Added
2014-05-03T08:43:26.000
Time Stamp
2015-05-29T00:45:03.000
186053175
Svc Request Number: 186053175 • Workorder Number: 843188985 • Workorder Activity Code: WLDSC
Svc Request Number
186053175
Workorder Number
843188985
Workorder Activity Code
WLDSC
Workorder Activity Description
SCAN WATER MAINS- LEAK DET.
Workorder Started
2015-12-17T08:55:00.000
Workorder Completed
2015-12-17T11:05:00.000
Workorder Added
2015-12-21T09:10:06.000
Time Stamp
2015-12-22T00:45:01.000
185879676
Svc Request Number: 185879676 • Workorder Number: 843106158 • Workorder Activity Code: SMPC
Svc Request Number
185879676
Workorder Number
843106158
Workorder Activity Code
SMPC
Workorder Activity Description
POLE CAMERA
Workorder Started
2015-07-17T07:17:00.000
Workorder Completed
2015-07-17T07:17:00.000
Workorder Added
2015-07-13T12:22:35.000
Time Stamp
2015-08-01T00:45:11.000
185874449
Svc Request Number: 185874449 • Workorder Number: 843019975 • Workorder Activity Code: SA26
Svc Request Number
185874449
Workorder Number
843019975
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-06-23T00:00:00.000
Workorder Completed
2015-06-23T03:00:00.000
Workorder Added
2015-01-28T13:02:01.000
Time Stamp
2015-07-29T00:45:11.000
186009674
Svc Request Number: 186009674 • Workorder Number: 843140337 • Workorder Activity Code: WA01A
Svc Request Number
186009674
Workorder Number
843140337
Workorder Activity Code
WA01A
Workorder Activity Description
REPLACE BROKEN MAIN
Workorder Completed
2015-11-17T07:00:00.000
Workorder Added
2015-09-24T10:57:07.000
Time Stamp
2015-11-18T00:45:09.000
185749804
Svc Request Number: 185749804 • Workorder Number: 842895473 • Workorder Activity Code: SA26
Svc Request Number
185749804
Workorder Number
842895473
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-09-16T00:00:00.000
Workorder Completed
2015-09-16T00:00:00.000
Workorder Added
2014-05-19T02:05:13.000
Time Stamp
2015-09-18T00:45:10.000
185876700
Svc Request Number: 185876700 • Workorder Number: 843024414 • Workorder Activity Code: SA26
Svc Request Number
185876700
Workorder Number
843024414
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-09-20T08:30:00.000
Workorder Completed
2015-09-20T10:30:00.000
Workorder Added
2015-02-11T13:11:09.000
Time Stamp
2015-10-12T00:45:12.000
185971050
Svc Request Number: 185971050 • Workorder Number: 843143360 • Workorder Activity Code: SA12R
Svc Request Number
185971050
Workorder Number
843143360
Workorder Activity Code
SA12R
Workorder Activity Description
CAVE IN RESTORATION
Workorder Started
2015-10-01T11:30:00.000
Workorder Completed
2015-10-02T00:00:00.000
Workorder Added
2015-10-01T14:11:43.000
Time Stamp
2015-10-07T00:45:09.000
186043776
Svc Request Number: 186043776 • Workorder Number: 843169769 • Workorder Activity Code: SA26
Svc Request Number
186043776
Workorder Number
843169769
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Added
2015-11-20T11:29:42.000
Time Stamp
2015-11-22T00:45:09.000
185965235
Svc Request Number: 185965235 • Workorder Number: 843120541 • Workorder Activity Code: SCC
Svc Request Number
185965235
Workorder Number
843120541
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-08-23T11:30:00.000
Workorder Completed
2015-08-23T12:35:00.000
Workorder Added
2015-08-25T10:09:17.000
Time Stamp
2015-08-26T00:45:09.000
185959047
Svc Request Number: 185959047 • Workorder Number: 843184612 • Workorder Activity Code: SA12R
Svc Request Number
185959047
Workorder Number
843184612
Workorder Activity Code
SA12R
Workorder Activity Description
CAVE IN RESTORATION
Workorder Started
2015-07-15T12:40:00.000
Workorder Added
2015-12-09T15:39:54.000
Time Stamp
2015-12-10T00:45:02.000
185712301
Svc Request Number: 185712301 • Workorder Number: 842883484 • Workorder Activity Code: SPLATE
Svc Request Number
185712301
Workorder Number
842883484
Workorder Activity Code
SPLATE
Workorder Activity Description
Install Steel Plate
Workorder Completed
2015-10-22T00:00:00.000
Workorder Added
2014-04-25T18:42:23.000
Time Stamp
2015-10-31T00:45:07.000
185712301
Svc Request Number: 185712301 • Workorder Number: 842883485 • Workorder Activity Code: SPLATE
Svc Request Number
185712301
Workorder Number
842883485
Workorder Activity Code
SPLATE
Workorder Activity Description
Install Steel Plate
Workorder Completed
2015-10-22T00:00:00.000
Workorder Added
2014-04-25T18:42:23.000
Time Stamp
2015-10-31T00:45:07.000
185894624
Svc Request Number: 185894624 • Workorder Number: 843059845 • Workorder Activity Code: WA03
Svc Request Number
185894624
Workorder Number
843059845
Workorder Activity Code
WA03
Workorder Activity Description
INSTALL TOP SECTION
Workorder Started
2015-05-22T08:20:00.000
Workorder Completed
2015-05-22T09:05:00.000
Workorder Added
2015-05-03T11:32:20.000
Time Stamp
2015-05-27T00:45:08.000
185185024
Svc Request Number: 185185024 • Workorder Number: 842206266 • Workorder Activity Code: SA26
Svc Request Number
185185024
Workorder Number
842206266
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-08-21T08:00:00.000
Workorder Completed
2015-08-21T08:00:00.000
Workorder Added
2011-01-23T18:29:00.000
Time Stamp
2015-08-24T00:45:39.000
185907760
Svc Request Number: 185907760 • Workorder Number: 843044772 • Workorder Activity Code: SA21
Svc Request Number
185907760
Workorder Number
843044772
Workorder Activity Code
SA21
Workorder Activity Description
REPLACE CURB PIECE
Workorder Added
2015-03-30T08:01:24.000
Time Stamp
2015-06-02T00:45:08.000
185897117
Svc Request Number: 185897117 • Workorder Number: 843038747 • Workorder Activity Code: WA10
Svc Request Number
185897117
Workorder Number
843038747
Workorder Activity Code
WA10
Workorder Activity Description
RESET/REPLACE VALVE BOX
Workorder Started
2015-05-22T16:30:00.000
Workorder Completed
2015-05-22T20:00:00.000
Workorder Added
2015-03-11T15:33:49.000
Time Stamp
2015-05-30T00:45:06.000
185801633
Svc Request Number: 185801633 • Workorder Number: 843023472 • Workorder Activity Code: SRB
Svc Request Number
185801633
Workorder Number
843023472
Workorder Activity Code
SRB
Workorder Activity Description
REPAIR SEWER BREAK (CONTRACT.)
Workorder Started
2015-05-26T07:00:00.000
Workorder Completed
2015-06-10T15:00:00.000
Workorder Added
2015-02-09T10:37:40.000
Time Stamp
2015-06-26T00:45:06.000
185986461
Svc Request Number: 185986461 • Workorder Number: 843113610 • Workorder Activity Code: SSFC
Svc Request Number
185986461
Workorder Number
843113610
Workorder Activity Code
SSFC
Workorder Activity Description
FLUSH PAST HOUSE CONNECTION
Workorder Started
2015-08-11T09:45:00.000
Workorder Completed
2015-08-11T10:30:00.000
Workorder Added
2015-08-06T01:42:24.000
Time Stamp
2015-08-13T00:45:08.000
185827945
Svc Request Number: 185827945 • Workorder Number: 842988416 • Workorder Activity Code: CCTV
Svc Request Number
185827945
Workorder Number
842988416
Workorder Activity Code
CCTV
Workorder Activity Description
CLOSE CIRCUIT TV
Workorder Started
2015-05-14T00:00:00.000
Workorder Completed
2015-05-14T00:00:00.000
Workorder Added
2014-11-05T17:50:56.000
Time Stamp
2015-06-10T00:45:08.000
185933186
Svc Request Number: 185933186 • Workorder Number: 843084505 • Workorder Activity Code: SCC
Svc Request Number
185933186
Workorder Number
843084505
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-05-29T07:55:00.000
Workorder Completed
2015-05-29T08:20:00.000
Workorder Added
2015-06-01T15:00:57.000
Time Stamp
2015-06-02T00:45:08.000
185800990
Svc Request Number: 185800990 • Workorder Number: 842990864 • Workorder Activity Code: SRL
Svc Request Number
185800990
Workorder Number
842990864
Workorder Activity Code
SRL
Workorder Activity Description
LINE SEWER (CONTRACTOR)
Workorder Started
2015-04-27T07:00:00.000
Workorder Completed
2015-05-07T15:00:00.000
Workorder Added
2014-11-12T12:00:19.000
Time Stamp
2015-05-21T00:45:09.000
185933186
Svc Request Number: 185933186 • Workorder Number: 843084506 • Workorder Activity Code: SCC
Svc Request Number
185933186
Workorder Number
843084506
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-05-29T07:55:00.000
Workorder Completed
2015-05-29T08:20:00.000
Workorder Added
2015-06-01T15:00:57.000
Time Stamp
2015-06-02T00:45:08.000
185062875
Svc Request Number: 185062875 • Workorder Number: 842098282 • Workorder Activity Code: SA25
Svc Request Number
185062875
Workorder Number
842098282
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2010-07-02T15:23:17.000
Time Stamp
2015-10-01T00:45:07.000
185764882
Svc Request Number: 185764882 • Workorder Number: 842908519 • Workorder Activity Code: SRB
Svc Request Number
185764882
Workorder Number
842908519
Workorder Activity Code
SRB
Workorder Activity Description
REPAIR SEWER BREAK (CONTRACT.)
Workorder Started
2014-11-01T07:00:00.000
Workorder Completed
2015-05-26T15:00:00.000
Workorder Added
2014-06-16T15:10:02.000
Time Stamp
2015-06-26T00:45:06.000
186043927
Svc Request Number: 186043927 • Workorder Number: 843170991 • Workorder Activity Code: SCC
Svc Request Number
186043927
Workorder Number
843170991
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-11-21T11:50:00.000
Workorder Completed
2015-11-21T12:25:00.000
Workorder Added
2015-11-23T12:58:21.000
Time Stamp
2015-12-03T00:45:06.000
185892850
Svc Request Number: 185892850 • Workorder Number: 843076915 • Workorder Activity Code: SVAC
Svc Request Number
185892850
Workorder Number
843076915
Workorder Activity Code
SVAC
Workorder Activity Description
VACTOR SEWER
Workorder Started
2015-05-14T07:00:00.000
Workorder Completed
2015-05-14T15:30:00.000
Workorder Added
2015-05-16T11:04:21.000
Time Stamp
2015-05-17T00:45:07.000
185986670
Svc Request Number: 185986670 • Workorder Number: 843113286 • Workorder Activity Code: WL3D
Svc Request Number
185986670
Workorder Number
843113286
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-08-04T21:10:00.000
Workorder Completed
2015-08-11T21:20:00.000
Workorder Added
2015-08-05T11:08:35.000
Time Stamp
2015-08-14T00:45:10.000
185923135
Svc Request Number: 185923135 • Workorder Number: 843089433 • Workorder Activity Code: SCC
Svc Request Number
185923135
Workorder Number
843089433
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-05-22T12:35:00.000
Workorder Completed
2015-05-26T14:00:00.000
Workorder Added
2015-06-12T10:59:13.000
Time Stamp
2015-06-13T00:45:09.000