Name: CE NoV Report Table

Display Field: DIVISION

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 969860be9bfd457c9f7e5fe07609a353

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

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

Templates:

• Name: CE NoV Report Table
  Description:
  Prototype:
  Violator: null
  NOV_Violation: null
  DIVISION: null
  DEPARTMENT: null
  CATEGORY: null
  INCIDENT_ID: null
  INCIDENT_NUMBER: null
  INCIDENT_TYPE_ID: null
  REQUEST_TYPE: null
  REPORTED_DATE: null
  REQUEST_SUMMARY: null
  CREATED_BY_USER: null
  LAST_UPDATE_DATE: null
  UPDATED_BY_USER: null
  FOLLOWUP_DATE: null
  NOV_DATE: null
  Court_Date: null
  JOB_NOTES: null
  CLOSE_DATE: null
  SUPERVISOR: null
  ADDRESS1: null
  ADDRESS2: null
  ADDRESS3: null
  CITY: null
  STATE: null
  POSTAL_CODE: null
  PARCEL_ID: null
  PERSON_ADDRESS1: null
  PERSON_ADDRESS2: null
  PERSON_ADDRESS3: null
  PERSON_STATE: null
  PERSON_CITY: null
  PERSON_ZIP_CODE: null
  MAP_PG: null
  MAP_BLK: null
  CODE_DISTRICT: null
  CODE_SUBDISTRICT: null
  TARGET_BLOCK: null
  MLGW_CUSTOMER: null
  MLGW_CONTACT1: null
  MLGW_CONTACT2: null
  MLGW_EMAIL: null
  X_COORD: null
  Y_COORD: null
  Abate_Date: null
  Sect_3081: null
  Sect_3082_3083: null
  Sect_3092_3093_3095: null
  Sect_6054: null
  Sect_6023_6031: null
  Sect_3027_3041: null
  Sect_3081_3082: null
  Sect_3024: null
  Sect_3021_3081: null
  Sect_3028_1: null
  Sect_3028_2: null
  Sect_3028_30281_30282: null
  Other_Offense: null
  Insp_PhoneNum: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  SR_GUID: null
  NOV_Recip: null
  
  Drawing Tool: esriFeatureEditToolNone

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)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata