Report the Process Owner for each Instrument Typical Record from the Connected Typical Nozzle

In the example, the project administrator has created a customized SQL script routine designed to modify the instrument table INSTLIST to report the process owner for each instrument typical record from the connected typical nozzle.

The drawing displays a vessel with a connected nozzle that contains three typical records.

The nozzle symbol connects with three instruments symbols, each containing three typical records.

Instruments thermowell TW-115-A, temperature element TE-115A and temperature transmitter TT-115-A are connected to nozzle symbol 20-V-1101 N1.

The nozzle symbol contains three typical records: 20-V-1101 N2, 20-V-1101 N3 and 20-V-1101 N4.

Each of the instruments connected to the nozzle contains three typical records.

Thermowell TW-115-A contains three typical records: TW-115-B, TW-115-C and TW-115-D.

Temperature element TE-115-A contains three typical records: TE-115-B, TT-115-C and TE-115-D.

Temperature transmitter TT-115-A contains three typical records: TT-115-B, TT-115-C and TT-115-D.

The example script will return the process owner for each typical record of an instrument symbol when the symbol is connected to a nozzle with typical records.

-- First: Set instrument typical process owner to instrument parent symbol tag name

UPDATE INSTLIST

SET [Process Owner] = OtherTable.[Process Owner] ,

[Inst Process Owner] = OtherTable.[Inst Process Owner]

FROM (

SELECT Handle1, [DRG+SHT], [Process Owner] , [Inst Process Owner]

FROM INSTLIST) AS OtherTable

WHERE

OtherTable.Handle1 = substring(INSTLIST.Handle1, 1, CHARINDEX('#',INSTLIST.Handle1)-1)

and INSTLIST.Handle1 like ('%#%')

and OtherTable.[DRG+SHT] = INSTLIST.[DRG+SHT]

and INSTLIST.[Process Owner] = ''

UPDATE INSTLIST

SET [Process Owner] = OtherTable.[Instrument Label] ,

[Inst Process Owner] = OtherTable.[Instrument Label]

FROM (

SELECT Handle1, [DRG+SHT], [Inst Owner Handle], [Process Owner] , [Inst Process Owner] , [Instrument Label]

FROM INSTLIST) AS OtherTable

WHERE

OtherTable.[Handle1] like '%#%'

and INSTLIST.Handle1 like ('%#%')

and OtherTable.[DRG+SHT] = INSTLIST.[DRG+SHT]

and INSTLIST.[Inst Owner Handle] = substring(OtherTable.Handle1, 1, CHARINDEX('#',OtherTable.Handle1)-1)

and substring(INSTLIST.[Handle1], CHARINDEX('#',INSTLIST.[Handle1])+1, 3) = substring(OtherTable.[Handle1], CHARINDEX('#',OtherTable.Handle1)+1, 3)

-- Update instrument process owner for equipment process owner getting specific typical nozzle tag.

UPDATE INSTLIST

SET [Process Owner] = NozTable.[FULL TAG] , [Inst Process Owner] = NozTable.[Equipment Label]

FROM (

SELECT Handle, [DRG+SHT], [FULL TAG] , [Equipment Label]

FROM NOZLIST) As NozTable

WHERE

INSTLIST.Handle1 like '%#%'

AND NozTable.Handle LIKE '%#%'

and INSTLIST.[Inst Owner Handle] = substring(NozTable.[Handle], 1, CHARINDEX('#',NozTable.Handle)-1)

and substring(INSTLIST.[Handle1], CHARINDEX('#',INSTLIST.Handle1)+1, 3) = substring(NozTable.[Handle], CHARINDEX('#',NozTable.Handle) + 1, 3)

and NozTable.[DRG+SHT] = INSTLIST.[DRG+SHT]

At the database grid table, the typical generated instrument is hosted by the process owner with the tag value pointing to the corresponding typical nozzle tag value.