{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "AssetQuarterlyReport", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1683215405000 }, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Project_Manager", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project_Manager", "type": "esriFieldTypeString", "alias": "Project Manager", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Manager" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Department" }, { "name": "Project_Number", "type": "esriFieldTypeInteger", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Project_Title", "type": "esriFieldTypeString", "alias": "Project Title", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Title" }, { "name": "Lifetime_Amount", "type": "esriFieldTypeInteger", "alias": "Lifetime Amount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lifetime_Amount" }, { "name": "Project_Status", "type": "esriFieldTypeString", "alias": "Project Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Status" }, { "name": "F2020_Consumption", "type": "esriFieldTypeDouble", "alias": "2020 Consumption", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F2020_Consumption" }, { "name": "F2021_Consumption", "type": "esriFieldTypeDouble", "alias": "2021 Consumption", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F2021_Consumption" }, { "name": "F2022_Consumption", "type": "esriFieldTypeDouble", "alias": "2022 Consumption", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F2022_Consumption" }, { "name": "F2023_Consumption", "type": "esriFieldTypeDouble", "alias": "2023 Consumption", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F2023_Consumption" }, { "name": "Total_Consumption", "type": "esriFieldTypeDouble", "alias": "Total Consumption", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Consumption" }, { "name": "Project_Start", "type": "esriFieldTypeInteger", "alias": "Project Start", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Start" }, { "name": "Project_Finish", "type": "esriFieldTypeInteger", "alias": "Project Finish", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Finish" }, { "name": "ACQUISITION_PROJECT__Y_N_", "type": "esriFieldTypeString", "alias": "ACQUISITION PROJECT? Y/N?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ACQUISITION_PROJECT__Y_N_" }, { "name": "STAGE_OF_ACQUISITION_", "type": "esriFieldTypeString", "alias": "STAGE OF ACQUISITION?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STAGE_OF_ACQUISITION_" }, { "name": "STAGE_OF_CONSTRUCTION_PROJECT_", "type": "esriFieldTypeString", "alias": "STAGE OF CONSTRUCTION PROJECT?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STAGE_OF_CONSTRUCTION_PROJECT_" }, { "name": "PROJECT_PROJECTED_TO_FINISH_ON_", "type": "esriFieldTypeString", "alias": "PROJECT PROJECTED TO FINISH ON TIME: Y/N/MAYBE?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROJECT_PROJECTED_TO_FINISH_ON_" }, { "name": "WHY_", "type": "esriFieldTypeString", "alias": "WHY?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WHY_" }, { "name": "PROJECT_PROJECTED_TO_FINISH_ON1", "type": "esriFieldTypeString", "alias": "PROJECT PROJECTED TO FINISH ON BUDGET: Y/N/MAYBE?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROJECT_PROJECTED_TO_FINISH_ON1" }, { "name": "WHY__1", "type": "esriFieldTypeString", "alias": "WHY?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WHY__1" }, { "name": "PROJECT_RISKS", "type": "esriFieldTypeString", "alias": "PROJECT RISKS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROJECT_RISKS" }, { "name": "PROJECT_SUCCESSES", "type": "esriFieldTypeString", "alias": "PROJECT SUCCESSES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROJECT_SUCCESSES" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R22746_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_22746", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_22746", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "AssetQuarterlyReport", "description": "", "prototype": { "attributes": { "PROJECT_SUCCESSES": null, "Project_Manager": null, "Department": null, "Project_Number": null, "Project_Title": null, "Lifetime_Amount": null, "Project_Status": null, "F2020_Consumption": null, "F2021_Consumption": null, "F2022_Consumption": null, "F2023_Consumption": null, "Total_Consumption": null, "Project_Start": null, "Project_Finish": null, "ACQUISITION_PROJECT__Y_N_": null, "STAGE_OF_ACQUISITION_": null, "STAGE_OF_CONSTRUCTION_PROJECT_": null, "PROJECT_PROJECTED_TO_FINISH_ON_": null, "WHY_": null, "PROJECT_PROJECTED_TO_FINISH_ON1": null, "WHY__1": null, "PROJECT_RISKS": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }