{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "EPAS Findings", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Site_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Site_ID", "type": "esriFieldTypeString", "alias": "Site ID", "length": 25, "domain": null }, { "name": "Site_Name", "type": "esriFieldTypeString", "alias": "Site Name", "length": 50, "domain": null }, { "name": "State_Abbrev", "type": "esriFieldTypeString", "alias": "State", "length": 5, "domain": null }, { "name": "Project_Type", "type": "esriFieldTypeString", "alias": "Project Type", "length": 25, "domain": { "type": "codedValue", "name": "d_EPASProjType", "description": "EPAS Project Type", "codedValues": [ { "name": "External", "code": "EXTERNAL" }, { "name": "Internal", "code": "INTERNAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Previous_NOV", "type": "esriFieldTypeString", "alias": "Previous NOV", "length": 10, "domain": { "type": "codedValue", "name": "d_EPASYesNo", "description": "EPAS Yes No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Previous_Finding", "type": "esriFieldTypeString", "alias": "Previous Finding", "length": 10, "domain": { "type": "codedValue", "name": "d_EPASYesNo", "description": "EPAS Yes No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EPAS_Code", "type": "esriFieldTypeString", "alias": "EPAS Code", "length": 25, "domain": null }, { "name": "Root_Cause", "type": "esriFieldTypeString", "alias": "Root Cause", "length": 25, "domain": null }, { "name": "Justification", "type": "esriFieldTypeString", "alias": "Root Cause Justification", "length": 1024, "domain": null }, { "name": "ICAP_Status_Date", "type": "esriFieldTypeDate", "alias": "ICAP Status Date", "length": 8, "domain": null }, { "name": "Corrective_Actions", "type": "esriFieldTypeString", "alias": "Selected Corrective Actions", "length": 1024, "domain": null }, { "name": "Finding_ID", "type": "esriFieldTypeInteger", "alias": "Finding ID", "domain": null }, { "name": "ICAP_Status", "type": "esriFieldTypeString", "alias": "ICAP Status", "length": 50, "domain": null }, { "name": "Reference", "type": "esriFieldTypeString", "alias": "Reference", "length": 25, "domain": null }, { "name": "Protocol", "type": "esriFieldTypeString", "alias": "Protocol", "length": 50, "domain": { "type": "codedValue", "name": "d_EPASProtocol", "description": "EPAS Protocol", "codedValues": [ { "name": "AE - Air Emissions", "code": "Air Emissions" }, { "name": "CR - Cultural Resources", "code": "Cultural Resources" }, { "name": "HM - Hazardous Materials", "code": "Hazardous Materials" }, { "name": "HW - Hazardous Waste", "code": "Hazardous Waste" }, { "name": "NR - Natural Resources", "code": "Natural Resources" }, { "name": "01 - NEPA", "code": "NEPA" }, { "name": "02 - Environmental Noise", "code": "Environmental Noise" }, { "name": "03 - Cleanup", "code": "Cleanup" }, { "name": "04 - Pollution Prevention", "code": "Pollution Prevention" }, { "name": "05 - Program Management", "code": "Program Management" }, { "name": "06 - Waste Munitions", "code": "Waste Munitions" }, { "name": "07 - Environmental Management Systems (EMS)", "code": "Environmental Management Systems (EMS)" }, { "name": "PM - Pest Mgmt", "code": "Pest Mgmt" }, { "name": "PO - POL", "code": "POL" }, { "name": "SO - Solid Waste", "code": "Solid Waste" }, { "name": "ST - Storage Tank", "code": "Storage Tank" }, { "name": "T1 - PCB Mgmt", "code": "PCB Mgmt" }, { "name": "T2 - Asbestos Mgmt", "code": "Asbestos Mgmt" }, { "name": "T3 - Radon", "code": "Radon" }, { "name": "T4 - LBP Mgmt", "code": "LBP Mgmt" }, { "name": "WA - Wastewater", "code": "Wastewater" }, { "name": "WQ - Water Quality", "code": "Water Quality" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 200, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 200, "domain": null }, { "name": "Rating", "type": "esriFieldTypeString", "alias": "Rating", "length": 1, "domain": { "type": "codedValue", "name": "d_EPASRating", "description": "EPAS Rating", "codedValues": [ { "name": "High", "code": "H" }, { "name": "Medium", "code": "M" }, { "name": "Low", "code": "L" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Class", "length": 25, "domain": { "type": "codedValue", "name": "d_EPASClass", "description": "EPAS Class", "codedValues": [ { "name": "Class I", "code": "I" }, { "name": "Class II", "code": "II" }, { "name": "Class III", "code": "III" }, { "name": "MP", "code": "MP" }, { "name": "Positive", "code": "Positive" }, { "name": "S&H", "code": "S&H" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Details", "type": "esriFieldTypeString", "alias": "Details", "length": 1073741822, "domain": null }, { "name": "Requirements", "type": "esriFieldTypeString", "alias": "Requirements", "length": 1024, "domain": null }, { "name": "Citation", "type": "esriFieldTypeString", "alias": "Citation", "length": 1024, "domain": null }, { "name": "Responsibility", "type": "esriFieldTypeString", "alias": "Responsibility", "length": 100, "domain": null }, { "name": "ProtocolColor", "type": "esriFieldTypeString", "alias": "ProtocolColor", "length": 50, "domain": null } ], "indexes": [ { "name": "R454_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "47621319ecd444ddb405a60c87489683" }