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:

• CONVERTED_ACCOUNT_NUMBER (type: esriFieldTypeString, alias: CONVERTED_ACCOUNT_NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STREET_SUFFIX (type: esriFieldTypeString, alias: STREET_SUFFIX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DIRECTIONAL (type: esriFieldTypeString, alias: DIRECTIONAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BLOCK_NUMBER (type: esriFieldTypeInteger, alias: BLOCK_NUMBER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PREDIRECTIONAL (type: esriFieldTypeString, alias: PREDIRECTIONAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• APARTMENT (type: esriFieldTypeString, alias: APARTMENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CUSTOMER_NAME (type: esriFieldTypeString, alias: CUSTOMER_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• HOME_PHONE_NUMBER (type: esriFieldTypeDouble, alias: HOME_PHONE_NUMBER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• WORK_PHONE_NUMBER (type: esriFieldTypeDouble, alias: WORK_PHONE_NUMBER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• WORK_ORDER_NUMBER (type: esriFieldTypeString, alias: WORK_ORDER_NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WORK_ORDER_TYPE (type: esriFieldTypeString, alias: WORK_ORDER_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WORK_ORDER_PRIORITY (type: esriFieldTypeInteger, alias: WORK_ORDER_PRIORITY, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• DATE_ISSUED (type: esriFieldTypeDate, alias: DATE_ISSUED, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• TIME_ISSUED (type: esriFieldTypeDate, alias: TIME_ISSUED, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• REQUESTED_SERVICE_DATE (type: esriFieldTypeDate, alias: REQUESTED_SERVICE_DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• REQUESTED_SERVICE_TIME (type: esriFieldTypeDate, alias: REQUESTED_SERVICE_TIME, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• SERVICE_CODE (type: esriFieldTypeString, alias: SERVICE_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SERVICE_SEQUENCE (type: esriFieldTypeInteger, alias: SERVICE_SEQUENCE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• METER_NUMBER (type: esriFieldTypeInteger, alias: METER_NUMBER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• METER_MANUFACTURER_CODE (type: esriFieldTypeString, alias: METER_MANUFACTURER_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• METER_SIZE_CODE (type: esriFieldTypeString, alias: METER_SIZE_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SPECIAL_METER_ID (type: esriFieldTypeInteger, alias: SPECIAL_METER_ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• METER_SPECIAL_CODE_1 (type: esriFieldTypeString, alias: METER_SPECIAL_CODE_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• METER_SPECIAL_CODE_2 (type: esriFieldTypeString, alias: METER_SPECIAL_CODE_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LOCATION_CODE (type: esriFieldTypeString, alias: LOCATION_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• HAZARD_CODE (type: esriFieldTypeString, alias: HAZARD_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COMMENT (type: esriFieldTypeString, alias: COMMENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• METER_READ_DATE_PREVIOUS (type: esriFieldTypeString, alias: METER_READ_DATE_PREVIOUS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• METER_READING_PREVIOUS (type: esriFieldTypeInteger, alias: METER_READING_PREVIOUS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• INSTRUCTIONS (type: esriFieldTypeString, alias: INSTRUCTIONS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DATE_COMPLETED (type: esriFieldTypeString, alias: DATE_COMPLETED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• METER_READING (type: esriFieldTypeInteger, alias: METER_READING, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• DEMAND_READING (type: esriFieldTypeInteger, alias: DEMAND_READING, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• BOD_READING_CURRENT (type: esriFieldTypeInteger, alias: BOD_READING_CURRENT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SS_READING_CURRENT (type: esriFieldTypeInteger, alias: SS_READING_CURRENT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ESTIMATED_READING_FLAG (type: esriFieldTypeString, alias: ESTIMATED_READING_FLAG, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• METER_READERS_INITIALS (type: esriFieldTypeString, alias: METER_READERS_INITIALS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WORK_ORDER_FIELD_COMMENTS_600 (type: esriFieldTypeString, alias: WORK_ORDER_FIELD_COMMENTS_600, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_NUMBER (type: esriFieldTypeString, alias: CO_METER_NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_MANUFACTURER_CODE (type: esriFieldTypeString, alias: CO_METER_MANUFACTURER_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_DEMAND_METER_FLAG (type: esriFieldTypeString, alias: CO_DEMAND_METER_FLAG, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_SIZE_CODE (type: esriFieldTypeString, alias: CO_METER_SIZE_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_DIGITS_TO_READ (type: esriFieldTypeInteger, alias: CO_METER_DIGITS_TO_READ, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CO_UNIT_OF_MEASURE (type: esriFieldTypeString, alias: CO_UNIT_OF_MEASURE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_CONSUMPTION_MULTIPLIER (type: esriFieldTypeInteger, alias: CO_METER_CONSUMPTION_MULTIPLIER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CO_METER_DEMAND_MULTIPLIER (type: esriFieldTypeInteger, alias: CO_METER_DEMAND_MULTIPLIER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CO_SPECIAL_METER_ID (type: esriFieldTypeString, alias: CO_SPECIAL_METER_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_SPECIAL_CODE_1 (type: esriFieldTypeString, alias: CO_METER_SPECIAL_CODE_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_METER_SPECIAL_CODE_2 (type: esriFieldTypeString, alias: CO_METER_SPECIAL_CODE_2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_LOCATION_CODE (type: esriFieldTypeString, alias: CO_LOCATION_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_HAZARD_CODE (type: esriFieldTypeString, alias: CO_HAZARD_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CO_READING (type: esriFieldTypeInteger, alias: CO_READING, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• WORK_ORDER_GROUP (type: esriFieldTypeString, alias: WORK_ORDER_GROUP, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ASSIGNED_TO_DEPARTMENT (type: esriFieldTypeString, alias: ASSIGNED_TO_DEPARTMENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ASSIGNED_TO (type: esriFieldTypeString, alias: ASSIGNED_TO, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• USERID_CREATED (type: esriFieldTypeString, alias: USERID_CREATED, 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