# View: performer_salesforce_combined **View Name:** performer_salesforce_combined **Table Source:** `Derived from: Business_Systems_Salesforce_Data, Business_Systems_Salesforce_Data.Nr, Nr.Contributor_C, Nr.Society_C` **File Path:** `views/performer_salesforce_combined.view.lkml` ## Overview - **File Size:** 48945 bytes - **Lines of Code:** 1516 - **Dimensions:** 136 - **Measures:** 0 - **Dimension Groups:** 36 - **Filters:** 0 ## Comments & Notes - --- CONTRIBUTOR DIMENSIONS --- - --- SOCIETY REGISTRATION DIMENSIONS --- ## Dimensions | Name | Type | |------|------| | `contributor_id` | string | | `contributor_owner_id` | string | | `contributor_is_deleted` | yesno | | `contributor_name` | string | | `contributor_created_by_id` | string | | `contributor_last_modified_by_id` | string | | `contributor_account_priority` | string | | `contributor_address_type` | string | | `contributor_artist_name_type` | string | | `contributor_bank_currency` | string | | `contributor_bank_details_format` | string | | `contributor_bank_status` | string | | `contributor_citizenship_territory_2` | string | | `contributor_citizenship_territory_3` | string | | `contributor_citizenship_territory_4` | string | | `contributor_citizenship_territory` | string | | `contributor_contributor_type` | string | | `contributor_country_tax` | string | | `contributor_country` | string | | `contributor_country_of_birth` | string | | `contributor_country_of_residence` | string | | `contributor_eu_payee_vat_country` | string | | `contributor_eu_payee_vat_registered` | string | | `contributor_entity` | string | | `contributor_gender` | string | | `contributor_payee_type` | string | | `contributor_relationship_type` | string | | `contributor_residency_territory_2` | string | | `contributor_residency_territory_3` | string | | `contributor_residency_territory_4` | string | | `contributor_residency_territory` | string | | `contributor_status` | string | | `contributor_us_bank_account_type` | string | | `contributor_us_payee_tin_type` | string | | `contributor_us_payee_tax_classification` | string | | `contributor_us_payee_tax_form_type` | string | | `contributor_us_wht_reporting_requirement` | string | | `contributor_aud_bsb` | string | | `contributor_additional_details_address` | string | | `contributor_additional_details_bank_details` | string | | `contributor_additional_details_instructions` | string | | `contributor_additional_details_name` | string | | `contributor_address_description` | string | | `contributor_address_line_1_tax` | string | | `contributor_address_line_2_tax` | string | | `contributor_address_line_3_tax` | string | | `contributor_address_type_text` | string | | `contributor_aliases` | string | | `contributor_artist_music_brainz_id` | string | | `contributor_artist_name` | string | | `contributor_band_name` | string | | `contributor_bank_account_description` | string | | `contributor_bank_account_name` | string | | `contributor_bank_account_number` | string | | `contributor_bank_address` | string | | `contributor_bank_iban` | string | | `contributor_bank_name` | string | | `contributor_bank_sort_code` | string | | `contributor_bank_swift_bic` | string | | `contributor_beneficiary_address` | string | | `contributor_beneficiary_name` | string | | `contributor_birth_name` | string | | `contributor_citizenship_notes_2` | string | | `contributor_citizenship_notes_3` | string | | `contributor_citizenship_notes_4` | string | | `contributor_citizenship_notes` | string | | `contributor_citizenship_territory_2_text` | string | | `contributor_citizenship_territory_3_text` | string | | `contributor_citizenship_territory_4_text` | string | | `contributor_citizenship_territory_text` | string | | `contributor_city_tax` | string | | `contributor_client_owner` | string | | `contributor_contributor_type_text` | string | | `contributor_contributor_uuid` | string | | `contributor_country_tax_text` | string | | `contributor_country_of_birth_text` | string | | `contributor_eu_payee_ni_number` | string | | `contributor_eu_payee_vat_number` | string | | `contributor_eu_tax_id` | string | | `contributor_email_address` | string | | `contributor_entity_text` | string | | `contributor_fax_number` | string | | `contributor_foreign_payee_tax_identification_number` | string | | `contributor_forename` | string | | `contributor_ipda_ipn` | string | | `contributor_in_collection` | yesno | | `contributor_instruments` | string | | `contributor_knr_account_id` | string | | `contributor_maiden_name` | string | | `contributor_main_music_genre` | string | | `contributor_main_occupation` | string | | `contributor_middle_name_1` | string | | `contributor_middle_name_2` | string | | `contributor_name_suffice` | string | | `contributor_name_c` | string | | `contributor_oa_account_id` | string | | `contributor_payee_name` | string | | `contributor_phone_number` | string | | `contributor_post_collection_notes` | string | | `contributor_prefix` | string | | `contributor_primary_address` | string | | `contributor_relationship_description` | string | | `contributor_repertoire_owner` | string | | `contributor_residency_notes_2` | string | | `contributor_residency_notes_3` | string | | `contributor_residency_notes_4` | string | | `contributor_residency_notes` | string | | `contributor_residency_territory_2_text` | string | | `contributor_residency_territory_3_text` | string | | `contributor_residency_territory_4_text` | string | | `contributor_residency_territory_text` | string | | `contributor_society` | string | | `contributor_state_tax` | string | | `contributor_suffix` | string | | `contributor_surname` | string | | `contributor_tax_address` | string | | `contributor_term_end_note` | string | | `contributor_term_note` | string | | `contributor_terminated` | yesno | | `contributor_territory_of_representation` | string | | `contributor_us_payee_tax_identification_number` | string | | `contributor_us_payee_tax_name` | string | | `contributor_web_address` | string | | `contributor_zip_post_code_tax` | string | | `contributor_fivetran_deleted` | yesno | | `society_id` | string | | `society_is_deleted` | yesno | | `society_name` | string | | `society_created_by_id` | string | | `society_last_modified_by_id` | string | | `society_contributor_c` | string | | `society_status` | string | | `society_notes` | string | | `society_performer_id` | string | | `society_cmm_id_text` | string | | `society_fivetran_deleted` | yesno | ## Dimension Groups | Name | Type | |------|------| | `contributor_created` | time | | `contributor_last_modified` | time | | `contributor_system_modstamp` | time | | `contributor_last_viewed` | time | | `contributor_last_referenced` | time | | `contributor_agreement_start` | time | | `contributor_citizenship_end_date_2` | time | | `contributor_citizenship_end_date_3` | time | | `contributor_citizenship_end_date_4` | time | | `contributor_citizenship_end` | time | | `contributor_citizenship_start_date_2` | time | | `contributor_citizenship_start_date_3` | time | | `contributor_citizenship_start_date_4` | time | | `contributor_citizenship_start` | time | | `contributor_collection_period_end` | time | | `contributor_earliest_term_end_date_ral` | time | | `contributor_notice_serve` | time | | `contributor_residency_end_date_2` | time | | `contributor_residency_end_date_3` | time | | `contributor_residency_end_date_4` | time | | `contributor_residency_end` | time | | `contributor_residency_start_date_2` | time | | `contributor_residency_start_date_3` | time | | `contributor_residency_start_date_4` | time | | `contributor_residency_start` | time | | `contributor_rights_start` | time | | `contributor_tax_form_expiry` | time | | `contributor_term_end` | time | | `contributor_fivetran_synced` | time | | `society_created` | time | | `society_last_modified` | time | | `society_system_modstamp` | time | | `society_last_viewed` | time | | `society_last_referenced` | time | | `society_date` | time | | `society_fivetran_synced` | time | ## SQL Comments - --- CONTRIBUTOR TABLE (Prefix: CONTRIBUTOR_) --- - --- SOCIETY REGISTRATION TABLE (Prefix: SOCIETY_) --- ## Derived Table ```sql sql: SELECT -- --- CONTRIBUTOR TABLE (Prefix: CONTRIBUTOR_) --- contributor.ID AS CONTRIBUTOR_ID, contributor.OWNER_ID AS CONTRIBUTOR_OWNER_ID, contributor.IS_DELETED AS CONTRIBUTOR_IS_DELETED, contributor.NAME AS CONTRIBUTOR_NAME, contributor.CREATED_DATE AS CONTRIBUTOR_CREATED_DATE, contributor.CREATED_BY_ID AS CONTRIBUTOR_CREATED_BY_ID, contributor.LAST_MODIFIED_DATE AS CONTRIBUTOR_LAST_MODIFIED_DATE, contributor.LAST_MODIFIED_BY_ID AS CONTRIBUTOR_LAST_MODIFIED_BY_ID, contributor.SYSTEM_MODSTAMP AS CONTRIBUTOR_SYSTEM_MODSTAMP, contributor.LAST_VIEWED_DATE AS CONTRIBUTOR_LAST_VIEWED_DATE, contributor.LAST_REFERENCED_DATE AS CONTRIBUTOR_LAST_REFERENCED_DATE, contributor.ACCOUNT_PRIORITY_C AS CONTRIBUTOR_ACCOUNT_PRIORITY_C, contributor.ADDRESS_TYPE_C AS CONTRIBUTOR_ADDRESS_TYPE_C, contributor.ARTIST_NAME_TYPE_C AS CONTRIBUTOR_ARTIST_NAME_TYPE_C, contributor.BANK_CURRENCY_C AS CONTRIBUTOR_BANK_CURRENCY_C, contributor.BANK_DETAILS_FORMAT_C AS CONTRIBUTOR_BANK_DETAILS_FORMAT_C, contributor.BANK_STATUS_C AS CONTRIBUTOR_BANK_STATUS_C, contributor.CITIZENSHIP_TERRITORY_2_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_2_C, contributor.CITIZENSHIP_TERRITORY_3_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_3_C, contributor.CITIZENSHIP_TERRITORY_4_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_4_C, contributor.CITIZENSHIP_TERRITORY_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_C, contributor.CONTRIBUTOR_TYPE_C AS CONTRIBUTOR_CONTRIBUTOR_TYPE_C, contributor.COUNTRY_TAX_C AS CONTRIBUTOR_COUNTRY_TAX_C, contributor.COUNTRY_C AS CONTRIBUTOR_COUNTRY_C, contributor.COUNTRY_OF_BIRTH_C AS CONTRIBUTOR_COUNTRY_OF_BIRTH_C, contributor.COUNTRY_OF_RESIDENCE_C AS CONTRIBUTOR_COUNTRY_OF_RESIDENCE_C, contributor.EU_PAYEE_VAT_COUNTRY_C AS CONTRIBUTOR_EU_PAYEE_VAT_COUNTRY_C, contributor.EU_PAYEE_VAT_REGISTERED_C AS CONTRIBUTOR_EU_PAYEE_VAT_REGISTERED_C, contributor.ENTITY_C AS CONTRIBUTOR_ENTITY_C, contributor.GENDER_C AS CONTRIBUTOR_GENDER_C, contributor.PAYEE_TYPE_C AS CONTRIBUTOR_PAYEE_TYPE_C, contributor.RELATIONSHIP_TYPE_C AS CONTRIBUTOR_RELATIONSHIP_TYPE_C, contributor.RESIDENCY_TERRITORY_2_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_2_C, contributor.RESIDENCY_TERRITORY_3_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_3_C, contributor.RESIDENCY_TERRITORY_4_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_4_C, contributor.RESIDENCY_TERRITORY_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_C, contributor.STATUS_C AS CONTRIBUTOR_STATUS_C, contributor.US_BANK_ACCOUNT_TYPE_C AS CONTRIBUTOR_US_BANK_ACCOUNT_TYPE_C, contributor.US_PAYEE_TIN_TYPE_C AS CONTRIBUTOR_US_PAYEE_TIN_TYPE_C, contributor.US_PAYEE_TAX_CLASSIFICATION_C AS CONTRIBUTOR_US_PAYEE_TAX_CLASSIFICATION_C, contributor.US_PAYEE_TAX_FORM_TYPE_C AS CONTRIBUTOR_US_PAYEE_TAX_FORM_TYPE_C, contributor.US_WHT_REPORTING_REQUIREMENT_C AS CONTRIBUTOR_US_WHT_REPORTING_REQUIREMENT_C, contributor.AUD_BSB_C AS CONTRIBUTOR_AUD_BSB_C, contributor.ADDITIONAL_DETAILS_ADDRESS_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_ADDRESS_C, contributor.ADDITIONAL_DETAILS_BANK_DETAILS_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_BANK_DETAILS_C, contributor.ADDITIONAL_DETAILS_INSTRUCTIONS_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_INSTRUCTIONS_C, contributor.ADDITIONAL_DETAILS_NAME_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_NAME_C, contributor.ADDRESS_DESCRIPTION_C AS CONTRIBUTOR_ADDRESS_DESCRIPTION_C, contributor.ADDRESS_LINE_1_TAX_C AS CONTRIBUTOR_ADDRESS_LINE_1_TAX_C, contributor.ADDRESS_LINE_2_TAX_C AS CONTRIBUTOR_ADDRESS_LINE_2_TAX_C, contributor.ADDRESS_LINE_3_TAX_C AS CONTRIBUTOR_ADDRESS_LINE_3_TAX_C, contributor.ADDRESS_TYPE_TEXT_C AS CONTRIBUTOR_ADDRESS_TYPE_TEXT_C, contributor.AGREEMENT_START_DATE_C AS CONTRIBUTOR_AGREEMENT_START_DATE_C, contributor.ALIASES_C AS CONTRIBUTOR_ALIASES_C, contributor.ARTIST_MUSIC_BRAINZ_ID_C AS CONTRIBUTOR_ARTIST_MUSIC_BRAINZ_ID_C, contributor.ARTIST_NAME_C AS CONTRIBUTOR_ARTIST_NAME_C, contributor.BAND_NAME_C AS CONTRIBUTOR_BAND_NAME_C, contributor.BANK_ACCOUNT_DESCRIPTION_C AS CONTRIBUTOR_BANK_ACCOUNT_DESCRIPTION_C, contributor.BANK_ACCOUNT_NAME_C AS CONTRIBUTOR_BANK_ACCOUNT_NAME_C, contributor.BANK_ACCOUNT_NUMBER_C AS CONTRIBUTOR_BANK_ACCOUNT_NUMBER_C, contributor.BANK_ADDRESS_C AS CONTRIBUTOR_BANK_ADDRESS_C, contributor.BANK_IBAN_C AS CONTRIBUTOR_BANK_IBAN_C, contributor.BANK_NAME_C AS CONTRIBUTOR_BANK_NAME_C, contributor.BANK_SORT_CODE_C AS CONTRIBUTOR_BANK_SORT_CODE_C, contributor.BANK_SWIFT_BIC_C AS CONTRIBUTOR_BANK_SWIFT_BIC_C, contributor.BENEFICIARY_ADDRESS_C AS CONTRIBUTOR_BENEFICIARY_ADDRESS_C, contributor.BENEFICIARY_NAME_C AS CONTRIBUTOR_BENEFICIARY_NAME_C, contributor.BIRTH_NAME_C AS CONTRIBUTOR_BIRTH_NAME_C, contributor.CITIZENSHIP_END_DATE_2_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_2_C, contributor.CITIZENSHIP_END_DATE_3_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_3_C, contributor.CITIZENSHIP_END_DATE_4_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_4_C, contributor.CITIZENSHIP_END_DATE_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_C, contributor.CITIZENSHIP_NOTES_2_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_2_C, contributor.CITIZENSHIP_NOTES_3_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_3_C, contributor.CITIZENSHIP_NOTES_4_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_4_C, contributor.CITIZENSHIP_NOTES_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_C, contributor.CITIZENSHIP_START_DATE_2_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_2_C, contributor.CITIZENSHIP_START_DATE_3_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_3_C, contributor.CITIZENSHIP_START_DATE_4_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_4_C, contributor.CITIZENSHIP_START_DATE_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_C, contributor.CITIZENSHIP_TERRITORY_2_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_2_TEXT_C, contributor.CITIZENSHIP_TERRITORY_3_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_3_TEXT_C, contributor.CITIZENSHIP_TERRITORY_4_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_4_TEXT_C, contributor.CITIZENSHIP_TERRITORY_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_TEXT_C, contributor.CITY_TAX_C AS CONTRIBUTOR_CITY_TAX_C, contributor.CLIENT_OWNER_C AS CONTRIBUTOR_CLIENT_OWNER_C, contributor.COLLECTION_PERIOD_END_DATE_C AS CONTRIBUTOR_COLLECTION_PERIOD_END_DATE_C, contributor.CONTRIBUTOR_TYPE_TEXT_C AS CONTRIBUTOR_CONTRIBUTOR_TYPE_TEXT_C, contributor.CONTRIBUTOR_UUID_C AS CONTRIBUTOR_CONTRIBUTOR_UUID_C, contributor.COUNTRY_TAX_TEXT_C AS CONTRIBUTOR_COUNTRY_TAX_TEXT_C, contributor.COUNTRY_OF_BIRTH_TEXT_C AS CONTRIBUTOR_COUNTRY_OF_BIRTH_TEXT_C, contributor.EU_PAYEE_NI_NUMBER_C AS CONTRIBUTOR_EU_PAYEE_NI_NUMBER_C, contributor.EU_PAYEE_VAT_NUMBER_C AS CONTRIBUTOR_EU_PAYEE_VAT_NUMBER_C, contributor.EU_TAX_ID_C AS CONTRIBUTOR_EU_TAX_ID_C, contributor.EARLIEST_TERM_END_DATE_RAL_C AS CONTRIBUTOR_EARLIEST_TERM_END_DATE_RAL_C, contributor.EMAIL_ADDRESS_C AS CONTRIBUTOR_EMAIL_ADDRESS_C, contributor.ENTITY_TEXT_C AS CONTRIBUTOR_ENTITY_TEXT_C, contributor.FAX_NUMBER_C AS CONTRIBUTOR_FAX_NUMBER_C, contributor.FOREIGN_PAYEE_TAX_IDENTIFICATION_NUMBER_C AS CONTRIBUTOR_FOREIGN_PAYEE_TAX_IDENTIFICATION_NUMBER_C, contributor.FORENAME_C AS CONTRIBUTOR_FORENAME_C, contributor.IPDA_IPN_C AS CONTRIBUTOR_IPDA_IPN_C, contributor.IN_COLLECTION_C AS CONTRIBUTOR_IN_COLLECTION_C, contributor.INSTRUMENTS_C AS CONTRIBUTOR_INSTRUMENTS_C, contributor.KNR_ACCOUNT_ID_C AS CONTRIBUTOR_KNR_ACCOUNT_ID_C, contributor.MAIDEN_NAME_C AS CONTRIBUTOR_MAIDEN_NAME_C, contributor.MAIN_MUSIC_GENRE_C AS CONTRIBUTOR_MAIN_MUSIC_GENRE_C, contributor.MAIN_OCCUPATION_C AS CONTRIBUTOR_MAIN_OCCUPATION_C, contributor.MIDDLE_NAME_1_C AS CONTRIBUTOR_MIDDLE_NAME_1_C, contributor.MIDDLE_NAME_2_C AS CONTRIBUTOR_MIDDLE_NAME_2_C, contributor.NAME_SUFFICE_C AS CONTRIBUTOR_NAME_SUFFICE_C, contributor.NAME_C AS CONTRIBUTOR_NAME_C, contributor.NOTICE_SERVE_DATE_C AS CONTRIBUTOR_NOTICE_SERVE_DATE_C, contributor.OA_ACCOUNT_ID_C AS CONTRIBUTOR_OA_ACCOUNT_ID_C, contributor.PAYEE_NAME_C AS CONTRIBUTOR_PAYEE_NAME_C, contributor.PHONE_NUMBER_C AS CONTRIBUTOR_PHONE_NUMBER_C, contributor.POST_COLLECTION_NOTES_C AS CONTRIBUTOR_POST_COLLECTION_NOTES_C, contributor.PREFIX_C AS CONTRIBUTOR_PREFIX_C, contributor.PRIMARY_ADDRESS_C AS CONTRIBUTOR_PRIMARY_ADDRESS_C, contributor.RELATIONSHIP_DESCRIPTION_C AS CONTRIBUTOR_RELATIONSHIP_DESCRIPTION_C, contributor.REPERTOIRE_OWNER_C AS CONTRIBUTOR_REPERTOIRE_OWNER_C, contributor.RESIDENCY_END_DATE_2_C AS CONTRIBUTOR_RESIDENCY_END_DATE_2_C, contributor.RESIDENCY_END_DATE_3_C AS CONTRIBUTOR_RESIDENCY_END_DATE_3_C, contributor.RESIDENCY_END_DATE_4_C AS CONTRIBUTOR_RESIDENCY_END_DATE_4_C, contributor.RESIDENCY_END_DATE_C AS CONTRIBUTOR_RESIDENCY_END_DATE_C, contributor.RESIDENCY_NOTES_2_C AS CONTRIBUTOR_RESIDENCY_NOTES_2_C, contributor.RESIDENCY_NOTES_3_C AS CONTRIBUTOR_RESIDENCY_NOTES_3_C, contributor.RESIDENCY_NOTES_4_C AS CONTRIBUTOR_RESIDENCY_NOTES_4_C, contributor.RESIDENCY_NOTES_C AS CONTRIBUTOR_RESIDENCY_NOTES_C, contributor.RESIDENCY_START_DATE_2_C AS CONTRIBUTOR_RESIDENCY_START_DATE_2_C, contributor.RESIDENCY_START_DATE_3_C AS CONTRIBUTOR_RESIDENCY_START_DATE_3_C, contributor.RESIDENCY_START_DATE_4_C AS CONTRIBUTOR_RESIDENCY_START_DATE_4_C, contributor.RESIDENCY_START_DATE_C AS CONTRIBUTOR_RESIDENCY_START_DATE_C, contributor.RESIDENCY_TERRITORY_2_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_2_TEXT_C, contributor.RESIDENCY_TERRITORY_3_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_3_TEXT_C, contributor.RESIDENCY_TERRITORY_4_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_4_TEXT_C, contributor.RESIDENCY_TERRITORY_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_TEXT_C, contributor.RIGHTS_START_DATE_C AS CONTRIBUTOR_RIGHTS_START_DATE_C, contributor.SOCIETY_C AS CONTRIBUTOR_SOCIETY_C, contributor.STATE_TAX_C AS CONTRIBUTOR_STATE_TAX_C, contributor.SUFFIX_C AS CONTRIBUTOR_SUFFIX_C, contributor.SURNAME_C AS CONTRIBUTOR_SURNAME_C, contributor.TAX_ADDRESS_C AS CONTRIBUTOR_TAX_ADDRESS_C, contributor.TAX_FORM_EXPIRY_DATE_C AS CONTRIBUTOR_TAX_FORM_EXPIRY_DATE_C, contributor.TERM_END_DATE_C AS CONTRIBUTOR_TERM_END_DATE_C, contributor.TERM_END_NOTE_C AS CONTRIBUTOR_TERM_END_NOTE_C, contributor.TERM_NOTE_C AS CONTRIBUTOR_TERM_NOTE_C, contributor.TERMINATED_C AS CONTRIBUTOR_TERMINATED_C, contributor.TERRITORY_OF_REPRESENTATION_C AS CONTRIBUTOR_TERRITORY_OF_REPRESENTATION_C, contributor.US_PAYEE_TAX_IDENTIFICATION_NUMBER_C AS CONTRIBUTOR_US_PAYEE_TAX_IDENTIFICATION_NUMBER_C, contributor.US_PAYEE_TAX_NAME_C AS CONTRIBUTOR_US_PAYEE_TAX_NAME_C, contributor.WEB_ADDRESS_C AS CONTRIBUTOR_WEB_ADDRESS_C, contributor.ZIP_POST_CODE_TAX_C AS CONTRIBUTOR_ZIP_POST_CODE_TAX_C, contributor._FIVETRAN_DELETED AS CONTRIBUTOR_FIVETRAN_DELETED, contributor._FIVETRAN_SYNCED AS CONTRIBUTOR_FIVETRAN_SYNCED, -- --- SOCIETY REGISTRATION TABLE (Prefix: SOCIETY_) --- society.ID AS SOCIETY_ID, society.IS_DELETED AS SOCIETY_IS_DELETED, society.NAME AS SOCIETY_NAME, society.CREATED_DATE AS SOCIETY_CREATED_DATE, society.CREATED_BY_ID AS SOCIETY_CREATED_BY_ID, society.LAST_MODIFIED_DATE AS SOCIETY_LAST_MODIFIED_DATE, society.LAST_MODIFIED_BY_ID AS SOCIETY_LAST_MODIFIED_BY_ID, society.SYSTEM_MODSTAMP AS SOCIETY_SYSTEM_MODSTAMP, society.LAST_VIEWED_DATE AS SOCIETY_LAST_VIEWED_DATE, society.LAST_REFERENCED_DATE AS SOCIETY_LAST_REFERENCED_DATE, society.CONTRIBUTOR_C AS SOCIETY_CONTRIBUTOR_C, society.STATUS_C AS SOCIETY_STATUS_C, society.DATE_C AS SOCIETY_DATE_C, society.NOTES_C AS SOCIETY_NOTES_C, society.SOCIETY_PERFORMER_ID_C AS SOCIETY_SOCIETY_PERFORMER_ID_C, society.CMM_ID_TEXT_C AS SOCIETY_CMM_ID_TEXT_C, society._FIVETRAN_DELETED AS SOCIETY_FIVETRAN_DELETED, society._FIVETRAN_SYNCED AS SOCIETY_FIVETRAN_SYNCED FROM BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.CONTRIBUTOR_C AS contributor LEFT JOIN BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.SOCIETY_C AS society ON contributor.ID = society.CONTRIBUTOR_C ;; ```