Name: PWSDE.PUBWORKS.Sign_Orders

Display Field: SignCode

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SignCode ( type: esriFieldTypeString, alias: SignCode, length: 1073741822 , Coded Values: [Z1-10Y: Z1-10Y] , [Z1-10W: Z1-10W] , [Z1-10R: Z1-10R] , ...219 more... )
• SignDescription ( type: esriFieldTypeString, alias: SignDescription, length: 1073741822 , 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, length: 1073741822 , Coded Values: [24 0100: 24 0100] , [24 0101: 24 0101] , [24 0103: 24 0103] , ...322 more... )
• Qty ( type: esriFieldTypeInteger, alias: Qty )
• ActivityCode ( type: esriFieldTypeString, alias: ActivityCode, length: 1073741822 , Coded Values: [Add to Inventory: Add to Inventory] , [Adjust: Adjust] , [Adjust Pressure: Adjust Pressure] , ...239 more... )
• SubmittedBy ( type: esriFieldTypeString, alias: SubmittedBy, length: 1073741822 )
• SubmittedDate ( type: esriFieldTypeString, alias: SubmittedDate, length: 1073741822 )
• Department ( type: esriFieldTypeString, alias: Department, length: 1073741822 , Coded Values: [110BRIDGES: 110BRIDGES] , [110CONADMI: CONSTRUCTION ADMIN] , [110COSV: CITY OF SPOKANE VALLEY] , ...110 more... )
• WorkOrderID ( type: esriFieldTypeInteger, alias: WorkOrderID )
• BlankDescription ( type: esriFieldTypeString, alias: BlankDescription, length: 1073741822 , 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, length: 1073741822 , Coded Values: [24 0923: 24 0923] , [24 0925: 24 0925] , [24 0926: 24 0926] , ...237 more... )
• BlankPreSheeted ( type: esriFieldTypeInteger, alias: BlankPreSheeted )
• BlankNew ( type: esriFieldTypeInteger, alias: BlankNew )
• LaborTime ( type: esriFieldTypeDouble, alias: LaborTime )
• LaborRate ( type: esriFieldTypeDouble, alias: LaborRate )
• Status ( type: esriFieldTypeString, alias: Status, length: 1073741822 )
• ProcessedBy ( type: esriFieldTypeString, alias: ProcessedBy, length: 1073741822 )
• ProcessedDate ( type: esriFieldTypeString, alias: ProcessedDate, length: 1073741822 )
• FasterID ( type: esriFieldTypeString, alias: FasterID, length: 1073741822 )
• PostGUID ( type: esriFieldTypeGUID, alias: Post GUID, length: 38 )
• PlateGUID ( type: esriFieldTypeGUID, alias: Plate GUID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata