Name: Case_Main

Display Field: CASE_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 576da40e77a843c7a093f7b549286cad

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:

• PREFIX ( type: esriFieldTypeString, alias: PREFIX, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PREFIX )
• YRMO ( type: esriFieldTypeDouble, alias: YRMO, editable: true, nullable: true, defaultValue: null, modelName: YRMO )
• SEQ_NO ( type: esriFieldTypeDouble, alias: SEQ_NO, editable: true, nullable: true, defaultValue: null, modelName: SEQ_NO )
• CASE_NO ( type: esriFieldTypeString, alias: CASE_NO, editable: true, nullable: false, length: 30, defaultValue: null, modelName: CASE_NO )
• CASE_NAME ( type: esriFieldTypeString, alias: CASE_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CASE_NAME )
• STARTED ( type: esriFieldTypeDate, alias: STARTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTED )
• STARTED_BY ( type: esriFieldTypeString, alias: STARTED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: STARTED_BY )
• CLOSED ( type: esriFieldTypeDate, alias: CLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSED )
• CLOSED_BY ( type: esriFieldTypeString, alias: CLOSED_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CLOSED_BY )
• LASTACTION ( type: esriFieldTypeDate, alias: LASTACTION, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTACTION )
• LASTACTION_BY ( type: esriFieldTypeString, alias: LASTACTION_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: LASTACTION_BY )
• FOLLOWUP ( type: esriFieldTypeDate, alias: FOLLOWUP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FOLLOWUP )
• FOLLOWUP_BY ( type: esriFieldTypeString, alias: FOLLOWUP_BY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FOLLOWUP_BY )
• RECEIVED_BY ( type: esriFieldTypeString, alias: RECEIVED_BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RECEIVED_BY )
• HOW_RECEIVED ( type: esriFieldTypeString, alias: HOW_RECEIVED, editable: true, nullable: true, length: 30, defaultValue: null, modelName: HOW_RECEIVED )
• CaseType ( type: esriFieldTypeString, alias: CaseType, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CaseType )
• CaseSubType ( type: esriFieldTypeString, alias: CaseSubType, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CaseSubType )
• CASE_LOCATION ( type: esriFieldTypeString, alias: CASE_LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CASE_LOCATION )
• SITE_APN ( type: esriFieldTypeString, alias: SITE_APN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_APN )
• SITE_STREETID ( type: esriFieldTypeInteger, alias: SITE_STREETID, editable: true, nullable: true, defaultValue: null, modelName: SITE_STREETID )
• SITE_NUMBER ( type: esriFieldTypeString, alias: SITE_NUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SITE_NUMBER )
• SITE_STREETNAME ( type: esriFieldTypeString, alias: SITE_STREETNAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: SITE_STREETNAME )
• SITE_UNIT_NO ( type: esriFieldTypeString, alias: SITE_UNIT_NO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_UNIT_NO )
• SITE_CITY ( type: esriFieldTypeString, alias: SITE_CITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SITE_CITY )
• SITE_STATE ( type: esriFieldTypeString, alias: SITE_STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SITE_STATE )
• SITE_ZIP ( type: esriFieldTypeString, alias: SITE_ZIP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_ZIP )
• SITE_LOT_NO ( type: esriFieldTypeString, alias: SITE_LOT_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITE_LOT_NO )
• SITE_BLOCK ( type: esriFieldTypeString, alias: SITE_BLOCK, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_BLOCK )
• SITE_TRACT ( type: esriFieldTypeString, alias: SITE_TRACT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE_TRACT )
• SITE_SUBDIVISION ( type: esriFieldTypeString, alias: SITE_SUBDIVISION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SITE_SUBDIVISION )
• SITE_DESCRIPTION ( type: esriFieldTypeString, alias: SITE_DESCRIPTION, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: SITE_DESCRIPTION )
• SITE_ADDR ( type: esriFieldTypeString, alias: SITE_ADDR, editable: true, nullable: true, length: 85, defaultValue: null, modelName: SITE_ADDR )
• CODE_SECTION ( type: esriFieldTypeString, alias: CODE_SECTION, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CODE_SECTION )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 5000, defaultValue: null, modelName: DESCRIPTION )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: ASSIGNED_TO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ASSIGNED_TO )
• REFERRED_TO ( type: esriFieldTypeString, alias: REFERRED_TO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: REFERRED_TO )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 60, defaultValue: null, modelName: STATUS )
• FEES_CHARGED ( type: esriFieldTypeDouble, alias: FEES_CHARGED, editable: true, nullable: true, defaultValue: null, modelName: FEES_CHARGED )
• FEES_PAID ( type: esriFieldTypeDouble, alias: FEES_PAID, editable: true, nullable: true, defaultValue: null, modelName: FEES_PAID )
• BALANCE_DUE ( type: esriFieldTypeDouble, alias: BALANCE_DUE, editable: true, nullable: true, defaultValue: null, modelName: BALANCE_DUE )
• PARENT_PROJECT_NO ( type: esriFieldTypeString, alias: PARENT_PROJECT_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARENT_PROJECT_NO )
• OTHER_DATE1 ( type: esriFieldTypeDate, alias: OTHER_DATE1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OTHER_DATE1 )
• OTHER_BY1 ( type: esriFieldTypeString, alias: OTHER_BY1, editable: true, nullable: true, length: 6, defaultValue: null, modelName: OTHER_BY1 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: OWNER_NAME )
• RESIDENT_NAME ( type: esriFieldTypeString, alias: RESIDENT_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: RESIDENT_NAME )
• COMPLAINANT_NAME ( type: esriFieldTypeString, alias: COMPLAINANT_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: COMPLAINANT_NAME )
• RECORDID ( type: esriFieldTypeString, alias: RECORDID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RECORDID )
• LOCKID ( type: esriFieldTypeString, alias: LOCKID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOCKID )
• LOC_RECORDID ( type: esriFieldTypeString, alias: LOC_RECORDID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOC_RECORDID )
• DEPOSITTYPE ( type: esriFieldTypeString, alias: DEPOSITTYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DEPOSITTYPE )
• HISTORICAL_APN ( type: esriFieldTypeString, alias: HISTORICAL_APN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HISTORICAL_APN )
• PARENT_PERMIT_NO ( type: esriFieldTypeString, alias: PARENT_PERMIT_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARENT_PERMIT_NO )
• PARENT_BUS_LIC_NO ( type: esriFieldTypeString, alias: PARENT_BUS_LIC_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PARENT_BUS_LIC_NO )
• REFERENCE_NO ( type: esriFieldTypeString, alias: REFERENCE_NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: REFERENCE_NO )
• SITE_ALTERNATE_ID ( type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SITE_ALTERNATE_ID )
• SITE_GEOTYPE ( type: esriFieldTypeString, alias: SITE_GEOTYPE, editable: true, nullable: true, length: 60, defaultValue: null, modelName: SITE_GEOTYPE )
• Parent_Generic1_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic1_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic1_ActivityNo )
• Parent_Generic2_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic2_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic2_ActivityNo )
• Parent_Generic3_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic3_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic3_ActivityNo )
• Parent_Generic4_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic4_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic4_ActivityNo )
• Parent_Generic5_ActivityNo ( type: esriFieldTypeString, alias: Parent_Generic5_ActivityNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Parent_Generic5_ActivityNo )
• TSstatus ( type: esriFieldTypeInteger, alias: TSstatus, editable: true, nullable: true, defaultValue: null, modelName: TSstatus )
• ActivityTypeID ( type: esriFieldTypeInteger, alias: ActivityTypeID, editable: true, nullable: false, defaultValue: null, modelName: ActivityTypeID )
• Unique_Key ( type: esriFieldTypeGUID, alias: Unique_Key, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Unique_Key )
• RowNum ( type: esriFieldTypeOID, alias: RowNum, editable: false, nullable: false, defaultValue: null, modelName: RowNum )

Templates:

• Name: Case_Main
  Description:
  Prototype:
  Unique_Key: null
  PREFIX: null
  YRMO: null
  SEQ_NO: null
  CASE_NO:
  CASE_NAME: null
  STARTED: null
  STARTED_BY: null
  CLOSED: null
  CLOSED_BY: null
  LASTACTION: null
  LASTACTION_BY: null
  FOLLOWUP: null
  FOLLOWUP_BY: null
  RECEIVED_BY: null
  HOW_RECEIVED: null
  CaseType: null
  CaseSubType: null
  CASE_LOCATION: null
  SITE_APN: null
  SITE_STREETID: null
  SITE_NUMBER: null
  SITE_STREETNAME: null
  SITE_UNIT_NO: null
  SITE_CITY: null
  SITE_STATE: null
  SITE_ZIP: null
  SITE_LOT_NO: null
  SITE_BLOCK: null
  SITE_TRACT: null
  SITE_SUBDIVISION: null
  SITE_DESCRIPTION: null
  SITE_ADDR: null
  CODE_SECTION: null
  DESCRIPTION: null
  ASSIGNED_TO: null
  REFERRED_TO: null
  STATUS: null
  FEES_CHARGED: null
  FEES_PAID: null
  BALANCE_DUE: null
  PARENT_PROJECT_NO: null
  OTHER_DATE1: null
  OTHER_BY1: null
  OWNER_NAME: null
  RESIDENT_NAME: null
  COMPLAINANT_NAME: null
  RECORDID: null
  LOCKID: null
  LOC_RECORDID: null
  DEPOSITTYPE: null
  HISTORICAL_APN: null
  PARENT_PERMIT_NO: null
  PARENT_BUS_LIC_NO: null
  REFERENCE_NO: null
  SITE_ALTERNATE_ID: null
  SITE_GEOTYPE: null
  Parent_Generic1_ActivityNo: null
  Parent_Generic2_ActivityNo: null
  Parent_Generic3_ActivityNo: null
  Parent_Generic4_ActivityNo: null
  Parent_Generic5_ActivityNo: null
  TSstatus: null
  ActivityTypeID: 0
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata