Name: Capitalisation Details

Display Field: PROJECT_NO

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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: false
Supports TrueCurve: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString , alias: Asset ID , length: 8 )
• GlobalID_REL ( type: esriFieldTypeGUID , alias: GlobalID_REL , length: 38 )
• FY_REPORT ( type: esriFieldTypeSmallInteger , alias: Finance Year Reported )
• TOTAL_COST ( type: esriFieldTypeDouble , alias: Total Costs )
• ACT_COST ( type: esriFieldTypeDouble , alias: Actualised Costs )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• NOTE ( type: esriFieldTypeString , alias: Note , length: 255 )
• CATEGORY ( type: esriFieldTypeSmallInteger , alias: Category , Coded Values: [1: Bin] , [2: Fence] , [3: Footpath] , ...7 more... )
• TYPE ( type: esriFieldTypeString , alias: Type , length: 50 )
• PROJ_STAT ( type: esriFieldTypeString , alias: Project Status , length: 20 , Coded Values: [Complete: Complete] , [In Progress: In Progress] )
• SITENAME ( type: esriFieldTypeString , alias: Site Name , length: 120 )
• PROJECT_NO ( type: esriFieldTypeString , alias: Project No , length: 14 )
• MATERIAL ( type: esriFieldTypeString , alias: Material , length: 50 )
• PERC_RENEWED ( type: esriFieldTypeSmallInteger , alias: Percent Renewed )
• PERC_RETIRED ( type: esriFieldTypeSmallInteger , alias: Percent Retired )
• FINANCE_CAT ( type: esriFieldTypeString , alias: Finance Category , length: 40 , Coded Values: [New: New] , [Renewed: Renewed] , [Partially Renewed: Partially Renewed] , ...9 more... )

Relationships:

• GIS.WMC.parkassets_A (10) -- Related To: Park Assets - Polygons (2)
• GIS.WMC.parkassets_L (6) -- Related To: Park Assets - Line (1)
• GIS.WMC.parkassets_P (1) -- Related To: Park Assets - Points (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates