Name: Capital Projects

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 )
• FY_REPORT ( type: esriFieldTypeSmallInteger , alias: Finance Year Reported )
• PROJECT_NO ( type: esriFieldTypeString , alias: Project No , length: 10 )
• PROJ_DESC ( type: esriFieldTypeString , alias: Project Description , length: 255 )
• EXP_WIP ( type: esriFieldTypeDouble , alias: WIP Expenditure )
• EXP_CC ( type: esriFieldTypeDouble , alias: CC Expenditure )
• EXP_TOTAL ( type: esriFieldTypeDouble , alias: Total Expenditure )
• OPERATIONAL ( type: esriFieldTypeDouble , alias: Operational )
• ENG_SERVICES ( type: esriFieldTypeDouble , alias: Engineering Services )
• PROPERTY ( type: esriFieldTypeDouble , alias: Property )
• WIP ( type: esriFieldTypeDouble , alias: WIP )
• STATUS ( type: esriFieldTypeString , alias: Status , length: 25 , Coded Values: [Complete: Complete] , [In Progress: In Progress] )
• NOTE ( type: esriFieldTypeString , alias: Note , length: 255 )
• CAP_COSTS ( type: esriFieldTypeDouble , alias: Capital Costs )
• ACTUALISED_CAP ( type: esriFieldTypeDouble , alias: Actualised Capital Expenditure )
• NEW ( type: esriFieldTypeDouble , alias: New )
• RENEWED ( type: esriFieldTypeDouble , alias: Renewed )
• NO_ASSETS ( type: esriFieldTypeSmallInteger , alias: No. Assets )
• CC ( type: esriFieldTypeSmallInteger , alias: Cost Centre )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• EXP_OTH ( type: esriFieldTypeDouble , alias: Other Expenditure )

Supported Operations:   Query   Generate Renderer   Return Updates