{ "currentVersion": 10.91, "id": 1, "name": "Legacy Service Request Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeDouble", "alias": "ID", "domain": null }, { "name": "SubmitDate", "type": "esriFieldTypeDate", "alias": "SubmitDate", "length": 8, "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "length": 255, "domain": null }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "StreetNum", "type": "esriFieldTypeString", "alias": "StreetNum", "length": 255, "domain": null }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "length": 255, "domain": null }, { "name": "CrossStreet", "type": "esriFieldTypeString", "alias": "CrossStreet", "length": 255, "domain": null }, { "name": "SecondStreet", "type": "esriFieldTypeString", "alias": "SecondStreet", "length": 255, "domain": null }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 255, "domain": null }, { "name": "Landmark", "type": "esriFieldTypeString", "alias": "Landmark", "length": 255, "domain": null }, { "name": "DateAssigned", "type": "esriFieldTypeDate", "alias": "DateAssigned", "length": 8, "domain": null }, { "name": "DateWorkStarted", "type": "esriFieldTypeDate", "alias": "DateWorkStarted", "length": 8, "domain": null }, { "name": "DateDue", "type": "esriFieldTypeDate", "alias": "DateDue", "length": 8, "domain": null }, { "name": "DateResolved", "type": "esriFieldTypeDate", "alias": "DateResolved", "length": 8, "domain": null }, { "name": "ActionTaken", "type": "esriFieldTypeString", "alias": "ActionTaken", "length": 255, "domain": null }, { "name": "CloseComments", "type": "esriFieldTypeString", "alias": "CloseComments", "length": 255, "domain": null }, { "name": "Responder", "type": "esriFieldTypeString", "alias": "Responder", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "UserName", "type": "esriFieldTypeString", "alias": "UserName", "length": 255, "domain": null }, { "name": "AssignedTo", "type": "esriFieldTypeDouble", "alias": "AssignedTo", "domain": null }, { "name": "Equipment", "type": "esriFieldTypeString", "alias": "Equipment", "length": 255, "domain": null }, { "name": "Labor", "type": "esriFieldTypeString", "alias": "Labor", "length": 255, "domain": null }, { "name": "Billing", "type": "esriFieldTypeDouble", "alias": "Billing", "domain": null }, { "name": "Billed", "type": "esriFieldTypeDouble", "alias": "Billed", "domain": null }, { "name": "Materials", "type": "esriFieldTypeString", "alias": "Materials", "length": 255, "domain": null }, { "name": "ConAdd", "type": "esriFieldTypeString", "alias": "ConAdd", "length": 255, "domain": null }, { "name": "ObjectID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R305_SDE_ROWID_UK", "fields": "ObjectID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_305", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "EastLongmeadowGIS.dbo.IMC_JOINGEOCODE", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ConAdd", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }