{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 8, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_Number", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 30, "domain": { "type": "codedValue", "name": "dContractor", "description": "", "codedValues": [ { "name": "J. Fletcher Creamer & Son, Inc", "code": "J. Fletcher Creamer & Son, Inc" }, { "name": "Civil Construction LLC", "code": "Civil Construction LLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "length": 50, "domain": { "type": "codedValue", "name": "dInspectors", "description": "", "codedValues": [ { "name": "Ashley Galloway", "code": "Ashley Galloway" }, { "name": "Luke Mulry", "code": "Luke Mulry" }, { "name": "Clarence Wayman", "code": "Clarence Wayman" }, { "name": "David Wiley", "code": "David Wiley" }, { "name": "Hernan Guadalupe", "code": "Hernan Guadalupe" }, { "name": "Utieyin Edema-Eyen", "code": "Utieyin Edema-Eyen" }, { "name": "Amin Alizad", "code": "Amin Alizad" }, { "name": "Amir Fayaz", "code": "Amir Fayaz" }, { "name": "Brian Brophy", "code": "Brian Brophy" }, { "name": "Fitzroy French", "code": "Fitzroy French" }, { "name": "Kia Saunders", "code": "Kia Saunders" }, { "name": "John Foster", "code": "John Foster" }, { "name": "Micheal Rebert", "code": "Micheal Rebert" }, { "name": "Prakash Shahi", "code": "Prakash Shahi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "Service_Work_Act", "type": "esriFieldTypeString", "alias": "Service_Work_Act", "length": 50, "domain": { "type": "codedValue", "name": "dService_Work_Activity", "description": "", "codedValues": [ { "name": "Renew Water Service", "code": "Renew Water Service" }, { "name": "New Water Service", "code": "New Water Service" }, { "name": "Replace Existing Water Service", "code": "Replace Existing Water Service" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pipe_Size_Same", "type": "esriFieldTypeString", "alias": "Pipe_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Pipe_Size", "type": "esriFieldTypeDouble", "alias": "New_Pipe_Size", "domain": { "type": "codedValue", "name": "WA_VVT_WSP_Pipe_Size", "description": "", "codedValues": [ { "name": ".63\"", "code": 0.63 }, { "name": ".75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.25\"", "code": 1.25 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Material_Same", "type": "esriFieldTypeString", "alias": "Material_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Material", "type": "esriFieldTypeString", "alias": "New_Material", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WSP_Material", "description": "", "codedValues": [ { "name": "Cast Iron", "code": "CI" }, { "name": "Copper", "code": "COP" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Galvanized", "code": "GLV" }, { "name": "Polyethylene", "code": "PE" }, { "name": "PVC", "code": "PVC" }, { "name": "Steel", "code": "ST" }, { "name": "Unknown", "code": "UNK" }, { "name": "Lead", "code": "LD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Length_Same", "type": "esriFieldTypeString", "alias": "Length_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Length", "type": "esriFieldTypeDouble", "alias": "New_Length", "domain": null }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Service_Work_Act1", "type": "esriFieldTypeString", "alias": "Service_Work_Act1", "length": 50, "domain": { "type": "codedValue", "name": "dService_Work_Activity", "description": "", "codedValues": [ { "name": "Renew Water Service", "code": "Renew Water Service" }, { "name": "New Water Service", "code": "New Water Service" }, { "name": "Replace Existing Water Service", "code": "Replace Existing Water Service" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "length": 20, "domain": { "type": "codedValue", "name": "dDiscrepancyType", "description": "", "codedValues": [ { "name": "Attribute", "code": "Attribute" }, { "name": "Geometry", "code": "Geometry" }, { "name": "Other (see comments)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "length": 20, "domain": { "type": "codedValue", "name": "dWorkActivityStatus", "description": "", "codedValues": [ { "name": "Not Complete/In Progress", "code": "Not Complete" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "length": 150, "domain": null }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelGlobalID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R33_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G81RelObjectID", "fields": "RelObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G81Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "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 } }