CityDW: Service Request Data Dictionary Page 1
DC Home Mayor Fenty DC Guide Residents Business Visitors DC Government Kids

Citywide Data Warehouse

CityDW HOME
CityDW HOME
CAPStat HOME
About CityDW
Web Feeds
OCTO HOME
SERVICES
SERVICES
SERVICES
INFORMATION
ONLINE SERVICE
  REQUESTS

ONLINE SERVICE
REQUESTS

ONLINE SERVICE
  REQUESTS

About CityDW
How to Reach Us
Site Map
News Room
Data Catalog and Data Feeds
Summary Reports
Field Work Force
 Wireless Access

CityDW Program
Data
Articles

Service Request Data Dictionary

The table below provides detailed information on each field name associated with the Service Request live data feed.  
 
Element Name Description
servicerequestid                Unique identifier assigned to the service request
servicepriority Priority assigned to the request
servicecode Service request type code
servicecodedescription Service request type code description
servicetypecode Type of service request
servicetypecodedescription Description of service request type
serviceorderdate Date the problem occurred
serviceorderstatus Status of the service
servicecallcount Numbers of calls associated with the particular service request
agencyabbreviation Agency who is responsible for addressing the request
inspectionflag A flag stating if inspection is complete or not
inspectiondate For services that require an inspection, the date the inspection took place
resolution Description of how agency resolved the request
resolutiondate Date the request was resolved
serviceduedate Date due to close the service type. Most services have standard closure rates
servicenotes Comments entered to further describe the service request                            
Page 1 of 3    Go To Previous Page  1  2  3  Go To Next Page