Name: GISDept.dbo.tblWorkOrder

Display Field: ReqTypeDesc

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cda6be5bb90c4eee80aefb6d0e59c7ee

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• WorkOrderNo ( type: esriFieldTypeInteger, alias: WorkOrderNo, editable: true, nullable: true, defaultValue: null, modelName: WorkOrderNo )
• ReqTypeID ( type: esriFieldTypeInteger, alias: ReqTypeID, editable: true, nullable: true, defaultValue: null, modelName: ReqTypeID )
• ReqTypeDesc ( type: esriFieldTypeString, alias: ReqTypeDesc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReqTypeDesc )
• ReqUserID ( type: esriFieldTypeInteger, alias: ReqUserID, editable: true, nullable: true, defaultValue: null, modelName: ReqUserID )
• ReqUser ( type: esriFieldTypeString, alias: ReqUser, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReqUser )
• ReqUserDept ( type: esriFieldTypeString, alias: ReqUserDept, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReqUserDept )
• ReqUserDeptID ( type: esriFieldTypeInteger, alias: ReqUserDeptID, editable: true, nullable: true, defaultValue: null, modelName: ReqUserDeptID )
• OtherRequestor ( type: esriFieldTypeString, alias: OtherRequestor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OtherRequestor )
• MapAreaInterest ( type: esriFieldTypeString, alias: MapAreaInterest, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MapAreaInterest )
• ReqComment ( type: esriFieldTypeString, alias: ReqComment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ReqComment )
• UrgencyTypeID ( type: esriFieldTypeInteger, alias: UrgencyTypeID, editable: true, nullable: true, defaultValue: null, modelName: UrgencyTypeID )
• DateNeed ( type: esriFieldTypeDate, alias: DateNeed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateNeed )
• DateTime ( type: esriFieldTypeString, alias: DateTime, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DateTime )
• DateTimeID ( type: esriFieldTypeInteger, alias: DateTimeID, editable: true, nullable: true, defaultValue: null, modelName: DateTimeID )
• TimeUsed ( type: esriFieldTypeDouble, alias: TimeUsed, editable: true, nullable: true, defaultValue: null, modelName: TimeUsed )
• Completed ( type: esriFieldTypeSmallInteger, alias: Completed, editable: true, nullable: true, defaultValue: null, modelName: Completed )
• CompleteDate ( type: esriFieldTypeDate, alias: CompleteDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CompleteDate )
• CompleteNotes ( type: esriFieldTypeString, alias: CompleteNotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CompleteNotes )
• MgrComment ( type: esriFieldTypeString, alias: MgrComment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MgrComment )
• AssignToID ( type: esriFieldTypeInteger, alias: AssignToID, editable: true, nullable: true, defaultValue: null, modelName: AssignToID )
• AssignToUser ( type: esriFieldTypeString, alias: AssignToUser, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssignToUser )
• AssignDate ( type: esriFieldTypeDate, alias: AssignDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AssignDate )
• CDate ( type: esriFieldTypeDate, alias: CDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CDate )
• MDate ( type: esriFieldTypeDate, alias: MDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MDate )
• MUser ( type: esriFieldTypeInteger, alias: MUser, editable: true, nullable: true, defaultValue: null, modelName: MUser )
• MgrUserID ( type: esriFieldTypeInteger, alias: MgrUserID, editable: true, nullable: true, defaultValue: null, modelName: MgrUserID )
• MgrDateTime ( type: esriFieldTypeDate, alias: MgrDateTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MgrDateTime )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• WorkOrderID ( type: esriFieldTypeOID, alias: WorkOrderID, editable: false, nullable: false, defaultValue: null, modelName: WorkOrderID )
• AssignToID2 ( type: esriFieldTypeInteger, alias: AssignToID2, editable: true, nullable: true, defaultValue: null, modelName: AssignToID2 )
• AssignToID3 ( type: esriFieldTypeInteger, alias: AssignToID3, editable: true, nullable: true, defaultValue: null, modelName: AssignToID3 )
• TimeAssign1 ( type: esriFieldTypeDouble, alias: TimeAssign1, editable: true, nullable: true, defaultValue: null, modelName: TimeAssign1 )
• TimeAssign2 ( type: esriFieldTypeDouble, alias: TimeAssign2, editable: true, nullable: true, defaultValue: null, modelName: TimeAssign2 )
• TimeAssign3 ( type: esriFieldTypeDouble, alias: TimeAssign3, editable: true, nullable: true, defaultValue: null, modelName: TimeAssign3 )

Templates:

• Name: GISDept.dbo.tblWorkOrder
  Description:
  Prototype:
  TimeAssign2: null
  WorkOrderNo: null
  ReqTypeID: null
  ReqTypeDesc: null
  ReqUserID: null
  ReqUser: null
  ReqUserDept: null
  ReqUserDeptID: null
  OtherRequestor: null
  MapAreaInterest: null
  ReqComment: null
  UrgencyTypeID: null
  DateNeed: null
  DateTime: null
  DateTimeID: null
  TimeUsed: null
  Completed: null
  CompleteDate: null
  CompleteNotes: null
  MgrComment: null
  AssignToID: null
  AssignToUser: null
  AssignDate: null
  CDate: null
  MDate: null
  MUser: null
  MgrUserID: null
  MgrDateTime: null
  POINT_X: null
  POINT_Y: null
  TimeAssign3: null
  AssignToID2: null
  AssignToID3: null
  TimeAssign1: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata