Name: CASE_UDF

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• CASE_NO (type: esriFieldTypeString, alias: CASE_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• IMPROVED (type: esriFieldTypeString, alias: IMPROVED, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DEFAULT_INSPECTOR (type: esriFieldTypeString, alias: DEFAULT_INSPECTOR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RECORDID (type: esriFieldTypeString, alias: RECORDID, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• MGR (type: esriFieldTypeString, alias: MGR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• EntryDate (type: esriFieldTypeDate, alias: EntryDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DaysToAck (type: esriFieldTypeDouble, alias: DaysToAck, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DaysToClose (type: esriFieldTypeDouble, alias: DaysToClose, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IncidentTime (type: esriFieldTypeDate, alias: IncidentTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ResponseTime (type: esriFieldTypeDate, alias: ResponseTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HHorE_Threat (type: esriFieldTypeString, alias: HHorE_Threat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RptToRB (type: esriFieldTypeDate, alias: RptToRB, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PrevIncident (type: esriFieldTypeString, alias: PrevIncident, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• EnfActionNo (type: esriFieldTypeString, alias: EnfActionNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• FollowUpReq (type: esriFieldTypeString, alias: FollowUpReq, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DateReq (type: esriFieldTypeDate, alias: DateReq, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CityExpenditure (type: esriFieldTypeString, alias: CityExpenditure, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformLat (type: esriFieldTypeString, alias: InformLat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformLong (type: esriFieldTypeString, alias: InformLong, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformWatershed (type: esriFieldTypeString, alias: InformWatershed, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformCAContNo (type: esriFieldTypeString, alias: InformCAContNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformSICcode (type: esriFieldTypeString, alias: InformSICcode, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformSCcat (type: esriFieldTypeString, alias: InformSCcat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• InformClassification (type: esriFieldTypeString, alias: InformClassification, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactCode (type: esriFieldTypeString, alias: ImpactCode, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactInventoried (type: esriFieldTypeString, alias: ImpactInventoried, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactLat (type: esriFieldTypeString, alias: ImpactLat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactLong (type: esriFieldTypeString, alias: ImpactLong, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactWatershed (type: esriFieldTypeString, alias: ImpactWatershed, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactCAContNo (type: esriFieldTypeString, alias: ImpactCAContNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactSICcode (type: esriFieldTypeString, alias: ImpactSICcode, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactSICcat (type: esriFieldTypeString, alias: ImpactSICcat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactClassification (type: esriFieldTypeString, alias: ImpactClassification, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactClassDesc (type: esriFieldTypeString, alias: ImpactClassDesc, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactPriority (type: esriFieldTypeString, alias: ImpactPriority, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactPubPriv (type: esriFieldTypeString, alias: ImpactPubPriv, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ImpactWDIDno (type: esriFieldTypeString, alias: ImpactWDIDno, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyCode (type: esriFieldTypeString, alias: RespPartyCode, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyInventoried (type: esriFieldTypeString, alias: RespPartyInventoried, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyLat (type: esriFieldTypeString, alias: RespPartyLat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyLong (type: esriFieldTypeString, alias: RespPartyLong, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyWatershed (type: esriFieldTypeString, alias: RespPartyWatershed, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyCAContNo (type: esriFieldTypeString, alias: RespPartyCAContNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartySICcode (type: esriFieldTypeString, alias: RespPartySICcode, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartySICcat (type: esriFieldTypeString, alias: RespPartySICcat, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyClassification (type: esriFieldTypeString, alias: RespPartyClassification, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyClassDesc (type: esriFieldTypeString, alias: RespPartyClassDesc, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RespPartyWDIDno (type: esriFieldTypeString, alias: RespPartyWDIDno, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CITATION (type: esriFieldTypeString, alias: CITATION, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• VIN (type: esriFieldTypeString, alias: VIN, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• MAKE (type: esriFieldTypeString, alias: MAKE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LICENSE (type: esriFieldTypeString, alias: LICENSE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• YEAR_FIELD (type: esriFieldTypeString, alias: YEAR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• REGISTERED (type: esriFieldTypeString, alias: REGISTERED, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DATE_FIELD (type: esriFieldTypeDate, alias: DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DEFAULT_INSPECTOR1 (type: esriFieldTypeString, alias: DEFAULT_INSPECTOR1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RECORDID1 (type: esriFieldTypeString, alias: RECORDID1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• COLOR (type: esriFieldTypeString, alias: COLOR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DAILYFEE (type: esriFieldTypeDouble, alias: DAILYFEE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEE (type: esriFieldTypeDouble, alias: FEE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SCOTT (type: esriFieldTypeString, alias: SCOTT, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• WEEKS (type: esriFieldTypeInteger, alias: WEEKS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INCIDENT_NUMBER (type: esriFieldTypeString, alias: INCIDENT_NUMBER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CITATION_NUMBER (type: esriFieldTypeString, alias: CITATION_NUMBER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• VEHICLE_MARK (type: esriFieldTypeString, alias: VEHICLE_MARK, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• WARNING (type: esriFieldTypeString, alias: WARNING, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• TOWED (type: esriFieldTypeString, alias: TOWED, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• TAG_MOYR (type: esriFieldTypeString, alias: TAG_MOYR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DATE_MARKED (type: esriFieldTypeString, alias: DATE_MARKED, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CONTACT_OWNER (type: esriFieldTypeString, alias: CONTACT_OWNER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINTS (type: esriFieldTypeInteger, alias: POINTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIMARY_COLOR (type: esriFieldTypeString, alias: PRIMARY_COLOR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• MARKINGS (type: esriFieldTypeString, alias: MARKINGS, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DOCUMENT_NUMBER (type: esriFieldTypeString, alias: DOCUMENT_NUMBER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DOCUMENT_DATE (type: esriFieldTypeDate, alias: DOCUMENT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TYPE_OF_ANIMAL (type: esriFieldTypeString, alias: TYPE_OF_ANIMAL, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• NAME_OF_ANIMAL (type: esriFieldTypeString, alias: NAME_OF_ANIMAL, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ANIMALS_AGE (type: esriFieldTypeString, alias: ANIMALS_AGE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ANIMALS_SEX (type: esriFieldTypeString, alias: ANIMALS_SEX, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ANIMALS_WEIGHT (type: esriFieldTypeString, alias: ANIMALS_WEIGHT, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PRIMARY_BREED (type: esriFieldTypeString, alias: PRIMARY_BREED, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• APPLICATION_TYPE (type: esriFieldTypeString, alias: APPLICATION_TYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PROV_MADE (type: esriFieldTypeString, alias: PROV_MADE, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• BEAT (type: esriFieldTypeString, alias: BEAT, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• BADGE (type: esriFieldTypeString, alias: BADGE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LOC_TYPE (type: esriFieldTypeString, alias: LOC_TYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• HR_EXECPT (type: esriFieldTypeString, alias: HR_EXECPT, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DATE_ABATED (type: esriFieldTypeString, alias: DATE_ABATED, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT4_1 (type: esriFieldTypeString, alias: POINT4_1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT4_2 (type: esriFieldTypeString, alias: POINT4_2, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_1 (type: esriFieldTypeString, alias: POINT2_1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_2 (type: esriFieldTypeString, alias: POINT2_2, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_3 (type: esriFieldTypeString, alias: POINT2_3, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_4 (type: esriFieldTypeString, alias: POINT2_4, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_5 (type: esriFieldTypeString, alias: POINT2_5, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_6 (type: esriFieldTypeString, alias: POINT2_6, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_7 (type: esriFieldTypeString, alias: POINT2_7, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT2_8 (type: esriFieldTypeString, alias: POINT2_8, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_1 (type: esriFieldTypeString, alias: POINT1_1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_2 (type: esriFieldTypeString, alias: POINT1_2, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_3 (type: esriFieldTypeString, alias: POINT1_3, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_4 (type: esriFieldTypeString, alias: POINT1_4, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_5 (type: esriFieldTypeString, alias: POINT1_5, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_6 (type: esriFieldTypeString, alias: POINT1_6, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_7 (type: esriFieldTypeString, alias: POINT1_7, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• POINT1_8 (type: esriFieldTypeString, alias: POINT1_8, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• update_originator_id (type: esriFieldTypeInteger, alias: update_originator_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• update_timestamp (type: esriFieldTypeString, alias: update_timestamp, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• create_timestamp (type: esriFieldTypeString, alias: create_timestamp, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RECEIVED_FROM (type: esriFieldTypeString, alias: RECEIVED_FROM, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PHONE_FROM (type: esriFieldTypeString, alias: PHONE_FROM, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ADDRESS_FROM (type: esriFieldTypeString, alias: ADDRESS_FROM, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SUBJECT (type: esriFieldTypeString, alias: SUBJECT, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• DETAILS (type: esriFieldTypeString, alias: DETAILS, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• RECEIVED_BY (type: esriFieldTypeString, alias: RECEIVED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• NBO (type: esriFieldTypeString, alias: NBO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DEPT (type: esriFieldTypeString, alias: DEPT, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• REFERRED_TO (type: esriFieldTypeString, alias: REFERRED_TO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• insert_originator_id (type: esriFieldTypeInteger, alias: insert_originator_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LVL_CLASSIFICATION (type: esriFieldTypeString, alias: LVL_CLASSIFICATION, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CONFINE_INSPECT (type: esriFieldTypeDate, alias: CONFINE_INSPECT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PERMIT_STATUS (type: esriFieldTypeString, alias: PERMIT_STATUS, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• OWN_ID (type: esriFieldTypeString, alias: OWN_ID, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• OWN_ID_EXPIRES (type: esriFieldTypeDate, alias: OWN_ID_EXPIRES, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ANIMAL_LIC_NO (type: esriFieldTypeString, alias: ANIMAL_LIC_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ANIMAL_LIC_NO_EXPIRES (type: esriFieldTypeDate, alias: ANIMAL_LIC_NO_EXPIRES, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MICROCHIP_NO (type: esriFieldTypeString, alias: MICROCHIP_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SJACS_NO (type: esriFieldTypeString, alias: SJACS_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ADDITIONAL_CONDITIONS (type: esriFieldTypeString, alias: ADDITIONAL_CONDITIONS, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• MARKING_OFFICIER (type: esriFieldTypeString, alias: MARKING_OFFICIER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• TOW_COMPANY (type: esriFieldTypeString, alias: TOW_COMPANY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CROSS_STREET (type: esriFieldTypeString, alias: CROSS_STREET, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PR (type: esriFieldTypeString, alias: PR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• FN (type: esriFieldTypeString, alias: FN, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• others (type: esriFieldTypeString, alias: others, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/4/2026 10:30:38 PM

Schema Last Edit Date: 8/4/2026 10:30:38 PM

Data Last Edit Date: 8/4/2026 10:30:38 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat