Name: All Active 90 Day Old Tickets

Display Field: GROUP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 01901823e977404899124c9f1479a330

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -6.446010433784268E7
YMin: -4790160.328718349
XMax: 5.391925586260903E7
YMax: 3.641184469033514E7
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: INCIDENT_TYPE_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [148, 0, 143, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 10392
  Label: CE-Accumulation of Stagnant
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [241, 245, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10396
  Label: CE-Code Miscellaneous
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 115, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 26748
  Label: CE-Covid19
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [127, 173, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 28747
  Label: CE-Covid19(EO)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 68, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 27747
  Label: CE-Covid19(Mask)
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 162, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10393
  Label: CE-Downtown Cleanup
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 225, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10395
  Label: CE-Junky Yard
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 38, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10401
  Label: CE-Open Storage and Furnishin
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [103, 158, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10408
  Label: CE-Recreational Vehicle Illeg
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 136, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10409
  Label: CE-Substandard,Derelict Struc
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 89, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10711
  Label: CE-Vacant Lot Code Violation
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [33, 110, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10400
  Label: CE-Vehicle Violations
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [81, 143, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10547
  Label: CE-Weeds Occupied Property
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [153, 191, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 21747
  Label: COMM - Miscellaneous
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [56, 125, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 34747
  Label: COMM-Graffiti
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 97, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 34748
  Label: COMM-Junky Property
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [208, 227, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 34749
  Label: COMM-Pot Holes
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [181, 209, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 34750
  Label: COMM-Substandard Delelict, Struc
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 247, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 34751
  Label: COMM-Vehicle Violation
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 204, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 34752
  Label: COMM-Weeds Occupied Property
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 179, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:

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

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• 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 )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 )
• REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
• REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
• SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
• CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
• UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
• NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
• JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 1000 )
• REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 4000 )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 )
• ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 )
• NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 )
• QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 )
• QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating )
• SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 20 )
• SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
• RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
• RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 )
• RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
• RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 60 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
• ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
• ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, 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 )
• P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
• P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
• CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
• CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
• 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 )
• GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number )
• CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District )
• CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 )
• DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
• DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
• STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
• STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
• TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
• SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 )
• SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 )
• COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 )
• SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
• PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
• CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
• MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
• MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 )
• SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 )
• SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 )
• 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 )
• NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
• LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
• RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
• cd_name ( type: esriFieldTypeInteger, alias: Council District No )
• cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
• sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
• sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
• scd_name ( type: esriFieldTypeInteger, alias: Super District No )
• scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
• neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
• neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
• tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
• tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
• voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
• voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
• zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
• zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
• ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
• ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
• cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
• CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
• SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
• SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
• EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• Previous_Res_Code ( type: esriFieldTypeString, alias: Previous Res Code, length: 50 )
• Dept_Type ( type: esriFieldTypeString, alias: Internal Dept Referral, length: 50 )
• emailFlag ( type: esriFieldTypeSmallInteger, alias: emailFlag )
• AntiNeglect_NTO_Mail_Date ( type: esriFieldTypeDate, alias: Anti Neglect NTO Mail Date, length: 8 )
• AntiNeglect_App_Proc_Date ( type: esriFieldTypeDate, alias: Anti Neglect Appeal Process Date, length: 8 )
• AntiNeglect_Build_Reg_Date ( type: esriFieldTypeDate, alias: Anti Neglect Building Registered Date, length: 8 )
• AntiNeglect_RePlans_Subm_Date ( type: esriFieldTypeDate, alias: Anti Neglect Rehab Plans Submit Date, length: 8 )
• AntiNeglect_Plans_App_Date ( type: esriFieldTypeDate, alias: Anti Neglect Plans Approved Date, length: 8 )
• AntiNeglect_Plans_App_By ( type: esriFieldTypeString, alias: Anti Neglect Plans Approved By, length: 500 )
• AntiNeglect_OwnAppeal_Req_Date ( type: esriFieldTypeDate, alias: Anti Neglect Owner Appeals Reqs Date, length: 8 )
• AntiNeglect_Permit_Issued_Date ( type: esriFieldTypeDate, alias: Anti Neglect Permits Issued Date, length: 8 )
• AntiNeglect_Const_Insp_Date ( type: esriFieldTypeDate, alias: Anti Neglect Construction Inspection Date, length: 8 )
• AntiNeglect_Notes ( type: esriFieldTypeString, alias: Anti Neglect Notes, length: 250 )
• AntiNeglect_Work_Complete_Date ( type: esriFieldTypeDate, alias: Anti Neglect Work Completed Date, length: 8 )
• BoardUp_Complaint_Date ( type: esriFieldTypeDate, alias: Board Up Complaint Date, length: 8 )
• BoardUp_Complaint_By ( type: esriFieldTypeString, alias: Board Up Complaint By, length: 50 )
• BoardUp_Inspection_Date ( type: esriFieldTypeDate, alias: Board Up Inspection Date, length: 8 )
• BoardUp_Inspection_Description ( type: esriFieldTypeString, alias: Board Up Inspection Description, length: 250 )
• BoardUp_VO_Order_Sent_Date ( type: esriFieldTypeDate, alias: Board Up VO Order Sent Date, length: 8 )
• BoardUp_FollowUpDate ( type: esriFieldTypeDate, alias: Board Up Follow Up Date, length: 8 )
• BoardUp_BoardandRequest_Date ( type: esriFieldTypeDate, alias: Board Up Board and Request Date, length: 8 )
• BoardUp_Contractor ( type: esriFieldTypeString, alias: Board Up Contractor, length: 50 )
• BoardUp_Contractor_Compl_Date ( type: esriFieldTypeDate, alias: Board Up Contractor Completion Date, length: 8 )
• BoardUp_Contractor_Invoice_Date ( type: esriFieldTypeDate, alias: Board Up Contractor Invoice Date, length: 8 )
• BoardUp_Notes ( type: esriFieldTypeString, alias: Board Up Notes, length: 2000 )
• BoardUp_Close_Date ( type: esriFieldTypeDate, alias: Board Up Close Date, length: 8 )
• BoardUp_Close_Description ( type: esriFieldTypeString, alias: Board Up Close Description, length: 250 )
• IllegalDumping_NTO_Mail_Date ( type: esriFieldTypeDate, alias: Illegal Dumping NTO Mail Date, length: 8 )
• IllegalDumping_PicsSentDate ( type: esriFieldTypeDate, alias: Illegal Dumping Pics Sent Date, length: 8 )
• VacantProperty_Type ( type: esriFieldTypeString, alias: Vacant Property Type, length: 50 )
• VacantProperty_Citizen_Reg_Date ( type: esriFieldTypeDate, alias: Vacant Property Citizen Register Date, length: 8 )
• VacantProperty_Code_Reg_Date ( type: esriFieldTypeDate, alias: Vacant Property Code Register Date, length: 8 )
• VacantProperty_VPR_NTR_Date ( type: esriFieldTypeDate, alias: Vacant Property VPR Notice To Register Date, length: 8 )
• Business_Lic ( type: esriFieldTypeString, alias: Business Lic., length: 50 )
• Business_Name ( type: esriFieldTypeString, alias: Tire Shop Name, length: 255 )
• CertCompliance_Date ( type: esriFieldTypeDate, alias: Cert. Compliance Date, length: 8 )
• Disposal_Manifest ( type: esriFieldTypeString, alias: Disposal Manifest, length: 50 )
• Hauling_Permit ( type: esriFieldTypeString, alias: Hauling Permit, length: 50 )
• Initial_InspDate ( type: esriFieldTypeDate, alias: Initial Inspection Date, length: 8 )
• Latest_InspDate ( type: esriFieldTypeDate, alias: Last Inspection date, length: 8 )
• Mailer_Date ( type: esriFieldTypeDate, alias: Mailer Date, length: 8 )
• Storage_Space ( type: esriFieldTypeString, alias: Storage Space, length: 50 )
• Summons_Date ( type: esriFieldTypeDate, alias: Summons Date, length: 8 )
• Tire_Count ( type: esriFieldTypeInteger, alias: Current Tire Count )
• TirePermit_Date ( type: esriFieldTypeDate, alias: Permit Date, length: 8 )
• TirePermit_No ( type: esriFieldTypeString, alias: Permit Number, length: 50 )
• TireShop_Status ( type: esriFieldTypeString, alias: Tire Shop Status, length: 50 )
• Tireshop_Type ( type: esriFieldTypeString, alias: Tire Shop Type, length: 50 )
• BILL_YESNO ( type: esriFieldTypeString, alias: Billing Yes/No, length: 10 )
• BILLING_ADMINFEE ( type: esriFieldTypeDouble, alias: Billing Admin Fee )
• BILLING_DATE ( type: esriFieldTypeDate, alias: Billing Date, length: 8 )
• BILLING_INVOICE_NUMBER ( type: esriFieldTypeString, alias: Billing Invoice Number, length: 50 )
• BILLING_NO_OF_HOURS ( type: esriFieldTypeDouble, alias: Billing Hours )
• BILLING_NOTICEFEE ( type: esriFieldTypeDouble, alias: Billing Notice Fee )
• BILLING_TOTAL ( type: esriFieldTypeDouble, alias: Billing Total )
• BILLING_VIOLATIONFEE ( type: esriFieldTypeDouble, alias: Billing Violation Fee )
• NPA_Type ( type: esriFieldTypeString, alias: NPA Type, length: 50 )
• NPA_Referral ( type: esriFieldTypeString, alias: NPA Referral, length: 500 )
• NPA_Assigned_To ( type: esriFieldTypeString, alias: NPA Assigned To, length: 50 )
• NPA_Lawsuit_Creator ( type: esriFieldTypeString, alias: NPA Lawsuit Creator, length: 50 )
• NPA_Sent_To_Univ_Date ( type: esriFieldTypeDate, alias: NPA Sent to University Date, length: 8 )
• NPA_PreCourt_Inspection_Date ( type: esriFieldTypeDate, alias: NPA Pre Court Inspection Date, length: 8 )
• NPA_Inspect_Summary ( type: esriFieldTypeString, alias: NPA Inspect Summary, length: 250 )
• NPA_Inspect_Resolved_Date ( type: esriFieldTypeDate, alias: NPA Inspect Resolved Date, length: 8 )
• Court_Status ( type: esriFieldTypeString, alias: Court Status, length: 50 )
• Court_AssignedTo ( type: esriFieldTypeString, alias: Court Assigned To, length: 50 )
• Case_Number ( type: esriFieldTypeString, alias: Case Number, length: 50 )
• CivilWarrant ( type: esriFieldTypeInteger, alias: Civil Warrant )
• CityFileNo ( type: esriFieldTypeString, alias: City File No, length: 50 )
• Court_Date ( type: esriFieldTypeDate, alias: Court Date, length: 8 )
• NextCourtDate ( type: esriFieldTypeDate, alias: Next Court Date, length: 8 )
• NextSetting ( type: esriFieldTypeDate, alias: Next Setting, length: 8 )
• Court_Property_Owner ( type: esriFieldTypeString, alias: Property Owner, length: 100 )
• ContactName ( type: esriFieldTypeString, alias: Contact Name, length: 500 )
• OwnerContactNumber ( type: esriFieldTypeString, alias: Owner Contact Number, length: 100 )
• BestWayToContact ( type: esriFieldTypeString, alias: Best Way To Contact, length: 500 )
• PhotoAfter ( type: esriFieldTypeString, alias: Photo After, length: 255 )
• PhotoBefore ( type: esriFieldTypeString, alias: Photo Before, 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 )
• ASSET_ID ( type: esriFieldTypeInteger, alias: Asset ID )
• COMM_Area ( type: esriFieldTypeString, alias: Commercial Area, length: 50 )
• NotesInitialFiling ( type: esriFieldTypeString, alias: Notes Initial Filing, length: 1000 )
• NotesOnService ( type: esriFieldTypeString, alias: Notes On Service, length: 500 )
• Other ( type: esriFieldTypeString, alias: Other, length: 250 )
• DismissedCondition ( type: esriFieldTypeString, alias: Dismissed Condition, length: 50 )
• DismissStatus ( type: esriFieldTypeString, alias: Dismiss Status, length: 50 )
• EnvCourt_Approved ( type: esriFieldTypeString, alias: Env Court Approved, length: 20 )
• EnvCourt_Status ( type: esriFieldTypeString, alias: Env Court Status, length: 50 )
• EnvCourt_AssignedTo ( type: esriFieldTypeString, alias: Env Court Assigned To, length: 50 )
• EnvCourt_CaseNumber ( type: esriFieldTypeString, alias: Env Court Case Number, length: 50 )
• EnvCourt_CourtDate ( type: esriFieldTypeDate, alias: Env Court Court Date, length: 8 )
• EnvCourt_NextSetting ( type: esriFieldTypeDate, alias: Env Court Next Setting, length: 8 )
• EnvCourt_InitialFilingNotes ( type: esriFieldTypeString, alias: Env Court Initial Filing Notes, length: 1000 )
• EnvCourt_DismissedCondition ( type: esriFieldTypeString, alias: Env Court Dismissed Condition, length: 50 )
• EnvCourt_DismissedStatus ( type: esriFieldTypeString, alias: Env Court Dismissed Status, length: 50 )
• OLD_OBJECTID ( type: esriFieldTypeInteger, alias: OLD_OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• THREAT_DETECTION ( type: esriFieldTypeString, alias: Threat Detection, length: 10 )
• THREAT_NOTES ( type: esriFieldTypeString, alias: THREAT_NOTES, length: 255 )
• PropertyOwnerName ( type: esriFieldTypeString, alias: PropertyOwnerName, length: 255 )
• THREAT_DETECTIONDATE ( type: esriFieldTypeDate, alias: Threat Detection Date, length: 8 )
• NotesFromCorrespondence ( type: esriFieldTypeString, alias: NotesFromCorrespondence, length: 2000 )
• CourtNotes ( type: esriFieldTypeString, alias: Court Notes, length: 2000 )
• EnvCourt_CourtNotes ( type: esriFieldTypeString, alias: EnvCourt_CourtNotes, length: 2000 )
• Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 )
• Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 )
• Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )
• Veh_Color ( type: esriFieldTypeString, alias: Veh_Color, length: 255 )
• Veh_Make ( type: esriFieldTypeString, alias: Veh_Make, length: 255 )
• Veh_Model ( type: esriFieldTypeString, alias: Veh_Model, length: 255 )
• Veh_Vin ( type: esriFieldTypeString, alias: Veh_Vin, length: 255 )
• Veh_LicPlate ( type: esriFieldTypeString, alias: Veh_LicPlate, length: 255 )
• Veh_LocOnProp ( type: esriFieldTypeString, alias: Veh_LocOnProp, length: 255 )
• SYSREVSTATUS ( type: esriFieldTypeString, alias: SYSREVSTATUS, length: 255 )

Relationships:

• Code_CE_NOV_ReportTable (16) -- Related To: CE NoV Report Table (19)
• PW_Code_CourtRecords (17) -- Related To: Court Records (34)

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

  Iteminfo   Thumbnail   Metadata