Name: Review

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:

• WorkOrderId (type: esriFieldTypeInteger, alias: WorkOrderId, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SCRStatus (type: esriFieldTypeString, alias: SCRStatus, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Start (type: esriFieldTypeDate, alias: Start, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Finish (type: esriFieldTypeDate, alias: Finish, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Project_Name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Project_Type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Type_of_Development (type: esriFieldTypeString, alias: Type of Development, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Peak_Flow__GPD_ (type: esriFieldTypeDouble, alias: Peak Flow (GPD), SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Average_Daily_Flow__GPD_ (type: esriFieldTypeString, alias: Average Daily Flow (GPD), SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Developer_Name (type: esriFieldTypeString, alias: Developer Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Developer_Contact (type: esriFieldTypeString, alias: Developer Contact, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Developer_Phone__ (type: esriFieldTypeString, alias: Developer Phone #, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Developer_Email_Address (type: esriFieldTypeString, alias: Developer Email Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Developer_Address (type: esriFieldTypeString, alias: Developer Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Engineer_s_Name (type: esriFieldTypeString, alias: Engineer's Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Engineer_s_Contact (type: esriFieldTypeString, alias: Engineer's Contact, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Engineer_s_Phone__ (type: esriFieldTypeString, alias: Engineer's Phone #, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Engineer_s_Email_Address (type: esriFieldTypeString, alias: Engineer's Email Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Engineer_s_Address (type: esriFieldTypeString, alias: Engineer's Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Sewershed (type: esriFieldTypeString, alias: Sewershed, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Evaluation (type: esriFieldTypeString, alias: Evaluation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Approval_Date (type: esriFieldTypeDate, alias: Approval Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ApprovalYear (type: esriFieldTypeInteger, alias: ApprovalYear, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Estimated_Date_of_Connection (type: esriFieldTypeString, alias: Estimated Date of Connection, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Actual_Date_of_Connection (type: esriFieldTypeString, alias: Actual Date of Connection, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Illicit_Connection (type: esriFieldTypeString, alias: Illicit Connection, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Essential_Service (type: esriFieldTypeString, alias: Essential Service, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MHID (type: esriFieldTypeString, alias: MHID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• XCoord (type: esriFieldTypeDouble, alias: XCoord, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• YCoord (type: esriFieldTypeDouble, alias: YCoord, SQL Type: sqlTypeFloat, 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

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