{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 3, "name": "CIP_PROJECTS_SMARTSHEET", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": 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,PBF" }, "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": "F_", "type": "esriFieldTypeString", "alias": "$", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "F_" }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Time" }, { "name": "Other", "type": "esriFieldTypeSmallInteger", "alias": "Other", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Other" }, { "name": "Charter", "type": "esriFieldTypeSmallInteger", "alias": "Charter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Charter" }, { "name": "Project__", "type": "esriFieldTypeString", "alias": "Project #", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project__" }, { "name": "Munis__", "type": "esriFieldTypeString", "alias": "Munis #", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Munis__" }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Name" }, { "name": "D_PM", "type": "esriFieldTypeString", "alias": "D-PM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "D_PM" }, { "name": "C_PM", "type": "esriFieldTypeString", "alias": "C-PM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "C_PM" }, { "name": "Project_Budget", "type": "esriFieldTypeString", "alias": "Project Budget", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Budget" }, { "name": "Project_Cost", "type": "esriFieldTypeDouble", "alias": "Project Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Cost" }, { "name": "Prior_Years_Actuals", "type": "esriFieldTypeString", "alias": "Prior Years Actuals", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Prior_Years_Actuals" }, { "name": "FY19_20_Actuals", "type": "esriFieldTypeDouble", "alias": "FY19-20 Actuals", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY19_20_Actuals" }, { "name": "FY21_Actuals", "type": "esriFieldTypeDouble", "alias": "FY21 Actuals", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY21_Actuals" }, { "name": "FY22_Actuals", "type": "esriFieldTypeDouble", "alias": "FY22 Actuals", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Actuals" }, { "name": "Est__Substantial_Date", "type": "esriFieldTypeString", "alias": "Est. Substantial Date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Est__Substantial_Date" }, { "name": "Final_Date", "type": "esriFieldTypeDate", "alias": "Final Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Final_Date" }, { "name": "Procurement", "type": "esriFieldTypeString", "alias": "Procurement", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Procurement" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Department" }, { "name": "Council_Date", "type": "esriFieldTypeString", "alias": "Council Date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Council_Date" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "name": "Act__Design_Completion_date", "type": "esriFieldTypeString", "alias": "Act. Design Completion date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Act__Design_Completion_date" }, { "name": "Act__Substantial_Date", "type": "esriFieldTypeDate", "alias": "Act. Substantial Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Act__Substantial_Date" }, { "name": "Fac_", "type": "esriFieldTypeSmallInteger", "alias": "Fac.", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fac_" }, { "name": "W_S", "type": "esriFieldTypeSmallInteger", "alias": "W/S", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "W_S" }, { "name": "Street", "type": "esriFieldTypeSmallInteger", "alias": "Street", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Street" }, { "name": "HAS_PIO", "type": "esriFieldTypeSmallInteger", "alias": "HAS PIO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HAS_PIO" }, { "name": "Active_Project", "type": "esriFieldTypeString", "alias": "Active Project", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Active_Project" }, { "name": "Fy2021_Q1_Spend", "type": "esriFieldTypeDouble", "alias": "Fy2021 Q1 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fy2021_Q1_Spend" }, { "name": "FY2021_Q1_Chargebacks", "type": "esriFieldTypeDouble", "alias": "FY2021 Q1 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY2021_Q1_Chargebacks" }, { "name": "Fy2021_Q2_Spend", "type": "esriFieldTypeDouble", "alias": "Fy2021 Q2 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fy2021_Q2_Spend" }, { "name": "FY2021_Q2_Chargebacks", "type": "esriFieldTypeDouble", "alias": "FY2021 Q2 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY2021_Q2_Chargebacks" }, { "name": "FY2021_Q3_Spend", "type": "esriFieldTypeDouble", "alias": "FY2021 Q3 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY2021_Q3_Spend" }, { "name": "Fy2021_Q3_Chargebacks", "type": "esriFieldTypeDouble", "alias": "Fy2021 Q3 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fy2021_Q3_Chargebacks" }, { "name": "Fy2021_Q4_Spend", "type": "esriFieldTypeDouble", "alias": "Fy2021 Q4 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Fy2021_Q4_Spend" }, { "name": "FY21_Q4_Chargebacks", "type": "esriFieldTypeDouble", "alias": "FY21 Q4 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY21_Q4_Chargebacks" }, { "name": "Total_Billable_FY21_Chargebacks", "type": "esriFieldTypeDouble", "alias": "Total Billable FY21 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Billable_FY21_Chargebacks" }, { "name": "Total_Actual_Fy21_Chargebacks", "type": "esriFieldTypeDouble", "alias": "Total Actual Fy21 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Actual_Fy21_Chargebacks" }, { "name": "FY22_Q1_Chargebacks", "type": "esriFieldTypeDouble", "alias": "FY22 Q1 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Q1_Chargebacks" }, { "name": "FY22_Q1_Spend", "type": "esriFieldTypeDouble", "alias": "FY22 Q1 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Q1_Spend" }, { "name": "FY22_Total_Chargebacks", "type": "esriFieldTypeDouble", "alias": "Fy22 Total Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Total_Chargebacks" }, { "name": "Total_Invoices", "type": "esriFieldTypeDouble", "alias": "Total Invoices", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Invoices" }, { "name": "Budget_Status", "type": "esriFieldTypeString", "alias": "Budget Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Budget_Status" }, { "name": "Billable_vs_Actual_Chargebacks", "type": "esriFieldTypeDouble", "alias": "Billable vs Actual Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Billable_vs_Actual_Chargebacks" }, { "name": "Address_Start", "type": "esriFieldTypeString", "alias": "Address Start", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address_Start" }, { "name": "Address_End", "type": "esriFieldTypeString", "alias": "Address End", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address_End" }, { "name": "Citywide__Yes_No_", "type": "esriFieldTypeString", "alias": "Citywide (Yes/No)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Citywide__Yes_No_" }, { "name": "FY23_Actuals", "type": "esriFieldTypeDouble", "alias": "FY23 Actuals", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY23_Actuals" }, { "name": "Est__Charter_Design_Completion_", "type": "esriFieldTypeDate", "alias": "Est. Charter Design Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Est__Charter_Design_Completion_" }, { "name": "Actual_Design_Start_Date__Kicko", "type": "esriFieldTypeString", "alias": "Actual Design Start Date (Kickoff Date)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Actual_Design_Start_Date__Kicko" }, { "name": "Contract_Design_Completion_Date", "type": "esriFieldTypeDate", "alias": "Contract Design Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Contract_Design_Completion_Date" }, { "name": "Actual_Construction_Start_Date_", "type": "esriFieldTypeString", "alias": "Actual Construction Start Date (NTP Date)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Actual_Construction_Start_Date_" }, { "name": "FY22_Q2_Spend", "type": "esriFieldTypeDouble", "alias": "FY22 Q2 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Q2_Spend" }, { "name": "FY22Q2_Chargebacks", "type": "esriFieldTypeDouble", "alias": "FY22Q2 Chargebacks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22Q2_Chargebacks" }, { "name": "FY22_Q3_Spend", "type": "esriFieldTypeDouble", "alias": "FY22 Q3 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Q3_Spend" }, { "name": "FY22_Q3_Chargeback", "type": "esriFieldTypeDouble", "alias": "FY22 Q3 Chargeback", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Q3_Chargeback" }, { "name": "FY22_Q4_Spend", "type": "esriFieldTypeDouble", "alias": "FY22 Q4 Spend", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FY22_Q4_Spend" }, { "name": "FY22_Q4_Chargeback", "type": "esriFieldTypeString", "alias": "FY22 Q4 Chargeback", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FY22_Q4_Chargeback" }, { "name": "Priority_Order", "type": "esriFieldTypeDouble", "alias": "Priority Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Priority_Order" }, { "name": "WSD_Lead_Representative", "type": "esriFieldTypeString", "alias": "WSD Lead Representative", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WSD_Lead_Representative" }, { "name": "WSD_Reviewer", "type": "esriFieldTypeString", "alias": "WSD Reviewer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WSD_Reviewer" }, { "name": "Latest_Comment", "type": "esriFieldTypeString", "alias": "Latest Comment", "domain": null, "editable": true, "nullable": true, "length": 360, "defaultValue": null, "modelName": "Latest_Comment" }, { "name": "Action_Items", "type": "esriFieldTypeString", "alias": "Action Items", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Action_Items" } ], "indexes": [ { "name": "R4401_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "US Mountain Standard Time", "timeZoneIANA": "Etc/GMT+7", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "US Mountain Standard Time", "timeZoneIANA": "Etc/GMT+7", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "CIP_PROJECTS_SMARTSHEET", "description": "", "prototype": { "attributes": { "Latest_Comment": null, "F_": null, "Time": null, "Other": null, "Charter": null, "Project__": null, "Munis__": null, "Project_Name": null, "D_PM": null, "C_PM": null, "Project_Budget": null, "Project_Cost": null, "Prior_Years_Actuals": null, "FY19_20_Actuals": null, "FY21_Actuals": null, "FY22_Actuals": null, "Est__Substantial_Date": null, "Final_Date": null, "Procurement": null, "Department": null, "Council_Date": null, "Status": null, "Act__Design_Completion_date": null, "Act__Substantial_Date": null, "Fac_": null, "W_S": null, "Street": null, "HAS_PIO": null, "Active_Project": null, "Fy2021_Q1_Spend": null, "FY2021_Q1_Chargebacks": null, "Fy2021_Q2_Spend": null, "FY2021_Q2_Chargebacks": null, "FY2021_Q3_Spend": null, "Fy2021_Q3_Chargebacks": null, "Fy2021_Q4_Spend": null, "FY21_Q4_Chargebacks": null, "Total_Billable_FY21_Chargebacks": null, "Total_Actual_Fy21_Chargebacks": null, "FY22_Q1_Chargebacks": null, "FY22_Q1_Spend": null, "FY22_Total_Chargebacks": null, "Total_Invoices": null, "Budget_Status": null, "Billable_vs_Actual_Chargebacks": null, "Address_Start": null, "Address_End": null, "Citywide__Yes_No_": null, "FY23_Actuals": null, "Est__Charter_Design_Completion_": null, "Actual_Design_Start_Date__Kicko": null, "Contract_Design_Completion_Date": null, "Actual_Construction_Start_Date_": null, "FY22_Q2_Spend": null, "FY22Q2_Chargebacks": null, "FY22_Q3_Spend": null, "FY22_Q3_Chargeback": null, "FY22_Q4_Spend": null, "FY22_Q4_Chargeback": null, "Priority_Order": null, "WSD_Lead_Representative": null, "WSD_Reviewer": null, "Action_Items": 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": "7436baff872943a38690f25442460e43" }