Name: License_Main
Display Field: OWNER_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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- BALANCE_DUE (type: esriFieldTypeDouble, alias: BALANCE_DUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CHECKBOX1 (type: esriFieldTypeString, alias: CHECKBOX1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX2 (type: esriFieldTypeString, alias: CHECKBOX2, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX3 (type: esriFieldTypeString, alias: CHECKBOX3, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX4 (type: esriFieldTypeString, alias: CHECKBOX4, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX5 (type: esriFieldTypeString, alias: CHECKBOX5, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX6 (type: esriFieldTypeString, alias: CHECKBOX6, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX7 (type: esriFieldTypeString, alias: CHECKBOX7, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- CHECKBOX8 (type: esriFieldTypeString, alias: CHECKBOX8, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- COMPANY (type: esriFieldTypeString, alias: COMPANY, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- COMPANY_PRINT_AS (type: esriFieldTypeString, alias: COMPANY_PRINT_AS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- DEFAULT_INSPECTOR (type: esriFieldTypeString, alias: DEFAULT_INSPECTOR, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- DEPOSITTYPE (type: esriFieldTypeString, alias: DEPOSITTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- EMAIL (type: esriFieldTypeString, alias: EMAIL, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- EMERGENCY (type: esriFieldTypeString, alias: EMERGENCY, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- APPLIED (type: esriFieldTypeDate, alias: APPLIED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- APPLIED_BY (type: esriFieldTypeString, alias: APPLIED_BY, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- EXPIRED (type: esriFieldTypeDate, alias: EXPIRED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- EXPIRED_BY (type: esriFieldTypeString, alias: EXPIRED_BY, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- FAX (type: esriFieldTypeString, alias: FAX, SQL Type: sqlTypeOther, length: 15, 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)
- HISTORICAL_APN (type: esriFieldTypeString, alias: HISTORICAL_APN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ISSUED (type: esriFieldTypeDate, alias: ISSUED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ISSUED_BY (type: esriFieldTypeString, alias: ISSUED_BY, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- LIAB_CARRIER (type: esriFieldTypeString, alias: LIAB_CARRIER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LIAB_EXP (type: esriFieldTypeDate, alias: LIAB_EXP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LIAB_ISS (type: esriFieldTypeDate, alias: LIAB_ISS, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LIAB_NO (type: esriFieldTypeString, alias: LIAB_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LICENSE_NO (type: esriFieldTypeString, alias: LICENSE_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LICENSE_SUBTYPE (type: esriFieldTypeString, alias: LICENSE_SUBTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- LICENSE_TYPE (type: esriFieldTypeString, alias: LICENSE_TYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- LOC_RECORDID (type: esriFieldTypeString, alias: LOC_RECORDID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LOCKID (type: esriFieldTypeString, alias: LOCKID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- MAIL_ADDRESS1 (type: esriFieldTypeString, alias: MAIL_ADDRESS1, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- MAIL_ADDRESS2 (type: esriFieldTypeString, alias: MAIL_ADDRESS2, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- MAIL_CITY (type: esriFieldTypeString, alias: MAIL_CITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- MAIL_STATE (type: esriFieldTypeString, alias: MAIL_STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- MAIL_ZIP (type: esriFieldTypeString, alias: MAIL_ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MAINTEXTFIELD1 (type: esriFieldTypeString, alias: MAINTEXTFIELD1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD2 (type: esriFieldTypeString, alias: MAINTEXTFIELD2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD3 (type: esriFieldTypeString, alias: MAINTEXTFIELD3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD4 (type: esriFieldTypeString, alias: MAINTEXTFIELD4, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD5 (type: esriFieldTypeString, alias: MAINTEXTFIELD5, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD6 (type: esriFieldTypeString, alias: MAINTEXTFIELD6, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD7 (type: esriFieldTypeString, alias: MAINTEXTFIELD7, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MAINTEXTFIELD8 (type: esriFieldTypeString, alias: MAINTEXTFIELD8, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- OWNER_NAME (type: esriFieldTypeString, alias: OWNER_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- PARENT_RECORDID (type: esriFieldTypeString, alias: PARENT_RECORDID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- PHONE (type: esriFieldTypeString, alias: PHONE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- RECORDID (type: esriFieldTypeString, alias: RECORDID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- REFERENCE_NO (type: esriFieldTypeString, alias: REFERENCE_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SEQ_NO (type: esriFieldTypeDouble, alias: SEQ_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SIC_2 (type: esriFieldTypeString, alias: SIC_2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- SIC_3 (type: esriFieldTypeString, alias: SIC_3, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- SITE_ALTERNATE_ID (type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- SITE_APN (type: esriFieldTypeString, alias: SITE_APN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SITE_BLOCK (type: esriFieldTypeString, alias: SITE_BLOCK, 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_DESCRIPTION (type: esriFieldTypeString, alias: SITE_DESCRIPTION, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- SITE_GEOTYPE (type: esriFieldTypeString, alias: SITE_GEOTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- SITE_LOT_NO (type: esriFieldTypeString, alias: SITE_LOT_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SITE_NUMBER (type: esriFieldTypeString, alias: SITE_NUMBER, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- SITE_STATE (type: esriFieldTypeString, alias: SITE_STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- SITE_STREETID (type: esriFieldTypeInteger, alias: SITE_STREETID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SITE_STREETNAME (type: esriFieldTypeString, alias: SITE_STREETNAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- SITE_SUBDIVISION (type: esriFieldTypeString, alias: SITE_SUBDIVISION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- SITE_TRACT (type: esriFieldTypeString, alias: SITE_TRACT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SITE_UNIT_NO (type: esriFieldTypeString, alias: SITE_UNIT_NO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- SITE_ZIP (type: esriFieldTypeString, alias: SITE_ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ST_LIC_EXP (type: esriFieldTypeDate, alias: ST_LIC_EXP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ST_LIC_ISS (type: esriFieldTypeDate, alias: ST_LIC_ISS, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- STATUS_BY (type: esriFieldTypeString, alias: STATUS_BY, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- TAG (type: esriFieldTypeString, alias: TAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- TEXTFIELD1 (type: esriFieldTypeString, alias: TEXTFIELD1, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD2 (type: esriFieldTypeString, alias: TEXTFIELD2, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD3 (type: esriFieldTypeString, alias: TEXTFIELD3, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD4 (type: esriFieldTypeString, alias: TEXTFIELD4, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD5 (type: esriFieldTypeString, alias: TEXTFIELD5, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD6 (type: esriFieldTypeString, alias: TEXTFIELD6, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD7 (type: esriFieldTypeString, alias: TEXTFIELD7, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- TEXTFIELD8 (type: esriFieldTypeString, alias: TEXTFIELD8, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- W_COMP_EXP (type: esriFieldTypeDate, alias: W_COMP_EXP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- W_COMP_ISS (type: esriFieldTypeDate, alias: W_COMP_ISS, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- W_COMP_NO (type: esriFieldTypeString, alias: W_COMP_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- WRKR_COMP (type: esriFieldTypeString, alias: WRKR_COMP, SQL Type: sqlTypeOther, length: 26, nullable: true, editable: true)
- YRMO (type: esriFieldTypeDouble, alias: YRMO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SITE_ADDR (type: esriFieldTypeString, alias: SITE_ADDR, SQL Type: sqlTypeOther, length: 85, nullable: true, editable: true)
- OWNERSHIP_TYPE (type: esriFieldTypeString, alias: OWNERSHIP_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- RESALE_ID (type: esriFieldTypeString, alias: RESALE_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SIC_1 (type: esriFieldTypeString, alias: SIC_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- INVOICE_DATE (type: esriFieldTypeDate, alias: INVOICE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- PHONE_EXT (type: esriFieldTypeString, alias: PHONE_EXT, SQL Type: sqlTypeOther, length: 5, 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)
- TAX_ID (type: esriFieldTypeBlob, alias: TAX_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Unique_Key (type: esriFieldTypeGUID, alias: Unique_Key, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
Templates:
Name: License_Main
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/5/2022 3:31:57 PM
Schema Last Edit Date: 10/5/2022 3:31:57 PM
Data Last Edit Date: 10/5/2022 3:31:57 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat