Name: lien_notification_final_orders

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:

• b1_alt_id (type: esriFieldTypeString, alias: b1_alt_id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• b1_appl_status (type: esriFieldTypeString, alias: b1_appl_status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• final_order_state (type: esriFieldTypeString, alias: final_order_state, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• date_of_notification (type: esriFieldTypeDate, alias: date_of_notification, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• stno (type: esriFieldTypeInteger, alias: stno, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• predir (type: esriFieldTypeString, alias: predir, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• stname (type: esriFieldTypeString, alias: stname, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• suffix (type: esriFieldTypeString, alias: suffix, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• stsub (type: esriFieldTypeString, alias: stsub, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• fullname (type: esriFieldTypeString, alias: fullname, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• addr1 (type: esriFieldTypeString, alias: addr1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• addr2 (type: esriFieldTypeString, alias: addr2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: state, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: zip, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• inspector (type: esriFieldTypeString, alias: inspector, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• insp_result (type: esriFieldTypeString, alias: insp_result, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• insp_date (type: esriFieldTypeDate, alias: insp_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• insp_num (type: esriFieldTypeString, alias: insp_num, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• aca_deeplink (type: esriFieldTypeString, alias: aca_deeplink, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• hearing_added (type: esriFieldTypeDate, alias: hearing_added, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• hearing_scheduled (type: esriFieldTypeDate, alias: hearing_scheduled, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• hearing_completed (type: esriFieldTypeDate, alias: hearing_completed, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• hearing_result (type: esriFieldTypeString, alias: hearing_result, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• hearing_comments (type: esriFieldTypeString, alias: hearing_comments, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• final_citation_amount (type: esriFieldTypeDouble, alias: final_citation_amount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/4/2026 3:24:37 PM

Schema Last Edit Date: 1/4/2026 3:24:37 PM

Data Last Edit Date: 1/4/2026 3:24:34 PM

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