{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Tap Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CustName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": { "type": "codedValue", "name": "PropType", "description": "Property Type", "codedValues": [ { "name": "Residential", "code": "Residential" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Rental", "code": "Rental" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CustName", "type": "esriFieldTypeString", "alias": "Customer Name", "length": 100, "domain": null }, { "name": "AccountNum", "type": "esriFieldTypeString", "alias": "Account #", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 50, "domain": null }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "length": 100, "domain": null }, { "name": "ConName", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 50, "domain": null }, { "name": "InsuranceNum", "type": "esriFieldTypeString", "alias": "Insurance #", "length": 50, "domain": null }, { "name": "ContName", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 100, "domain": null }, { "name": "CAddress", "type": "esriFieldTypeString", "alias": "Contractor Address", "length": 50, "domain": null }, { "name": "ConPhone", "type": "esriFieldTypeString", "alias": "Contractor Phone", "length": 50, "domain": null }, { "name": "ConEmail", "type": "esriFieldTypeString", "alias": "Contractor Email", "length": 50, "domain": null }, { "name": "TapLoc", "type": "esriFieldTypeString", "alias": "Tap Location", "length": 50, "domain": { "type": "codedValue", "name": "Direction", "description": "Direction", "codedValues": [ { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "East", "code": "East" }, { "name": "West", "code": "West" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Foundation", "type": "esriFieldTypeString", "alias": "Foundation", "length": 50, "domain": { "type": "codedValue", "name": "Foundation", "description": "Foundation", "codedValues": [ { "name": "Basement", "code": "Basement" }, { "name": "Crawl Space", "code": "Crawl Space" }, { "name": "Slab", "code": "Slab" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleanout", "type": "esriFieldTypeString", "alias": "Gravity?Clean out#", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Grinder", "type": "esriFieldTypeString", "alias": "Grinder", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BackwaterV", "type": "esriFieldTypeString", "alias": "Backwater Valve", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SumpPump", "type": "esriFieldTypeString", "alias": "Sump Pump", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SumpPumpL", "type": "esriFieldTypeString", "alias": "Sump Pump Discharge Locaiton", "length": 300, "domain": null }, { "name": "Downspouts", "type": "esriFieldTypeString", "alias": "Down Spouts", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Tile", "type": "esriFieldTypeString", "alias": "Tile", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Ground", "type": "esriFieldTypeString", "alias": "Ground", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SizeofPipe", "type": "esriFieldTypeString", "alias": "Size of Pipe", "length": 50, "domain": null }, { "name": "TypeofPipe", "type": "esriFieldTypeString", "alias": "Type of Pipe", "length": 50, "domain": null }, { "name": "PumpedOCS", "type": "esriFieldTypeString", "alias": "Pumped out and clean of solids", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TopCrushed", "type": "esriFieldTypeString", "alias": "Top Crushed", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Filled", "type": "esriFieldTypeString", "alias": "Filled with approved backfill", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TankRemoved", "type": "esriFieldTypeString", "alias": "Tank Removed", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DissFAF", "type": "esriFieldTypeString", "alias": "Disconnected from absorption field", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DissElec", "type": "esriFieldTypeString", "alias": "Disconnect Electric", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SeptageHaul", "type": "esriFieldTypeString", "alias": "Septage Hauler", "length": 50, "domain": null }, { "name": "Septnum", "type": "esriFieldTypeString", "alias": "Septage Hauler #", "length": 50, "domain": null }, { "name": "NGPU", "type": "esriFieldTypeString", "alias": "New Grinder Pump Unit/Pump #", "length": 50, "domain": null }, { "name": "ICT4ILC", "type": "esriFieldTypeString", "alias": "Inspect Connection to 4_ Influent Line or Cleanout", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBVODLIGU", "type": "esriFieldTypeString", "alias": "Open Ball Valve on Discharge Line Inside Grinder Unit", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TOBAGP", "type": "esriFieldTypeString", "alias": "Turn on breaker at grinder pump unit junction box, and check that power is on at breaker at meter at power pole.", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateIns", "type": "esriFieldTypeDate", "alias": "Date Inpsected", "length": 8, "domain": null }, { "name": "Reinspection", "type": "esriFieldTypeString", "alias": "Reinspection", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Reconnect", "type": "esriFieldTypeString", "alias": "Reconnect", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "TapFee", "type": "esriFieldTypeString", "alias": "Tape Fee Paid", "length": 50, "domain": null }, { "name": "DatePaid", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "Check_", "type": "esriFieldTypeString", "alias": "Check #", "length": 50, "domain": null }, { "name": "Cash", "type": "esriFieldTypeString", "alias": "Cash", "length": 50, "domain": null } ], "indexes": [ { "name": "R17_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G16AccountNum", "fields": "AccountNum", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ServicedParcels", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "AccountNum", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }