Name: WorkHistory

Display Field: PROJECT_NAME

Type: Table

Geometry Type: N/A

Description: Record of work history on each segment of PAMs

Service Item Id: 199f02ce1d6346359839e782d3562cb1

Copyright Text: null

Default Visibility: false

MaxRecordCount: 20000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, length: 100 )
• PROJECT_PHASE ( type: esriFieldTypeString, alias: PROJECT_PHASE, length: 2 )
• JOB_NUMBER ( type: esriFieldTypeString, alias: JOB_NUMBER, length: 50 )
• CONTRACTOR ( type: esriFieldTypeSmallInteger, alias: CONTRACTOR , Coded Values: [1: DPW&T's OHM] , [4: Private Permittee, non-utility company] , [5: WG] , ...4 more... )
• WORK_DATE ( type: esriFieldTypeDate, alias: WORK_DATE, length: 8 )
• WORK_TYPE ( type: esriFieldTypeString, alias: WORK_TYPE, length: 50 , Coded Values: [M_O: Mill and Overlay] , [OL_ONLY: Overlay Only] , [BR_ONLY: Base Pavement Repair Only] , ...9 more... )
• MATERIAL_TYPE ( type: esriFieldTypeSmallInteger, alias: MATERIAL_TYPE , Coded Values: [530: 4.75mm HMA Superpave,PG 70-22] , [531: 9.5 mm HMA Superpave, PG 70-22] , [533: 12.5mm HMA Superpave, PG 70-22] , ...2 more... )
• THICKNESS_UNITS ( type: esriFieldTypeString, alias: THICKNESS_UNITS, length: 2 , Coded Values: [IN: inches] , [FT: feet] , [MI: miles] )
• MAJOR_MR ( type: esriFieldTypeString, alias: MAJOR_MR, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• WEDGE_LEVELING ( type: esriFieldTypeDouble, alias: WEDGE_LEVELING )
• WORK_STATUS ( type: esriFieldTypeSmallInteger, alias: WORK_STATUS , Coded Values: [1: Complete] , [2: Proposed] , [3: Needs List] )
• MP_EXPORT_DATE ( type: esriFieldTypeDate, alias: MP_EXPORT_DATE, length: 8 )
• WORKHISTORYID ( type: esriFieldTypeGUID, alias: WORKHISTORYID, length: 38 )
• LAST_UPDATED ( type: esriFieldTypeDate, alias: LAST_UPDATED, length: 8 )
• WORK_COST ( type: esriFieldTypeDouble, alias: WORK_COST )
• THICKNESS ( type: esriFieldTypeDouble, alias: THICKNESS , Coded Values: [0: 0] , [0.25: 0.25] , [0.5: 0.5] , ...8 more... )
• PROJECT_ID ( type: esriFieldTypeGUID, alias: PROJECT_ID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• projects (6) -- Related To: PAMS Projects (27)
• pavements (13) -- Related To: Pavement by Owner (19)

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

  Iteminfo   Thumbnail   Metadata