Name: CE NoV Report Table

Display Field: DIVISION

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b0dc60ad91304e60b3d0deb884c64074

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
• DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
• CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
• REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
• CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
• UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
• NOV_DATE ( type: esriFieldTypeDate, alias: Notice Given Date, length: 8 )
• Court_Date ( type: esriFieldTypeDate, alias: Court Date, length: 8 )
• JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 )
• ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
• ADDRESS2 ( type: esriFieldTypeString, alias: Apt/ Unit No, length: 100 )
• ADDRESS3 ( type: esriFieldTypeString, alias: P.O. Box, length: 100 )
• CITY ( type: esriFieldTypeString, alias: City, length: 100 )
• STATE ( type: esriFieldTypeString, alias: State, length: 50 )
• POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
• PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
• PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
• PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
• PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
• PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
• PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
• MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 )
• MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 )
• CODE_DISTRICT ( type: esriFieldTypeString, alias: Code District, length: 50 )
• CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 )
• MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
• MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
• MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
• MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• Abate_Date ( type: esriFieldTypeDate, alias: Abatement Date, length: 8 )
• Sect_3081 ( type: esriFieldTypeString, alias: Sect. 308.1, length: 10 )
• Sect_3082_3083 ( type: esriFieldTypeString, alias: Sect. 308.1, length: 10 )
• Sect_3092_3093_3095 ( type: esriFieldTypeString, alias: Sect. 309.2;309.3;309.5, length: 10 )
• Sect_6054 ( type: esriFieldTypeString, alias: Sect. 605.4, length: 10 )
• Sect_6023_6031 ( type: esriFieldTypeString, alias: Sect. 602.3; 603.1, length: 10 )
• Sect_3027_3041 ( type: esriFieldTypeString, alias: Sect. 302.7; 304.1, length: 10 )
• Sect_3081_3082 ( type: esriFieldTypeString, alias: Sect. 308.1; 308.2, length: 10 )
• Sect_3024 ( type: esriFieldTypeString, alias: Sect. 302.4, length: 10 )
• Sect_3021_3081 ( type: esriFieldTypeString, alias: Sect. 302.1; 308.1, length: 10 )
• Sect_3028_1 ( type: esriFieldTypeString, alias: Sect. 302.8, length: 10 )
• Sect_3028_2 ( type: esriFieldTypeString, alias: Sect. 302.8, length: 10 )
• Sect_3028_30281_30282 ( type: esriFieldTypeString, alias: Sect. 302.8; 302.8.1; 302.8.2, length: 10 )
• Other_Offense ( type: esriFieldTypeString, alias: Other Offenses, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SR_GUID ( type: esriFieldTypeGUID, alias: SR_GUID, length: 38 )
• NOV_Recip ( type: esriFieldTypeString, alias: NOV_Recip, length: 255 )
• NOV_Violation ( type: esriFieldTypeString, alias: NOV_Violation, length: 255 )
• Violator ( type: esriFieldTypeString, alias: Violator, length: 255 )
• Insp_PhoneNum ( type: esriFieldTypeString, alias: Insp_PhoneNum, length: 50 )

Relationships:

• PW_Code_ServiceRequests (1) -- Related To: All Code Service Requests (0)
• PW_Code_ServiceRequests (4) -- Related To: All Active Service Requests (1)
• PW_Code_ServiceRequests (7) -- Related To: All Active Residential SR (2)
• PW_Code_ServiceRequests (10) -- Related To: Follow Ups This Week - Residential SR (3)
• PW_Code_ServiceRequests (13) -- Related To: All Follow Up Past Due Residential SR (4)
• PW_Code_ServiceRequests (16) -- Related To: All Supervisor Approval Needed (5)
• PW_Code_ServiceRequests (19) -- Related To: All Supervisor Approved (6)
• PW_Code_ServiceRequests (22) -- Related To: Denied Requests (13)
• PW_Code_ServiceRequests (25) -- Related To: Tickets Worked < 24 hours (7)
• PW_Code_ServiceRequests (28) -- Related To: Open over 5 days (8)
• PW_Code_ServiceRequests (31) -- Related To: All Closed/ Resolved Service Requests (9)
• PW_Code_ServiceRequests (34) -- Related To: Follow Up Today (10)
• PW_Code_ServiceRequests (37) -- Related To: Pending Litigation (12)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata