{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "Folder Milestone", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "milestone_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "folder_rsn", "type": "esriFieldTypeInteger", "alias": "Folder RSN", "domain": null }, { "name": "process_rsn", "type": "esriFieldTypeInteger", "alias": "Process RSN", "domain": null }, { "name": "folder_type", "type": "esriFieldTypeString", "alias": "Folder Type", "length": 4, "domain": null }, { "name": "milestone_type", "type": "esriFieldTypeString", "alias": "Milestone Type", "length": 50, "domain": null }, { "name": "milestone_name", "type": "esriFieldTypeString", "alias": "Milestone Name", "length": 100, "domain": null }, { "name": "milestone_status", "type": "esriFieldTypeString", "alias": "Milestone Status", "length": 100, "domain": null }, { "name": "milestone_sort", "type": "esriFieldTypeInteger", "alias": "Milestone Sort", "domain": null }, { "name": "milestone_start_date", "type": "esriFieldTypeDate", "alias": "Start Date", "length": 8, "domain": null }, { "name": "milestone_end_date", "type": "esriFieldTypeDate", "alias": "End Date", "length": 8, "domain": null }, { "name": "milestone_elapsed_days", "type": "esriFieldTypeInteger", "alias": "Elapsed Days", "domain": null }, { "name": "milestone_goal_time", "type": "esriFieldTypeInteger", "alias": "Goal Time", "domain": null }, { "name": "milestone_overdue_days", "type": "esriFieldTypeInteger", "alias": "Overdue Days", "domain": null }, { "name": "milestone_result", "type": "esriFieldTypeString", "alias": "Milestone Result", "length": 50, "domain": null }, { "name": "gis_process_status", "type": "esriFieldTypeString", "alias": "GIS Process Status", "length": 100, "domain": null }, { "name": "review_round", "type": "esriFieldTypeInteger", "alias": "Review Round", "domain": null }, { "name": "milestone_start_name", "type": "esriFieldTypeString", "alias": "Start Name", "length": 100, "domain": null }, { "name": "milestone_end_name", "type": "esriFieldTypeString", "alias": "End Name", "length": 100, "domain": null }, { "name": "responsibility", "type": "esriFieldTypeString", "alias": "Responsibility", "length": 255, "domain": null }, { "name": "folder_work_type", "type": "esriFieldTypeString", "alias": "Folder Work Type", "length": 255, "domain": null }, { "name": "folder_in_date", "type": "esriFieldTypeDate", "alias": "Folder In Date", "length": 8, "domain": null }, { "name": "folder_section", "type": "esriFieldTypeString", "alias": "Folder Section", "length": 255, "domain": null }, { "name": "folder_status", "type": "esriFieldTypeString", "alias": "Folder Status", "length": 255, "domain": null }, { "name": "start_attempt_rsn", "type": "esriFieldTypeInteger", "alias": "Start Attempt RSN", "domain": null }, { "name": "end_attempt_rsn", "type": "esriFieldTypeInteger", "alias": "End Attempt RSN", "domain": null }, { "name": "elapsed_days_from_und_rev", "type": "esriFieldTypeInteger", "alias": "Elapsed Days from Under Review", "domain": null }, { "name": "folder_sub_type", "type": "esriFieldTypeString", "alias": "Folder Sub Type", "length": 255, "domain": null }, { "name": "folder_under_review_date", "type": "esriFieldTypeDate", "alias": "Folder Under Review Date", "length": 8, "domain": null }, { "name": "folder_final_valuation", "type": "esriFieldTypeInteger", "alias": "Folder Final Valuation", "domain": null }, { "name": "milestone_overdue_status", "type": "esriFieldTypeString", "alias": "Overdue Status", "length": 50, "domain": null }, { "name": "bureau", "type": "esriFieldTypeString", "alias": "Bureau", "length": 20, "domain": null }, { "name": "folder_final_value_class", "type": "esriFieldTypeString", "alias": "Folder Final Valuation Class", "length": 255, "domain": null }, { "name": "folder_year", "type": "esriFieldTypeString", "alias": "Folder Create Year", "length": 4, "domain": null }, { "name": "folder_fiscal_year", "type": "esriFieldTypeString", "alias": "Folder Fiscal Year", "length": 20, "domain": null }, { "name": "relative_date_class", "type": "esriFieldTypeString", "alias": "Relative Date Class", "length": 50, "domain": null }, { "name": "milestone_goal_date", "type": "esriFieldTypeDate", "alias": "Milestone Goal Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R126_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I32051relative_d", "fields": "relative_date_class", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_fis", "fields": "folder_fiscal_year", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_yea", "fields": "folder_year", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_fin", "fields": "folder_final_value_class", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_fin_1", "fields": "folder_final_valuation", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_und", "fields": "folder_under_review_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_sub", "fields": "folder_sub_type", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_sta", "fields": "folder_status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_sec", "fields": "folder_section", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_in_", "fields": "folder_in_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_wor", "fields": "folder_work_type", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051bureau", "fields": "bureau", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051responsibi", "fields": "responsibility", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051gis_proces", "fields": "gis_process_status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone_", "fields": "milestone_overdue_status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__1", "fields": "milestone_overdue_days", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__2", "fields": "milestone_goal_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051elapsed_da", "fields": "elapsed_days_from_und_rev", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__3", "fields": "milestone_elapsed_days", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__4", "fields": "milestone_sort", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__5", "fields": "milestone_status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__6", "fields": "milestone_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051review_rou", "fields": "review_round", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051milestone__7", "fields": "milestone_type", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_typ", "fields": "folder_type", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051end_attemp", "fields": "end_attempt_rsn", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051start_atte", "fields": "start_attempt_rsn", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051process_rs", "fields": "process_rsn", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I32051folder_rsn", "fields": "folder_rsn", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "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": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }