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
185971570
Svc Request Number: 185971570 • Workorder Number: 843128959 • Workorder Activity Code: SMPC
Svc Request Number
185971570
Workorder Number
843128959
Workorder Activity Code
SMPC
Workorder Activity Description
POLE CAMERA
Workorder Started
2015-07-30T11:00:00.000
Workorder Completed
2015-07-30T12:00:00.000
Workorder Added
2015-09-01T18:13:53.000
Time Stamp
2015-09-02T00:45:08.000
185907116
Svc Request Number: 185907116 • Workorder Number: 843047493 • Workorder Activity Code: WA10
Svc Request Number
185907116
Workorder Number
843047493
Workorder Activity Code
WA10
Workorder Activity Description
RESET/REPLACE VALVE BOX
Workorder Started
2015-05-30T12:30:00.000
Workorder Completed
2015-05-30T16:20:00.000
Workorder Added
2015-04-03T10:41:43.000
Time Stamp
2015-06-03T00:45:09.000
185971744
Svc Request Number: 185971744 • Workorder Number: 843124603 • Workorder Activity Code: WA05
Svc Request Number
185971744
Workorder Number
843124603
Workorder Activity Code
WA05
Workorder Activity Description
REPAIR OPERATIVE HYDRANT
Workorder Started
2015-11-02T08:30:00.000
Workorder Completed
2015-11-02T09:00:00.000
Workorder Added
2015-08-28T11:40:53.000
Time Stamp
2015-12-05T00:45:08.000
185466603
Svc Request Number: 185466603 • Workorder Number: 842526516 • Workorder Activity Code: SA25
Svc Request Number
185466603
Workorder Number
842526516
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2012-08-10T14:49:13.000
Time Stamp
2015-10-01T00:45:07.000
185472857
Svc Request Number: 185472857 • Workorder Number: 842540097 • Workorder Activity Code: SA25
Svc Request Number
185472857
Workorder Number
842540097
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2012-09-14T14:50:35.000
Time Stamp
2015-10-01T00:45:07.000
185477093
Svc Request Number: 185477093 • Workorder Number: 842539446 • Workorder Activity Code: SA25
Svc Request Number
185477093
Workorder Number
842539446
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2012-09-13T12:50:20.000
Time Stamp
2015-10-01T00:45:07.000
185915033
Svc Request Number: 185915033 • Workorder Number: 843073631 • Workorder Activity Code: WA03
Svc Request Number
185915033
Workorder Number
843073631
Workorder Activity Code
WA03
Workorder Activity Description
INSTALL TOP SECTION
Workorder Started
2015-05-11T08:25:00.000
Workorder Completed
2015-05-11T09:10:00.000
Workorder Added
2015-05-08T08:51:48.000
Time Stamp
2015-05-14T00:45:08.000
186017442
Svc Request Number: 186017442 • Workorder Number: 843154102 • Workorder Activity Code: SCC
Svc Request Number
186017442
Workorder Number
843154102
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-10-01T09:30:00.000
Workorder Completed
2015-10-01T10:30:00.000
Workorder Added
2015-10-18T17:31:41.000
Time Stamp
2015-10-20T00:45:07.000
186044012
Svc Request Number: 186044012 • Workorder Number: 843170838 • Workorder Activity Code: WL3D
Svc Request Number
186044012
Workorder Number
843170838
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-11-30T10:20:00.000
Workorder Completed
2015-11-30T10:35:00.000
Workorder Added
2015-11-23T11:13:43.000
Time Stamp
2015-12-31T00:45:02.000
185981807
Svc Request Number: 185981807 • Workorder Number: 843111652 • Workorder Activity Code: SSFC
Svc Request Number
185981807
Workorder Number
843111652
Workorder Activity Code
SSFC
Workorder Activity Description
FLUSH PAST HOUSE CONNECTION
Workorder Started
2015-08-02T13:55:00.000
Workorder Completed
2015-08-02T14:25:00.000
Workorder Added
2015-07-30T00:11:06.000
Time Stamp
2015-08-04T00:45:09.000
186017460
Svc Request Number: 186017460 • Workorder Number: 843144144 • Workorder Activity Code: SCC
Svc Request Number
186017460
Workorder Number
843144144
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-10-01T08:00:00.000
Workorder Completed
2015-10-01T08:45:00.000
Workorder Added
2015-10-02T12:44:11.000
Time Stamp
2015-11-10T00:45:07.000
185916224
Svc Request Number: 185916224 • Workorder Number: 843053488 • Workorder Activity Code: SCF
Svc Request Number
185916224
Workorder Number
843053488
Workorder Activity Code
SCF
Workorder Activity Description
FLUSH CATCH BASIN/CONNECTION
Workorder Started
2015-07-21T11:00:00.000
Workorder Completed
2015-07-21T11:00:00.000
Workorder Added
2015-04-20T09:46:28.000
Time Stamp
2015-07-29T00:45:11.000
185918008
Svc Request Number: 185918008 • Workorder Number: 843107764 • Workorder Activity Code: WA12I
Svc Request Number
185918008
Workorder Number
843107764
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-07-24T11:40:00.000
Workorder Completed
2015-07-24T12:05:00.000
Workorder Added
2015-05-16T17:38:26.000
Time Stamp
2015-07-28T00:45:02.000
185918042
Svc Request Number: 185918042 • Workorder Number: 843083213 • Workorder Activity Code: WA04
Svc Request Number
185918042
Workorder Number
843083213
Workorder Activity Code
WA04
Workorder Activity Description
REPAIR INOPERATIVE HYDRANT
Workorder Started
2015-07-24T08:25:00.000
Workorder Completed
2015-07-24T09:00:00.000
Workorder Added
2015-05-28T14:02:16.000
Time Stamp
2015-08-07T00:45:08.000
185891422
Svc Request Number: 185891422 • Workorder Number: 843037360 • Workorder Activity Code: SA26
Svc Request Number
185891422
Workorder Number
843037360
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-07-01T12:00:00.000
Workorder Completed
2015-07-01T14:00:00.000
Workorder Added
2015-03-06T14:39:58.000
Time Stamp
2015-07-04T00:45:10.000
185985470
Svc Request Number: 185985470 • Workorder Number: 843114085 • Workorder Activity Code: SCC
Svc Request Number
185985470
Workorder Number
843114085
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-08-05T10:50:00.000
Workorder Completed
2015-08-05T11:10:00.000
Workorder Added
2015-08-07T09:18:35.000
Time Stamp
2015-08-08T00:45:06.000
185915236
Svc Request Number: 185915236 • Workorder Number: 843074252 • Workorder Activity Code: WA04
Svc Request Number
185915236
Workorder Number
843074252
Workorder Activity Code
WA04
Workorder Activity Description
REPAIR INOPERATIVE HYDRANT
Workorder Started
2015-05-11T08:00:00.000
Workorder Completed
2015-05-11T08:30:00.000
Workorder Added
2015-05-10T23:57:04.000
Time Stamp
2015-05-13T00:45:10.000
185917058
Svc Request Number: 185917058 • Workorder Number: 843075297 • Workorder Activity Code: WA03
Svc Request Number
185917058
Workorder Number
843075297
Workorder Activity Code
WA03
Workorder Activity Description
INSTALL TOP SECTION
Workorder Started
2015-05-14T11:40:00.000
Workorder Completed
2015-05-14T12:25:00.000
Workorder Added
2015-05-13T09:07:35.000
Time Stamp
2015-05-16T00:45:10.000
186056113
Svc Request Number: 186056113 • Workorder Number: 843193622 • Workorder Activity Code: SCC
Svc Request Number
186056113
Workorder Number
843193622
Workorder Activity Code
SCC
Workorder Activity Description
CLEAN CATCH BASIN/INLET
Workorder Started
2015-12-17T10:40:00.000
Workorder Completed
2015-12-17T11:10:00.000
Workorder Added
2016-01-05T11:17:27.000
Time Stamp
2016-01-06T00:45:01.000
186009790
Svc Request Number: 186009790 • Workorder Number: 843156205 • Workorder Activity Code: WA06A
Svc Request Number
186009790
Workorder Number
843156205
Workorder Activity Code
WA06A
Workorder Activity Description
SHUT TAP/WET CON. /NON-COMP.
Workorder Started
2015-11-05T08:30:00.000
Workorder Completed
2015-11-05T14:30:00.000
Workorder Added
2015-10-22T13:55:50.000
Time Stamp
2015-11-18T00:45:09.000
185985510
Svc Request Number: 185985510 • Workorder Number: 843112909 • Workorder Activity Code: WA04
Svc Request Number
185985510
Workorder Number
843112909
Workorder Activity Code
WA04
Workorder Activity Description
REPAIR INOPERATIVE HYDRANT
Workorder Started
2015-08-05T12:30:00.000
Workorder Completed
2015-08-05T13:00:00.000
Workorder Added
2015-08-04T09:26:01.000
Time Stamp
2015-08-27T00:45:17.000
185941433
Svc Request Number: 185941433 • Workorder Number: 843084521 • Workorder Activity Code: SA12R
Svc Request Number
185941433
Workorder Number
843084521
Workorder Activity Code
SA12R
Workorder Activity Description
CAVE IN RESTORATION
Workorder Started
2015-06-01T08:00:00.000
Workorder Completed
2015-06-01T12:00:00.000
Workorder Added
2015-06-01T15:08:29.000
Time Stamp
2015-06-30T00:45:09.000
185936818
Svc Request Number: 185936818 • Workorder Number: 843083750 • Workorder Activity Code: SMDT
Svc Request Number
185936818
Workorder Number
843083750
Workorder Activity Code
SMDT
Workorder Activity Description
PERFORM DYE TEST
Workorder Started
2015-05-29T10:15:00.000
Workorder Completed
2015-05-29T11:15:00.000
Workorder Added
2015-05-29T15:35:48.000
Time Stamp
2015-05-30T00:45:06.000
185927942
Svc Request Number: 185927942 • Workorder Number: 843079485 • Workorder Activity Code: WA02
Svc Request Number
185927942
Workorder Number
843079485
Workorder Activity Code
WA02
Workorder Activity Description
REPAIR HYDRANT-MAJOR
Workorder Started
2015-06-06T07:00:00.000
Workorder Completed
2015-06-06T11:00:00.000
Workorder Added
2015-05-20T09:29:31.000
Time Stamp
2015-06-10T00:45:08.000
185925443
Svc Request Number: 185925443 • Workorder Number: 843080494 • Workorder Activity Code: WA12F
Svc Request Number
185925443
Workorder Number
843080494
Workorder Activity Code
WA12F
Workorder Activity Description
APPLY COLD PATCH
Workorder Started
2015-05-20T11:45:00.000
Workorder Completed
2015-05-20T12:15:00.000
Workorder Added
2015-05-21T12:31:23.000
Time Stamp
2015-05-22T00:45:09.000
185986798
Svc Request Number: 185986798 • Workorder Number: 843114081 • Workorder Activity Code: WA04
Svc Request Number
185986798
Workorder Number
843114081
Workorder Activity Code
WA04
Workorder Activity Description
REPAIR INOPERATIVE HYDRANT
Workorder Started
2015-08-08T11:25:00.000
Workorder Completed
2015-08-08T12:05:00.000
Workorder Added
2015-08-07T09:15:24.000
Time Stamp
2015-08-27T00:45:17.000
185917138
Svc Request Number: 185917138 • Workorder Number: 843076353 • Workorder Activity Code: WLDSC
Svc Request Number
185917138
Workorder Number
843076353
Workorder Activity Code
WLDSC
Workorder Activity Description
SCAN WATER MAINS- LEAK DET.
Workorder Started
2015-05-14T12:10:00.000
Workorder Completed
2015-05-14T13:10:00.000
Workorder Added
2015-05-14T23:21:04.000
Time Stamp
2015-05-21T00:45:09.000
185919134
Svc Request Number: 185919134 • Workorder Number: 843054268 • Workorder Activity Code: CCTV
Svc Request Number
185919134
Workorder Number
843054268
Workorder Activity Code
CCTV
Workorder Activity Description
CLOSE CIRCUIT TV
Workorder Completed
2015-07-25T00:00:00.000
Workorder Added
2015-04-21T17:17:17.000
Time Stamp
2015-08-20T00:45:08.000
185916926
Svc Request Number: 185916926 • Workorder Number: 843108847 • Workorder Activity Code: WL10D
Svc Request Number
185916926
Workorder Number
843108847
Workorder Activity Code
WL10D
Workorder Activity Description
ISSUE 10 DAY NOTICE
Workorder Added
2015-05-04T15:31:21.000
Time Stamp
2015-07-22T00:45:08.000
185915814
Svc Request Number: 185915814 • Workorder Number: 843059359 • Workorder Activity Code: WL3D
Svc Request Number
185915814
Workorder Number
843059359
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-04-30T11:35:00.000
Workorder Completed
2015-05-11T14:10:00.000
Workorder Added
2015-05-01T10:45:28.000
Time Stamp
2015-05-16T00:45:10.000
185925457
Svc Request Number: 185925457 • Workorder Number: 843080697 • Workorder Activity Code: SA34
Svc Request Number
185925457
Workorder Number
843080697
Workorder Activity Code
SA34
Workorder Activity Description
REPAIR NOISY MANHOLE CASTING
Workorder Started
2015-05-20T11:35:00.000
Workorder Completed
2015-05-20T12:00:00.000
Workorder Added
2015-05-21T14:33:38.000
Time Stamp
2015-05-22T00:45:09.000
185913506
Svc Request Number: 185913506 • Workorder Number: 843053598 • Workorder Activity Code: SA24
Svc Request Number
185913506
Workorder Number
843053598
Workorder Activity Code
SA24
Workorder Activity Description
REPAIR BASIN-MAJOR
Workorder Started
2015-06-17T04:15:00.000
Workorder Completed
2015-06-17T06:00:00.000
Workorder Added
2015-04-20T12:05:39.000
Time Stamp
2015-07-06T00:45:08.000
185916064
Svc Request Number: 185916064 • Workorder Number: 843077200 • Workorder Activity Code: SCR
Svc Request Number
185916064
Workorder Number
843077200
Workorder Activity Code
SCR
Workorder Activity Description
ROD CATCH BASIN CONNECTION
Workorder Started
2015-05-11T09:10:00.000
Workorder Completed
2015-05-11T09:55:00.000
Workorder Added
2015-05-17T14:49:39.000
Time Stamp
2015-05-18T00:45:10.000
185897520
Svc Request Number: 185897520 • Workorder Number: 843104086 • Workorder Activity Code: SA25
Svc Request Number
185897520
Workorder Number
843104086
Workorder Activity Code
SA25
Workorder Activity Description
REPAIR CONNECTION
Workorder Added
2015-07-06T11:45:38.000
Time Stamp
2015-07-07T00:45:01.000
185916219
Svc Request Number: 185916219 • Workorder Number: 843079507 • Workorder Activity Code: SMDT
Svc Request Number
185916219
Workorder Number
843079507
Workorder Activity Code
SMDT
Workorder Activity Description
PERFORM DYE TEST
Workorder Started
2015-05-11T10:20:00.000
Workorder Completed
2015-05-11T11:00:00.000
Workorder Added
2015-05-20T10:10:34.000
Time Stamp
2015-06-09T00:45:09.000
186064379
Svc Request Number: 186064379 • Workorder Number: 843202229 • Workorder Activity Code: WL10D
Svc Request Number
186064379
Workorder Number
843202229
Workorder Activity Code
WL10D
Workorder Activity Description
ISSUE 10 DAY NOTICE
Workorder Added
2016-01-21T10:14:30.000
Time Stamp
2016-01-26T00:45:02.000
186010178
Svc Request Number: 186010178 • Workorder Number: 843163452 • Workorder Activity Code: SA12F
Svc Request Number
186010178
Workorder Number
843163452
Workorder Activity Code
SA12F
Workorder Activity Description
APPLY COLD PATCH
Workorder Started
2015-11-05T10:10:00.000
Workorder Completed
2015-11-05T10:30:00.000
Workorder Added
2015-11-06T10:44:55.000
Time Stamp
2015-12-03T00:45:06.000
185916239
Svc Request Number: 185916239 • Workorder Number: 843053305 • Workorder Activity Code: SA34
Svc Request Number
185916239
Workorder Number
843053305
Workorder Activity Code
SA34
Workorder Activity Description
REPAIR NOISY MANHOLE CASTING
Workorder Started
2015-05-11T13:45:00.000
Workorder Completed
2015-05-11T14:00:00.000
Workorder Added
2015-04-20T05:35:16.000
Time Stamp
2015-05-13T00:45:10.000
186017676
Svc Request Number: 186017676 • Workorder Number: 843142975 • Workorder Activity Code: SA26
Svc Request Number
186017676
Workorder Number
843142975
Workorder Activity Code
SA26
Workorder Activity Description
REPLACE MANHOLE CASTING
Workorder Started
2015-10-01T00:45:00.000
Workorder Completed
2015-10-01T03:45:00.000
Workorder Added
2015-09-30T21:42:20.000
Time Stamp
2015-10-03T00:45:08.000
186094937
Svc Request Number: 186094937 • Workorder Number: 843265889 • Workorder Activity Code: WL10D
Svc Request Number
186094937
Workorder Number
843265889
Workorder Activity Code
WL10D
Workorder Activity Description
ISSUE 10 DAY NOTICE
Workorder Added
2016-05-09T12:23:53.000
Time Stamp
2016-05-26T00:45:01.000
185980352
Svc Request Number: 185980352 • Workorder Number: 843116866 • Workorder Activity Code: WA12I
Svc Request Number
185980352
Workorder Number
843116866
Workorder Activity Code
WA12I
Workorder Activity Description
APPLY HOT PATCH
Workorder Started
2015-12-09T09:10:00.000
Workorder Completed
2015-12-09T09:35:00.000
Workorder Added
2015-08-05T10:33:59.000
Time Stamp
2015-12-16T00:46:28.000
185911479
Svc Request Number: 185911479 • Workorder Number: 843048611 • Workorder Activity Code: WL3D
Svc Request Number
185911479
Workorder Number
843048611
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-05-05T10:00:00.000
Workorder Completed
2015-05-05T10:10:00.000
Workorder Added
2015-04-07T11:26:16.000
Time Stamp
2015-05-07T00:45:07.000
185930586
Svc Request Number: 185930586 • Workorder Number: 843082048 • Workorder Activity Code: SCR
Svc Request Number
185930586
Workorder Number
843082048
Workorder Activity Code
SCR
Workorder Activity Description
ROD CATCH BASIN CONNECTION
Workorder Added
2015-05-26T10:49:04.000
Time Stamp
2015-05-27T00:45:08.000
186043775
Svc Request Number: 186043775 • Workorder Number: 843175244 • Workorder Activity Code: SA22O
Svc Request Number
186043775
Workorder Number
843175244
Workorder Activity Code
SA22O
Workorder Activity Description
INSTALL HOOD & HANGER ON OPEN CURB PIECE
Workorder Started
2015-11-27T10:05:00.000
Workorder Completed
2015-11-27T10:45:00.000
Workorder Added
2015-11-28T11:26:13.000
Time Stamp
2015-11-29T00:45:12.000
186025088
Svc Request Number: 186025088 • Workorder Number: 843152991 • Workorder Activity Code: WA02
Svc Request Number
186025088
Workorder Number
843152991
Workorder Activity Code
WA02
Workorder Activity Description
REPAIR HYDRANT-MAJOR
Workorder Started
2015-11-14T08:30:00.000
Workorder Completed
2015-11-14T12:30:00.000
Workorder Added
2015-10-16T09:36:16.000
Time Stamp
2015-11-19T00:45:09.000
185899072
Svc Request Number: 185899072 • Workorder Number: 843049625 • Workorder Activity Code: WA02
Svc Request Number
185899072
Workorder Number
843049625
Workorder Activity Code
WA02
Workorder Activity Description
REPAIR HYDRANT-MAJOR
Workorder Started
2015-06-10T10:00:00.000
Workorder Completed
2015-06-10T14:00:00.000
Workorder Added
2015-04-09T12:30:00.000
Time Stamp
2015-06-16T00:45:01.000
185937128
Svc Request Number: 185937128 • Workorder Number: 843081047 • Workorder Activity Code: WL3D
Svc Request Number
185937128
Workorder Number
843081047
Workorder Activity Code
WL3D
Workorder Activity Description
ISSUE 3-DAY NOTICE
Workorder Started
2015-05-29T17:10:00.000
Workorder Completed
2015-05-29T17:20:00.000
Workorder Added
2015-05-22T12:22:38.000
Time Stamp
2015-06-04T00:45:08.000
185917185
Svc Request Number: 185917185 • Workorder Number: 843054901 • Workorder Activity Code: WA06A
Svc Request Number
185917185
Workorder Number
843054901
Workorder Activity Code
WA06A
Workorder Activity Description
SHUT TAP/WET CON. /NON-COMP.
Workorder Started
2015-05-17T00:30:00.000
Workorder Completed
2015-05-17T07:00:00.000
Workorder Added
2015-04-23T04:15:22.000
Time Stamp
2015-05-20T00:45:09.000
185662807
Svc Request Number: 185662807 • Workorder Number: 843114537 • Workorder Activity Code: WA12A
Svc Request Number
185662807
Workorder Number
843114537
Workorder Activity Code
WA12A
Workorder Activity Description
RESTORE CEMENT AROUND HYDRANT
Workorder Started
2015-08-03T08:30:00.000
Workorder Completed
2015-08-03T10:30:00.000
Workorder Added
2013-11-01T08:28:14.000
Time Stamp
2015-09-12T00:45:09.000
185913702
Svc Request Number: 185913702 • Workorder Number: 843056301 • Workorder Activity Code: WA06A
Svc Request Number
185913702
Workorder Number
843056301
Workorder Activity Code
WA06A
Workorder Activity Description
SHUT TAP/WET CON. /NON-COMP.
Workorder Started
2015-04-30T08:20:00.000
Workorder Completed
2015-05-03T00:00:00.000
Workorder Added
2015-04-27T12:14:07.000
Time Stamp
2015-05-16T00:45:10.000