Name: Capital Projects

Display Field: PROJECT_NO

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

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: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Capital Projects
  Description:
  Prototype:
  CC: null
  EXP_OTH: null
  FY_REPORT: 0
  PROJECT_NO:
  PROJ_DESC:
  EXP_WIP: 0
  EXP_CC: 0
  NO_ASSETS: null
  OPERATIONAL: 0
  ENG_SERVICES: 0
  PROPERTY: 0
  WIP: 0
  STATUS: null
  NOTE: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Generate Renderer   Return Updates