20250314 09224700 1.0 FALSE Drain_Hotspots_For_Creation2025 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1968500.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-86.0],PARAMETER[&quot;Standard_Parallel_1&quot;,35.25],PARAMETER[&quot;Standard_Parallel_2&quot;,36.41666666666666],PARAMETER[&quot;Latitude_Of_Origin&quot;,34.33333333333334],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2274]]</WKT><XOrigin>-121521300</XOrigin><YOrigin>-93934000</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102736</WKID><LatestWKID>2274</LatestWKID></ProjectedCoordinateSystem> 20250605 21022500 20250605 21022500 Esri ArcGIS 13.3.0.52636 Drain_Hotspots_For_Creation2025 Enterprise Geodatabase Feature Class dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE Drain_Hotspots_For_Creation2025 Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. REC_EDIT_MODE Live Link: Change to MANUAL String 50 0 0 REC_EDIT_MODE_COMMENTS REC_EDIT_MODE_COMMENTS String 255 0 0 X X Double 8 38 8 Y Y Double 8 38 8 DIVISION Division String 150 0 0 DEPARTMENT Department String 150 0 0 CATEGORY Category String 50 0 0 INCIDENT_ID Oracle ID Integer 4 10 0 INCIDENT_NUMBER Service Request Number String 15 0 0 INCIDENT_TYPE_ID Service Request Type ID Integer 4 10 0 REQUEST_TYPE Service Request Type String 100 0 0 REQUEST_STATUS Service Request Status String 20 0 0 REQUEST_PRIORITY Service Request Priority String 15 0 0 REPORTED_DATE Reported Date Date 8 0 0 REQUEST_SUMMARY Service Request Summary String 2000 0 0 SR_CREATION_CHANNEL SR_CREATION_CHANNEL String 50 0 0 CREATED_BY_USER Created By String 255 0 0 DAYS_OLD Days Old SmallInteger 2 5 0 CREATION_DATE Creation Date Date 8 0 0 CREATED_BY CREATED_BY Integer 4 10 0 LAST_UPDATE_DATE Last Updated Date Date 8 0 0 UPDATED_BY_USER Updated By String 50 0 0 LAST_UPDATED_BY LAST_UPDATED_BY Integer 4 10 0 LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN Integer 4 10 0 LAST_MODIFIED_DATE LAST_MODIFIED_DATE Date 8 0 0 FOLLOWUP_DATE Follow Up Date Date 8 0 0 NEXT_OPEN_TASK_DATE NEXT_OPEN_TASK_DATE Date 8 0 0 JOB_NOTES Job Notes String 255 0 0 REQUEST_NOTES Consolidated Notes String 2000 0 0 ASSIGNED_TO Assigned To String 50 0 0 SUPERVISOR Supervisor String 50 0 0 NOTIFICATION Notification To String 50 0 0 QAQC_YESNO QA/QC String 50 0 0 QAQC_RATING QA/QC Rating Integer 4 10 0 SUPERVISOR_APPROVAL Supervisor Approval String 5 0 0 SUPERVISOR_NOTES Supervisor Notes String 255 0 0 RESOLVED_DATE Resolved Date Date 8 0 0 CLOSE_DATE Closed Date Date 8 0 0 RESOLUTION_CODE Resolution Code String 100 0 0 RESOLUTION_CODE_MEANING RESOLUTION_CODE_MEANING String 255 0 0 RESOLUTION_SUMMARY Resolution Summary String 2000 0 0 GROUP_NAME GROUP_NAME String 50 0 0 OWNER_NAME OWNER_NAME String 50 0 0 STREET_NAME STREET_NAME String 100 0 0 ADDRESS1 Location String 255 0 0 ADDRESS2 ADDRESS2 String 100 0 0 ADDRESS3 ADDRESS3 String 100 0 0 CITY City String 100 0 0 STATE State String 50 0 0 POSTAL_CODE Postal Code String 20 0 0 PARCEL_ID Parcel ID String 20 0 0 ASSET_ID Asset ID String 20 0 0 P_LOCATION_ID P_LOCATION_ID Integer 4 10 0 P_PARTY_ID P_PARTY_ID Integer 4 10 0 CONTACT_NAME_FIRST Owner Name String 255 0 0 CONTACT_NAME_LAST Owner Name 2 String 255 0 0 PERSON_ADDRESS1 Owner Address1 String 255 0 0 PERSON_ADDRESS2 Owner Address2 String 255 0 0 PERSON_ADDRESS3 Owner Address3 String 255 0 0 PERSON_STATE Owner State String 50 0 0 PERSON_CITY Owner City String 100 0 0 PERSON_ZIP_CODE Owner Zip Code String 50 0 0 MAP_PG Map Page String 50 0 0 MAP_BLK Map Block String 50 0 0 GRID_NO Grid Number SmallInteger 2 5 0 CODE_DISTRICT Code District String 50 0 0 CODE_SUBDISTRICT Code Sub-District String 50 0 0 TARGET_BLOCK Target Block String 50 0 0 Drain_Zone Drain Zone String 50 0 0 Drain_Grid Drain Grid String 50 0 0 Street_Zone Street Zone String 50 0 0 Street_Grid Street Grid String 50 0 0 Sign_Zone Sign Zone String 50 0 0 SWM_AREA SWM Area String 10 0 0 SWM_ZONE SWM Zone String 10 0 0 COLLECTION_DAY Collection Day String 20 0 0 SWM_ROUTE SWM Route String 10 0 0 PREM_CODE Premise Code Integer 4 10 0 CUST_CODE Customer Code Integer 4 10 0 MLGW_ON MLGW Est Date String 25 0 0 MLGW_STATUS MLGW Acct. Status String 25 0 0 SWF_RATE SWM Fee Rate String 10 0 0 SWF_STATUS SWM Fee Status String 10 0 0 MLGW_CUSTOMER MLGW Customer String 255 0 0 MLGW_CONTACT1 MLGW Contact 1 String 25 0 0 MLGW_CONTACT2 MLGW Contact 2 String 25 0 0 MLGW_EMAIL MLGW Contact Email String 100 0 0 NUMBER_OF_TASKS NUMBER_OF_TASKS Integer 4 10 0 LINKED_SR Linked SR String 50 0 0 RELATION Relation with SR String 50 0 0 cd_name Council District No Integer 4 10 0 cd_desc Council District String 100 0 0 sccd_name Shelby Co. Council No Integer 4 10 0 sccd_desc Shelby Co. Council District String 100 0 0 scd_name Super District No Integer 4 10 0 scd_desc Super Council District String 100 0 0 neigh_name neigh_name String 100 0 0 neigh_desc Neighborhood Name String 100 0 0 tract_name Tract Number Integer 4 10 0 tract_desc Tract String 100 0 0 voting_name voting_name String 100 0 0 voting_desc Voting String 100 0 0 zip_name Zip Code No Integer 4 10 0 zip_desc Zip Code String 100 0 0 ce_name ce_name String 100 0 0 ce_desc ce_desc String 100 0 0 cityzone City Zone String 100 0 0 CONTACT_NAME SCF Name String 100 0 0 CONTACT_EMAIL SCF Email String 100 0 0 CONTACT_PHONE SCF Phone String 50 0 0 SCF_URL SeeClickFix URL String 1000 0 0 SCF_Description SeeClickFix Description String 2000 0 0 EX_ATTRIBUTE12 EX_ATTRIBUTE12 String 100 0 0 STATE_ROUTE Intersect String 50 0 0 ADMIN_REQUEST Administration Request String 50 0 0 Reporting_Agency Reporting Agency String 50 0 0 Reported_Issue Reported Issue String 50 0 0 Owner_Notified Owner Notified String 10 0 0 Dispatched_Date Dispatched Date Date 8 0 0 Dispatched_To Dispatched To String 50 0 0 Dispatched Dispatched SmallInteger 2 5 0 ReferredTo Referred To String 50 0 0 ReferredContact Referred Contact String 100 0 0 Referring_Supervisor Referring Supervisor String 25 0 0 ReferredFromNotes Referred From Notes String 1000 0 0 NoCleaned Number Serviced SmallInteger 2 5 0 NoInspected Number Inspected SmallInteger 2 5 0 No_Barricades No Barricades SmallInteger 2 5 0 Barricade_Date Barricade Date Date 8 0 0 Barricade_By Barricade By String 50 0 0 Barricade_PickUpDate Barricade Pick Up Date Date 8 0 0 Barricade_PickUpBy Barricade Pick Up By String 50 0 0 Barricade_InspectionDate Barricade Inspection Date Date 8 0 0 RollIn_YesNo Roll In Yes/No String 5 0 0 RollIn_Length Roll In Length SmallInteger 2 5 0 RollIn_Width Roll In Width SmallInteger 2 5 0 RollIn_ReferralDate Roll In Referral Date Date 8 0 0 RollIn_CrewNo Roll In Crew No SmallInteger 2 5 0 RollIn_Status Roll In Status String 50 0 0 RollIn_Notes Roll In Notes String 250 0 0 RollIn_LaborHours Roll In Labor Hours Double 8 38 8 RollIn_CompletionDate Roll In Completion Date Date 8 0 0 Roll_In_Depth Roll In Depth SmallInteger 2 5 0 Roll_In_Inspector Roll In Inspector String 50 0 0 Roll_In_Plate Roll In Plate String 50 0 0 BackHoe_Hours Back Hoe Hours Double 8 38 8 Roller_Hours Roller Hours Double 8 38 8 CrewCab_Hours Crew Cab Hours Double 8 38 8 TandemDump_Hours Tandem Dump Hours Double 8 38 8 CR610_Tons CR610 Tons Double 8 38 8 Hotmix_TonnageCost Hot Mix Tonnage Cost Double 8 38 8 Hotmix_Tons Hot Mix Tons Double 8 38 8 Coldmix_Tons Cold Mix Tons Double 8 38 8 Labor_HourlyRate Labor Hourly Rate Double 8 38 8 BackHoe_HourlyRate Back Hoe Hourly Rate Double 8 38 8 Roller_HourlyRate Roller Hourly Rate Double 8 38 8 CrewCab_HourlyRate Crew Cab Hourly Rate Double 8 38 8 TandemDump_HourlyRate Tandem Dump Hourly Rate Double 8 38 8 CR610_TonnageCost CR610 Tonnage Cost Double 8 38 8 Coldmix_TonnageCost Cold Mix Tonnage Cost Double 8 38 8 Pipe_Patch Pipe Patch Date 8 0 0 Plated_Date Plated Date Date 8 0 0 Distance_Cleansed Ditch Distance Cleaned Double 8 38 8 Loads_Hauled Loads Hauled Count Double 8 38 8 created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 ASSIGNED_DATE ASSIGNED_DATE Date 8 0 0 X_COORD X_COORD Double 8 38 8 Y_COORD Y_COORD Double 8 38 8 Barricade_YesNo Barricade Yes/No String 5 0 0 OLD_OBJECTID OLD_OBJECTID Integer 4 10 0 RollIn_SqYards RollIn SqYards Double 8 38 8 Transfer Is Transferring String 5 0 0 Transfer_Dept Transferring To String 150 0 0 Transfer_Notes Transfer Justification String 2000 0 0 Number_Closing_Pics_Taken Number Closing Pics Taken SmallInteger 2 5 0 PW (DM)-RESET/REPLACE MANHOLE COVER 29765 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-RESET/REPLACE MANHOLE COVER DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_MANHOLECOVER DM_RES_MANHOLECOVER Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-RESET/REPLACE INLET GRATE 29764 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-RESET/REPLACE INLET GRATE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_INLETGRATE DM_RES_INLETGRATE Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-REPAIR INLET 29763 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-REPAIR INLET DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_REPAIRINLET DM_RES_REPAIRINLET Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-FLOODING STRUCTURE 29762 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-FLOODING STRUCTURE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_FLOODING DM_RES_FLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-FLOODING STREET 29761 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-FLOODING STREET DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_STREETFLOODING DM_RES_STREETFLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-FLOODING LAND 29760 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-FLOODING LAND DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_FLOODING DM_RES_FLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLEAN WASH RACK 29759 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLEAN WASH RACK DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLEANRACK DM_RES_CLEANRACK Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLEAN DRIVEWAY PIPE 29758 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLEAN DRIVEWAY PIPE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLEANDRIVEWAY DM_RES_CLEANDRIVEWAY Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-DITCH MAINTENANCE 29757 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-DITCH MAINTENANCE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_DITCHMAINT DM_RES_DITCHMAINT Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM MANHOLE COVER 29756 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM MANHOLE COVER DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIM_MANHOLE DM_RES_CLAIM_MANHOLE Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM FROM INLET 29755 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM FROM INLET DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMINLET DM_RES_CLAIMINLET Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM FLOODING STREET 29754 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM FLOODING STREET DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMSTREETFLOODING DM_RES_CLAIMSTREETFLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM FLOODING LAND 29753 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM FLOODING LAND DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMFLOODING DM_RES_CLAIMFLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM FLOODING HOUSE 29752 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM FLOODING HOUSE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMFLOODING DM_RES_CLAIMFLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM FLOODING BUILDING 29751 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM FLOODING BUILDING DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMFLOODING DM_RES_CLAIMFLOODING Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM FENCE 29750 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM FENCE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMFENCE DM_RES_CLAIMFENCE Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CLAIM CAVITY 29749 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CLAIM CAVITY DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CLAIMCAVITY DM_RES_CLAIMCAVITY Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CAVITY OFF STREET 29748 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CAVITY OFF STREET DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CAVITYOFFSTREET DM_RES_CAVITYOFFSTREET Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-CAVITY IN STREET 29747 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-CAVITY IN STREET DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_CAVITYINSTREET DM_RES_CAVITYINSTREET Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-PREVENTATIVE MAINTENANCE 24747 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-PREVENTATIVE MAINTENANCE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_PREVENTATIVEMAINT DM_RES_PREVENTATIVEMAINT Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-REPAIR 14747 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-REPAIR DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_REPAIR DM_RES_REPAIR Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-SITE CHECK 13750 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE PW (DM)-SITE CHECK DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_CODE DM_RES_SITECHECK DM_RES_SITECHECK Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String PW (DM)-DRAIN INLET CLOGGED 10709 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE DM_Request_Types DM_Request_Types Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String UPDATED_BY_USER DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String ASSIGNED_TO DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String SUPERVISOR DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String QAQC_YESNO YesNo_String YesNo_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer SUPERVISOR_APPROVAL YesNo_String YesNo_String Coded Value Default value Default value String RESOLUTION_SUMMARY DM_RES_SUMMARY List of Resolution Summary Options for Drain Maintenance Coded Value Default value Default value String MAP_PG MAP_PG MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO GRID_NO Coded Value Default value Default value SmallInteger CODE_SUBDISTRICT CODE_SUBDISTRICT CODE_SUBDISTRICT Coded Value Default value Default value String TARGET_BLOCK TARGET_BLOCK TARGET_BLOCK Coded Value Default value Default value String SWM_AREA SWM_AREA SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS MLGW_STATUS Coded Value Default value Default value String STATE_ROUTE STATE_ROUTE STATE_ROUTE Coded Value Default value Default value String ADMIN_REQUEST PW_Admin_Requester PW Admin Requester Coded Value Default value Default value String Reporting_Agency DM_ReportingAgencies Service Request Report Source Coded Value Default value Default value String Reported_Issue DM_Issue Both Reported and Actual Issue Coded Value Default value Default value String Owner_Notified YesNo_String YesNo_String Coded Value Default value Default value String Dispatched_To DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Dispatched YesNo_Integer YesNo_Integer Coded Value Default value Default value Integer ReferredTo DM_ReferredTo Service Request Referred To Coded Value Default value Default value String Referring_Supervisor DM_ReferringSupervisor Used for transerring requests to other depts. Coded Value Default value Default value String Barricade_By DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String Barricade_PickUpBy DM_AssignedTo Service Request - Person Assigned To Coded Value Default value Default value String RollIn_YesNo YesNo_String YesNo_String Coded Value Default value Default value String RollIn_CrewNo SM_RollInCrewNo Street Maintenance Roll In Crew Nos Coded Value Default value Default value SmallInteger RollIn_Status DM_RequestStatus Service Requests Ticket Status Coded Value Default value Default value String Barricade_YesNo YesNo_String YesNo_String Coded Value Default value Default value String Transfer YesNo_String YesNo_String Coded Value Default value Default value String Number_Closing_Pics_Taken 311_Number_Closing_Pics 311 Number of Closing Pics Taken Coded Value Default value Default value SmallInteger 20250605