Report the Process Owner for each Typical Generated Record of each Instrument Symbol connected to the Piping Network

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 typical generated record of each instrument symbol connected to the piping network.

The drawing displays Instrument symbols that each contain one typical record. Each instrument symbol connects to a different branch of the piping network, each branch contains one typical record.

Piping network 50-SW-110-S1A-5L contains a typical record with number 111 and tag 50-SW-111-S1A-5L.

Instrument symbol TI-1001 contains typical record TI-1001-A and is is connected to the piping network using an unnamed valve symbol outlet connection.

Instrument symbol TI-1000 contains typical record TI-1000-A and is connected to the piping network using valve symbol outlet V-222.

Valve V-222 contains typical record V-223.

Instrument symbol TI-1002 contains typical record TI-1002-A and is connected to the piping network using a flange outlet symbol.

The example script will return the process owner for each typical generated record of each instrument symbol connected to the piping network.

-- Find instrument process owner connected to valve table

UPDATE INSTLIST

SET [Process Owner] = VLVTable.[Process Owner] , [Inst Process Owner] = VLVTable.[Process Owner]

FROM (

SELECT Handle, [DRG+SHT], [Process Owner] ,[Valve Tag]

FROM VLVLIST) As VLVTable

WHERE

INSTLIST.[Process Owner] = ''

and INSTLIST.[Inst Owner Handle] = VLVTable.[Handle]

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

-- Find instrument process owner connected to valve record generated with typicals

UPDATE INSTLIST

SET [Process Owner] =VLVTable.[Process Owner] , [Inst Process Owner] = VLVTable.[Process Owner]

FROM (

SELECT Handle, [DRG+SHT], [Process Owner] ,[Valve Tag]

FROM VLVLIST) As VLVTable

WHERE

INSTLIST.Handle1 like '%#%'

AND VLVTable.Handle LIKE '%#%'

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

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

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

UPDATE INSTLIST

SET [Process Owner] =VLVTable.[Valve Tag] , [Inst Process Owner] = VLVTable.[Valve Tag]

FROM (

SELECT Handle, [DRG+SHT], [Process Owner] ,[Valve Tag]

FROM VLVLIST) As VLVTable

WHERE

VLVTable.[Valve Tag] <> ''

and INSTLIST.Handle1 like '%#%'

AND VLVTable.Handle LIKE '%#%'

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

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

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

-- Find instrument process owner connected to line fitting

UPDATE INSTLIST

SET [Process Owner] = LIFTABLE.[Process Owner] , [Inst Process Owner] = LIFTable.[Process Owner]

FROM (

SELECT Handle, [DRG+SHT], [Process Owner] ,[ValveTag] , [Special Item No]

FROM INLNLIST) As LIFTable

WHERE

INSTLIST.[Process Owner] = ''

and INSTLIST.[Inst Owner Handle] =LIFTable.[Handle]

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

At the database grid table, each typical generated instrument is hosted by the respective branch connection tag, when the connected valve does not have a tag value. When the connected valve has a tag value, the valve tag is reported and hosted by the instrument record.