MC filters

[JoneUE]

View: Custom_MechanicalCompletionPackage_v2
FilterName - FAMname

• Facility - Facility
• Project - Project
• MC Remark - Remark
• MC Status - MechanicalCompletionStatus
• MC Location - Location
• MC Phase - MechanicalCompletionPhase
• MC Discipline - DisciplineDescription
• MC Responsible - Responsible
• Handover Status - Need to be created
• M-01 Contractor Final Punch - M01_Actual
• M-02 Punch Status accepted - M02_Actual
• M-03 RFC - M03_Actual
• Comm Phase - CommissioningPhase
• Comm System - System
• Comm SubSystem - SubSystem
• Comm Priority 1 - Priority1
• Comm Priority 2 - Priority2
• Comm Priority 3 - Priority3
• Comm Identifier - Identifier

---

• Added to Workspace
• Added to Analytics

[JoneUE]

SQL for HandoverStatus

,CASE 
WHEN m8.ActualDate is not null THEN 'RFOC Rejected'
    WHEN m8.ActualDate is not null THEN 'RFOC Accepted'
    WHEN m7.ActualDate is not null THEN 'RFOC Sent'
    WHEN c6.IsRejected=1 then 'TAC Rejected'
    WHEN c6.IsAccepted=1 then 'TAC Accepted'
    WHEN c6.IsShipped=1 then 'TAC Sent'
    WHEN m4.ActualDate is not null THEN 'RFCC Accepted'
    WHEN m3.ActualDate is not null THEN 'RFCC Sent'
    WHEN m2.ActualDate is not null then 'Punch Status Accepted'
    WHEN m1.ActualDate is not null THEN 'Contractor Final Punch'
    ELSE 'OS'
    END AS HandoverStatus

[espenkalle]

Dont think we need Handover Status to be created?
Its under CommissioningStatus

[espenkalle]

Remark blir nok ikke et filter.
Kan legges inn i søk?
name MC Remark.txt

[JoneUE]

That's okay. But is the Commissioning Status calculated in the backend now?

[espenkalle]

Its in the view

[aman-riaz]

Filters added to analytics