Variable | Metric | Value | Year |
---|---|---|---|
signature | Research lock_open
|
No value | 2022 |
board_approval | Research lock_open
|
No value | 2022 |
organizational_structure | No value | 2022 | |
supply_chain_disclosure | Research lock_open
|
No value | 2022 |
risk_identification | Research lock_open
|
No value | 2022 |
risk_assessment | Research lock_open
|
No value | 2022 |
risk_management | Research lock_open
|
No value | 2022 |
incident_remediation | No value | 2022 | |
grievance_mechanism | No value | 2022 | |
kpis_effectiveness | Research lock_open
|
No value | 2022 |
consultation_process | Research lock_open
|
No value | 2022 |
assessed_statement | No value | 2022 | |
registry_submission | No | 2022 |
Formula
= signature_accepted_values = ["Signed by CEO", "Signed by Director", "Signed by Managing Director", "Signed by Chairman"]
supply_chain_disclosure_accepted_values = ["Geographical", "Facility/Supplier"]
risk_identification_accepted_values = ["Geographic","Resource", "Workforce","Industry"]
incident_remediation_accepted_values = ["Worker remediation", "Corrective action plan", "Senior management", "Cancel contracts"]
grievance_mechanism_accepted_values = ["Hotline, Email, Contact Form (direct employees)", "Hotline, Email, Contact Form (supply chain workers)", "Whistleblower protection (direct employees)", "Whistleblower protection (supply chain workers)", "Focal Point (direct employees)", "Focal Point (supply chain workers)"]
risk_assessment_accepted_values = [ "Risk-based questionnaires", "Use of risk management tool or software", "Conducting desk research"]
risk_management_accepted_values = ["Audits of suppliers (self- reporting)", "Audits of suppliers (independent)", "On-site visits (self- reporting)", "On-site visits (independent)"]
c1 = signature_accepted_values.includes signature
c2 = board_approval == "Approved by Board"
c3 = registry_submission == "Yes"
c4 = organizational_structure == "Yes"
c5 = supply_chain_disclosure_accepted_values.some((v)=> supply_chain_disclosure.indexOf(v) >= 0)
c6 = risk_identification_accepted_values.some((v) => risk_identification.indexOf(v) >= 0)
c7 = grievance_mechanism_accepted_values.some((v) => grievance_mechanism.indexOf(v) >= 0)
c8 = kpis_effectiveness == "Yes"
c9 = consultation_process == "Yes"
c10 = risk_assessment_accepted_values.some((v) => risk_assessment.indexOf(v) >= 0)
c11 = risk_management_accepted_values.some((v) => risk_management.indexOf(v) >= 0)
c12 = incident_remediation_accepted_values.some((v) => incident_remediation.indexOf(v) >= 0)
c13 = assessed_statement == "Yes"
if c1 && c2 && c3 && c4 && c5 && c6 && c7 && c8 && c9 && c10 && c11 && c12 && c13
"Yes"
else if c13
"No"
else
"Unknown"