{ "currentVersion": 10.81, "id": 1, "name": "CONSUMER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "ServicePoint", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "StrucID_SP", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FeederName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ConsumerAccountNumber", "type": "esriFieldTypeString", "alias": "ConsumerAccountNumber", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ConsumerAccountNumber" }, { "name": "Consumerinformationnumber", "type": "esriFieldTypeString", "alias": "Consumerinformationnumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Consumerinformationnumber" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Address" }, { "name": "PhonenumberMobile", "type": "esriFieldTypeString", "alias": "PhonenumberMobile", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PhonenumberMobile" }, { "name": "ConnectedToPoleID", "type": "esriFieldTypeString", "alias": "ConnectedToPoleID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ConnectedToPoleID" }, { "name": "ConnectedDTCCode", "type": "esriFieldTypeString", "alias": "ConnectedDTCCode", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ConnectedDTCCode" }, { "name": "FeederID", "type": "esriFieldTypeString", "alias": "FeederID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FeederID" }, { "name": "FeederName", "type": "esriFieldTypeString", "alias": "FeederName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FeederName" }, { "name": "SubstationCode", "type": "esriFieldTypeString", "alias": "SubstationCode", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SubstationCode" }, { "name": "SubstationName", "type": "esriFieldTypeString", "alias": "SubstationName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SubstationName" }, { "name": "ConsumerStatus", "type": "esriFieldTypeString", "alias": "ConsumerStatus", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ConsumerStatus" }, { "name": "ConnectionStatus", "type": "esriFieldTypeString", "alias": "ConnectionStatus", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ConnectionStatus" }, { "name": "Typeofsupply", "type": "esriFieldTypeString", "alias": "Typeofsupply", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Typeofsupply" }, { "name": "ConnectedPhase", "type": "esriFieldTypeSmallInteger", "alias": "ConnectedPhase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConnectedPhase" }, { "name": "CustomerSupplyVoltage", "type": "esriFieldTypeSmallInteger", "alias": "CustomerSupplyVoltage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CustomerSupplyVoltage" }, { "name": "ConsumerClass", "type": "esriFieldTypeString", "alias": "ConsumerClass", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ConsumerClass" }, { "name": "TariffCategory", "type": "esriFieldTypeString", "alias": "TariffCategory", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TariffCategory" }, { "name": "MeterOwnership", "type": "esriFieldTypeString", "alias": "MeterOwnership", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MeterOwnership" }, { "name": "MeterSerialNumber", "type": "esriFieldTypeString", "alias": "MeterSerialNumber", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MeterSerialNumber" }, { "name": "MeterManufacturer", "type": "esriFieldTypeString", "alias": "MeterManufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MeterManufacturer" }, { "name": "TypeofMeter", "type": "esriFieldTypeString", "alias": "TypeofMeter", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "TypeofMeter" }, { "name": "ConnectionDate", "type": "esriFieldTypeString", "alias": "ConnectionDate", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ConnectionDate" }, { "name": "SanctionedLoad", "type": "esriFieldTypeDouble", "alias": "SanctionedLoad", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SanctionedLoad" }, { "name": "ConnectedLoad", "type": "esriFieldTypeString", "alias": "ConnectedLoad", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ConnectedLoad" }, { "name": "NOCScode", "type": "esriFieldTypeString", "alias": "NOCScode", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NOCScode" }, { "name": "Circlecode", "type": "esriFieldTypeString", "alias": "Circlecode", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Circlecode" }, { "name": "Zonecode", "type": "esriFieldTypeString", "alias": "Zonecode", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Zonecode" }, { "name": "BookNumber", "type": "esriFieldTypeString", "alias": "BookNumber", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BookNumber" }, { "name": "XLocation", "type": "esriFieldTypeDouble", "alias": "XLocation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "XLocation" }, { "name": "YLocation", "type": "esriFieldTypeDouble", "alias": "YLocation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YLocation" }, { "name": "ConsumerName", "type": "esriFieldTypeString", "alias": "ConsumerName", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ConsumerName" }, { "name": "BuildingID", "type": "esriFieldTypeString", "alias": "BuildingID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BuildingID" }, { "name": "Subtype", "type": "esriFieldTypeSmallInteger", "alias": "Subtype", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Subtype" }, { "name": "BillGroup", "type": "esriFieldTypeString", "alias": "BillGroup", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BillGroup" }, { "name": "CustomerType", "type": "esriFieldTypeString", "alias": "CustomerType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CustomerType" }, { "name": "ConsumerNumber", "type": "esriFieldTypeString", "alias": "ConsumerNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ConsumerNumber" }, { "name": "StrucID_SP", "type": "esriFieldTypeString", "alias": "StrucID_SP", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StrucID_SP" }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Remarks" }, { "name": "Floor", "type": "esriFieldTypeSmallInteger", "alias": "Floor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Floor" }, { "name": "IsAdminApprove", "type": "esriFieldTypeInteger", "alias": "IsAdminApprove", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsAdminApprove" }, { "name": "ApprovedBy", "type": "esriFieldTypeString", "alias": "ApprovedBy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ApprovedBy" }, { "name": "ShiftedBy", "type": "esriFieldTypeString", "alias": "ShiftedBy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ShiftedBy" }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreatedDate" }, { "name": "ApproveDate", "type": "esriFieldTypeDate", "alias": "ApproveDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ApproveDate" }, { "name": "UpdatedDate", "type": "esriFieldTypeDate", "alias": "UpdatedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UpdatedDate" }, { "name": "SurveyedBy", "type": "esriFieldTypeString", "alias": "SurveyedBy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SurveyedBy" }, { "name": "SurveyedDate", "type": "esriFieldTypeDate", "alias": "SurveyedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SurveyedDate" }, { "name": "ShiftedToMainDabase", "type": "esriFieldTypeInteger", "alias": "ShiftedToMainDabase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ShiftedToMainDabase" }, { "name": "TrackingNumber", "type": "esriFieldTypeString", "alias": "TrackingNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TrackingNumber" }, { "name": "SurveyID", "type": "esriFieldTypeString", "alias": "SurveyID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SurveyID" }, { "name": "NOCSName", "type": "esriFieldTypeString", "alias": "NOCSName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NOCSName" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R110_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I580TariffCatego", "fields": "TariffCategory", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I580StrucID_SP", "fields": "StrucID_SP", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I580BuildingID", "fields": "BuildingID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "CONSUMER", "description": "", "prototype": { "attributes": { "NOCSName": null, "SurveyID": null, "ConsumerAccountNumber": null, "Consumerinformationnumber": null, "Address": null, "PhonenumberMobile": null, "ConnectedToPoleID": null, "ConnectedDTCCode": null, "FeederID": null, "FeederName": null, "SubstationCode": null, "SubstationName": null, "ConsumerStatus": null, "ConnectionStatus": null, "Typeofsupply": null, "ConnectedPhase": null, "CustomerSupplyVoltage": null, "ConsumerClass": null, "TariffCategory": null, "MeterOwnership": null, "MeterSerialNumber": null, "MeterManufacturer": null, "TypeofMeter": null, "ConnectionDate": null, "SanctionedLoad": null, "ConnectedLoad": null, "NOCScode": null, "Circlecode": null, "Zonecode": null, "BookNumber": null, "XLocation": null, "YLocation": null, "ConsumerName": null, "BuildingID": null, "Subtype": null, "BillGroup": null, "CustomerType": null, "ConsumerNumber": null, "StrucID_SP": null, "Remarks": null, "Floor": null, "IsAdminApprove": null, "ApprovedBy": null, "ShiftedBy": null, "CreatedDate": null, "ApproveDate": null, "UpdatedDate": null, "SurveyedBy": null, "SurveyedDate": null, "ShiftedToMainDabase": null, "TrackingNumber": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "8a58241f922e4beca1071a64f3b91d97" }