# View: salesforce_society_IDs

**View Name:** salesforce_society_ids
**Table Source:** `Derived from: Business_Systems_Salesforce_Data, Business_Systems_Salesforce_Data.Nr, Nr.Contributor_C, Nr.Society_C`
**File Path:** `views/salesforce_society_IDs.view.lkml`

## Overview

- **File Size:** 1051 bytes
- **Lines of Code:** 40
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `contributor_name` | string |
| `contributor_uuid` | string |
| `cmm_id` | string |
| `society_name` | string |
| `society_performer_id` | string |

## Derived Table

```sql
sql:
      SELECT
        c.NAME                              AS contributor_name,
        c.CONTRIBUTOR_UUID_C                AS contributor_uuid,
        s.CMM_ID_TEXT_C                     AS cmm_id,
        s.NAME                              AS society_name,
        s.SOCIETY_PERFORMER_ID_C            AS society_performer_id
      FROM BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.SOCIETY_C s
      INNER JOIN BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.CONTRIBUTOR_C c
        ON s.CONTRIBUTOR_C = c.ID
      ;;
```