Name: CODE_GDB.CODEGISEDITOR.PW_Code_EnvEnf_NOV_ReportTable

Display Field: CONTACT_NAME_FIRST

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4d4247805e054de1a2a051217defa21c

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 )
• CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACT_NAME_FIRST )
• CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACT_NAME_LAST )
• 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 )
• VOYC ( type: esriFieldTypeString, alias: VOYC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VOYC )
• VOB ( type: esriFieldTypeString, alias: VOB, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VOB )
• VOM ( type: esriFieldTypeString, alias: VOM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VOM )
• NOV_Owner ( type: esriFieldTypeString, alias: NOV Owner, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NOV_Owner )
• NOV_Agent ( type: esriFieldTypeString, alias: NOV Agent, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NOV_Agent )
• NOV_Occupant ( type: esriFieldTypeString, alias: NOV Occupant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NOV_Occupant )
• Abate_Date ( type: esriFieldTypeDate, alias: Abatement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Abate_Date )
• Ord15_48 ( type: esriFieldTypeString, alias: Ord. 15-48, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord15_48 )
• Ord15_54 ( type: esriFieldTypeString, alias: Ord. 15-54, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord15_54 )
• Ord15_49 ( type: esriFieldTypeString, alias: Ord. 15-49, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord15_49 )
• Ord15_52 ( type: esriFieldTypeString, alias: Ord. 15-52, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord15_52 )
• Ord20_26 ( type: esriFieldTypeString, alias: Ord. 20-26, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord20_26 )
• Ord15_34 ( type: esriFieldTypeString, alias: Ord. 15-34, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord15_34 )
• Ord15_24 ( type: esriFieldTypeString, alias: Ord. 15-24, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord15_24 )
• Ord5708_Sect3021 ( type: esriFieldTypeString, alias: Ord. 5708 Sect. 302.1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord5708_Sect3021 )
• Ord5708_Sect3081 ( type: esriFieldTypeString, alias: Ord. 5708 Sect. 308.1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord5708_Sect3081 )
• Ord5708_Sect3082 ( type: esriFieldTypeString, alias: Ord. 5708 Sect. 308.2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ord5708_Sect3082 )
• Other_Offense ( type: esriFieldTypeString, alias: Other Offenses, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Other_Offense )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: CODE_GDB.CODEGISEDITOR.PW_Code_EnvEnf_NOV_ReportTable
  Description:
  Prototype:
  Ord5708_Sect3082: null
  Other_Offense: 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
  CONTACT_NAME_FIRST: null
  CONTACT_NAME_LAST: 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
  VOYC: null
  VOB: null
  VOM: null
  NOV_Owner: null
  NOV_Agent: null
  NOV_Occupant: null
  Abate_Date: null
  Ord15_48: null
  Ord15_54: null
  Ord15_49: null
  Ord15_52: null
  Ord20_26: null
  Ord15_34: null
  Ord15_24: null
  Ord5708_Sect3021: null
  Ord5708_Sect3081: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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