{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 70, "name": "SUMP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ASSETNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SMARTTAG", "type": "esriFieldTypeString", "alias": "SMARTTag", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SMARTTAG" }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LEGACYID" }, { "name": "ASSETNAME", "type": "esriFieldTypeString", "alias": "Asset Name", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "ASSETNAME" }, { "name": "ASSETDESCRIPTION", "type": "esriFieldTypeString", "alias": "Asset Description", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "ASSETDESCRIPTION" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "Model Number", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "MODELNUMBER" }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SERIALNUMBER" }, { "name": "ASSETSUBTYPE", "type": "esriFieldTypeString", "alias": "Asset Sub Type", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "ASSETSUBTYPE" }, { "name": "ASSOCIATEDEQUIP", "type": "esriFieldTypeString", "alias": "Associated Equipment", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ASSOCIATEDEQUIP" }, { "name": "QUANTITY", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "QUANTITY" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "SIZE1", "type": "esriFieldTypeString", "alias": "Size1", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SIZE1" }, { "name": "UNIT1", "type": "esriFieldTypeString", "alias": "Unit1", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "UNIT1" }, { "name": "SIZE2", "type": "esriFieldTypeString", "alias": "Size2", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SIZE2" }, { "name": "UNIT2", "type": "esriFieldTypeString", "alias": "Unit2", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "UNIT2" }, { "name": "SIZE3", "type": "esriFieldTypeString", "alias": "Size3", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SIZE3" }, { "name": "UNIT3", "type": "esriFieldTypeString", "alias": "Unit3", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "UNIT3" }, { "name": "SIZE4", "type": "esriFieldTypeString", "alias": "Size4", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SIZE4" }, { "name": "UNIT4", "type": "esriFieldTypeString", "alias": "Unit4", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "UNIT4" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Installation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "Site", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SITE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LOCATION" }, { "name": "PROCESS", "type": "esriFieldTypeString", "alias": "Process", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROCESS" }, { "name": "SUBPROCESS", "type": "esriFieldTypeString", "alias": "Sub Process", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUBPROCESS" }, { "name": "SYSTEM", "type": "esriFieldTypeString", "alias": "System", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SYSTEM" }, { "name": "LOCATIONTYPE", "type": "esriFieldTypeString", "alias": "Location Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATIONTYPE" }, { "name": "USEFULLIFE_ACC", "type": "esriFieldTypeDouble", "alias": "Useful Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "USEFULLIFE_ACC" }, { "name": "USEFULLIFE_AM", "type": "esriFieldTypeDouble", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "USEFULLIFE_AM" }, { "name": "CONDITION", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CONDITION" }, { "name": "TARGETCONDITION", "type": "esriFieldTypeDouble", "alias": "Target Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TARGETCONDITION" }, { "name": "CONDITIONCOMMENT", "type": "esriFieldTypeString", "alias": "Condition Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "CONDITIONCOMMENT" }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CONDITIONDATE" }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTCOST" }, { "name": "REPLACEMENTCOSTVAR", "type": "esriFieldTypeDouble", "alias": "Replacement Cost Adjustment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTCOSTVAR" }, { "name": "LASTREHABYEAR", "type": "esriFieldTypeDouble", "alias": "Year Last Rehabbed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LASTREHABYEAR" }, { "name": "REHABFREQUENCY1", "type": "esriFieldTypeDouble", "alias": "Rehab Frequency 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REHABFREQUENCY1" }, { "name": "REHABCOST1", "type": "esriFieldTypeDouble", "alias": "Rehab Cost 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REHABCOST1" }, { "name": "REHABFREQUENCY2", "type": "esriFieldTypeDouble", "alias": "Rehab Frequency 2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REHABFREQUENCY2" }, { "name": "REHABCOST2", "type": "esriFieldTypeDouble", "alias": "Rehab Cost 2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REHABCOST2" }, { "name": "PERCENTCONSUMED", "type": "esriFieldTypeDouble", "alias": "Percent Consumed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PERCENTCONSUMED" }, { "name": "ANNUALDEPRECIATION", "type": "esriFieldTypeDouble", "alias": "Annual Depreciation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ANNUALDEPRECIATION" }, { "name": "ANNUALDEPRECIATIONRATE", "type": "esriFieldTypeDouble", "alias": "Annual Depreciation Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ANNUALDEPRECIATIONRATE" }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecyle Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LIFECYCLESTATUS" }, { "name": "LASTUPDATED", "type": "esriFieldTypeDate", "alias": "Last Updated", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATED" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "IMAGES", "type": "esriFieldTypeString", "alias": "Image Path", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "IMAGES" }, { "name": "FINANCIALTYPE", "type": "esriFieldTypeString", "alias": "Financial Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FINANCIALTYPE" }, { "name": "FINANCIALSUBTYPE", "type": "esriFieldTypeString", "alias": "Financial SubType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FINANCIALSUBTYPE" }, { "name": "SCADATAG", "type": "esriFieldTypeString", "alias": "SCADA Tag", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SCADATAG" }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ASSETID" }, { "name": "FLOORID", "type": "esriFieldTypeString", "alias": "Relate ID - Floor ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FLOORID" }, { "name": "SUBPROCESSID", "type": "esriFieldTypeString", "alias": "Relate ID - SubProcess ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUBPROCESSID" }, { "name": "SYSTEMID", "type": "esriFieldTypeString", "alias": "Relate ID - System ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SYSTEMID" }, { "name": "ROOMID", "type": "esriFieldTypeString", "alias": "Relate ID - Room ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ROOMID" }, { "name": "PARENTASSETID", "type": "esriFieldTypeString", "alias": "Relate ID - ParentAssetID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PARENTASSETID" }, { "name": "Proc_ID", "type": "esriFieldTypeString", "alias": "Proc_ID", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Proc_ID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Site_Proc_ID", "type": "esriFieldTypeString", "alias": "Site_Proc_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Site_Proc_ID" } ], "indexes": [ { "name": "R102_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_102", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_102", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SUMP", "description": "", "prototype": { "attributes": { "Site_Proc_ID": null, "Proc_ID": null, "SMARTTAG": null, "LEGACYID": null, "ASSETNAME": null, "ASSETDESCRIPTION": null, "MANUFACTURER": null, "MODELNUMBER": null, "SERIALNUMBER": null, "ASSETSUBTYPE": null, "ASSOCIATEDEQUIP": null, "QUANTITY": null, "MATERIAL": null, "SIZE1": null, "UNIT1": null, "SIZE2": null, "UNIT2": null, "SIZE3": null, "UNIT3": null, "SIZE4": null, "UNIT4": null, "INSTALLDATE": null, "WARRANTYDATE": null, "SITE": null, "LOCATION": null, "PROCESS": null, "SUBPROCESS": null, "SYSTEM": null, "LOCATIONTYPE": null, "USEFULLIFE_ACC": null, "USEFULLIFE_AM": null, "CONDITION": null, "TARGETCONDITION": null, "CONDITIONCOMMENT": null, "CONDITIONDATE": null, "POF": null, "COF": null, "BRE": null, "REPLACEMENTCOST": null, "REPLACEMENTCOSTVAR": null, "LASTREHABYEAR": null, "REHABFREQUENCY1": null, "REHABCOST1": null, "REHABFREQUENCY2": null, "REHABCOST2": null, "PERCENTCONSUMED": null, "ANNUALDEPRECIATION": null, "ANNUALDEPRECIATIONRATE": null, "LIFECYCLESTATUS": null, "LASTUPDATED": null, "LASTEDITOR": null, "COMMENTS": null, "IMAGES": null, "FINANCIALTYPE": null, "FINANCIALSUBTYPE": null, "SCADATAG": null, "ASSETID": null, "FLOORID": null, "SUBPROCESSID": null, "SYSTEMID": null, "ROOMID": null, "PARENTASSETID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "8918931698a64729ae7646e260e20ae0" }