Name: Updates

Display Field: FiscalYear

Type: Table

Geometry Type: N/A

Description: This table is used to track updates to the CIP projects after they have been approved and are in progress.This data should be edited from the Capital Improvement Program Editor.It can be viewed from the Capital Improvement Program dashboard.

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text: City of Johnson City, TN Solution created by Ellen Lester (IT GIS) in coordination with Dustin Thompson and Samantha Rivera (Budget)

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ParentGUID ( type: esriFieldTypeGUID, alias: ParentGUID, length: 38 )
• FiscalYear ( type: esriFieldTypeString, alias: FiscalYear, length: 255 )
• PlannedCost ( type: esriFieldTypeDouble, alias: PlannedCost )
• ActualCost ( type: esriFieldTypeDouble, alias: ActualCost )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 2500 )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CIPVersion ( type: esriFieldTypeString, alias: CIPVersion, length: 255 )
• OldParentGUID ( type: esriFieldTypeGUID, alias: OldParentGUID, length: 38 )

Relationships:

• JC.CapitalImprovementsProgram_Updates (2) -- Related To: CIP (0)

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

  Iteminfo   Thumbnail   Metadata