close open_in_new
  1. Home
  2. Answers
  3. Commons+Industry+Aetna+2019
help edit space_dashboard
Question: What are the company's industry or industries?
Answer:
Finance and insurance
Commons
Industry
Aetna
2019
Unverified - Added by Steward
  • Details
  • Years 1
  • calculations 1
  • inputs
Research
Flag!
Variable Metric Value Year
m1
Industry Section
Formula
No value latest
m2
Commons+Image
Standard Industrial Classification Division
Formula
H latest
m3
Commons+Image
Has Brands
Relationship
No value latest
m4
Commons+Image
Shareholder Of
Relationship
No value latest
m5
Principles for Responsible Investment+Image
PRI Signatory
Research lock_open
No value latest
m6
Commons+Image
is Tin supplier of
Inverse Relationship
No value latest
m7
Vasiliki Gkatziaki+Image
is Gold supplier of
Inverse Relationship
No value latest
m8
Commons+Image
is Tantalum supplier of
Inverse Relationship
No value latest
m9
Commons+Image
is Tungsten supplier of
Inverse Relationship
No value latest
m10
Commons+Image
Supplier of
Inverse Relationship
No value latest
m11
Sector (Industry)
Research lock_open
No value latest
m12
Alliance for Corporate Transparency+Image
Sector
Research lock
No value latest
Formula
= isicSection = m1 sicDivision = m2 hasBrands = m3 financeMetrics = [m4, m5] supplierMetrics = [m6, m7, m8, m9, m10] gri = m11 act = m12 sicMap = A: "A" B: "B" C: "F" D: "C" F: "G" G: "G" H: "K" J: "O" griMap = "Automotive": ["C", "G"] "Chemicals": "C" "Energy": "D" "Metals Products": "C" "Telecommunications": "J" "Financial Services": "K" actMap = "Consumption": "G" "Energy & Resource Extraction": "D" "Financials": "K" "Health Care": "Q" "Resource Transformation": "C" "Technology & Communications": "J" "Transportation": "H" isKnown = (answer) -> answer != "Unknown" anyKnown = (answerList) -> answerList.find isKnown mappedCodes = (answer, map) -> return unless isKnown answer codes = answer.map (a) -> map[a] codes = codes.filter Boolean return codes if codes.length if isKnown isicSection isicSection else if val = mappedCodes sicDivision, sicMap val else if isKnown hasBrands "G" else if anyKnown financeMetrics "K" else if anyKnown supplierMetrics "C" else if val = griMap[gri] val else if val = mappedCodes act, actMap val else "Unknown"