Name: CIP_Projects_Data_0

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Project_Nu (type: esriFieldTypeString, alias: Project_Nu, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Phase (type: esriFieldTypeString, alias: Phase, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PM (type: esriFieldTypeString, alias: PM, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• EXPECTED_AD__BID_DATE (type: esriFieldTypeDouble, alias: EXPECTED AD/ BID DATE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• BID_Quarter (type: esriFieldTypeString, alias: BID Quarter, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Year (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Bid_Date (type: esriFieldTypeString, alias: Bid Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• NTP (type: esriFieldTypeString, alias: NTP, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• NTP_Quarter (type: esriFieldTypeString, alias: NTP Quarter, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• NTP_Year (type: esriFieldTypeInteger, alias: NTP Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• NTP_date (type: esriFieldTypeString, alias: NTP date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PO (type: esriFieldTypeString, alias: PO, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PO_Amount (type: esriFieldTypeDouble, alias: PO Amount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Change_Orders (type: esriFieldTypeDouble, alias: Change Orders, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Construction_Cost_to_date (type: esriFieldTypeDouble, alias: Construction Cost to date, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Per_Complete (type: esriFieldTypeString, alias: Per_Complete, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Est__Substantial_Completion (type: esriFieldTypeDate, alias: Est. Substantial Completion, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ESC_Quarter (type: esriFieldTypeString, alias: ESC Quarter, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ESC_Year (type: esriFieldTypeInteger, alias: ESC Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Expected_Completion_Date (type: esriFieldTypeString, alias: Expected Completion Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Dashboard_gaps (type: esriFieldTypeString, alias: Dashboard gaps, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Cost (type: esriFieldTypeInteger, alias: Total Cost, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2024 4:36:44 PM

Schema Last Edit Date: 8/13/2024 4:36:44 PM

Data Last Edit Date: 8/13/2024 4:36:44 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat