Name: CIP Relate

Display Field: PROJECT_NUMBER

Type: Table

Geometry Type: N/A

Description: null

Service Item Id:

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
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_NUMBER ( type: esriFieldTypeString, alias: PROJECT NUMBER , length: 10 )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT , length: 15 )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT , length: 100 )
• SUB_PROJECT ( type: esriFieldTypeString, alias: SUB-PROJECT, length: 50 )
• GENERAL_DESCRIPTION ( type: esriFieldTypeString, alias: GENERAL DESCRIPTION , length: 60 )
• PROJECT_PHASE ( type: esriFieldTypeString, alias: PROJECT PHASE, length: 20 )
• SCHEDULE_CLASSIFICATION ( type: esriFieldTypeString, alias: SCHEDULE, length: 30 )
• FUNDING_SOURCE ( type: esriFieldTypeString, alias: FUNDING SOURCE , length: 20 )
• ESTIMATED_COST ( type: esriFieldTypeString, alias: ESTIMATED_COST , length: 15 )
• EST_COST1 ( type: esriFieldTypeInteger, alias: EST_COST1 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION , length: 500 )
• PROJECTED_START_DATE ( type: esriFieldTypeString, alias: PROJECTED START DATE , length: 15 )
• PROJECTED_END_DATE ( type: esriFieldTypeString, alias: PROJECTED END DATE , length: 15 )
• ACTUAL_START_DATE ( type: esriFieldTypeString, alias: ACTUAL START DATE , length: 15 )
• ACTUAL_END_DATE ( type: esriFieldTypeString, alias: ACTUAL END DATE , length: 15 )
• EXTENSION_DATE ( type: esriFieldTypeString, alias: EXTENSION DATE , length: 15 )
• OBLIGATION_DATE ( type: esriFieldTypeString, alias: OBLIGATION DATE , length: 15 )
• ENCUMBER_TO_DATE ( type: esriFieldTypeString, alias: ENCUMBER TO DATE , length: 15 )
• NOTES ( type: esriFieldTypeString, alias: NOTES , length: 255 )
• CONTENT_LINK ( type: esriFieldTypeString, alias: CONTENT LINK, length: 255 )
• PROJECT_PAGE ( type: esriFieldTypeString, alias: PROJECT PAGE, length: 255 )
• SUB_PROJECT_NUMBER ( type: esriFieldTypeString, alias: Sub-Project Number, length: 10 )
• SHORT_TITLE ( type: esriFieldTypeString, alias: SHORT TITLE, length: 10 )
• EST_COST ( type: esriFieldTypeSmallInteger, alias: ESTIMATED COST )
• JUSTIFICATION ( type: esriFieldTypeString, alias: PROJECT JUSTIFICATION, length: 300 )
• LN_MILEAGE ( type: esriFieldTypeDouble, alias: LANE MILEAGE )
• DESIGN_PERCENT_COMPLETE ( type: esriFieldTypeSmallInteger, alias: DESIGN % COMPLETE )
• DESIGN_PERCENT_COMPLETE1 ( type: esriFieldTypeSingle, alias: DESIGN % COMPLETE (Decimal) )
• CONSTRUCTION_PERCENT_COMPLETE ( type: esriFieldTypeSmallInteger, alias: CONSTRUCTION % COMPLETE )
• CONSTRUCTION_PERCENT_COMPLETE1 ( type: esriFieldTypeSingle, alias: CONSTRUCTION % COMPLETE (Decimal) )

Relationships:

• Engineering.DBO.CIP_Points (0) -- Related To: CIP Points (0)
• Engineering.DBO.CIP_LIines (1) -- Related To: CIP Lines (1)

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

  Iteminfo   Thumbnail   Metadata