Name: PWSDE.PUBWORKS.Sign_Orders

Display Field: SignCode

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SignCode ( type: esriFieldTypeString, alias: SignCode, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignCode , Coded Values: [Z1-10Y: Z1-10Y] , [Z1-10W: Z1-10W] , [Z1-10R: Z1-10R] , ...219 more... )
• SignDescription ( type: esriFieldTypeString, alias: SignDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignDescription , Coded Values: [ S SCHOOL XWALK ARROW FL YEL GR RIGHT: S SCHOOL XWALK ARROW FL YEL GR RIGHT] , [18" LIME GREEN CONES: 18" LIME GREEN CONES] , [3" X 36" FLURESCENT YLW STRIP: 3" X 36" FLURESCENT YLW STRIP] , ...324 more... )
• SignItemNumber ( type: esriFieldTypeString, alias: SignItemNumber, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SignItemNumber , Coded Values: [24 0100: 24 0100] , [24 0101: 24 0101] , [24 0103: 24 0103] , ...322 more... )
• Qty ( type: esriFieldTypeInteger, alias: Qty, editable: true, nullable: true, defaultValue: null, modelName: Qty )
• ActivityCode ( type: esriFieldTypeString, alias: ActivityCode, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ActivityCode , Coded Values: [Add to Inventory: Add to Inventory] , [Adjust: Adjust] , [Adjust Pressure: Adjust Pressure] , ...239 more... )
• SubmittedBy ( type: esriFieldTypeString, alias: SubmittedBy, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubmittedBy )
• SubmittedDate ( type: esriFieldTypeString, alias: SubmittedDate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SubmittedDate )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Department , Coded Values: [110BRIDGES: 110BRIDGES] , [110CONADMI: CONSTRUCTION ADMIN] , [110COSV: CITY OF SPOKANE VALLEY] , ...110 more... )
• WorkOrderID ( type: esriFieldTypeInteger, alias: WorkOrderID, editable: true, nullable: true, defaultValue: null, modelName: WorkOrderID )
• BlankDescription ( type: esriFieldTypeString, alias: BlankDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BlankDescription , Coded Values: [1-WAY PAVEMENT MARKERS YELLO: 1-WAY PAVEMENT MARKERS YELLO] , [24" SUMMA WHITE REFLECTIVE: 24" SUMMA WHITE REFLECTIVE] , [24" SUMMA WHITE VINYL: 24" SUMMA WHITE VINYL] , ...243 more... )
• BlankItemNumber ( type: esriFieldTypeString, alias: BlankItemNumber, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BlankItemNumber , Coded Values: [24 0923: 24 0923] , [24 0925: 24 0925] , [24 0926: 24 0926] , ...237 more... )
• BlankPreSheeted ( type: esriFieldTypeInteger, alias: BlankPreSheeted, editable: true, nullable: true, defaultValue: null, modelName: BlankPreSheeted )
• BlankNew ( type: esriFieldTypeInteger, alias: BlankNew, editable: true, nullable: true, defaultValue: null, modelName: BlankNew )
• LaborTime ( type: esriFieldTypeDouble, alias: LaborTime, editable: true, nullable: true, defaultValue: null, modelName: LaborTime )
• LaborRate ( type: esriFieldTypeDouble, alias: LaborRate, editable: true, nullable: true, defaultValue: null, modelName: LaborRate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Status )
• ProcessedBy ( type: esriFieldTypeString, alias: ProcessedBy, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProcessedBy )
• ProcessedDate ( type: esriFieldTypeString, alias: ProcessedDate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProcessedDate )
• FasterID ( type: esriFieldTypeString, alias: FasterID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FasterID )
• PostGUID ( type: esriFieldTypeGUID, alias: Post GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PostGUID )
• PlateGUID ( type: esriFieldTypeGUID, alias: Plate GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PlateGUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: PWSDE.PUBWORKS.Sign_Orders
  Description:
  Prototype:
  PlateGUID: null
  SignCode: null
  SignDescription: null
  SignItemNumber: null
  Qty: null
  ActivityCode: null
  SubmittedBy: null
  SubmittedDate: null
  Department: null
  WorkOrderID: null
  BlankDescription: null
  BlankItemNumber: null
  BlankPreSheeted: null
  BlankNew: null
  LaborTime: null
  LaborRate: null
  Status: null
  ProcessedBy: null
  ProcessedDate: null
  FasterID: null
  PostGUID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PWSDE.PUBWORKS.SignPosts (2) -- Related To: PWSDE.PUBWORKS.SignPosts (21)
• PWSDE.PUBWORKS.SignPlates (4) -- Related To: PWSDE.PUBWORKS.SignPlates (22)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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