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

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Case_Name___Case_Number (type: esriFieldTypeString, alias: Case Name / Case Number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Type_of_Project (type: esriFieldTypeString, alias: Type of Project, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Date_Received (type: esriFieldTypeString, alias: Date Received, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Date_Responded_Completed (type: esriFieldTypeString, alias: Date Responded/Completed, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Customer_Name (type: esriFieldTypeString, alias: Customer Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Is_this_a_repeat_customer_ (type: esriFieldTypeString, alias: Is this a repeat customer?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Is_this_a_Non_English_Speaker_ (type: esriFieldTypeString, alias: Is this a Non-English Speaker?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contact_Information__Email__ (type: esriFieldTypeString, alias: Contact Information (Email):, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contact_Information__Phone_ (type: esriFieldTypeString, alias: Contact Information (Phone), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Zip_Code (type: esriFieldTypeInteger, alias: Zip Code, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Council_District (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Type_of_Customer (type: esriFieldTypeString, alias: Type of Customer, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Stated_Issues_Questions (type: esriFieldTypeString, alias: Stated Issues/Questions, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• How_did_the_Customer_Hear_About (type: esriFieldTypeString, alias: How did the Customer Hear About our Team?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Which_COA_Staff_referred_the_cu (type: esriFieldTypeString, alias: Which COA Staff referred the customer?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Which_Staff_is_the_Team_Referri (type: esriFieldTypeString, alias: Which Staff is the Team Referring the Customer to First?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_Process_is_the_Customer_in (type: esriFieldTypeString, alias: What Process is the Customer in?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Is_this_a_Qualified_Customer_ (type: esriFieldTypeString, alias: Is this a Qualified Customer?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Which_Dept__is_responsible_for_ (type: esriFieldTypeString, alias: Which Dept. is responsible for the issue/question?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Is_this_related_to_a_Code_Viola (type: esriFieldTypeString, alias: Is this related to a Code Violation?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• How_did_the_Customer_Communicat (type: esriFieldTypeString, alias: How did the Customer Communicate with the Team Initially?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• How_did_the_Team_respond_to_the (type: esriFieldTypeString, alias: How did the Team respond to the Customer?, SQL Type: sqlTypeNVarchar, length: 4000, 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