{
 "currentVersion": 11.4,
 "cimVersion": "3.4.0",
 "id": 3,
 "name": "CIP_PROJECTS_SMARTSHEET",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Project_Name",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "F_",
   "type": "esriFieldTypeString",
   "alias": "$",
   "length": 255,
   "domain": null
  },
  {
   "name": "Time",
   "type": "esriFieldTypeString",
   "alias": "Time",
   "length": 255,
   "domain": null
  },
  {
   "name": "Other",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Other",
   "domain": null
  },
  {
   "name": "Charter",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Charter",
   "domain": null
  },
  {
   "name": "Project__",
   "type": "esriFieldTypeString",
   "alias": "Project #",
   "length": 255,
   "domain": null
  },
  {
   "name": "Munis__",
   "type": "esriFieldTypeString",
   "alias": "Munis #",
   "length": 255,
   "domain": null
  },
  {
   "name": "Project_Name",
   "type": "esriFieldTypeString",
   "alias": "Project Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "D_PM",
   "type": "esriFieldTypeString",
   "alias": "D-PM",
   "length": 255,
   "domain": null
  },
  {
   "name": "C_PM",
   "type": "esriFieldTypeString",
   "alias": "C-PM",
   "length": 255,
   "domain": null
  },
  {
   "name": "Project_Budget",
   "type": "esriFieldTypeString",
   "alias": "Project Budget",
   "length": 255,
   "domain": null
  },
  {
   "name": "Project_Cost",
   "type": "esriFieldTypeDouble",
   "alias": "Project Cost",
   "domain": null
  },
  {
   "name": "Prior_Years_Actuals",
   "type": "esriFieldTypeString",
   "alias": "Prior Years Actuals",
   "length": 255,
   "domain": null
  },
  {
   "name": "FY19_20_Actuals",
   "type": "esriFieldTypeDouble",
   "alias": "FY19-20 Actuals",
   "domain": null
  },
  {
   "name": "FY21_Actuals",
   "type": "esriFieldTypeDouble",
   "alias": "FY21 Actuals",
   "domain": null
  },
  {
   "name": "FY22_Actuals",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Actuals",
   "domain": null
  },
  {
   "name": "Est__Substantial_Date",
   "type": "esriFieldTypeString",
   "alias": "Est. Substantial Date",
   "length": 255,
   "domain": null
  },
  {
   "name": "Final_Date",
   "type": "esriFieldTypeDate",
   "alias": "Final Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Procurement",
   "type": "esriFieldTypeString",
   "alias": "Procurement",
   "length": 255,
   "domain": null
  },
  {
   "name": "Department",
   "type": "esriFieldTypeString",
   "alias": "Department",
   "length": 255,
   "domain": null
  },
  {
   "name": "Council_Date",
   "type": "esriFieldTypeString",
   "alias": "Council Date",
   "length": 255,
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 255,
   "domain": null
  },
  {
   "name": "Act__Design_Completion_date",
   "type": "esriFieldTypeString",
   "alias": "Act. Design Completion date",
   "length": 255,
   "domain": null
  },
  {
   "name": "Act__Substantial_Date",
   "type": "esriFieldTypeDate",
   "alias": "Act. Substantial Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Fac_",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Fac.",
   "domain": null
  },
  {
   "name": "W_S",
   "type": "esriFieldTypeSmallInteger",
   "alias": "W/S",
   "domain": null
  },
  {
   "name": "Street",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Street",
   "domain": null
  },
  {
   "name": "HAS_PIO",
   "type": "esriFieldTypeSmallInteger",
   "alias": "HAS PIO",
   "domain": null
  },
  {
   "name": "Active_Project",
   "type": "esriFieldTypeString",
   "alias": "Active Project",
   "length": 255,
   "domain": null
  },
  {
   "name": "Fy2021_Q1_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "Fy2021 Q1 Spend",
   "domain": null
  },
  {
   "name": "FY2021_Q1_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "FY2021 Q1 Chargebacks",
   "domain": null
  },
  {
   "name": "Fy2021_Q2_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "Fy2021 Q2 Spend",
   "domain": null
  },
  {
   "name": "FY2021_Q2_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "FY2021 Q2 Chargebacks",
   "domain": null
  },
  {
   "name": "FY2021_Q3_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "FY2021 Q3 Spend",
   "domain": null
  },
  {
   "name": "Fy2021_Q3_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "Fy2021 Q3 Chargebacks",
   "domain": null
  },
  {
   "name": "Fy2021_Q4_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "Fy2021 Q4 Spend",
   "domain": null
  },
  {
   "name": "FY21_Q4_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "FY21 Q4 Chargebacks",
   "domain": null
  },
  {
   "name": "Total_Billable_FY21_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "Total Billable FY21 Chargebacks",
   "domain": null
  },
  {
   "name": "Total_Actual_Fy21_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "Total Actual Fy21 Chargebacks",
   "domain": null
  },
  {
   "name": "FY22_Q1_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Q1 Chargebacks",
   "domain": null
  },
  {
   "name": "FY22_Q1_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Q1 Spend",
   "domain": null
  },
  {
   "name": "FY22_Total_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "Fy22 Total Chargebacks",
   "domain": null
  },
  {
   "name": "Total_Invoices",
   "type": "esriFieldTypeDouble",
   "alias": "Total Invoices",
   "domain": null
  },
  {
   "name": "Budget_Status",
   "type": "esriFieldTypeString",
   "alias": "Budget Status",
   "length": 255,
   "domain": null
  },
  {
   "name": "Billable_vs_Actual_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "Billable vs Actual Chargebacks",
   "domain": null
  },
  {
   "name": "Address_Start",
   "type": "esriFieldTypeString",
   "alias": "Address Start",
   "length": 255,
   "domain": null
  },
  {
   "name": "Address_End",
   "type": "esriFieldTypeString",
   "alias": "Address End",
   "length": 255,
   "domain": null
  },
  {
   "name": "Citywide__Yes_No_",
   "type": "esriFieldTypeString",
   "alias": "Citywide (Yes/No)",
   "length": 255,
   "domain": null
  },
  {
   "name": "FY23_Actuals",
   "type": "esriFieldTypeDouble",
   "alias": "FY23 Actuals",
   "domain": null
  },
  {
   "name": "Est__Charter_Design_Completion_",
   "type": "esriFieldTypeDate",
   "alias": "Est. Charter Design Completion Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Actual_Design_Start_Date__Kicko",
   "type": "esriFieldTypeString",
   "alias": "Actual Design Start Date (Kickoff Date)",
   "length": 255,
   "domain": null
  },
  {
   "name": "Contract_Design_Completion_Date",
   "type": "esriFieldTypeDate",
   "alias": "Contract Design Completion Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Actual_Construction_Start_Date_",
   "type": "esriFieldTypeString",
   "alias": "Actual Construction Start Date (NTP Date)",
   "length": 255,
   "domain": null
  },
  {
   "name": "FY22_Q2_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Q2 Spend",
   "domain": null
  },
  {
   "name": "FY22Q2_Chargebacks",
   "type": "esriFieldTypeDouble",
   "alias": "FY22Q2 Chargebacks",
   "domain": null
  },
  {
   "name": "FY22_Q3_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Q3 Spend",
   "domain": null
  },
  {
   "name": "FY22_Q3_Chargeback",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Q3 Chargeback",
   "domain": null
  },
  {
   "name": "FY22_Q4_Spend",
   "type": "esriFieldTypeDouble",
   "alias": "FY22 Q4 Spend",
   "domain": null
  },
  {
   "name": "FY22_Q4_Chargeback",
   "type": "esriFieldTypeString",
   "alias": "FY22 Q4 Chargeback",
   "length": 255,
   "domain": null
  },
  {
   "name": "Priority_Order",
   "type": "esriFieldTypeDouble",
   "alias": "Priority Order",
   "domain": null
  },
  {
   "name": "WSD_Lead_Representative",
   "type": "esriFieldTypeString",
   "alias": "WSD Lead Representative",
   "length": 255,
   "domain": null
  },
  {
   "name": "WSD_Reviewer",
   "type": "esriFieldTypeString",
   "alias": "WSD Reviewer",
   "length": 255,
   "domain": null
  },
  {
   "name": "Latest_Comment",
   "type": "esriFieldTypeString",
   "alias": "Latest Comment",
   "length": 360,
   "domain": null
  },
  {
   "name": "Action_Items",
   "type": "esriFieldTypeString",
   "alias": "Action Items",
   "length": 255,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R4401_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "US Mountain Standard Time",
  "timeZoneIANA": "Etc/GMT+7",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": {
  "timeZone": "US Mountain Standard Time",
  "timeZoneIANA": "Etc/GMT+7",
  "respectsDaylightSaving": false
 },
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
}