Geocortex Essentials Sites Directory Sign In Sign Out ( Guest )

Table: crw_net.dbo.Case_Main (ID: 21)

Display Name:   crw_net.dbo.Case_Main

Description:   

Type:   TableLayer

Display Field:   CASE_NAME

Primary Key Field:   ESRI_OID

Searchable:   False

Queryable:   True

Has Attachments:   False

Feature Label:   {CASE_NAME}

Feature Description:   N/A

Feature Long Description:   N/A

Icon:   N/A

Data Provider:   Default

Fields:
  • PREFIX (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • YRMO (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SEQ_NO (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CASE_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CASE_NAME (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • STARTED (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • STARTED_BY (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CLOSED (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CLOSED_BY (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • LASTACTION (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • LASTACTION_BY (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FOLLOWUP (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FOLLOWUP_BY (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • RECEIVED_BY (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • HOW_RECEIVED (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CaseType (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CaseSubType (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CASE_LOCATION (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_APN (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_STREETID (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_NUMBER (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_STREETNAME (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_UNIT_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_CITY (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_STATE (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_ZIP (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_LOT_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_BLOCK (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_TRACT (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_SUBDIVISION (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_DESCRIPTION (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_ADDR (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CODE_SECTION (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DESCRIPTION (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • ASSIGNED_TO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • REFERRED_TO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • STATUS (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FEES_CHARGED (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FEES_PAID (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • BALANCE_DUE (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PARENT_PROJECT_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • OTHER_DATE1 (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • OTHER_BY1 (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • OWNER_NAME (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • RESIDENT_NAME (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • COMPLAINANT_NAME (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • RECORDID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • LOCKID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • LOC_RECORDID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DEPOSITTYPE (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • HISTORICAL_APN (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PARENT_PERMIT_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PARENT_BUS_LIC_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • REFERENCE_NO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_ALTERNATE_ID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SITE_GEOTYPE (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Parent_Generic1_ActivityNo (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Parent_Generic2_ActivityNo (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Parent_Generic3_ActivityNo (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Parent_Generic4_ActivityNo (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Parent_Generic5_ActivityNo (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • TSstatus (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • ESRI_OID (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)

Layer Hyperlinks:
N/A

    Show Feature Hyperlinks:   Show

    Feature Hyperlinks:
    N/A

      Queries:

        Relationships:
        N/A





        Supported Interfaces:  REST