Name: Projects

Display Field: project

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• project (type: esriFieldTypeString, alias: PROJECT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• project_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ppa__ (type: esriFieldTypeString, alias: PPA #, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• year_bid (type: esriFieldTypeInteger, alias: Year BID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sq_ft__subs_completion_ (type: esriFieldTypeInteger, alias: SQ FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• consultant (type: esriFieldTypeString, alias: CONSULTANT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• consultant___total__ (type: esriFieldTypeString, alias: CONSULTANT - TOTAL $, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• contractor (type: esriFieldTypeString, alias: CONTRACTOR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• contractor___total__ (type: esriFieldTypeInteger, alias: CONTRACTOR - TOTAL $, SQL Type: sqlTypeOther, nullable: true, editable: true)
• src (type: esriFieldTypeString, alias: src, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• construction_____per_sf (type: esriFieldTypeDouble, alias: CONSTRUCTION - $ PER SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• project___total__ (type: esriFieldTypeInteger, alias: PROJECT - TOTAL $, SQL Type: sqlTypeOther, nullable: true, editable: true)
• project_____per_sf (type: esriFieldTypeDouble, alias: PROJECT - $ PER SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• delegated_or_state_managed (type: esriFieldTypeString, alias: DELEGATED OR STATE MANAGED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• who_put_in_for_gccm_contract_ (type: esriFieldTypeString, alias: WHO PUT IN FOR GCCM CONTRACT?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• f__years_to_escalate__06_22_mid (type: esriFieldTypeInteger, alias: # Years to Escalate (06/22 mid point construction), SQL Type: sqlTypeOther, nullable: true, editable: true)
• annual_avg_esc (type: esriFieldTypeDouble, alias: Annual Avg Esc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• multiplier (type: esriFieldTypeDouble, alias: Multiplier, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_project_cost_escalated_to (type: esriFieldTypeDouble, alias: Total Project Cost Escalated to 2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• buildid (type: esriFieldTypeString, alias: Building ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: Projects
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• MSUBuilding20200608 (0) -- Related To: Building (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/2/2020 6:41:23 PM

Schema Last Edit Date: 12/2/2020 6:41:23 PM

Data Last Edit Date: 12/2/2020 6:41:23 PM

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