🎁: Columns - A column & Filter is needed for Critical Heat Traces

[EDUT-Equinor]

Expected outcome

Tag.Description data needs to be avaliable

We need a column / filter for safety criticality

The Safety Critical column should also be in the side sheet after the HT column. Can we use Red SC and black dashes to denote safety critical stuff (maybe this is one for the UX team :) ):

There are two ways in Tag.Description that criticality is noted: • “CRITICAL_HEAT_TRACING_CABLE” when the contractor is “AS, AKER ENGINEERING AND TECHNOLOGY” • “CRITICAL HEAT TRACING CABLE” when the contractor is “SC, SEMBCORP MARINE”

Acceptance Criteria

• [ ] Columns for Safety Criticality in side sheet that pics up data from ProCoSyS
• [ ] Columns for Safety Criticality in main RC sheet that pics up Safety criticality from the Side sheet.
• [ ] Filter for Safety Criticality "Yes / No"

[EDUT-Equinor]

There may be an additional need for Safety Critical Circuits?

[EDUT-Equinor]

I understand there is no automated way to gather safety criticality through ProCoSyS. Hence, users will have to manually tag safety critical HTs / Circuits

[EDUT-Equinor]

There is a link to the STID ISO drawings for HTs found at the link here in ProCoSyS. Can we use that?

[EDUT-Equinor]

Apparently we should avoid manual to enhance safety. I am speaking to bent-andre.risnes@akersolutions.com +47 92085655 regarding critical heat traces. Followed up with a call today

[MagnusGjosund]

Talked to @aman-riaz to add this to the view. She will investigate which field that are needed. Please add it to Custom_Scope_TagV1

[aman-riaz]

22.03.24 Meeting with Edward, Magnus: Agreed to do this after easter. Release control app in jc portal:

Table 1 (first table above) Table 2 (lower tabler)

Table 1: Custom_Rc_Tag

• Remove SignedDate
• Remove VerifiedDate
• Remove MC Responsible
• Checklist Responsible (string agg)

Table 2: Custom_Scope_Tag_cc

• Remove SignedDate
• Remove Switchboard
• Remove Verified
• Add Tag.Description
• Checklist Responsible (string agg)

@MagnusGjosund
Please provide me a list of all fields that are used in Custom_rc_tag and custom_scope_tag_cc. Link to another related issue: https://github.com/orgs/equinor/projects/636/views/7?filterQuery=is%3AOpen&pane=issue&itemId=57105970

[MagnusGjosund]

All the fields we are using in Custom_RCTag:

All the fields we are using in Custom_Scope_Tag_CC:

[MagnusGjosund]

Also there's a typo in TagUrlId in Custom_Scope_Tag_CC. Please fix the typo :D

[MagnusGjosund]

Here is the mapping for table 1 Custom_RCTag:

Here is the mapping for table 2 Custom_Scope_Tag_CC:

[ken-mellem]

This must be pushed to next week due to Aman being away this week. @MagnusGjosund