Name: crw_net.dbo.Case_Main
Display Field: CASE_NAME
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 3000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
PREFIX
(
type: esriFieldTypeString, alias: PREFIX, length: 6
)
-
YRMO
(
type: esriFieldTypeDouble, alias: YRMO
)
-
SEQ_NO
(
type: esriFieldTypeDouble, alias: SEQ_NO
)
-
CASE_NO
(
type: esriFieldTypeString, alias: CASE_NO, length: 15
)
-
CASE_NAME
(
type: esriFieldTypeString, alias: CASE_NAME, length: 60
)
-
STARTED
(
type: esriFieldTypeDate, alias: STARTED, length: 8
)
-
STARTED_BY
(
type: esriFieldTypeString, alias: STARTED_BY, length: 6
)
-
CLOSED
(
type: esriFieldTypeDate, alias: CLOSED, length: 8
)
-
CLOSED_BY
(
type: esriFieldTypeString, alias: CLOSED_BY, length: 6
)
-
LASTACTION
(
type: esriFieldTypeDate, alias: LASTACTION, length: 8
)
-
LASTACTION_BY
(
type: esriFieldTypeString, alias: LASTACTION_BY, length: 6
)
-
FOLLOWUP
(
type: esriFieldTypeDate, alias: FOLLOWUP, length: 8
)
-
FOLLOWUP_BY
(
type: esriFieldTypeString, alias: FOLLOWUP_BY, length: 6
)
-
RECEIVED_BY
(
type: esriFieldTypeString, alias: RECEIVED_BY, length: 30
)
-
HOW_RECEIVED
(
type: esriFieldTypeString, alias: HOW_RECEIVED, length: 30
)
-
CaseType
(
type: esriFieldTypeString, alias: CaseType, length: 60
)
-
CaseSubType
(
type: esriFieldTypeString, alias: CaseSubType, length: 60
)
-
CASE_LOCATION
(
type: esriFieldTypeString, alias: CASE_LOCATION, length: 100
)
-
SITE_APN
(
type: esriFieldTypeString, alias: SITE_APN, length: 50
)
-
SITE_STREETID
(
type: esriFieldTypeInteger, alias: SITE_STREETID
)
-
SITE_NUMBER
(
type: esriFieldTypeString, alias: SITE_NUMBER, length: 12
)
-
SITE_STREETNAME
(
type: esriFieldTypeString, alias: SITE_STREETNAME, length: 30
)
-
SITE_UNIT_NO
(
type: esriFieldTypeString, alias: SITE_UNIT_NO, length: 10
)
-
SITE_CITY
(
type: esriFieldTypeString, alias: SITE_CITY, length: 30
)
-
SITE_STATE
(
type: esriFieldTypeString, alias: SITE_STATE, length: 2
)
-
SITE_ZIP
(
type: esriFieldTypeString, alias: SITE_ZIP, length: 10
)
-
SITE_LOT_NO
(
type: esriFieldTypeString, alias: SITE_LOT_NO, length: 10
)
-
SITE_BLOCK
(
type: esriFieldTypeString, alias: SITE_BLOCK, length: 10
)
-
SITE_TRACT
(
type: esriFieldTypeString, alias: SITE_TRACT, length: 50
)
-
SITE_SUBDIVISION
(
type: esriFieldTypeString, alias: SITE_SUBDIVISION, length: 100
)
-
SITE_DESCRIPTION
(
type: esriFieldTypeString, alias: SITE_DESCRIPTION, length: 2000
)
-
SITE_ADDR
(
type: esriFieldTypeString, alias: SITE_ADDR, length: 30
)
-
CODE_SECTION
(
type: esriFieldTypeString, alias: CODE_SECTION, length: 30
)
-
DESCRIPTION
(
type: esriFieldTypeString, alias: DESCRIPTION, length: 2000
)
-
ASSIGNED_TO
(
type: esriFieldTypeString, alias: ASSIGNED_TO, length: 30
)
-
REFERRED_TO
(
type: esriFieldTypeString, alias: REFERRED_TO, length: 30
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 60
)
-
FEES_CHARGED
(
type: esriFieldTypeDouble, alias: FEES_CHARGED
)
-
FEES_PAID
(
type: esriFieldTypeDouble, alias: FEES_PAID
)
-
BALANCE_DUE
(
type: esriFieldTypeDouble, alias: BALANCE_DUE
)
-
PARENT_PROJECT_NO
(
type: esriFieldTypeString, alias: PARENT_PROJECT_NO, length: 15
)
-
OTHER_DATE1
(
type: esriFieldTypeDate, alias: OTHER_DATE1, length: 8
)
-
OTHER_BY1
(
type: esriFieldTypeString, alias: OTHER_BY1, length: 6
)
-
OWNER_NAME
(
type: esriFieldTypeString, alias: OWNER_NAME, length: 60
)
-
RESIDENT_NAME
(
type: esriFieldTypeString, alias: RESIDENT_NAME, length: 60
)
-
COMPLAINANT_NAME
(
type: esriFieldTypeString, alias: COMPLAINANT_NAME, length: 60
)
-
RECORDID
(
type: esriFieldTypeString, alias: RECORDID, length: 30
)
-
LOCKID
(
type: esriFieldTypeString, alias: LOCKID, length: 30
)
-
LOC_RECORDID
(
type: esriFieldTypeString, alias: LOC_RECORDID, length: 30
)
-
DEPOSITTYPE
(
type: esriFieldTypeString, alias: DEPOSITTYPE, length: 60
)
-
HISTORICAL_APN
(
type: esriFieldTypeString, alias: HISTORICAL_APN, length: 50
)
-
PARENT_PERMIT_NO
(
type: esriFieldTypeString, alias: PARENT_PERMIT_NO, length: 15
)
-
PARENT_BUS_LIC_NO
(
type: esriFieldTypeString, alias: PARENT_BUS_LIC_NO, length: 20
)
-
REFERENCE_NO
(
type: esriFieldTypeString, alias: REFERENCE_NO, length: 30
)
-
SITE_ALTERNATE_ID
(
type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, length: 40
)
-
SITE_GEOTYPE
(
type: esriFieldTypeString, alias: SITE_GEOTYPE, length: 60
)
-
Parent_Generic1_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic1_ActivityNo, length: 15
)
-
Parent_Generic2_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic2_ActivityNo, length: 15
)
-
Parent_Generic3_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic3_ActivityNo, length: 15
)
-
Parent_Generic4_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic4_ActivityNo, length: 15
)
-
Parent_Generic5_ActivityNo
(
type: esriFieldTypeString, alias: Parent_Generic5_ActivityNo, length: 15
)
-
TSstatus
(
type: esriFieldTypeInteger, alias: TSstatus
)
-
ESRI_OID
(
type: esriFieldTypeOID, alias: ESRI_OID
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata