{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Schedule", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "mhfd_geodb.dbo.routine_schedule.scheduled_start_date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "mhfd_geodb.dbo.routine_schedule.routine_schedule_id", "type": "esriFieldTypeOID", "alias": "routine_schedule_id", "domain": null }, { "name": "mhfd_geodb.dbo.routine_schedule.scheduled_start_date", "type": "esriFieldTypeDate", "alias": "scheduled_start_date", "length": 8, "domain": null }, { "name": "mhfd_geodb.dbo.routine_schedule.routine_id", "type": "esriFieldTypeInteger", "alias": "routine_id", "domain": null }, { "name": "mhfd_geodb.dbo.routine_schedule.is_debris", "type": "esriFieldTypeSmallInteger", "alias": "is_debris", "domain": null }, { "name": "mhfd_geodb.dbo.routine_schedule.is_vegetation", "type": "esriFieldTypeSmallInteger", "alias": "is_vegetation", "domain": null }, { "name": "mhfd_geodb.dbo.vw_routine_maintenance_spatial.contract", "type": "esriFieldTypeString", "alias": "contract", "length": 100, "domain": null }, { "name": "mhfd_geodb.dbo.vw_routine_maintenance_spatial.work_item_name", "type": "esriFieldTypeString", "alias": "work_item_name", "length": 255, "domain": null }, { "name": "mhfd_geodb.DBO.code_local_government.business_associates_id", "type": "esriFieldTypeInteger", "alias": "business_associates_id", "domain": null }, { "name": "mhfd_geodb.DBO.code_local_government.symbology_id", "type": "esriFieldTypeInteger", "alias": "symbology_id", "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.business_associates_id", "type": "esriFieldTypeInteger", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.business_associates_id", "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.business_associate_name", "type": "esriFieldTypeString", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.business_associate_name", "length": 255, "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.business_name", "type": "esriFieldTypeString", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.business_name", "length": 255, "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.primary_business_associate_contact_id", "type": "esriFieldTypeInteger", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.primary_business_associate_contact_id", "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.ba_tyler_id", "type": "esriFieldTypeString", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.ba_tyler_id", "length": 50, "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.code_business_associates_type_id", "type": "esriFieldTypeInteger", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.code_business_associates_type_id", "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.created_date", "type": "esriFieldTypeDate", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.created_date", "length": 8, "precision": 1, "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.modified_date", "type": "esriFieldTypeDate", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.modified_date", "length": 8, "precision": 1, "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.last_modified_by", "type": "esriFieldTypeString", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.last_modified_by", "length": 50, "domain": null }, { "name": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.created_by", "type": "esriFieldTypeString", "alias": "mhfd_geodb.SVC_PRPUBUSER.%business_associates.created_by", "length": 50, "domain": null }, { "name": "mhfd_geodb.DBO.code_state_county.code_budget_area_id", "type": "esriFieldTypeInteger", "alias": "code_budget_area_id", "domain": null }, { "name": "mhfd_geodb.DBO.code_state_county.construction_manager", "type": "esriFieldTypeString", "alias": "mhfd_construction_manager", "length": 100, "domain": null }, { "name": "mhfd_geodb.DBO.code_state_county.program_manager", "type": "esriFieldTypeString", "alias": "mhfd_program_manager", "length": 100, "domain": null } ], "indexes": [ { "name": "PK_routine_schedule", "fields": "mhfd_geodb.dbo.routine_schedule.routine_schedule_id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_Unique_business_associates_business_associate_name", "fields": "business_associate_name", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "62a841d95416475ba8af43de20691ae8" }