Name: Review

Display Field:

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

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• column0 (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column1 (type: esriFieldTypeString, alias: Developer, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column2 (type: esriFieldTypeString, alias: Application / Job #, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column3 (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column4 (type: esriFieldTypeString, alias: City / Town, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column5 (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column6 (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column7 (type: esriFieldTypeString, alias: NYSIO Load Zone, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column8 (type: esriFieldTypeString, alias: Circuit ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column9 (type: esriFieldTypeString, alias: Substation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• System_Type (type: esriFieldTypeString, alias: Hybrid (Y/N), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column12 (type: esriFieldTypeString, alias: ESS (kWAC), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Metering (type: esriFieldTypeString, alias: Metering, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column14 (type: esriFieldTypeString, alias: Value Stack (Y/N), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• APPLICATION_REVIEW (type: esriFieldTypeString, alias: Application Review: Start Data, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column17 (type: esriFieldTypeString, alias: Application Review: End Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column18 (type: esriFieldTypeString, alias: Application Review: Calculated Duration, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column19 (type: esriFieldTypeString, alias: Application Approved Date , SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PRELIMINARY_REVIEW (type: esriFieldTypeString, alias: Preliminary Review: Start Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column21 (type: esriFieldTypeString, alias: Preliminary Review: End Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column22 (type: esriFieldTypeString, alias: Preliminary Review: Calculated Duration, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CESIR (type: esriFieldTypeString, alias: CESIR: Payment Received Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column24 (type: esriFieldTypeString, alias: CESIR: Start Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column25 (type: esriFieldTypeString, alias: CESIR: End Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column26 (type: esriFieldTypeString, alias: CESIR: Calculated Duration, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SIR_Costs (type: esriFieldTypeString, alias: CESIR Study cost paid by applicant, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column28 (type: esriFieldTypeString, alias: Estimated Upgrade Costs Identified by Utility (CESIR or Not), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column29 (type: esriFieldTypeString, alias: Actual Project Costs Paid by Applicant, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Construction (type: esriFieldTypeString, alias: Construction: Down Payment Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column31 (type: esriFieldTypeString, alias: Construction: Full Payment Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column34 (type: esriFieldTypeString, alias: Verification Testing or Final Acceptance Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column35 (type: esriFieldTypeString, alias: Final Letter of Acceptance Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column36 (type: esriFieldTypeString, alias: Project Complete (Y/N/W), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• column38 (type: esriFieldTypeString, alias: Utility Retention of REC (Y/N), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, 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/1/2025 7:34:52 AM

Schema Last Edit Date: 8/1/2025 7:34:52 AM

Data Last Edit Date: 8/1/2025 7:34:52 AM

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