{ "currentVersion": 10.91, "id": 1, "name": "Related Records Table - Variances", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FULL_ADDRESS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCEL_ID", "type": "esriFieldTypeDouble", "alias": "Parcel Number", "domain": null }, { "name": "FULL_ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 254, "domain": null }, { "name": "ZONING", "type": "esriFieldTypeString", "alias": "Zoning", "length": 254, "domain": null }, { "name": "PLAN_REVIEW_TYPE", "type": "esriFieldTypeString", "alias": "Property Use", "length": 254, "domain": null }, { "name": "VARIANCE_TYPE", "type": "esriFieldTypeString", "alias": "Variance Type", "length": 254, "domain": null }, { "name": "DESCRIPTION_OF_WORK", "type": "esriFieldTypeString", "alias": "Description of Work", "length": 254, "domain": null }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "Case Number", "length": 254, "domain": null }, { "name": "ISSUED_DATE", "type": "esriFieldTypeDate", "alias": "Issued Date", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 254, "domain": null }, { "name": "CONDITIONS", "type": "esriFieldTypeString", "alias": "Number of Conditions", "length": 50, "domain": null }, { "name": "Cond_Find", "type": "esriFieldTypeString", "alias": "Conditional Findings", "length": 254, "domain": null }, { "name": "CONDITION_1", "type": "esriFieldTypeString", "alias": "CONDITION 1", "length": 254, "domain": null }, { "name": "CONDITION_2", "type": "esriFieldTypeString", "alias": "CONDITION 2", "length": 254, "domain": null }, { "name": "CONDITION_3", "type": "esriFieldTypeString", "alias": "CONDITION 3", "length": 254, "domain": null }, { "name": "CONDITION_4", "type": "esriFieldTypeString", "alias": "CONDITION 4", "length": 254, "domain": null }, { "name": "CONDITION_5", "type": "esriFieldTypeString", "alias": "CONDITION 5", "length": 254, "domain": null }, { "name": "EXPIRATION_DATE", "type": "esriFieldTypeString", "alias": "Expiration Date", "length": 254, "domain": null }, { "name": "Year_Built", "type": "esriFieldTypeString", "alias": "Year Built", "length": 50, "domain": null }, { "name": "Year_Annex", "type": "esriFieldTypeString", "alias": "Year Annexed", "length": 50, "domain": null }, { "name": "Staff_Rec", "type": "esriFieldTypeString", "alias": "Staff Recommendation", "length": 254, "domain": null }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "length": 50, "domain": null } ], "indexes": [ { "name": "R228_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G615PARCEL_ID", "fields": "PARCEL_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "VariancestoAddressPoints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARCEL_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }