{ "currentVersion": 10.71, "id": 8, "name": "Supplement History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "SuplementDate", "type": "esriFieldTypeString", "alias": "Suplement Date", "length": 10, "domain": null }, { "name": "RollTypeDesc", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 106, "domain": null }, { "name": "SuplementTypeDesc", "type": "esriFieldTypeString", "alias": "Suplement Type", "length": 106, "domain": null }, { "name": "RevisedIND", "type": "esriFieldTypeString", "alias": "Revised IND", "length": 1, "domain": null }, { "name": "CorrectedDate", "type": "esriFieldTypeString", "alias": "Corrected Date", "length": 10, "domain": null }, { "name": "CorrectionCode", "type": "esriFieldTypeString", "alias": "Correction Code", "length": 4, "domain": null }, { "name": "SupplementYear", "type": "esriFieldTypeString", "alias": "Supplement Year", "length": 4, "domain": null }, { "name": "LegalStatus", "type": "esriFieldTypeString", "alias": "Legal Status", "length": 9, "domain": null }, { "name": "TRA", "type": "esriFieldTypeInteger", "alias": "TRA", "domain": null }, { "name": "BilliedOwner", "type": "esriFieldTypeString", "alias": "Billied Owner", "length": 72, "domain": null }, { "name": "JointOwner", "type": "esriFieldTypeString", "alias": "Joint Owner", "length": 72, "domain": null }, { "name": "NewLand", "type": "esriFieldTypeDouble", "alias": "New Land", "domain": null }, { "name": "NEwImprovement", "type": "esriFieldTypeDouble", "alias": "New Improvement", "domain": null }, { "name": "OldLand", "type": "esriFieldTypeDouble", "alias": "Old Land", "domain": null }, { "name": "OldImprovement", "type": "esriFieldTypeDouble", "alias": "Old Improvement", "domain": null }, { "name": "NewHox", "type": "esriFieldTypeDouble", "alias": "New Hox", "domain": null }, { "name": "OldHox", "type": "esriFieldTypeDouble", "alias": "Old Hox", "domain": null }, { "name": "SuppHox", "type": "esriFieldTypeDouble", "alias": "Supp Hox", "domain": null }, { "name": "SpecialExemptions", "type": "esriFieldTypeDouble", "alias": "Special Exemptions", "domain": null }, { "name": "ImproPenalty", "type": "esriFieldTypeDouble", "alias": "Improvements Penalty", "domain": null }, { "name": "PriorSupps", "type": "esriFieldTypeDouble", "alias": "Prior Supps", "domain": null }, { "name": "ConstinProgress", "type": "esriFieldTypeDouble", "alias": "Construction In Progress", "domain": null }, { "name": "PSUP_NET_VALUE", "type": "esriFieldTypeDouble", "alias": "Net Value", "domain": null }, { "name": "MonthsProrated", "type": "esriFieldTypeSmallInteger", "alias": "Months Prorated", "domain": null }, { "name": "NopicDate", "type": "esriFieldTypeString", "alias": "NOPIC Date", "length": 10, "domain": null }, { "name": "ExtractDate", "type": "esriFieldTypeString", "alias": "Extract Date", "length": 10, "domain": null }, { "name": "CorrStatus", "type": "esriFieldTypeString", "alias": "Corr Status", "length": 3, "domain": null }, { "name": "OriginalParcel", "type": "esriFieldTypeString", "alias": "Original Parcel", "length": 13, "domain": null }, { "name": "SpclExmTyp1", "type": "esriFieldTypeString", "alias": "Special Exemption Type 1", "length": 2, "domain": null }, { "name": "SpclExm1", "type": "esriFieldTypeDouble", "alias": "Special Exemption 1", "domain": null }, { "name": "SpclExmTyp2", "type": "esriFieldTypeString", "alias": "Special Exemption Type 2", "length": 2, "domain": null }, { "name": "SpclExm2", "type": "esriFieldTypeString", "alias": "Special Exemption 2", "length": 2, "domain": null }, { "name": "SupplementSortKey", "type": "esriFieldTypeDate", "alias": "Supplement Sort Key", "length": 8, "domain": null } ], "indexes": [ { "name": "R24_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }