{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "OneYearWarrantiesRT", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ProjectName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RelatedGlobalID", "type": "esriFieldTypeGUID", "alias": "RelatedGlobalID", "length": 38, "domain": null }, { "name": "DateOfOneYearInspection", "type": "esriFieldTypeDate", "alias": "Date Of One Year Warranty Review", "length": 8, "domain": null }, { "name": "NotesConcerns", "type": "esriFieldTypeString", "alias": "Notes & Concerns", "length": 1000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "length": 254, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Deficiency1", "type": "esriFieldTypeString", "alias": "Deficiency 1", "length": 500, "domain": null }, { "name": "Deficiency2", "type": "esriFieldTypeString", "alias": "Deficiency 2", "length": 500, "domain": null }, { "name": "Deficiency3", "type": "esriFieldTypeString", "alias": "Deficiency 3", "length": 500, "domain": null }, { "name": "Deficiency4", "type": "esriFieldTypeString", "alias": "Deficiency 4", "length": 500, "domain": null }, { "name": "Deficiency5", "type": "esriFieldTypeString", "alias": "Deficiency 5", "length": 500, "domain": null }, { "name": "Deficiency6", "type": "esriFieldTypeString", "alias": "Deficiency 6", "length": 500, "domain": null }, { "name": "Deficiency7", "type": "esriFieldTypeString", "alias": "Deficiency 7", "length": 500, "domain": null }, { "name": "Deficiency8", "type": "esriFieldTypeString", "alias": "Deficiency 8", "length": 500, "domain": null }, { "name": "Deficiency9", "type": "esriFieldTypeString", "alias": "Deficiency 9", "length": 500, "domain": null }, { "name": "Deficiency10", "type": "esriFieldTypeString", "alias": "Deficiency 10", "length": 500, "domain": null }, { "name": "Deficiency11", "type": "esriFieldTypeString", "alias": "Deficiency 11", "length": 500, "domain": null }, { "name": "Deficiency12", "type": "esriFieldTypeString", "alias": "Deficiency 12", "length": 500, "domain": null }, { "name": "Deficiency13", "type": "esriFieldTypeString", "alias": "Deficiency 13", "length": 500, "domain": null }, { "name": "Deficiency14", "type": "esriFieldTypeString", "alias": "Deficiency 14", "length": 500, "domain": null }, { "name": "Deficiency15", "type": "esriFieldTypeString", "alias": "Deficiency 15", "length": 500, "domain": null }, { "name": "Deficiency16", "type": "esriFieldTypeString", "alias": "Deficiency 16", "length": 500, "domain": null }, { "name": "Deficiency17", "type": "esriFieldTypeString", "alias": "Deficiency 17", "length": 500, "domain": null }, { "name": "Deficiency18", "type": "esriFieldTypeString", "alias": "Deficiency 18", "length": 500, "domain": null }, { "name": "Deficiency19", "type": "esriFieldTypeString", "alias": "Deficiency 19", "length": 500, "domain": null }, { "name": "Deficiency20", "type": "esriFieldTypeString", "alias": "Deficiency 20", "length": 500, "domain": null }, { "name": "Deficiency21", "type": "esriFieldTypeString", "alias": "Deficiency 21", "length": 500, "domain": null }, { "name": "Deficiency22", "type": "esriFieldTypeString", "alias": "Deficiency 22", "length": 500, "domain": null }, { "name": "Deficiency23", "type": "esriFieldTypeString", "alias": "Deficiency 23", "length": 500, "domain": null }, { "name": "Deficiency24", "type": "esriFieldTypeString", "alias": "Deficiency 24", "length": 500, "domain": null }, { "name": "Deficiency25", "type": "esriFieldTypeString", "alias": "Deficiency 25", "length": 500, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector\n", "length": 255, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor\n", "length": 255, "domain": null }, { "name": "ContractorPhone", "type": "esriFieldTypeString", "alias": "Contractor Phone\n", "length": 255, "domain": null }, { "name": "ContractorEmail", "type": "esriFieldTypeString", "alias": "Contractor Email", "length": 255, "domain": null }, { "name": "ImperviousArea", "type": "esriFieldTypeDouble", "alias": "Impervious Area", "domain": null }, { "name": "ContractorEmail2", "type": "esriFieldTypeString", "alias": "Contractor Email 2", "length": 255, "domain": null }, { "name": "ContractorEmail3", "type": "esriFieldTypeString", "alias": "Contractor Email 3", "length": 255, "domain": null }, { "name": "ContractorEmail4", "type": "esriFieldTypeString", "alias": "Contractor Email 4", "length": 255, "domain": null }, { "name": "ContractorEmail5", "type": "esriFieldTypeString", "alias": "Contractor Email 5", "length": 255, "domain": null }, { "name": "FinalInspectionDateApproved", "type": "esriFieldTypeDate", "alias": "Date Project Entered into One Year Warranty", "length": 8, "domain": null }, { "name": "LogType", "type": "esriFieldTypeString", "alias": "LogType", "length": 255, "domain": { "type": "codedValue", "name": "DailyLogType", "description": "Daily Inspection Log Type of Feature Class", "codedValues": [ { "name": "Development Poly", "code": "Development Poly" }, { "name": "Development Line", "code": "Development Line" }, { "name": "City Poly", "code": "City Poly" }, { "name": "City Line", "code": "City Line" }, { "name": "Excavation Permit", "code": "Excavation Permit" }, { "name": "Precon Meeting", "code": "Precon Meeting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WarrantyApprovedDate", "type": "esriFieldTypeDate", "alias": "One Year Warranty Date of Approval", "length": 8, "domain": null }, { "name": "WarrantyApproval", "type": "esriFieldTypeString", "alias": "One Year Warranty Approved?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff1", "type": "esriFieldTypeString", "alias": "Sign Off 1?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff2", "type": "esriFieldTypeString", "alias": "Sign Off 2?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff3", "type": "esriFieldTypeString", "alias": "Sign Off 3?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff4", "type": "esriFieldTypeString", "alias": "Sign Off 4?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff5", "type": "esriFieldTypeString", "alias": "Sign Off 5?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff6", "type": "esriFieldTypeString", "alias": "Sign Off 6?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff7", "type": "esriFieldTypeString", "alias": "Sign Off 7?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff8", "type": "esriFieldTypeString", "alias": "Sign Off 8?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff9", "type": "esriFieldTypeString", "alias": "Sign Off 9?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff10", "type": "esriFieldTypeString", "alias": "Sign Off 10?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff11", "type": "esriFieldTypeString", "alias": "Sign Off 11?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff12", "type": "esriFieldTypeString", "alias": "Sign Off 12?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff13", "type": "esriFieldTypeString", "alias": "Sign Off 13?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff14", "type": "esriFieldTypeString", "alias": "Sign Off 14?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff15", "type": "esriFieldTypeString", "alias": "Sign Off 15?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff16", "type": "esriFieldTypeString", "alias": "Sign Off 16?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff17", "type": "esriFieldTypeString", "alias": "Sign Off 17?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff18", "type": "esriFieldTypeString", "alias": "Sign Off 18?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff19", "type": "esriFieldTypeString", "alias": "Sign Off 19?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff20", "type": "esriFieldTypeString", "alias": "Sign Off 20?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff21", "type": "esriFieldTypeString", "alias": "Sign Off 21?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff22", "type": "esriFieldTypeString", "alias": "Sign Off 22?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff23", "type": "esriFieldTypeString", "alias": "Sign Off 23?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff24", "type": "esriFieldTypeString", "alias": "Sign Off 24?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SignOff25", "type": "esriFieldTypeString", "alias": "Sign Off 25?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SecretaryEmail", "type": "esriFieldTypeString", "alias": "Secretary Email", "length": 100, "domain": { "type": "codedValue", "name": "SecretaryEmails", "description": "Email list for all Engineering Secretaries", "codedValues": [ { "name": "jfinch@spanishfork.org", "code": "jfinch@spanishfork.org" }, { "name": "marciec@spanishfork.org", "code": "marciec@spanishfork.org" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } } ], "indexes": [ { "name": "UUID_32", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G50RelatedGlobal", "fields": "RelatedGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R32_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.DevelopmentProjectLines", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelatedGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4FCD2D29-8E29-4B81-84AE-D55E4AD5A539}" }, { "id": 11, "name": "DBO.CityProjectLines", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "RelatedGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{46B0ECC3-0F70-4C98-8E83-B0161D6B1C91}" }, { "id": 0, "name": "DBO.ExcavationPermits", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "RelatedGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{819869A8-8759-42EF-95E4-2C35BEB0DAFA}" }, { "id": 19, "name": "DBO.CityProjectPolygons", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "RelatedGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{45A58E2F-00E1-461E-800A-BA33C684F4FE}" }, { "id": 15, "name": "DBO.DevelopmentProjectPolygons", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "RelatedGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0E51715E-7F87-46ED-8CD5-EF8FF4095815}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1661849395000 }, "serviceItemId": "8e8eff8d62f54fe0a360187e229d7033" }