Name: MLE_Event table

Display Field: EventName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• EventId ( type: esriFieldTypeOID, alias: EventId, editable: false, nullable: false, defaultValue: null, modelName: EventId )
• EventStatus ( type: esriFieldTypeString, alias: EventStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EventStatus )
• EventStatusNotes ( type: esriFieldTypeString, alias: EventStatusNotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: EventStatusNotes )
• EventStartDate ( type: esriFieldTypeDate, alias: EventStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EventStartDate )
• EventStartTime ( type: esriFieldTypeDate, alias: EventStartTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EventStartTime )
• EventEndDate ( type: esriFieldTypeDate, alias: EventEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EventEndDate )
• EventEndTime ( type: esriFieldTypeDate, alias: EventEndTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EventEndTime )
• DepartureDate ( type: esriFieldTypeDate, alias: DepartureDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DepartureDate )
• DepartureTime ( type: esriFieldTypeDate, alias: DepartureTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DepartureTime )
• EventName ( type: esriFieldTypeString, alias: EventName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EventName )
• DriveTime ( type: esriFieldTypeDouble, alias: DriveTime, editable: true, nullable: true, defaultValue: null, modelName: DriveTime )
• LocationName ( type: esriFieldTypeString, alias: LocationName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LocationName )
• LocationAddress ( type: esriFieldTypeString, alias: LocationAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LocationAddress )
• LocationCity ( type: esriFieldTypeString, alias: LocationCity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LocationCity )
• LocationCounty ( type: esriFieldTypeString, alias: LocationCounty, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LocationCounty )
• LocationState ( type: esriFieldTypeString, alias: LocationState, editable: true, nullable: true, length: 2, defaultValue: KS, modelName: LocationState )
• LocationZip ( type: esriFieldTypeString, alias: LocationZip, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LocationZip )
• AdequateParking ( type: esriFieldTypeSmallInteger, alias: AdequateParking, editable: true, nullable: true, defaultValue: null, modelName: AdequateParking )
• ParkingDetails ( type: esriFieldTypeString, alias: ParkingDetails, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ParkingDetails )
• Overnight ( type: esriFieldTypeSmallInteger, alias: Overnight, editable: true, nullable: true, defaultValue: null, modelName: Overnight )
• PermissionSlips ( type: esriFieldTypeString, alias: PermissionSlips, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PermissionSlips )
• PowerSource ( type: esriFieldTypeString, alias: PowerSource, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PowerSource )
• SetupStartTime ( type: esriFieldTypeDate, alias: SetupStartTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SetupStartTime )
• RequestDate ( type: esriFieldTypeDate, alias: RequestDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RequestDate )
• StudentAccomReq ( type: esriFieldTypeSmallInteger, alias: StudentAccomReq, editable: true, nullable: true, defaultValue: null, modelName: StudentAccomReq )
• StudentAccomDetails ( type: esriFieldTypeString, alias: StudentAccomDetails, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: StudentAccomDetails )
• Kindergarten ( type: esriFieldTypeSmallInteger, alias: Kindergarten, editable: true, nullable: true, defaultValue: null, modelName: Kindergarten )
• Grade1 ( type: esriFieldTypeSmallInteger, alias: Grade1, editable: true, nullable: true, defaultValue: null, modelName: Grade1 )
• Grade2 ( type: esriFieldTypeSmallInteger, alias: Grade2, editable: true, nullable: true, defaultValue: null, modelName: Grade2 )
• Grade3 ( type: esriFieldTypeSmallInteger, alias: Grade3, editable: true, nullable: true, defaultValue: null, modelName: Grade3 )
• Grade4 ( type: esriFieldTypeSmallInteger, alias: Grade4, editable: true, nullable: true, defaultValue: null, modelName: Grade4 )
• Grade5 ( type: esriFieldTypeSmallInteger, alias: Grade5, editable: true, nullable: true, defaultValue: null, modelName: Grade5 )
• Grade6 ( type: esriFieldTypeSmallInteger, alias: Grade6, editable: true, nullable: true, defaultValue: null, modelName: Grade6 )
• Grade7 ( type: esriFieldTypeSmallInteger, alias: Grade7, editable: true, nullable: true, defaultValue: null, modelName: Grade7 )
• Grade8 ( type: esriFieldTypeSmallInteger, alias: Grade8, editable: true, nullable: true, defaultValue: null, modelName: Grade8 )
• Grade9 ( type: esriFieldTypeSmallInteger, alias: Grade9, editable: true, nullable: true, defaultValue: null, modelName: Grade9 )
• Grade10 ( type: esriFieldTypeSmallInteger, alias: Grade10, editable: true, nullable: true, defaultValue: null, modelName: Grade10 )
• Grade11 ( type: esriFieldTypeSmallInteger, alias: Grade11, editable: true, nullable: true, defaultValue: null, modelName: Grade11 )
• Grade12 ( type: esriFieldTypeSmallInteger, alias: Grade12, editable: true, nullable: true, defaultValue: null, modelName: Grade12 )
• PrimaryContact ( type: esriFieldTypeInteger, alias: PrimaryContact, editable: true, nullable: true, defaultValue: null, modelName: PrimaryContact )
• AttendeeCount ( type: esriFieldTypeInteger, alias: AttendeeCount, editable: true, nullable: true, defaultValue: null, modelName: AttendeeCount )
• CustomerID ( type: esriFieldTypeInteger, alias: CustomerID, editable: true, nullable: true, defaultValue: null, modelName: CustomerID )
• X_Longitude ( type: esriFieldTypeDouble, alias: X_Longitude, editable: true, nullable: true, defaultValue: null, modelName: X_Longitude )
• Y_Latitude ( type: esriFieldTypeDouble, alias: Y_Latitude, editable: true, nullable: true, defaultValue: null, modelName: Y_Latitude )
• Shape ( type: esriFieldTypeString, alias: Shape, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Shape )
• Survey123_GlobalID ( type: esriFieldTypeGUID, alias: Survey123_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Survey123_GlobalID )
• Merged ( type: esriFieldTypeSmallInteger, alias: Merged, editable: true, nullable: true, defaultValue: null, modelName: Merged )
• MergedDate ( type: esriFieldTypeDate, alias: MergedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MergedDate )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: MLE_Event table
  Description:
  Prototype:
  GlobalID: {00000000-0000-0000-0000-000000000000}
  MergedDate: null
  EventStatus: null
  EventStatusNotes: null
  EventStartDate: null
  EventStartTime: null
  EventEndDate: null
  EventEndTime: null
  DepartureDate: null
  DepartureTime: null
  EventName: null
  DriveTime: null
  LocationName: null
  LocationAddress: null
  LocationCity: null
  LocationCounty: null
  LocationState: KS
  LocationZip: null
  AdequateParking: null
  ParkingDetails: null
  Overnight: null
  PermissionSlips: null
  PowerSource: null
  SetupStartTime: null
  RequestDate: null
  StudentAccomReq: null
  StudentAccomDetails: null
  Kindergarten: null
  Grade1: null
  Grade2: null
  Grade3: null
  Grade4: null
  Grade5: null
  Grade6: null
  Grade7: null
  Grade8: null
  Grade9: null
  Grade10: null
  Grade11: null
  Grade12: null
  PrimaryContact: null
  AttendeeCount: null
  CustomerID: null
  X_Longitude: null
  Y_Latitude: null
  Shape: null
  Survey123_GlobalID: null
  Merged: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata