Layers:

Tables:

Case_Main (3)


Name: Case_Main

Display Field: CASE_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field:

Type ID Field:

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

Templates:

Name: Case_Main
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/4/2022 9:18:43 PM

Schema Last Edit Date: 2/4/2022 9:18:43 PM

Data Last Edit Date: 2/4/2022 9:18:43 PM