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

Citywide Data Warehouse

View sub-linksCityDW HOME
 
OCTO HOME
 
View sub-linksSERVICES
 
View sub-linksINFORMATION
 
ONLINE SERVICE
REQUESTS

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