{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "sbgis.DBO.ProcureDashboard_v3", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Project_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Name" }, { "name": "Board_Approved_Budget", "type": "esriFieldTypeDouble", "alias": "Board Approved Budget", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Board_Approved_Budget" }, { "name": "Current_Estimated_Budget", "type": "esriFieldTypeDouble", "alias": "Current Estimated Budget", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Current_Estimated_Budget" }, { "name": "Total_Expenditure_to_Date", "type": "esriFieldTypeDouble", "alias": "Total Expenditure to Date", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Expenditure_to_Date" }, { "name": "Construction_Expenditure", "type": "esriFieldTypeDouble", "alias": "Construction Expenditure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Construction_Expenditure" }, { "name": "CM_Contract_", "type": "esriFieldTypeString", "alias": "CM Contract#", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CM_Contract_" }, { "name": "CM_Vendor", "type": "esriFieldTypeString", "alias": "CM Vendor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CM_Vendor" }, { "name": "CM_Contract_Original", "type": "esriFieldTypeDouble", "alias": "CM Contract Original", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Contract_Original" }, { "name": "CM_Change_order", "type": "esriFieldTypeString", "alias": "CM Change order", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CM_Change_order" }, { "name": "CM_Contingency", "type": "esriFieldTypeDouble", "alias": "CM Contingency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Contingency" }, { "name": "CM_Contingency_Change", "type": "esriFieldTypeString", "alias": "CM Contingency Change", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CM_Contingency_Change" }, { "name": "CM_Contingency__Release_Typical", "type": "esriFieldTypeDouble", "alias": "CM Contingency Release Typical", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Contingency__Release_Typical" }, { "name": "CM_Contingency__Release_Non_Typ", "type": "esriFieldTypeDouble", "alias": "CM Contingency Release Non Typical", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Contingency__Release_Non_Typ" }, { "name": "CM_Remaining_Contingency", "type": "esriFieldTypeDouble", "alias": "CM Remaining Contingency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Remaining_Contingency" }, { "name": "CM_Current_Contract", "type": "esriFieldTypeDouble", "alias": "CM Current Contract", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Current_Contract" }, { "name": "CM_Expenditure", "type": "esriFieldTypeDouble", "alias": "CM Expenditure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Expenditure" }, { "name": "CM__Remaining", "type": "esriFieldTypeDouble", "alias": "CM Remaining", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM__Remaining" }, { "name": "CM____Expenditure", "type": "esriFieldTypeDouble", "alias": "CM % _Expenditure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM____Expenditure" }, { "name": "CC_Contract_", "type": "esriFieldTypeString", "alias": "CC Contract#", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CC_Contract_" }, { "name": "CC_Vendor", "type": "esriFieldTypeString", "alias": "CC Vendor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CC_Vendor" }, { "name": "CC_Original", "type": "esriFieldTypeDouble", "alias": "CC Original", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Original" }, { "name": "CC_Change_Order_Typical", "type": "esriFieldTypeDouble", "alias": "CC Change Order Typical", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Change_Order_Typical" }, { "name": "CC_Change_Order_Non_Typical", "type": "esriFieldTypeDouble", "alias": "CC Change Order Non Typical", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Change_Order_Non_Typical" }, { "name": "CC_Contingency", "type": "esriFieldTypeDouble", "alias": "CC Contingency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Contingency" }, { "name": "CC_Contingency_Change", "type": "esriFieldTypeDouble", "alias": "CC Contingency Change", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Contingency_Change" }, { "name": "CC_Remaining_Contingency", "type": "esriFieldTypeDouble", "alias": "CC Remaining Contingency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Remaining_Contingency" }, { "name": "CC_Current_Contract", "type": "esriFieldTypeDouble", "alias": "CC Current Contract", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Current_Contract" }, { "name": "CC_Expenditure", "type": "esriFieldTypeDouble", "alias": "CC Expenditure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Expenditure" }, { "name": "CC_Remaining", "type": "esriFieldTypeDouble", "alias": "CC Remaining", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Remaining" }, { "name": "CC____Expenditure", "type": "esriFieldTypeString", "alias": "CC % _Expenditure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CC____Expenditure" }, { "name": "Other_Const_Expenditure", "type": "esriFieldTypeDouble", "alias": "Other Const Expenditure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Other_Const_Expenditure" }, { "name": "CM_Contingency_Line", "type": "esriFieldTypeDouble", "alias": "CM Contingency Line", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Contingency_Line" }, { "name": "CC_Contingency_Line", "type": "esriFieldTypeDouble", "alias": "CC Contingency Line", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Contingency_Line" }, { "name": "CM_Original_Contingency_Change", "type": "esriFieldTypeDouble", "alias": "CM Original_Contingency_Change", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CM_Original_Contingency_Change" }, { "name": "CC_Original_Contingency__Change", "type": "esriFieldTypeDouble", "alias": "CC Original_Contingency _Change", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CC_Original_Contingency__Change" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Department" }, { "name": "CMChangeOrder_Num", "type": "esriFieldTypeInteger", "alias": "CM Change Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CMChangeOrder_Num" } ], "indexes": [ { "name": "R1503_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sbgis.DBO.ProcureDashboard_v3", "description": "", "prototype": { "attributes": { "Department": null, "CMChangeOrder_Num": null, "Project_Name": null, "Board_Approved_Budget": null, "Current_Estimated_Budget": null, "Total_Expenditure_to_Date": null, "Construction_Expenditure": null, "CM_Contract_": null, "CM_Vendor": null, "CM_Contract_Original": null, "CM_Change_order": null, "CM_Contingency": null, "CM_Contingency_Change": null, "CM_Contingency__Release_Typical": null, "CM_Contingency__Release_Non_Typ": null, "CM_Remaining_Contingency": null, "CM_Current_Contract": null, "CM_Expenditure": null, "CM__Remaining": null, "CM____Expenditure": null, "CC_Contract_": null, "CC_Vendor": null, "CC_Original": null, "CC_Change_Order_Typical": null, "CC_Change_Order_Non_Typical": null, "CC_Contingency": null, "CC_Contingency_Change": null, "CC_Remaining_Contingency": null, "CC_Current_Contract": null, "CC_Expenditure": null, "CC_Remaining": null, "CC____Expenditure": null, "Other_Const_Expenditure": null, "CM_Contingency_Line": null, "CC_Contingency_Line": null, "CM_Original_Contingency_Change": null, "CC_Original_Contingency__Change": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }