Tables:

Table: ProjectStaff (0)

Name: ProjectStaff

Display Field: DesignPMFullName

Type: Table

Geometry Type: N/A

Description: This table contains project staff data from COMPASS.

Service Item Id: 78496affe08f443292971ba22009a117

Copyright Text: AEC Applications, EGIS

Default Visibility: false

MaxRecordCount: 2000

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 )
• ProjectID ( type: esriFieldTypeInteger, alias: Project ID )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, length: 50 )
• ProposedProjectNumber ( type: esriFieldTypeString, alias: Proposed Project Number, length: 50 )
• DesignPMFullName ( type: esriFieldTypeString, alias: Design Project Manager Full Name, length: 100 )
• DesignPMUnit ( type: esriFieldTypeString, alias: Design Project Manager Unit, length: 100 )
• DesignPEFullName ( type: esriFieldTypeString, alias: Design Project Engineer Full Name, length: 100 )
• DesignPEUnit ( type: esriFieldTypeString, alias: Design Project Engineer Unit, length: 100 )
• DesignPETitle ( type: esriFieldTypeString, alias: Design Project Engineer Title, length: 100 )
• BridgeLeadFullName ( type: esriFieldTypeString, alias: Bridge Lead Full Name, length: 100 )
• BridgeLeadUnit ( type: esriFieldTypeString, alias: Bridge Lead Unit, length: 100 )
• BridgeLeadTitle ( type: esriFieldTypeString, alias: Bridge Lead Title, length: 100 )
• TrafficLeadFullName ( type: esriFieldTypeString, alias: Traffic Lead Full Name, length: 100 )
• TrafficLeadUnit ( type: esriFieldTypeString, alias: Traffic Lead Unit, length: 100 )
• TrafficLeadTitle ( type: esriFieldTypeString, alias: Traffic Lead Title, length: 100 )
• ConstructionTSEFullName ( type: esriFieldTypeString, alias: Construction TSE Full Name, length: 100 )
• ConstructionTSEUnit ( type: esriFieldTypeString, alias: Construction TSE Unit, length: 100 )
• ConstructionTSETitle ( type: esriFieldTypeString, alias: Construction TSE Title, length: 100 )
• ConstructionPMFullName ( type: esriFieldTypeString, alias: Construction Project Manager Full Name, length: 100 )
• ConstructionPMUnit ( type: esriFieldTypeString, alias: Construction Project Manager Unit, length: 100 )
• ConstructionPMTitle ( type: esriFieldTypeString, alias: Construction Project Manager Title, length: 100 )
• ChiefInspectorFullName ( type: esriFieldTypeString, alias: Chief Inspector Full Name, length: 100 )
• ChiefInspectorUnit ( type: esriFieldTypeString, alias: Chief Inspector Unit, length: 100 )
• ChiefInspectorTitle ( type: esriFieldTypeString, alias: Chief Inspector Title, length: 100 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )