us plan sponsor profile

      profile: {
        header: {
          attributes: [
            { 'key': '2905_', 'nickname': 'Total Assets'},
            { 'key': '2906_', 'nickname': 'Defined Benefit'},
            { 'key': '2985_', 'nickname': 'Defined Contribution'}
          ]
        },
        keyPeople: {
          attributes: [
            {'key': 'association_2246', 'plan_type': 'DB'},
            {'key': 'association_2271', 'plan_type': 'DC'}
          ]
        },
        overview:{
          db: {
            replace: [[new RegExp('% Of U\\.S\\. DB Assets Invested In', 'i'), '']],
            attributes: [
              {'key': '2906_', 'nickname': 'Total DB Assets', 'total_value': true},
              {'key': 'sum1_', 'nickname': 'Equity', 'sum': ['2911_', '2912_', '32195_'], 'type': 'percentage'},
              {'key': '2911_' }, // % domestic eq
              {'key': '2912_'}, // % intl  eq
              {'key': '32195_'}, // %global  eq
              {'key': 'sum2_', 'nickname': 'Fixed Income', 'sum': ['2913_', '2914_'], 'type': 'percentage'},
              {'key': '2913_', 'nickname': 'Domestic' }, // %domestic fi
              {'key': '2914_', 'nickname': 'International' }, // %intl fi
              {'key': 'sum3_', 'nickname': 'Alternatives', 'sum': ['2916_', '2917_', '24204_'], 'type': 'percentage'},
              {'key': '2916_', 'nickname': 'Private Equity'}, // %pe
              {'key': '2917_'}, // %re equity
              {'key': '24204_', 'nickname': 'Other'}, // %alt invest
              {'key': '2915_', 'nickname': 'Cash', 'sum': '2915_', 'type': 'percentage'},
              {'key': '2919_', 'nickname': 'Other', 'sum': '2919_', 'type': 'percentage'}
            ]
          },
          dcplantype: {
            replace: [[new RegExp('U\\.S\\. Defined Contribution', 'i'), '']],
            attributes: [
              {'key': '3000_', 'sum': '3000_'},
              {'key': '3001_', 'sum': '3001_'},
              {'key': '3002_', 'sum': '3002_'},
              {'key': '3003_', 'sum': '3003_'},
              {'key': '3004_', 'sum': '3004_'},
              {'key': '3005_', 'sum': '3005_'},
              {'key': '3006_', 'sum': '3006_'}
            ]
          },
          dc: {
            empty:'no data available',
            notes: [
              'The plan sponsor average is calculated by dividing the sum of the years total by 5. In the event the plan sponsor has not provided information for all five years, the average will not be comparable to the universe.'
            ],
            replace: [[new RegExp('% Of U\\.S\\. DC Assets Invested In ', 'i'), '']],
            attributes: [
              {'key': '2985_', 'nickname': 'Total DC Assets', 'total_value': true},
              {'key': 'sum1_', 'nickname': 'Equity', 'sum': ['2988_', '2989_', '2990_'], 'type': 'percentage'},
              {'key': '2988_', 'type': 'percentage' },
              {'key': '2989_', 'type': 'percentage' },
              {'key': '2990_', 'type': 'percentage' },
              {'key': 'sum2_', 'nickname': 'Fixed Income', 'sum': ['2991_', '2992_'], 'type': 'percentage'},
              {'key': '2991_', 'type': 'percentage'},
              {'key': '2992_', 'type': 'percentage'},
              {'key': '2993_', 'nickname': 'Cash', 'type': 'percentage', 'sum': '2993_' },
              {'key': '36550_', 'nickname': 'Target Date', 'type': 'percentage', 'sum': '36550_'},
              {'key': '36552_', 'nickname': 'Inflation Protection', 'type': 'percentage', 'sum': '36552_'},
              {'key': '36554_', 'nickname': 'Annuities', 'type': 'percentage', 'sum': '36554_'},
              {'key': '2994_', 'nickname': 'Other Investments', 'type': 'percentage', 'sum': '2994_'}
            ]
          }
        },
        managers:{
          db: {
            heading: 'Defined Benefit',
            replace: [[ new RegExp('.*', 'i'), '*']],
            columns: [
              { nickname: 'Managers', pivot: true},
              { nickname: 'Domestic Equities' },
              { nickname: 'Int\'l Equities' },
              { nickname: 'Global Equities' },
              { nickname: 'Domestic Fixed' },
              { nickname: 'Int\'l Fixed' },
              { nickname: 'Real Estate' },
              { nickname: 'Private Equity' },
              { nickname: 'Hedge Fund' }
            ],
            attributes: [
              { key: 'association_2252', association_key: 'firm_name'},
              { key: 'association_2253', association_key: 'firm_name'},
              { key: 'association_2889', association_key: 'firm_name'},
              { key: 'association_2254', association_key: 'firm_name'},
              { key: 'association_2255', association_key: 'firm_name'},
              { key: 'association_2257', association_key: 'firm_name'},
              { key: 'association_2256', association_key: 'firm_name'},
              { key: 'association_2258', association_key: 'firm_name'}
            ]
          },
          dc: {
            heading: 'Defined Contribution',
            replace: [[ new RegExp('.*', 'i'), '*']],
            empty:'no data available',
            columns: [
              { nickname: 'Managers', pivot: true},
              { nickname: 'Domestic Equities' },
              { nickname: 'Int\'l Equities' },
              { nickname: 'Fixed Income' },
              { nickname: 'Stable Value' },
              { nickname: 'Target-Date' },
              { nickname: 'Other' }
            ],
            attributes: [
              { key: 'association_2274', association_key: 'firm_name'},
              { key: 'association_2275', association_key: 'firm_name'},
              { key: 'association_2276', association_key: 'firm_name'},
              { key: 'association_2277', association_key: 'firm_name'},
              { key: 'association_2279', association_key: 'firm_name'},
              { key: 'association_2280', association_key: 'firm_name'}
            ]
          }
        },
        consultants:{
          heading: 'Consultant Types',
          empty:'no data available',
          columns: [
            { nickname: 'General - DB' },
            { nickname: 'Private Equity - DB' },
            { nickname: 'Real Estate - DB' },
            { nickname: 'Hedge Fund - DB' },
            { nickname: 'Defined Contribution' }
          ],
          attributes: [
            { key:      'association_2247', association_key: 'firm_name'},
            { key:      'association_2250', association_key: 'firm_name'},
            { key:      'association_2248', association_key: 'firm_name'},
            { key:      'association_2249', association_key: 'firm_name'},
            { key:      'association_2272', association_key: 'firm_name'}
          ]
        },
        funded: {
          replace: [[]],
          empty:'no data available',
          attributes: [
            {'key': '32388_', 'total_value': true},
            {'key': '32389_', 'total_value': true},
            {'key': '32390_', 'total_value': true},
            {'key': '32391_', 'total_value': true, 'type': 'percentage'},
            {'key': '32392_', 'total_value': true, 'type': 'percentage'},
            {'key': '32393_', 'nickname': 'Active Particpants', 'total_value': true},
            {'key': '32394_', 'nickname': 'Retirees', 'total_value': true}
          ]
        },
        investment: {
          notes: [
            '<a target="_blank" href="//researchcenter.pionline.com/asset-owner-performance">View full P&I Investment Return tool.</a>',
            'In some cases where three-year and five-year performance was not stated it was calculated from annual returns.',
            'U.S. corporate performance calculation: actual investment performance for current fiscal year/((fair value of assets in current fiscal year + fair value of assets in previous fiscal year)/2)',
            'Source: Annual Reports, Australian Prudential Regulation Authority (APRA) and Pensions & Investments'
          ],
          empty: 'no data available',
          attributes: []
        }
      }