{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "dbo.SitRep", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ReportingOrgName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Id", "type": "esriFieldTypeOID", "alias": "Id", "domain": null }, { "name": "MissionStatus", "type": "esriFieldTypeString", "alias": "MissionStatus", "length": 20, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": null }, { "name": "ReportingOrgResourceCategory", "type": "esriFieldTypeString", "alias": "ReportingOrgResourceCategory", "length": 60, "domain": null }, { "name": "ReportingOrgCategory", "type": "esriFieldTypeString", "alias": "ReportingOrgCategory", "length": 60, "domain": null }, { "name": "ReportingOrgName", "type": "esriFieldTypeString", "alias": "ReportingOrgName", "length": 60, "domain": null }, { "name": "ReportingPosition", "type": "esriFieldTypeString", "alias": "ReportingPosition", "length": 30, "domain": null }, { "name": "ReportingPerson", "type": "esriFieldTypeString", "alias": "ReportingPerson", "length": 50, "domain": null }, { "name": "ReportDateTime", "type": "esriFieldTypeDate", "alias": "ReportDateTime", "length": 8, "domain": null }, { "name": "ProjectedCompleteDate", "type": "esriFieldTypeDate", "alias": "ProjectedCompleteDate", "length": 8, "domain": null }, { "name": "PersonnelStatus", "type": "esriFieldTypeString", "alias": "PersonnelStatus", "length": 20, "domain": null }, { "name": "EquipmentStatus", "type": "esriFieldTypeString", "alias": "EquipmentStatus", "length": 20, "domain": null }, { "name": "SuppliesStatus", "type": "esriFieldTypeString", "alias": "SuppliesStatus", "length": 20, "domain": null }, { "name": "MaintenanceStatus", "type": "esriFieldTypeString", "alias": "MaintenanceStatus", "length": 20, "domain": null }, { "name": "PastActivities", "type": "esriFieldTypeString", "alias": "PastActivities", "length": 2147483647, "domain": null }, { "name": "CurrentActivities", "type": "esriFieldTypeString", "alias": "CurrentActivities", "length": 2147483647, "domain": null }, { "name": "FutureActivities", "type": "esriFieldTypeString", "alias": "FutureActivities", "length": 2147483647, "domain": null }, { "name": "CriticalPersonnelIssues", "type": "esriFieldTypeString", "alias": "CriticalPersonnelIssues", "length": 2147483647, "domain": null }, { "name": "CriticalOperationsIssues", "type": "esriFieldTypeString", "alias": "CriticalOperationsIssues", "length": 2147483647, "domain": null }, { "name": "CriticalLogisticsIssues", "type": "esriFieldTypeString", "alias": "CriticalLogisticsIssues", "length": 2147483647, "domain": null }, { "name": "OtherCriticalIssues", "type": "esriFieldTypeString", "alias": "OtherCriticalIssues", "length": 2147483647, "domain": null }, { "name": "Evacuee", "type": "esriFieldTypeString", "alias": "Evacuee", "length": 2147483647, "domain": null }, { "name": "Detainees", "type": "esriFieldTypeString", "alias": "Detainees", "length": 2147483647, "domain": null }, { "name": "Shelters", "type": "esriFieldTypeString", "alias": "Shelters", "length": 2147483647, "domain": null }, { "name": "Medical", "type": "esriFieldTypeString", "alias": "Medical", "length": 2147483647, "domain": null }, { "name": "TotalPersons", "type": "esriFieldTypeInteger", "alias": "TotalPersons", "domain": null }, { "name": "TotalEquipment", "type": "esriFieldTypeInteger", "alias": "TotalEquipment", "domain": null }, { "name": "PersonnelCosts", "type": "esriFieldTypeDouble", "alias": "PersonnelCosts", "domain": null }, { "name": "FacilityCosts", "type": "esriFieldTypeDouble", "alias": "FacilityCosts", "domain": null }, { "name": "OrganizatonCosts", "type": "esriFieldTypeDouble", "alias": "OrganizatonCosts", "domain": null }, { "name": "TotalManDays", "type": "esriFieldTypeInteger", "alias": "TotalManDays", "domain": null }, { "name": "EquipmentCosts", "type": "esriFieldTypeDouble", "alias": "EquipmentCosts", "domain": null }, { "name": "SupplyCosts", "type": "esriFieldTypeDouble", "alias": "SupplyCosts", "domain": null }, { "name": "ProcurementCosts", "type": "esriFieldTypeDouble", "alias": "ProcurementCosts", "domain": null }, { "name": "TotalCosts", "type": "esriFieldTypeDouble", "alias": "TotalCosts", "domain": null }, { "name": "IntColumn1", "type": "esriFieldTypeInteger", "alias": "IntColumn1", "domain": null }, { "name": "IntColumn2", "type": "esriFieldTypeInteger", "alias": "IntColumn2", "domain": null }, { "name": "CharColumn1", "type": "esriFieldTypeString", "alias": "CharColumn1", "length": 255, "domain": null }, { "name": "CharColumn2", "type": "esriFieldTypeString", "alias": "CharColumn2", "length": 255, "domain": null }, { "name": "CheckBoxColumn1", "type": "esriFieldTypeSmallInteger", "alias": "CheckBoxColumn1", "domain": null }, { "name": "CheckBoxColumn2", "type": "esriFieldTypeSmallInteger", "alias": "CheckBoxColumn2", "domain": null }, { "name": "DateTimeColumn1", "type": "esriFieldTypeDate", "alias": "DateTimeColumn1", "length": 8, "domain": null }, { "name": "DateTimeColumn2", "type": "esriFieldTypeDate", "alias": "DateTimeColumn2", "length": 8, "domain": null }, { "name": "EnteredBy", "type": "esriFieldTypeString", "alias": "EnteredBy", "length": 50, "domain": null }, { "name": "DatePrepared", "type": "esriFieldTypeDate", "alias": "DatePrepared", "length": 8, "domain": null }, { "name": "LocationId", "type": "esriFieldTypeInteger", "alias": "LocationId", "domain": null }, { "name": "missionId", "type": "esriFieldTypeInteger", "alias": "missionId", "domain": null }, { "name": "Quantity1", "type": "esriFieldTypeInteger", "alias": "Quantity1", "domain": null }, { "name": "Quantity2", "type": "esriFieldTypeInteger", "alias": "Quantity2", "domain": null }, { "name": "Quantity3", "type": "esriFieldTypeInteger", "alias": "Quantity3", "domain": null }, { "name": "Quantity4", "type": "esriFieldTypeInteger", "alias": "Quantity4", "domain": null }, { "name": "Quantity5", "type": "esriFieldTypeInteger", "alias": "Quantity5", "domain": null }, { "name": "Quantity6", "type": "esriFieldTypeInteger", "alias": "Quantity6", "domain": null }, { "name": "Quantity7", "type": "esriFieldTypeInteger", "alias": "Quantity7", "domain": null }, { "name": "Quantity8", "type": "esriFieldTypeInteger", "alias": "Quantity8", "domain": null }, { "name": "Quantity9", "type": "esriFieldTypeInteger", "alias": "Quantity9", "domain": null }, { "name": "Quantity10", "type": "esriFieldTypeInteger", "alias": "Quantity10", "domain": null }, { "name": "Quantity11", "type": "esriFieldTypeInteger", "alias": "Quantity11", "domain": null }, { "name": "Quantity12", "type": "esriFieldTypeInteger", "alias": "Quantity12", "domain": null }, { "name": "Quantity13", "type": "esriFieldTypeInteger", "alias": "Quantity13", "domain": null }, { "name": "Quantity14", "type": "esriFieldTypeInteger", "alias": "Quantity14", "domain": null }, { "name": "Quantity15", "type": "esriFieldTypeInteger", "alias": "Quantity15", "domain": null }, { "name": "Quantity16", "type": "esriFieldTypeInteger", "alias": "Quantity16", "domain": null }, { "name": "Quantity17", "type": "esriFieldTypeInteger", "alias": "Quantity17", "domain": null }, { "name": "Quantity18", "type": "esriFieldTypeInteger", "alias": "Quantity18", "domain": null }, { "name": "Quantity19", "type": "esriFieldTypeInteger", "alias": "Quantity19", "domain": null }, { "name": "Quantity20", "type": "esriFieldTypeInteger", "alias": "Quantity20", "domain": null }, { "name": "ReportingPeriodStart", "type": "esriFieldTypeDate", "alias": "ReportingPeriodStart", "length": 8, "domain": null }, { "name": "ReportingPeriodEnd", "type": "esriFieldTypeDate", "alias": "ReportingPeriodEnd", "length": 8, "domain": null }, { "name": "MissionNumber", "type": "esriFieldTypeString", "alias": "MissionNumber", "length": 35, "domain": null } ], "indexes": null, "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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "Id" ], "OIDFieldContainsHashValue": false }, "maxUniqueIDCount": 100000 }