Name: SITREP

Display Field: SITREP_WING

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: false

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SITREP_GUID (type: esriFieldTypeGUID, alias: SITREP GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• SITREP_WING (type: esriFieldTypeString, alias: SITREP Wing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AR: Arkansas], [AZ: Arizona], [CO: Colorado], ... 50 more ...)
• SITREP_DATE (type: esriFieldTypeDate, alias: SITREP Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SITREP_IC (type: esriFieldTypeString, alias: IC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Rank (type: esriFieldTypeString, alias: IC Rank, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2d Lt: 2d Lt], [1st Lt: 1st Lt], [Capt: Capt], ... 5 more ...)
• SITREP_IC_Email (type: esriFieldTypeString, alias: IC Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Phone (type: esriFieldTypeString, alias: IC Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Next (type: esriFieldTypeString, alias: Next IC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Next_Rank (type: esriFieldTypeString, alias: Next IC Rank, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2d Lt: 2d Lt], [1st Lt: 1st Lt], [Capt: Capt], ... 5 more ...)
• SITREP_IC_Next_Email (type: esriFieldTypeString, alias: Next IC Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Next_Phone (type: esriFieldTypeString, alias: Next IC Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_Mission_Current (type: esriFieldTypeString, alias: Current Narrative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PERSONNEL_Last24_EOC (type: esriFieldTypeSmallInteger, alias: Personnel - EOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_POD (type: esriFieldTypeSmallInteger, alias: Personnel - POD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_CallCntr (type: esriFieldTypeSmallInteger, alias: Personnel - Call Center, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Other (type: esriFieldTypeSmallInteger, alias: Personnel - Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Aircrew (type: esriFieldTypeSmallInteger, alias: Personnel - Aircrew, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Ground (type: esriFieldTypeSmallInteger, alias: Personnel - Ground Transport, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Staff (type: esriFieldTypeSmallInteger, alias: Personnel - Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Info (type: esriFieldTypeString, alias: Personnel - Other Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOURCE_Aircraft_Next24 (type: esriFieldTypeSmallInteger, alias: Aircraft Next 24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Aircraft_Next48 (type: esriFieldTypeSmallInteger, alias: Aircraft Next 48, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Aircraft_Next72 (type: esriFieldTypeSmallInteger, alias: Aircraft Next 72, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Ground_Next24 (type: esriFieldTypeSmallInteger, alias: Ground Crews Next 24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Ground_Next48 (type: esriFieldTypeSmallInteger, alias: Ground Crews Next 48, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Ground_Next72 (type: esriFieldTypeSmallInteger, alias: Ground Crews Next 72, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Other_Next24 (type: esriFieldTypeString, alias: Other Next 24, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOURCE_Other_Next48 (type: esriFieldTypeString, alias: Other Next 48, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOURCE_Other_Next72 (type: esriFieldTypeString, alias: Other Next 72, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AIRCRAFT_Flown (type: esriFieldTypeSmallInteger, alias: Aircraft Flown, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIRCRAFT_Sorties (type: esriFieldTypeSmallInteger, alias: Aircraft Sorties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIRCRAFT_Hours (type: esriFieldTypeSmallInteger, alias: Aircraft Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GROUND_Vehicles (type: esriFieldTypeSmallInteger, alias: Ground Vehicles Utilized, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GROUND_Sorties (type: esriFieldTypeSmallInteger, alias: Ground Sorties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITREP_DELIVERABLES (type: esriFieldTypeString, alias: Deliverables Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SITREP_ACTIVITY (type: esriFieldTypeString, alias: Activities Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SITREP_ISSUES (type: esriFieldTypeString, alias: Issues Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SITREP_IC_Tomorrow (type: esriFieldTypeString, alias: Same IC Y/N, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: SITREP
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• DELIVERABLES (3) -- Related To: DELIVERABLES (2)
• ACTIVITY (2) -- Related To: ACTIVITY (1)
• ISSUES (4) -- Related To: ISSUES (3)
• NOC_SITREP (0) -- Related To: NOC_SITREP (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/1/2021 12:12:37 AM

Schema Last Edit Date: 10/1/2021 12:12:37 AM

Data Last Edit Date: 10/1/2021 12:12:37 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat