Name: Sign Maintenance

Display Field: REPAIRDATE

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• SIGNID ( type: esriFieldTypeInteger , alias: SIGN ID , editable: true , nullable: true )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• REPAIR_TYPE ( type: esriFieldTypeSmallInteger , alias: REPAIR TYPE , editable: true , nullable: true , Coded Values: [1: ACCIDENT DAMAGE] , [2: SIGN REPLACEMENT] , [3: POLE REPLACEMENT] , ...1 more... )
• MATERIALS1 ( type: esriFieldTypeSmallInteger , alias: MATERIALS 1 , editable: true , nullable: true , Coded Values: [1: RIVETS] , [2: CORNER BOLTS] , [3: BANDING] , ...3 more... )
• COST1 ( type: esriFieldTypeSmallInteger , alias: COST 1 , editable: true , nullable: true )
• MATERIALS2 ( type: esriFieldTypeSmallInteger , alias: MATERIALS 2 , editable: true , nullable: true , Coded Values: [1: RIVETS] , [2: CORNER BOLTS] , [3: BANDING] , ...3 more... )
• COST2 ( type: esriFieldTypeSmallInteger , alias: COST 2 , editable: true , nullable: true )
• REPAIR_TIME ( type: esriFieldTypeDouble , alias: REPAIR TIME , editable: true , nullable: true )
• NUM_EMP ( type: esriFieldTypeSmallInteger , alias: NUMBER OF EMPLOYEES , editable: true , nullable: true )
• MANHOURS ( type: esriFieldTypeSmallInteger , alias: MAN HOURS , editable: true , nullable: true )
• LABORCOST ( type: esriFieldTypeDouble , alias: LABOR COST , editable: true , nullable: true )
• VEHICLENUM ( type: esriFieldTypeString , alias: VEHICLE NUMBER , editable: true , nullable: true , length: 50 )
• VEHICLEHOURS ( type: esriFieldTypeSmallInteger , alias: VEHICLE HOURS , editable: true , nullable: true )
• VEHICLECOST ( type: esriFieldTypeDouble , alias: VEHICLE COST , editable: true , nullable: true )
• TOTALCOST ( type: esriFieldTypeDouble , alias: TOTAL COST , editable: true , nullable: true )
• REPAIRDATE ( type: esriFieldTypeDate , alias: REPAIR DATE , editable: true , nullable: true , length: 8 )
• REPAIRID ( type: esriFieldTypeInteger , alias: REPAIR ID , editable: true , nullable: true )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )
• COMMENTS ( type: esriFieldTypeString , alias: COMMENTS , editable: true , nullable: true , length: 100 )

Templates:

• Name: Sign Maintenance
  Description:
  Prototype:
  REPAIRDATE: null
  COMMENTS: null
  SIGNID: null
  REPAIRID: null
  REPAIR_TYPE: null
  MATERIALS1: null
  COST1: null
  MATERIALS2: null
  COST2: null
  REPAIR_TIME: null
  NUM_EMP: null
  MANHOURS: null
  LABORCOST: null
  VEHICLENUM: null
  VEHICLEHOURS: null
  VEHICLECOST: null
  TOTALCOST: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SIGNS (0) -- Related To: Speed Limit Signs (0)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

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

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