{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 7, "name": "SR_and_WO", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Reqest_ID", "type": "esriFieldTypeDouble", "alias": "Reqest_ID", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "Workorder_ID", "type": "esriFieldTypeString", "alias": "Workorder_ID", "length": 60, "domain": null }, { "name": "SR_Initiated", "type": "esriFieldTypeDate", "alias": "SR_Initiated", "length": 8, "domain": null }, { "name": "SR_Closed", "type": "esriFieldTypeDate", "alias": "SR_Closed", "length": 8, "domain": null }, { "name": "WO_Initiated", "type": "esriFieldTypeDate", "alias": "WO_Initiated", "length": 8, "domain": null }, { "name": "WO_Closed", "type": "esriFieldTypeDate", "alias": "WO_Closed", "length": 8, "domain": null }, { "name": "WO_Description", "type": "esriFieldTypeString", "alias": "WO_Description", "length": 60, "domain": null }, { "name": "Problem_Code", "type": "esriFieldTypeString", "alias": "Problem_Code", "length": 20, "domain": null }, { "name": "SR_Description", "type": "esriFieldTypeString", "alias": "SR_Description", "length": 50, "domain": null }, { "name": "SR_Details", "type": "esriFieldTypeString", "alias": "SR_Details", "length": 500, "domain": null }, { "name": "Problem_Address", "type": "esriFieldTypeString", "alias": "Problem_Address", "length": 100, "domain": null }, { "name": "PROBADDTYPE", "type": "esriFieldTypeString", "alias": "PROBADDTYPE", "length": 30, "domain": null }, { "name": "Initiated_By", "type": "esriFieldTypeString", "alias": "Initiated_By", "length": 50, "domain": null }, { "name": "Submit_To", "type": "esriFieldTypeString", "alias": "Submit_To", "length": 50, "domain": null }, { "name": "Submit_To_Phone", "type": "esriFieldTypeString", "alias": "Submit_To_Phone", "length": 24, "domain": null }, { "name": "Submit_To_Email", "type": "esriFieldTypeString", "alias": "Submit_To_Email", "length": 256, "domain": null }, { "name": "Closed_By", "type": "esriFieldTypeString", "alias": "Closed_By", "length": 50, "domain": null }, { "name": "WO_ID_from_SR", "type": "esriFieldTypeString", "alias": "WO_ID_from_SR", "length": 60, "domain": null }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project_Name", "length": 130, "domain": null }, { "name": "SRX", "type": "esriFieldTypeDouble", "alias": "SRX", "domain": null }, { "name": "SRY", "type": "esriFieldTypeDouble", "alias": "SRY", "domain": null }, { "name": "Date_Submit_To", "type": "esriFieldTypeDate", "alias": "Date_Submit_To", "length": 8, "domain": null }, { "name": "Submit_To_Opened", "type": "esriFieldTypeString", "alias": "Submit_To_Opened", "length": 50, "domain": null }, { "name": "DATESUBMITTOOPEN", "type": "esriFieldTypeDate", "alias": "DATESUBMITTOOPEN", "length": 8, "domain": null }, { "name": "Dispatch_To", "type": "esriFieldTypeString", "alias": "Dispatch_To", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "Request_Category", "type": "esriFieldTypeString", "alias": "Request_Category", "length": 50, "domain": null }, { "name": "Problem_SID", "type": "esriFieldTypeDouble", "alias": "Problem_SID", "domain": null }, { "name": "REQCUSTFIELDCATID", "type": "esriFieldTypeDouble", "alias": "REQCUSTFIELDCATID", "domain": null }, { "name": "Project_Complete_Date", "type": "esriFieldTypeDate", "alias": "Project_Complete_Date", "length": 8, "domain": null }, { "name": "Projects_ID", "type": "esriFieldTypeDouble", "alias": "Projects_ID", "domain": null }, { "name": "INITIATEDBYAPP", "type": "esriFieldTypeString", "alias": "INITIATEDBYAPP", "length": 50, "domain": null }, { "name": "Street_Name", "type": "esriFieldTypeString", "alias": "Street_Name", "length": 50, "domain": null }, { "name": "Problem_Location", "type": "esriFieldTypeString", "alias": "Problem_Location", "length": 256, "domain": null }, { "name": "Text_9", "type": "esriFieldTypeString", "alias": "Text_9", "length": 100, "domain": null }, { "name": "INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null }, { "name": "SUBMITTOSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOSID", "domain": null }, { "name": "SUBMITTOOPENBYSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOOPENBYSID", "domain": null }, { "name": "CANCELLEDBYSID", "type": "esriFieldTypeInteger", "alias": "CANCELLEDBYSID", "domain": null }, { "name": "CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null }, { "name": "DISPATCHTOSID", "type": "esriFieldTypeInteger", "alias": "DISPATCHTOSID", "domain": null }, { "name": "DISPATCHOPENBYSID", "type": "esriFieldTypeInteger", "alias": "DISPATCHOPENBYSID", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }