PAP(Process Automation Platform)

--Export EDWIPD Control Valve
SELECT [TagNumber],
[P&IDNumber],
[Service],
[Linesize],
[Materialclass]
FROM Instrument
WHERE upper(Measured) In ('F','L','P') and upper([Inst.Type]) = 'VALVE'

--Export EDWIPD Flowmeter
SELECT
[TagNumber],
[Service],
[P&IDNumber],
[Location],
[Phaseupper],
[FluidHandledupper],
[Flowratemin],
[Flowratenor],
[Flowratemax],
[OperatingPressuremin],
[OperatingPressurenor],
[OperatingPressuremax],
[OperatingTemperaturemin],
[OperatingTemperaturenor],
[OperatingTemperaturemax],
[Densityupper],
[Viscosityupper],
[PressureDropmax],
[Compressibility],
[SpecificHeatRatio],
[MolecularWeight],
[DesignPressure],
[DesignTemperature]
FROM Instrument
WHERE upper(Measured) ='F' and upper([Inst.Type]) IN ('VORTEX','AREA', 'DISCRETE SINGLE','ORIF','ULTRASONIC')

--Export EDWIPD Level
SELECT
[TagNumber],
[P&IDNumber],
[FluidHandledupper],
[FluidHandledlower],
[Phaseupper],
[Phaselower],
[Densityupper],
[Densitylower],
[MolecularWeight],
[OperatingPressurenor],
[OperatingPressuremax],
[OperatingTemperaturenor],
[OperatingTemperaturemax],
[DesignPressure],
[DesignTemperature]
FROM Instrument
WHERE upper(Measured) = 'L' and
upper([Inst.Type]) = 'DISCRETE SINGLE'

--Export EDWIPD Pressure
SELECT
[TagNumber],
[P&IDNumber],
[Location],
[Service],
[FluidHandledupper],
[Phaseupper],
[OperatingPressuremin],
[OperatingPressurenor],
[OperatingPressuremax],
[OperatingTemperaturemin],
[OperatingTemperaturenor],
[OperatingTemperaturemax],
[DesignPressure],
[DesignTemperature]
FROM Instrument
WHERE upper(Measured) = 'P' and upper([Inst.Type]) = 'DISCRETE SINGLE'

--Export EDWIPD Safety Relief Valve
SELECT
[TagNumber],
[P&IDNumber],
[Service],
[Materialclass],
[FluidHandledupper],
[OperatingPressuremax],
[OperatingTemperaturenor],
[SetPressureover],
[RelieveingTemperature],
[SizingBasis],
[BackPressuresuperconst],
[BackPressuresupervariable],
[BackPressurebuiltup],
[BackPressuretotal],
[Allowableoverpressurein],
[Viscosityupper],
[MolecularWeight],
[SpecificHeatRatio],
[Compressibility],
[OrificeSize]
FROM Instrument
WHERE upper([Inst.Type]) = upper('ANGLE PRESS RELIEF VALVE')

--Export EDWIPD Temperature
SELECT
[TagNumber],
[P&IDNumber],
[Location],
[Service],
[FluidHandledupper],
[Phaseupper],
[OperatingPressuremin],
[OperatingPressurenor],
[OperatingPressuremax],
[OperatingTemperaturemin],
[OperatingTemperaturenor],
[OperatingTemperaturemax],
[DesignPressure],
[DesignTemperature]
FROM Instrument
WHERE upper(Measured) = 'T' and upper([Inst.Type]) IN ('DISCRETE SINGLE','WELL')