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
185929319
Svc Request Number: 185929319 • Workorder Number: 843085328 • Workorder Activity Code: WA12I
Svc Request Number
185929319
Workorder Number
843085328
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-21T08:09:00.000
Workorder Completed
2015-07-21T08:25:00.000
Workorder Added
2015-05-15T12:22:59.000
Time Stamp
2015-07-23T00:45:09.000
185918329
Svc Request Number: 185918329 • Workorder Number: 843055543 • Workorder Activity Code: WL3D
Svc Request Number
185918329
Workorder Number
843055543
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-04-23T21:30:00.000
Workorder Completed
2015-05-05T10:20:00.000
Workorder Added
2015-04-24T12:45:15.000
Time Stamp
2015-05-16T00:45:10.000
185942315
Svc Request Number: 185942315 • Workorder Number: 843105087 • Workorder Activity Code: SMCV
Svc Request Number
185942315
Workorder Number
843105087
Workorder Activity Code
SMCV
Workorder Activity Description
CLEAN CULVERT
Workorder Started
2015-06-01T17:30:00.000
Workorder Completed
2015-06-01T18:30:00.000
Workorder Added
2015-07-09T08:29:28.000
Time Stamp
2015-07-10T00:45:08.000
185929539
Svc Request Number: 185929539 • Workorder Number: 843085760 • Workorder Activity Code: WA12I
Svc Request Number
185929539
Workorder Number
843085760
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-21T09:50:00.000
Workorder Completed
2015-07-21T10:00:00.000
Workorder Added
2015-05-11T09:32:25.000
Time Stamp
2015-07-23T00:45:09.000
185956479
Svc Request Number: 185956479 • Workorder Number: 843107407 • Workorder Activity Code: WA06A
Svc Request Number
185956479
Workorder Number
843107407
Workorder Activity Code
WA06A
Workorder Activity Description
SHUT TAP/WET CON. /NON-COMP.
Workorder Started
2015-07-27T08:40:00.000
Workorder Completed
2015-07-27T18:50:00.000
Workorder Added
2015-07-16T09:53:26.000
Time Stamp
2015-08-13T00:45:08.000
185922566
Svc Request Number: 185922566 • Workorder Number: 843058212 • Workorder Activity Code: SA21
Svc Request Number
185922566
Workorder Number
843058212
Workorder Activity Code
SA21
Workorder Activity Description
REPLACE CURB PIECE
Workorder Started
2015-05-08T00:30:00.000
Workorder Completed
2015-05-08T01:30:00.000
Workorder Added
2015-04-29T11:02:20.000
Time Stamp
2015-05-17T00:45:07.000
185930382
Svc Request Number: 185930382 • Workorder Number: 843085758 • Workorder Activity Code: WA12I
Svc Request Number
185930382
Workorder Number
843085758
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-21T09:35:00.000
Workorder Completed
2015-07-21T09:45:00.000
Workorder Added
2015-05-16T11:21:11.000
Time Stamp
2015-07-23T00:45:09.000
185918567
Svc Request Number: 185918567 • Workorder Number: 843058805 • Workorder Activity Code: WL3D
Svc Request Number
185918567
Workorder Number
843058805
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-04-29T11:40:00.000
Workorder Completed
2015-05-05T18:50:00.000
Workorder Added
2015-04-30T11:06:44.000
Time Stamp
2015-05-09T00:45:08.000
185918573
Svc Request Number: 185918573 • Workorder Number: 843056742 • Workorder Activity Code: WL3D
Svc Request Number
185918573
Workorder Number
843056742
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-04-26T10:35:00.000
Workorder Completed
2015-05-05T10:55:00.000
Workorder Added
2015-04-28T10:17:02.000
Time Stamp
2015-05-16T00:45:10.000
185928896
Svc Request Number: 185928896 • Workorder Number: 843086844 • Workorder Activity Code: SMPC
Svc Request Number
185928896
Workorder Number
843086844
Workorder Activity Code
SMPC
Workorder Activity Description
POLE CAMERA
Workorder Started
2015-05-20T12:50:00.000
Workorder Completed
2015-05-20T13:20:00.000
Workorder Added
2015-06-06T13:18:52.000
Time Stamp
2015-06-07T00:45:10.000
185925830
Svc Request Number: 185925830 • Workorder Number: 843112047 • Workorder Activity Code: SVAC
Svc Request Number
185925830
Workorder Number
843112047
Workorder Activity Code
SVAC
Workorder Activity Description
VACTOR SEWER
Workorder Started
2015-07-14T06:30:00.000
Workorder Completed
2015-07-14T15:00:00.000
Workorder Added
2015-07-31T09:45:14.000
Time Stamp
2015-08-01T00:45:11.000
185875968
Svc Request Number: 185875968 • Workorder Number: 843044569 • Workorder Activity Code: SA26
Svc Request Number
185875968
Workorder Number
843044569
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-08-13T18:30:00.000
Workorder Completed
2015-08-13T22:30:00.000
Workorder Added
2015-03-27T20:25:08.000
Time Stamp
2015-09-10T00:45:06.000
185928904
Svc Request Number: 185928904 • Workorder Number: 843083425 • Workorder Activity Code: SMDT
Svc Request Number
185928904
Workorder Number
843083425
Workorder Activity Code
SMDT
Workorder Activity Description
PERFORM DYE TEST
Workorder Started
2015-05-20T14:10:00.000
Workorder Completed
2015-05-20T14:40:00.000
Workorder Added
2015-05-29T07:56:02.000
Time Stamp
2015-05-30T00:45:06.000
185925900
Svc Request Number: 185925900 • Workorder Number: 843095959 • Workorder Activity Code: SSFC
Svc Request Number
185925900
Workorder Number
843095959
Workorder Activity Code
SSFC
Workorder Activity Description
FLUSH PAST HOUSE CONNECTION
Workorder Started
2015-06-17T08:15:00.000
Workorder Completed
2015-06-17T09:00:00.000
Workorder Added
2015-06-18T10:32:20.000
Time Stamp
2015-07-01T00:45:09.000
185942286
Svc Request Number: 185942286 • Workorder Number: 843086343 • Workorder Activity Code: SSR
Svc Request Number
185942286
Workorder Number
843086343
Workorder Activity Code
SSR
Workorder Activity Description
ROD SEWER SECTION
Workorder Started
2015-06-02T13:20:00.000
Workorder Completed
2015-06-02T14:45:00.000
Workorder Added
2015-06-05T09:17:47.000
Time Stamp
2015-07-02T00:45:13.000
185913506
Svc Request Number: 185913506 • Workorder Number: 843103812 • Workorder Activity Code: WA12I
Svc Request Number
185913506
Workorder Number
843103812
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-08-04T11:00:00.000
Workorder Completed
2015-08-04T11:15:00.000
Workorder Added
2015-04-20T12:05:39.000
Time Stamp
2015-08-06T00:45:09.000
185931100
Svc Request Number: 185931100 • Workorder Number: 843090636 • Workorder Activity Code: WA12I
Svc Request Number
185931100
Workorder Number
843090636
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-21T12:05:00.000
Workorder Completed
2015-07-21T12:25:00.000
Workorder Added
2015-05-16T10:31:16.000
Time Stamp
2015-07-23T00:45:09.000
185918878
Svc Request Number: 185918878 • Workorder Number: 843054108 • Workorder Activity Code: SA12F
Svc Request Number
185918878
Workorder Number
843054108
Workorder Activity Code
SA12F
Workorder Activity Description
APPLY COLD PATCH
Workorder Started
2015-05-05T12:00:00.000
Workorder Completed
2015-05-05T12:30:00.000
Workorder Added
2015-04-21T14:12:26.000
Time Stamp
2015-05-08T00:45:09.000
186018199
Svc Request Number: 186018199 • Workorder Number: 843147610 • Workorder Activity Code: SCC
Svc Request Number
186018199
Workorder Number
843147610
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-10-04T12:00:00.000
Workorder Completed
2015-10-04T12:30:00.000
Workorder Added
2015-10-11T12:56:58.000
Time Stamp
2015-10-12T00:45:12.000
185989608
Svc Request Number: 185989608 • Workorder Number: 843118572 • Workorder Activity Code: SCC
Svc Request Number
185989608
Workorder Number
843118572
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-08-11T08:30:00.000
Workorder Completed
2015-08-11T09:13:00.000
Workorder Added
2015-08-20T12:50:05.000
Time Stamp
2015-08-21T00:45:10.000
185936281
Svc Request Number: 185936281 • Workorder Number: 843084662 • Workorder Activity Code: WA12I
Svc Request Number
185936281
Workorder Number
843084662
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-17T08:50:00.000
Workorder Completed
2015-07-17T08:55:00.000
Workorder Added
2015-05-21T12:14:59.000
Time Stamp
2015-07-21T00:45:08.000
185989608
Svc Request Number: 185989608 • Workorder Number: 843118573 • Workorder Activity Code: SCC
Svc Request Number
185989608
Workorder Number
843118573
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-08-11T08:30:00.000
Workorder Completed
2015-08-11T09:13:00.000
Workorder Added
2015-08-20T12:50:05.000
Time Stamp
2015-08-21T00:45:10.000
185936380
Svc Request Number: 185936380 • Workorder Number: 843080405 • Workorder Activity Code: WA04
Svc Request Number
185936380
Workorder Number
843080405
Workorder Activity Code
WA04
Workorder Activity Description
REPAIR INOPERATIVE HYDRANT
Workorder Started
2015-07-16T00:00:00.000
Workorder Completed
2015-07-18T00:00:00.000
Workorder Added
2015-05-21T11:02:02.000
Time Stamp
2015-07-24T00:45:08.000
185925843
Svc Request Number: 185925843 • Workorder Number: 843118514 • Workorder Activity Code: SMPC
Svc Request Number
185925843
Workorder Number
843118514
Workorder Activity Code
SMPC
Workorder Activity Description
POLE CAMERA
Workorder Started
2015-07-14T09:30:00.000
Workorder Completed
2015-07-14T10:30:00.000
Workorder Added
2015-08-20T11:49:18.000
Time Stamp
2015-08-21T00:45:10.000
185972860
Svc Request Number: 185972860 • Workorder Number: 843111831 • Workorder Activity Code: SMDT
Svc Request Number
185972860
Workorder Number
843111831
Workorder Activity Code
SMDT
Workorder Activity Description
PERFORM DYE TEST
Workorder Added
2015-07-30T12:26:47.000
Time Stamp
2015-07-31T00:45:10.000
185972860
Svc Request Number: 185972860 • Workorder Number: 843111833 • Workorder Activity Code: SMPC
Svc Request Number
185972860
Workorder Number
843111833
Workorder Activity Code
SMPC
Workorder Activity Description
POLE CAMERA
Workorder Added
2015-07-30T12:28:31.000
Time Stamp
2015-07-31T00:45:10.000
185956662
Svc Request Number: 185956662 • Workorder Number: 843098032 • Workorder Activity Code: SA24
Svc Request Number
185956662
Workorder Number
843098032
Workorder Activity Code
SA24
Workorder Activity Description
REPAIR BASIN-MAJOR
Workorder Started
2015-07-26T08:40:00.000
Workorder Completed
2015-07-28T13:00:00.000
Workorder Added
2015-06-23T13:41:19.000
Time Stamp
2015-07-28T00:45:02.000
185918954
Svc Request Number: 185918954 • Workorder Number: 843054597 • Workorder Activity Code: WL3D
Svc Request Number
185918954
Workorder Number
843054597
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-05-05T13:00:00.000
Workorder Completed
2015-05-05T13:10:00.000
Workorder Added
2015-04-22T12:56:25.000
Time Stamp
2015-05-08T00:45:09.000
185994613
Svc Request Number: 185994613 • Workorder Number: 843125177 • Workorder Activity Code: SA24
Svc Request Number
185994613
Workorder Number
843125177
Workorder Activity Code
SA24
Workorder Activity Description
REPAIR BASIN-MAJOR
Workorder Started
2015-08-20T08:30:00.000
Workorder Completed
2015-08-20T14:30:00.000
Workorder Added
2015-08-19T12:27:45.000
Time Stamp
2015-09-12T00:45:09.000
186056812
Svc Request Number: 186056812 • Workorder Number: 843188222 • Workorder Activity Code: SSFC
Svc Request Number
186056812
Workorder Number
843188222
Workorder Activity Code
SSFC
Workorder Activity Description
FLUSH PAST HOUSE CONNECTION
Workorder Started
2015-12-17T17:45:00.000
Workorder Completed
2015-12-17T21:15:00.000
Workorder Added
2015-12-18T08:52:50.000
Time Stamp
2016-01-21T00:45:02.000
185926879
Svc Request Number: 185926879 • Workorder Number: 843075419 • Workorder Activity Code: WA04
Svc Request Number
185926879
Workorder Number
843075419
Workorder Activity Code
WA04
Workorder Activity Description
REPAIR INOPERATIVE HYDRANT
Workorder Started
2015-05-15T10:35:00.000
Workorder Completed
2015-06-17T09:20:00.000
Workorder Added
2015-05-13T11:20:46.000
Time Stamp
2015-06-19T00:45:10.000
185972956
Svc Request Number: 185972956 • Workorder Number: 843117157 • Workorder Activity Code: SCF
Svc Request Number
185972956
Workorder Number
843117157
Workorder Activity Code
SCF
Workorder Activity Description
FLUSH CATCH BASIN/CONNECTION
Workorder Started
2015-07-30T09:50:00.000
Workorder Completed
2015-07-30T10:15:00.000
Workorder Added
2015-08-16T13:10:32.000
Time Stamp
2015-08-17T00:45:09.000
185924441
Svc Request Number: 185924441 • Workorder Number: 843058563 • Workorder Activity Code: SA26
Svc Request Number
185924441
Workorder Number
843058563
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-08-29T20:00:00.000
Workorder Completed
2015-08-29T22:30:00.000
Workorder Added
2015-04-29T15:05:47.000
Time Stamp
2015-09-01T00:45:12.000
185982642
Svc Request Number: 185982642 • Workorder Number: 843113049 • Workorder Activity Code: SCC
Svc Request Number
185982642
Workorder Number
843113049
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-08-02T08:30:00.000
Workorder Completed
2015-08-02T09:00:00.000
Workorder Added
2015-08-04T13:03:52.000
Time Stamp
2015-08-11T00:45:08.000
185949789
Svc Request Number: 185949789 • Workorder Number: 843102199 • Workorder Activity Code: SA12F
Svc Request Number
185949789
Workorder Number
843102199
Workorder Activity Code
SA12F
Workorder Activity Description
APPLY COLD PATCH
Workorder Added
2015-07-01T12:36:46.000
Time Stamp
2015-07-02T00:45:13.000
185918728
Svc Request Number: 185918728 • Workorder Number: 843081792 • Workorder Activity Code: SA24
Svc Request Number
185918728
Workorder Number
843081792
Workorder Activity Code
SA24
Workorder Activity Description
REPAIR BASIN-MAJOR
Workorder Started
2015-07-02T00:20:00.000
Workorder Completed
2015-07-02T00:00:00.000
Workorder Added
2015-05-25T13:51:29.000
Time Stamp
2015-07-08T00:45:09.000
185923036
Svc Request Number: 185923036 • Workorder Number: 843074479 • Workorder Activity Code: SCF
Svc Request Number
185923036
Workorder Number
843074479
Workorder Activity Code
SCF
Workorder Activity Description
FLUSH CATCH BASIN/CONNECTION
Workorder Started
2015-05-08T11:15:00.000
Workorder Completed
2015-05-08T11:50:00.000
Workorder Added
2015-05-11T11:46:02.000
Time Stamp
2015-05-12T00:45:09.000
186189932
Svc Request Number: 186189932 • Workorder Number: 843454377 • Workorder Activity Code: SSFC
Svc Request Number
186189932
Workorder Number
843454377
Workorder Activity Code
SSFC
Workorder Activity Description
FLUSH PAST HOUSE CONNECTION
Workorder Started
2016-08-20T10:20:00.000
Workorder Completed
2016-08-20T10:40:00.000
Workorder Added
2016-08-01T09:13:10.000
Time Stamp
2016-08-23T00:45:03.000
185986079
Svc Request Number: 185986079 • Workorder Number: 843114073 • Workorder Activity Code: SCC
Svc Request Number
185986079
Workorder Number
843114073
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-08-05T07:40:00.000
Workorder Completed
2015-08-05T08:15:00.000
Workorder Added
2015-08-07T09:06:42.000
Time Stamp
2015-08-08T00:45:06.000
185924263
Svc Request Number: 185924263 • Workorder Number: 843620431 • Workorder Activity Code: AMSAMPTEST
Svc Request Number
185924263
Workorder Number
843620431
Workorder Activity Code
AMSAMPTEST
Workorder Activity Description
AIR MONITORING SAMPLING AND TESTING
Workorder Added
2017-05-03T10:30:08.000
Time Stamp
2017-05-04T00:45:03.000
185927758
Svc Request Number: 185927758 • Workorder Number: 843084927 • Workorder Activity Code: WL3D
Svc Request Number
185927758
Workorder Number
843084927
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-06-17T09:30:00.000
Workorder Completed
2015-06-17T09:35:00.000
Workorder Added
2015-06-02T13:33:32.000
Time Stamp
2015-07-23T00:45:09.000
185738129
Svc Request Number: 185738129 • Workorder Number: 843048175 • Workorder Activity Code: SRB
Svc Request Number
185738129
Workorder Number
843048175
Workorder Activity Code
SRB
Workorder Activity Description
REPAIR SEWER BREAK (CONTRACT.)
Workorder Started
2015-05-15T00:00:00.000
Workorder Completed
2015-05-22T15:00:00.000
Workorder Added
2015-04-06T10:26:42.000
Time Stamp
2015-06-09T00:45:09.000
185739210
Svc Request Number: 185739210 • Workorder Number: 842887798 • Workorder Activity Code: WA10
Svc Request Number
185739210
Workorder Number
842887798
Workorder Activity Code
WA10
Workorder Activity Description
RESET/REPLACE VALVE BOX
Workorder Started
2015-05-28T00:30:00.000
Workorder Completed
2015-05-28T00:30:00.000
Workorder Added
2014-05-01T18:55:28.000
Time Stamp
2015-05-30T00:45:06.000
185904820
Svc Request Number: 185904820 • Workorder Number: 843072266 • Workorder Activity Code: SA26
Svc Request Number
185904820
Workorder Number
843072266
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-05-19T17:30:00.000
Workorder Completed
2015-05-19T20:30:00.000
Workorder Added
2015-05-05T10:11:04.000
Time Stamp
2015-05-21T00:45:09.000
185923036
Svc Request Number: 185923036 • Workorder Number: 843074480 • Workorder Activity Code: SCF
Svc Request Number
185923036
Workorder Number
843074480
Workorder Activity Code
SCF
Workorder Activity Description
FLUSH CATCH BASIN/CONNECTION
Workorder Started
2015-05-08T11:15:00.000
Workorder Completed
2015-05-08T11:50:00.000
Workorder Added
2015-05-11T11:46:02.000
Time Stamp
2015-05-12T00:45:09.000
185923895
Svc Request Number: 185923895 • Workorder Number: 843074383 • Workorder Activity Code: WA06J
Svc Request Number
185923895
Workorder Number
843074383
Workorder Activity Code
WA06J
Workorder Activity Description
REPAIR JOINT LEAK
Workorder Started
2015-05-14T09:00:00.000
Workorder Completed
2015-05-14T13:15:00.000
Workorder Added
2015-05-11T09:32:33.000
Time Stamp
2015-05-20T00:45:09.000
1995598
Svc Request Number: 1995598 • Workorder Number: 1734105 • Workorder Activity Code: SA27
Svc Request Number
1995598
Workorder Number
1734105
Workorder Activity Code
SA27
Workorder Activity Description
PERFORM OTHER MANHOLE WORK
Workorder Started
2015-09-13T11:00:00.000
Workorder Completed
2015-09-13T14:00:00.000
Workorder Added
2008-10-08T16:06:25.000
Time Stamp
2015-09-15T00:45:10.000
185923090
Svc Request Number: 185923090 • Workorder Number: 843058926 • Workorder Activity Code: WL3D
Svc Request Number
185923090
Workorder Number
843058926
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-04-29T12:55:00.000
Workorder Completed
2015-05-08T11:50:00.000
Workorder Added
2015-04-30T13:18:42.000
Time Stamp
2015-05-20T00:45:09.000
185919428
Svc Request Number: 185919428 • Workorder Number: 843053793 • Workorder Activity Code: QA
Svc Request Number
185919428
Workorder Number
843053793
Workorder Activity Code
QA
Workorder Activity Description
TAKE SAMPLE
Workorder Completed
2015-05-06T00:00:00.000
Workorder Added
2015-04-21T08:28:02.000
Time Stamp
2015-05-08T00:45:09.000
184977555
Svc Request Number: 184977555 • Workorder Number: 841994005 • Workorder Activity Code: SA26
Svc Request Number
184977555
Workorder Number
841994005
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-09-13T08:00:00.000
Workorder Completed
2015-09-13T11:00:00.000
Workorder Added
2010-01-20T10:21:50.000
Time Stamp
2015-09-15T00:45:10.000