{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 141, "name": "CMS_Projects", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "project_num", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "webcamStream", "type": "esriFieldTypeString", "alias": "webcamStream", "length": 500, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "project_num", "type": "esriFieldTypeString", "alias": "project_num", "length": 7, "domain": null }, { "name": "approved_budget", "type": "esriFieldTypeDouble", "alias": "approved_budget", "domain": null }, { "name": "title", "type": "esriFieldTypeString", "alias": "title", "length": 75, "domain": null }, { "name": "StatusFull", "type": "esriFieldTypeString", "alias": "StatusFull", "length": 12, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 511, "domain": null }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "start_date", "length": 8, "domain": null }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "end_date", "length": 8, "domain": null }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "length": 42, "domain": null }, { "name": "project_id", "type": "esriFieldTypeDouble", "alias": "project_id", "domain": null }, { "name": "fy", "type": "esriFieldTypeString", "alias": "fy", "length": 2, "domain": null }, { "name": "project", "type": "esriFieldTypeString", "alias": "project", "length": 4, "domain": null }, { "name": "account_no", "type": "esriFieldTypeString", "alias": "account_no", "length": 7, "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "type", "length": 1, "domain": null }, { "name": "cdp_type", "type": "esriFieldTypeString", "alias": "cdp_type", "length": 2, "domain": null }, { "name": "cycle", "type": "esriFieldTypeString", "alias": "cycle", "length": 4, "domain": null }, { "name": "fm_coord", "type": "esriFieldTypeString", "alias": "fm_coord", "length": 20, "domain": null }, { "name": "user_coord", "type": "esriFieldTypeString", "alias": "user_coord", "length": 20, "domain": null }, { "name": "nasf", "type": "esriFieldTypeInteger", "alias": "nasf", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 2147483647, "domain": null }, { "name": "gsf", "type": "esriFieldTypeInteger", "alias": "gsf", "domain": null }, { "name": "lastsave", "type": "esriFieldTypeDate", "alias": "lastsave", "length": 8, "domain": null }, { "name": "fiscal_closeout", "type": "esriFieldTypeDate", "alias": "fiscal_closeout", "length": 8, "domain": null }, { "name": "abor_pi", "type": "esriFieldTypeDate", "alias": "abor_pi", "length": 8, "domain": null }, { "name": "abor_ci", "type": "esriFieldTypeDate", "alias": "abor_ci", "length": 8, "domain": null }, { "name": "abor_pa", "type": "esriFieldTypeDate", "alias": "abor_pa", "length": 8, "domain": null }, { "name": "budget_saved_date", "type": "esriFieldTypeDate", "alias": "budget_saved_date", "length": 8, "domain": null }, { "name": "y2ksort", "type": "esriFieldTypeInteger", "alias": "y2ksort", "domain": null }, { "name": "budget_last_saved_date", "type": "esriFieldTypeDate", "alias": "budget_last_saved_date", "length": 8, "domain": null }, { "name": "abor_oth", "type": "esriFieldTypeDate", "alias": "abor_oth", "length": 8, "domain": null }, { "name": "opacct", "type": "esriFieldTypeInteger", "alias": "opacct", "domain": null }, { "name": "delivery", "type": "esriFieldTypeString", "alias": "delivery", "length": 6, "domain": null }, { "name": "revacct", "type": "esriFieldTypeInteger", "alias": "revacct", "domain": null }, { "name": "revenue_budget", "type": "esriFieldTypeDouble", "alias": "revenue_budget", "domain": null }, { "name": "billable", "type": "esriFieldTypeString", "alias": "billable", "length": 1, "domain": null }, { "name": "billable_hours_limit", "type": "esriFieldTypeSingle", "alias": "billable_hours_limit", "domain": null }, { "name": "abor_phase", "type": "esriFieldTypeString", "alias": "abor_phase", "length": 6, "domain": null }, { "name": "bldg_no", "type": "esriFieldTypeString", "alias": "bldg_no", "length": 10, "domain": null }, { "name": "projected_budget", "type": "esriFieldTypeDouble", "alias": "projected_budget", "domain": null }, { "name": "construction_budget", "type": "esriFieldTypeDouble", "alias": "construction_budget", "domain": null }, { "name": "warranty_messaged_date", "type": "esriFieldTypeDate", "alias": "warranty_messaged_date", "length": 8, "domain": null }, { "name": "concept_budget_saved_date", "type": "esriFieldTypeDate", "alias": "concept_budget_saved_date", "length": 8, "domain": null }, { "name": "sc_budget_saved_date", "type": "esriFieldTypeDate", "alias": "sc_budget_saved_date", "length": 8, "domain": null }, { "name": "revised_budget_saved_date", "type": "esriFieldTypeDate", "alias": "revised_budget_saved_date", "length": 8, "domain": null }, { "name": "jccr_flag", "type": "esriFieldTypeString", "alias": "jccr_flag", "length": 1, "domain": null }, { "name": "fy_4digit", "type": "esriFieldTypeInteger", "alias": "fy_4digit", "domain": null }, { "name": "design_intent", "type": "esriFieldTypeString", "alias": "design_intent", "length": 2147483647, "domain": null }, { "name": "web_suppress", "type": "esriFieldTypeSmallInteger", "alias": "web_suppress", "domain": null }, { "name": "web_counter", "type": "esriFieldTypeInteger", "alias": "web_counter", "domain": null }, { "name": "design_professional", "type": "esriFieldTypeString", "alias": "design_professional", "length": 128, "domain": null }, { "name": "contractor", "type": "esriFieldTypeString", "alias": "contractor", "length": 128, "domain": null }, { "name": "i_number", "type": "esriFieldTypeString", "alias": "i_number", "length": 6, "domain": null }, { "name": "sc_date", "type": "esriFieldTypeDate", "alias": "sc_date", "length": 8, "domain": null }, { "name": "community_update", "type": "esriFieldTypeString", "alias": "community_update", "length": 2147483647, "domain": null }, { "name": "notice_to_proceed_date", "type": "esriFieldTypeDate", "alias": "notice_to_proceed_date", "length": 8, "domain": null }, { "name": "sub_account", "type": "esriFieldTypeString", "alias": "sub_account", "length": 5, "domain": null }, { "name": "billing_suppress", "type": "esriFieldTypeSmallInteger", "alias": "billing_suppress", "domain": null }, { "name": "phoenix_campus", "type": "esriFieldTypeSmallInteger", "alias": "phoenix_campus", "domain": null }, { "name": "cd_switch", "type": "esriFieldTypeDate", "alias": "cd_switch", "length": 8, "domain": null }, { "name": "sharepoint_project", "type": "esriFieldTypeString", "alias": "sharepoint_project", "length": 10, "domain": null }, { "name": "DPM", "type": "esriFieldTypeString", "alias": "DPM", "length": 20, "domain": null }, { "name": "PM", "type": "esriFieldTypeString", "alias": "PM", "length": 20, "domain": null }, { "name": "story_map_title", "type": "esriFieldTypeString", "alias": "story_map_title", "length": 255, "domain": null }, { "name": "story_map", "type": "esriFieldTypeSmallInteger", "alias": "story_map", "domain": null }, { "name": "story_map_order", "type": "esriFieldTypeInteger", "alias": "story_map_order", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_project_num", "fields": "project_num", "isAscending": true, "isUnique": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }