Name: dbo.SitRep

Display Field: ReportingOrgName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Unique Id Infos:

Type: simple
Fields: ["Id"]
OID Field Contains Hash Value: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• Id ( type: esriFieldTypeOID, alias: Id )
• MissionStatus ( type: esriFieldTypeString, alias: MissionStatus, length: 20 )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 )
• ReportingOrgResourceCategory ( type: esriFieldTypeString, alias: ReportingOrgResourceCategory, length: 60 )
• ReportingOrgCategory ( type: esriFieldTypeString, alias: ReportingOrgCategory, length: 60 )
• ReportingOrgName ( type: esriFieldTypeString, alias: ReportingOrgName, length: 60 )
• ReportingPosition ( type: esriFieldTypeString, alias: ReportingPosition, length: 30 )
• ReportingPerson ( type: esriFieldTypeString, alias: ReportingPerson, length: 50 )
• ReportDateTime ( type: esriFieldTypeDate, alias: ReportDateTime, length: 8 )
• ProjectedCompleteDate ( type: esriFieldTypeDate, alias: ProjectedCompleteDate, length: 8 )
• PersonnelStatus ( type: esriFieldTypeString, alias: PersonnelStatus, length: 20 )
• EquipmentStatus ( type: esriFieldTypeString, alias: EquipmentStatus, length: 20 )
• SuppliesStatus ( type: esriFieldTypeString, alias: SuppliesStatus, length: 20 )
• MaintenanceStatus ( type: esriFieldTypeString, alias: MaintenanceStatus, length: 20 )
• PastActivities ( type: esriFieldTypeString, alias: PastActivities, length: 2147483647 )
• CurrentActivities ( type: esriFieldTypeString, alias: CurrentActivities, length: 2147483647 )
• FutureActivities ( type: esriFieldTypeString, alias: FutureActivities, length: 2147483647 )
• CriticalPersonnelIssues ( type: esriFieldTypeString, alias: CriticalPersonnelIssues, length: 2147483647 )
• CriticalOperationsIssues ( type: esriFieldTypeString, alias: CriticalOperationsIssues, length: 2147483647 )
• CriticalLogisticsIssues ( type: esriFieldTypeString, alias: CriticalLogisticsIssues, length: 2147483647 )
• OtherCriticalIssues ( type: esriFieldTypeString, alias: OtherCriticalIssues, length: 2147483647 )
• Evacuee ( type: esriFieldTypeString, alias: Evacuee, length: 2147483647 )
• Detainees ( type: esriFieldTypeString, alias: Detainees, length: 2147483647 )
• Shelters ( type: esriFieldTypeString, alias: Shelters, length: 2147483647 )
• Medical ( type: esriFieldTypeString, alias: Medical, length: 2147483647 )
• TotalPersons ( type: esriFieldTypeInteger, alias: TotalPersons )
• TotalEquipment ( type: esriFieldTypeInteger, alias: TotalEquipment )
• PersonnelCosts ( type: esriFieldTypeDouble, alias: PersonnelCosts )
• FacilityCosts ( type: esriFieldTypeDouble, alias: FacilityCosts )
• OrganizatonCosts ( type: esriFieldTypeDouble, alias: OrganizatonCosts )
• TotalManDays ( type: esriFieldTypeInteger, alias: TotalManDays )
• EquipmentCosts ( type: esriFieldTypeDouble, alias: EquipmentCosts )
• SupplyCosts ( type: esriFieldTypeDouble, alias: SupplyCosts )
• ProcurementCosts ( type: esriFieldTypeDouble, alias: ProcurementCosts )
• TotalCosts ( type: esriFieldTypeDouble, alias: TotalCosts )
• IntColumn1 ( type: esriFieldTypeInteger, alias: IntColumn1 )
• IntColumn2 ( type: esriFieldTypeInteger, alias: IntColumn2 )
• CharColumn1 ( type: esriFieldTypeString, alias: CharColumn1, length: 255 )
• CharColumn2 ( type: esriFieldTypeString, alias: CharColumn2, length: 255 )
• CheckBoxColumn1 ( type: esriFieldTypeSmallInteger, alias: CheckBoxColumn1 )
• CheckBoxColumn2 ( type: esriFieldTypeSmallInteger, alias: CheckBoxColumn2 )
• DateTimeColumn1 ( type: esriFieldTypeDate, alias: DateTimeColumn1, length: 8 )
• DateTimeColumn2 ( type: esriFieldTypeDate, alias: DateTimeColumn2, length: 8 )
• EnteredBy ( type: esriFieldTypeString, alias: EnteredBy, length: 50 )
• DatePrepared ( type: esriFieldTypeDate, alias: DatePrepared, length: 8 )
• LocationId ( type: esriFieldTypeInteger, alias: LocationId )
• missionId ( type: esriFieldTypeInteger, alias: missionId )
• Quantity1 ( type: esriFieldTypeInteger, alias: Quantity1 )
• Quantity2 ( type: esriFieldTypeInteger, alias: Quantity2 )
• Quantity3 ( type: esriFieldTypeInteger, alias: Quantity3 )
• Quantity4 ( type: esriFieldTypeInteger, alias: Quantity4 )
• Quantity5 ( type: esriFieldTypeInteger, alias: Quantity5 )
• Quantity6 ( type: esriFieldTypeInteger, alias: Quantity6 )
• Quantity7 ( type: esriFieldTypeInteger, alias: Quantity7 )
• Quantity8 ( type: esriFieldTypeInteger, alias: Quantity8 )
• Quantity9 ( type: esriFieldTypeInteger, alias: Quantity9 )
• Quantity10 ( type: esriFieldTypeInteger, alias: Quantity10 )
• Quantity11 ( type: esriFieldTypeInteger, alias: Quantity11 )
• Quantity12 ( type: esriFieldTypeInteger, alias: Quantity12 )
• Quantity13 ( type: esriFieldTypeInteger, alias: Quantity13 )
• Quantity14 ( type: esriFieldTypeInteger, alias: Quantity14 )
• Quantity15 ( type: esriFieldTypeInteger, alias: Quantity15 )
• Quantity16 ( type: esriFieldTypeInteger, alias: Quantity16 )
• Quantity17 ( type: esriFieldTypeInteger, alias: Quantity17 )
• Quantity18 ( type: esriFieldTypeInteger, alias: Quantity18 )
• Quantity19 ( type: esriFieldTypeInteger, alias: Quantity19 )
• Quantity20 ( type: esriFieldTypeInteger, alias: Quantity20 )
• ReportingPeriodStart ( type: esriFieldTypeDate, alias: ReportingPeriodStart, length: 8 )
• ReportingPeriodEnd ( type: esriFieldTypeDate, alias: ReportingPeriodEnd, length: 8 )
• MissionNumber ( type: esriFieldTypeString, alias: MissionNumber, length: 35 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata