Name: open_data_licence_application_history

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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:

• Record_ID (type: esriFieldTypeString, alias: Record_ID, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Application_Year (type: esriFieldTypeString, alias: Application_Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Application_Month (type: esriFieldTypeString, alias: Application_Month, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Application_Date (type: esriFieldTypeString, alias: Application_Date, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Premises_Address (type: esriFieldTypeString, alias: Premises_Address, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Application_Type (type: esriFieldTypeString, alias: Application_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Application_Description (type: esriFieldTypeString, alias: Application_Description, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Variation_Type (type: esriFieldTypeString, alias: Variation_Type, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• Variation_Description (type: esriFieldTypeString, alias: Variation_Description, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• Notes_Special (type: esriFieldTypeString, alias: Notes_Special, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• Applicant_Type (type: esriFieldTypeString, alias: Applicant_Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Applicant_Refused (type: esriFieldTypeString, alias: Applicant_Refused, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Applicant_Consent (type: esriFieldTypeString, alias: Applicant_Consent, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Alcohol_Sales (type: esriFieldTypeString, alias: Alcohol_Sales, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Current_Status (type: esriFieldTypeString, alias: Current_Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Licence_Board_Meeting (type: esriFieldTypeString, alias: Licence_Board_Meeting, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Decision (type: esriFieldTypeString, alias: Decision, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• Decision_Deadline (type: esriFieldTypeString, alias: Decision_Deadline, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Decision_Year (type: esriFieldTypeString, alias: Decision_Year, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Decision_Month (type: esriFieldTypeString, alias: Decision_Month, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Decision_Date (type: esriFieldTypeString, alias: Decision_Date, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Granted (type: esriFieldTypeString, alias: Granted, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• Date_Of_Effect (type: esriFieldTypeString, alias: Date_Of_Effect, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Conditions (type: esriFieldTypeString, alias: Conditions, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• Late_Conditions (type: esriFieldTypeString, alias: Late_Conditions, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Local_Conditions (type: esriFieldTypeString, alias: Local_Conditions, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Additional_Conditions (type: esriFieldTypeString, alias: Additional_Conditions, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/2/2025 3:45:24 PM

Schema Last Edit Date: 8/10/2024 12:25:28 AM

Data Last Edit Date: 3/2/2025 3:45:24 PM

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