Name: Needs Inventory - Table

Display Field: Name

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ProjectNum (type: esriFieldTypeInteger, alias: ProjectNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ProjectID (type: esriFieldTypeString, alias: ProjectID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Program (type: esriFieldTypeString, alias: Program, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ProjType (type: esriFieldTypeString, alias: ProjType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Council (type: esriFieldTypeString, alias: Council, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Quantity (type: esriFieldTypeDouble, alias: Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitCost (type: esriFieldTypeDouble, alias: UnitCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estimate (type: esriFieldTypeDouble, alias: Estimate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD01 (type: esriFieldTypeSmallInteger, alias: CD01, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD02 (type: esriFieldTypeSmallInteger, alias: CD02, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD03 (type: esriFieldTypeSmallInteger, alias: CD03, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD04 (type: esriFieldTypeSmallInteger, alias: CD04, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD05 (type: esriFieldTypeSmallInteger, alias: CD05, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD06 (type: esriFieldTypeSmallInteger, alias: CD06, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD07 (type: esriFieldTypeSmallInteger, alias: CD07, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD08 (type: esriFieldTypeSmallInteger, alias: CD08, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD09 (type: esriFieldTypeSmallInteger, alias: CD09, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD10 (type: esriFieldTypeSmallInteger, alias: CD10, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD11 (type: esriFieldTypeSmallInteger, alias: CD11, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD12 (type: esriFieldTypeSmallInteger, alias: CD12, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD13 (type: esriFieldTypeSmallInteger, alias: CD13, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD14 (type: esriFieldTypeSmallInteger, alias: CD14, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CDCW (type: esriFieldTypeSmallInteger, alias: CDCW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreatedOn (type: esriFieldTypeDate, alias: CreatedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ModifiedOn (type: esriFieldTypeDate, alias: ModifiedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RequestedBy (type: esriFieldTypeString, alias: Requested By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RequestedOn (type: esriFieldTypeDate, alias: Requested On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ApprovedBy (type: esriFieldTypeString, alias: Approved By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ApprovedOn (type: esriFieldTypeDate, alias: Approved On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LaneMiles (type: esriFieldTypeDouble, alias: Lane Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LengthFeet (type: esriFieldTypeDouble, alias: Length Feet, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Needs Inventory - Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/19/2026 10:25:08 AM

Schema Last Edit Date: 2/19/2026 10:25:08 AM

Data Last Edit Date: 2/19/2026 10:25:08 AM

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