{ "currentVersion": 10.61, "id": 59, "name": "TB_WRF_LabEquipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Location", "length": 130, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location Details", "length": 256, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "gStatus", "description": "Lifecycle Status", "codedValues": [ { "name": "Permitted", "code": "Permitted" }, { "name": "In Service", "code": "In Service" }, { "name": "Not In Service", "code": "Not In Service" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProcessArea", "type": "esriFieldTypeString", "alias": "Process Area", "length": 3, "domain": { "type": "codedValue", "name": "gProcessArea_3", "description": "Process Area", "codedValues": [ { "name": "M00", "code": "M00" }, { "name": "M01", "code": "M01" }, { "name": "M02", "code": "M02" }, { "name": "M03", "code": "M03" }, { "name": "M04", "code": "M04" }, { "name": "M05", "code": "M05" }, { "name": "M06", "code": "M06" }, { "name": "M07", "code": "M07" }, { "name": "M08", "code": "M08" }, { "name": "M09", "code": "M09" }, { "name": "M10", "code": "M10" }, { "name": "M11", "code": "M11" }, { "name": "M12", "code": "M12" }, { "name": "M13", "code": "M13" }, { "name": "M14", "code": "M14" }, { "name": "M16", "code": "M16" }, { "name": "M17", "code": "M17" }, { "name": "M18", "code": "M18" }, { "name": "M19", "code": "M19" }, { "name": "M21", "code": "M21" }, { "name": "M22", "code": "M22" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Process", "type": "esriFieldTypeString", "alias": "Process", "length": 100, "domain": { "type": "codedValue", "name": "gProcess_3", "description": "Process", "codedValues": [ { "name": "M00 Preaeration Basins Odor Control", "code": "M00 Preaeration Basins Odor Control" }, { "name": "M01 Equalization Basins", "code": "M01 Equalization Basins" }, { "name": "M01 Fuel Unloading", "code": "M01 Fuel Unloading" }, { "name": "M01 Pretreatment", "code": "M01 Pretreatment" }, { "name": "M02 Primary Pump Station Primary Clarifiers 1 through 5", "code": "M02 Primary Pump Station Primary Clarifiers 1 through 5" }, { "name": "M03 Blower Building Aeration Basins", "code": "M03 Blower Building Aeration Basins" }, { "name": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2", "code": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2" }, { "name": "M05 Denitrification Filters 1 through 24", "code": "M05 Denitrification Filters 1 through 24" }, { "name": "M06 Administration Building Old", "code": "M06 Administration Building Old" }, { "name": "M07 Generator and Electrical Distribution", "code": "M07 Generator and Electrical Distribution" }, { "name": "M08 Lime Handling Lime Tower", "code": "M08 Lime Handling Lime Tower" }, { "name": "M09 Control and Process Building", "code": "M09 Control and Process Building" }, { "name": "M10 Plant Wastewater Pump Station", "code": "M10 Plant Wastewater Pump Station" }, { "name": "M11 Grubbs Admin and Lab", "code": "M11 Grubbs Admin and Lab" }, { "name": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1", "code": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1" }, { "name": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2", "code": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2" }, { "name": "M13 Outside of Process Areas", "code": "M13 Outside of Process Areas" }, { "name": "M14 Operations Support Facility Maintenance", "code": "M14 Operations Support Facility Maintenance" }, { "name": "M16 Incinerator", "code": "M16 Incinerator" }, { "name": "M17 Dewatering Equipment Solids Building", "code": "M17 Dewatering Equipment Solids Building" }, { "name": "M18 Sludge Holding Tanks 1 and 4", "code": "M18 Sludge Holding Tanks 1 and 4" }, { "name": "M19 Ash Settling Basins Ash Cover", "code": "M19 Ash Settling Basins Ash Cover" }, { "name": "M21 Methanol Building", "code": "M21 Methanol Building" }, { "name": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade", "code": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProjectNum", "type": "esriFieldTypeString", "alias": "Project Number", "length": 30, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 256, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 25, "domain": null }, { "name": "AssetCost", "type": "esriFieldTypeDouble", "alias": "Asset Cost", "domain": null }, { "name": "ReplaceCost", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "RehabDate", "type": "esriFieldTypeDate", "alias": "Last Rehab Date", "length": 8, "domain": null }, { "name": "LifeExpectancy", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy in Yrs", "domain": null }, { "name": "RemUseLife", "type": "esriFieldTypeSmallInteger", "alias": "Remaining Useful Life in Yrs", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 25, "domain": null }, { "name": "ModelYear", "type": "esriFieldTypeSmallInteger", "alias": "Model Year", "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 25, "domain": null }, { "name": "LabEquipType", "type": "esriFieldTypeString", "alias": "Lab Equipment Type", "length": 54, "domain": { "type": "codedValue", "name": "gLabEquipType", "description": "Lab Equipment Type", "codedValues": [ { "name": "50ml Heat Block", "code": "50ml Heat Block" }, { "name": "50ml Heat Block Touch Screen", "code": "50ml Heat Block Touch Screen" }, { "name": "ATP Meter", "code": "ATP Meter" }, { "name": "Autoclave", "code": "Autoclave" }, { "name": "AutoSampler", "code": "AutoSampler" }, { "name": "Balance", "code": "Balance" }, { "name": "Block Digester", "code": "Block Digester" }, { "name": "CEM", "code": "CEM" }, { "name": "Centrifuge", "code": "Centrifuge" }, { "name": "CFM_CMM Thermo Anemometer plus InfraRed Thermometer", "code": "CFM_CMM Thermo Anemometer plus InfraRed Thermometer" }, { "name": "COD Reactor", "code": "COD Reactor" }, { "name": "Colony Counter", "code": "Colony Counter" }, { "name": "Conductivity Meter", "code": "Conductivity Meter" }, { "name": "Cooling Tower (Furnace)", "code": "Cooling Tower (Furnace)" }, { "name": "Dessicator", "code": "Dessicator" }, { "name": "Dishwasher", "code": "Dishwasher" }, { "name": "Dishwasher (Left)", "code": "Dishwasher (Left)" }, { "name": "Dishwasher (Right)", "code": "Dishwasher (Right)" }, { "name": "DO Meter", "code": "DO Meter" }, { "name": "Drying Oven", "code": "Drying Oven" }, { "name": "Electron Capture Device", "code": "Electron Capture Device" }, { "name": "Elix 35", "code": "Elix 35" }, { "name": "Flame", "code": "Flame" }, { "name": "Flammable Cabinet", "code": "Flammable Cabinet" }, { "name": "Fluke Thermometer", "code": "Fluke Thermometer" }, { "name": "Freezer_Refrigerator", "code": "Freezer_Refrigerator" }, { "name": "Fume Hood", "code": "Fume Hood" }, { "name": "Furnace", "code": "Furnace" }, { "name": "Gas Chromatograph", "code": "Gas Chromatograph" }, { "name": "Gas Leak Detector", "code": "Gas Leak Detector" }, { "name": "Gas Purifier", "code": "Gas Purifier" }, { "name": "Hach Colorimeter (COD)", "code": "Hach Colorimeter (COD)" }, { "name": "Hach Digester", "code": "Hach Digester" }, { "name": "Hach Spectrophotometer", "code": "Hach Spectrophotometer" }, { "name": "Hot Plate", "code": "Hot Plate" }, { "name": "ICP-MS", "code": "ICP-MS" }, { "name": "ICP-MS AutoDiluter", "code": "ICP-MS AutoDiluter" }, { "name": "ICP-MS AutoSampler", "code": "ICP-MS AutoSampler" }, { "name": "ICP-MS Chiller", "code": "ICP-MS Chiller" }, { "name": "ICP-OES", "code": "ICP-OES" }, { "name": "Incubator", "code": "Incubator" }, { "name": "Large Capacity Mixer", "code": "Large Capacity Mixer" }, { "name": "MARS Microwave Digester", "code": "MARS Microwave Digester" }, { "name": "Mass Spectrometer", "code": "Mass Spectrometer" }, { "name": "Mercury Analyzer", "code": "Mercury Analyzer" }, { "name": "Microscope", "code": "Microscope" }, { "name": "Milli-Q", "code": "Milli-Q" }, { "name": "Mixer Mill", "code": "Mixer Mill" }, { "name": "Muffle Furnace", "code": "Muffle Furnace" }, { "name": "NIST Thermometer", "code": "NIST Thermometer" }, { "name": "pH Meter", "code": "pH Meter" }, { "name": "Pipette Calibration Balance", "code": "Pipette Calibration Balance" }, { "name": "Pocket Colorimeter", "code": "Pocket Colorimeter" }, { "name": "Potable Field pH Meter", "code": "Potable Field pH Meter" }, { "name": "Quanti-Tray Sealer", "code": "Quanti-Tray Sealer" }, { "name": "Quanti-Tray Sealer Plus", "code": "Quanti-Tray Sealer Plus" }, { "name": "Reagent Pump", "code": "Reagent Pump" }, { "name": "Reference Weights", "code": "Reference Weights" }, { "name": "Refrigerator", "code": "Refrigerator" }, { "name": "Refrigerator (mini)", "code": "Refrigerator (mini)" }, { "name": "Scrubber", "code": "Scrubber" }, { "name": "SL-1000 (Field Instrument)", "code": "SL-1000 (Field Instrument)" }, { "name": "Sliding Door Fridge", "code": "Sliding Door Fridge" }, { "name": "Sonicator", "code": "Sonicator" }, { "name": "Spectrophotometer", "code": "Spectrophotometer" }, { "name": "Stratum Purge and Trap", "code": "Stratum Purge and Trap" }, { "name": "Toxic Gas Probe", "code": "Toxic Gas Probe" }, { "name": "Turbidimeter", "code": "Turbidimeter" }, { "name": "Ultraviolet Lamp", "code": "Ultraviolet Lamp" }, { "name": "Vacuum", "code": "Vacuum" }, { "name": "Vortex", "code": "Vortex" }, { "name": "Water Bath", "code": "Water Bath" }, { "name": "Working Weights - Bacti", "code": "Working Weights - Bacti" }, { "name": "Working Weights - Inorganics", "code": "Working Weights - Inorganics" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RefNum", "type": "esriFieldTypeString", "alias": "Reference Number", "length": 50, "domain": null }, { "name": "ScreenType", "type": "esriFieldTypeString", "alias": "Screen Type", "length": 12, "domain": { "type": "codedValue", "name": "gInfScreenType", "description": "Inflent Screen Type", "codedValues": [ { "name": "Sand", "code": "Sand" }, { "name": "Bar", "code": "Bar" }, { "name": "Band", "code": "Band" }, { "name": "Perforated", "code": "Perforated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RegulatoryID", "type": "esriFieldTypeString", "alias": "RegulatoryID", "length": 25, "domain": null }, { "name": "RegulatoryBody", "type": "esriFieldTypeString", "alias": "RegulatoryBody", "length": 50, "domain": null }, { "name": "RegulatorySource", "type": "esriFieldTypeString", "alias": "Regulatory Source", "length": 28, "domain": { "type": "codedValue", "name": "gRegulatorySource", "description": "Regulatory Source", "codedValues": [ { "name": "Air Permit", "code": "Air Permit" }, { "name": "Air Permit Support", "code": "Air Permit Support" }, { "name": "Reg 503", "code": "Reg 503" }, { "name": "Stormwater", "code": "Stormwater" }, { "name": "VPDES", "code": "VPDES" }, { "name": "Hazardous Use", "code": "Hazardous Use" }, { "name": "Permit (HUP)", "code": "Permit (HUP)" }, { "name": "Elevator", "code": "Elevator" }, { "name": "SPCC", "code": "SPCC" }, { "name": "UST", "code": "UST" }, { "name": "OSHA", "code": "OSHA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ServiceAgreement", "type": "esriFieldTypeString", "alias": "Service Agreement", "length": 3, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "Asset Name (Equipment No.)", "length": 50, "domain": null }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image Name", "length": 100, "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_BY", "type": "esriFieldTypeString", "alias": "LAST_EDITED_BY", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "indexes": [ { "name": "R514_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1124ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 57, "name": "TB_WRF_PositionPoint", "relatedTableId": 104, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "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 }