{ "currentVersion": 10.41, "id": 8, "name": "CISData", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PRD_MPU_ELECTRIC.DBO.CISData.firstname", "typeIdField": null, "fields": [ { "name": "PRD_MPU_ELECTRIC.DBO.CISData.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.parcel", "type": "esriFieldTypeString", "alias": "parcel", "length": 25, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.customer", "type": "esriFieldTypeString", "alias": "customer", "length": 15, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.account", "type": "esriFieldTypeString", "alias": "account", "length": 15, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.service", "type": "esriFieldTypeString", "alias": "service", "length": 2, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.readtype", "type": "esriFieldTypeString", "alias": "readtype", "length": 2, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.meter", "type": "esriFieldTypeString", "alias": "meter", "length": 10, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.date_installed", "type": "esriFieldTypeDate", "alias": "date_installed", "length": 8, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.firstname", "type": "esriFieldTypeString", "alias": "firstname", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.midlename", "type": "esriFieldTypeString", "alias": "midlename", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.lastname", "type": "esriFieldTypeString", "alias": "lastname", "length": 60, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.street_address", "type": "esriFieldTypeString", "alias": "street_address", "length": 51, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.owner_tenant", "type": "esriFieldTypeString", "alias": "owner_tenant", "length": 1, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.phone", "type": "esriFieldTypeString", "alias": "phone", "length": 50, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.CISData.demand", "type": "esriFieldTypeDouble", "alias": "demand", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ] } }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "codedValues": [ { "name": "Open", "code": 0 }, { "name": "Closed", "code": 1 } ] } }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.CreationUser", "type": "esriFieldTypeString", "alias": "CreationUser", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.LastUser", "type": "esriFieldTypeString", "alias": "LastUser", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.DateModified", "type": "esriFieldTypeDate", "alias": "DateModified", "length": 8, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "LifecycleStatus", "codedValues": [ { "name": "Construction", "code": "Construction" }, { "name": "As-Built", "code": "As-Built" }, { "name": "Abandoned", "code": "Abandoned" } ] } }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.FeederID", "type": "esriFieldTypeString", "alias": "FeederID", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.FeederID2", "type": "esriFieldTypeString", "alias": "FeederID2", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.JobTicket", "type": "esriFieldTypeString", "alias": "JobTicket", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Mfg", "type": "esriFieldTypeString", "alias": "Mfg", "length": 30, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.MfgDate", "type": "esriFieldTypeDate", "alias": "MfgDate", "length": 8, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.TraceWeight", "type": "esriFieldTypeInteger", "alias": "TraceWeight", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.WorkOrder", "type": "esriFieldTypeString", "alias": "WorkOrder", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.StationNo", "type": "esriFieldTypeString", "alias": "StationNo", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.SymbolRotation", "type": "esriFieldTypeDouble", "alias": "SymbolRotation", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.SubtypeCode", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.FeederInfo", "type": "esriFieldTypeInteger", "alias": "Feeder Information", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.ServiceNo", "type": "esriFieldTypeString", "alias": "Service Number", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.TransformerID", "type": "esriFieldTypeInteger", "alias": "Transformer ID", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.AccountNumber", "type": "esriFieldTypeInteger", "alias": "AccountNumber", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.DBID", "type": "esriFieldTypeString", "alias": "DBID", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.BkAccount", "type": "esriFieldTypeString", "alias": "BkAccount", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.MeterNumber", "type": "esriFieldTypeString", "alias": "MeterNumber", "length": 50, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Unit", "type": "esriFieldTypeString", "alias": "Unit", "length": 50, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Cycle", "type": "esriFieldTypeInteger", "alias": "Cycle", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Route", "type": "esriFieldTypeInteger", "alias": "Route", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.DeviceID", "type": "esriFieldTypeString", "alias": "DeviceID", "length": 50, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.RecorderID", "type": "esriFieldTypeString", "alias": "RecorderID", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.RegisterID", "type": "esriFieldTypeString", "alias": "RegisterID", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.MeterType", "type": "esriFieldTypeString", "alias": "MeterType", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Multiplier", "type": "esriFieldTypeDouble", "alias": "Multiplier", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Latitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Longitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.LocationSource", "type": "esriFieldTypeString", "alias": "LocationSource", "length": 10, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "length": 8, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.Phase", "type": "esriFieldTypeInteger", "alias": "Phase", "domain": { "type": "codedValue", "name": "Phase Designation", "codedValues": [ { "name": "A", "code": 4 }, { "name": "B", "code": 2 }, { "name": "C", "code": 1 }, { "name": "AB", "code": 6 }, { "name": "AC", "code": 5 }, { "name": "BC", "code": 3 }, { "name": "ABC", "code": 7 } ] } }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.ServAddrID", "type": "esriFieldTypeInteger", "alias": "ServAddrID", "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.OHUG", "type": "esriFieldTypeString", "alias": "OHUG", "length": 50, "domain": { "type": "codedValue", "name": "OH/UG", "codedValues": [ { "name": "OH", "code": "OH" }, { "name": "UG", "code": "UG" }, { "name": "Unknown", "code": "Unknown" } ] } }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.PhasingCode", "type": "esriFieldTypeInteger", "alias": "PhasingCode", "domain": { "type": "codedValue", "name": "Phase Designation", "codedValues": [ { "name": "A", "code": 4 }, { "name": "B", "code": 2 }, { "name": "C", "code": 1 }, { "name": "AB", "code": 6 }, { "name": "AC", "code": 5 }, { "name": "BC", "code": 3 }, { "name": "ABC", "code": 7 } ] } }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.StakeoutStationGUID", "type": "esriFieldTypeGUID", "alias": "StakeoutStationGUID", "length": 38, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.TaxParcelID", "type": "esriFieldTypeString", "alias": "TaxParcelID", "length": 20, "domain": null }, { "name": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R356_SDE_ROWID_UK", "fields": "PRD_MPU_ELECTRIC.DBO.CISData.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I474account", "fields": "PRD_MPU_ELECTRIC.DBO.CISData.account", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I474parcel", "fields": "PRD_MPU_ELECTRIC.DBO.CISData.parcel", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R410_pk", "fields": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_410", "fields": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G541TaxParcelID", "fields": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.TaxParcelID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_410", "fields": "PRD_MPU_ELECTRIC.DBO.ServiceLocation.GlobalID,PRD_MPU_ELECTRIC.DBO.ServiceLocation.OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "relationships": [], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true }, "dateFieldsTimeReference": null }