--- updatedAt: 2026-08-18T23:53:58.000Z agentTools: projectIndex: https://docs.luminatedata.com/llms.txt --- # Mapping Data This article contains the details for all of the mapping views that are available in Luminate's Music Data Share. # Musical Recording <> Song ## Summary `VW_MR_SONG_MAP_V2_DS` provides the mapping between Musical Recordings (ISRCs) and Luminate or Billboard Songs. ## Details | Field Name | Data Type | Description | | --------------- | --------------- | ------------------------------------------------------------------------------------------ | | `MR_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Recording. | | `SONG_ID` | `VARCHAR` | Unique Luminate ID associated to the Song. | | `CLIENT_DOMAIN` | `VARCHAR` | Song definition according to Luminate or Billboard | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Musical Recording <> Musical Product ## Summary `VW_MR_MP_MAP_DS` provides the mapping between Musical Recordings (ISRCs) and Musical Products (barcodes). ## Details | Field Name | Data Type | Description | | ------------- | --------------- | ------------------------------------------------------------------------------------------ | | `MR_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Recording. | | `ISRC` | `VARCHAR` | ISRC associated to the Musical Recording. | | `MP_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Product. | | `ICPN` | `VARCHAR` | Barcode associated to the Musical Product. | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Musical Product <> Musical Release ## Summary `VW_MP_MREL_MAP_DS` provides the mapping between Musical Products (barcodes) and Musical Releases. ## Details | Field Name | Data Type | Description | | ------------- | --------------- | ------------------------------------------------------------------------------------------ | | `MP_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Product. | | `MREL_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Release. | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Musical Release <> Musical Release Group ## Summary `VW_MREL_MRELG_MAP_DS` provides the mapping between Musical Releases and Musical Release Groups (albums). ## Details | Field Name | Data Type | Description | | ------------- | --------------- | ------------------------------------------------------------------------------------------ | | `MREL_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Release. | | `MRELG_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Release Group. | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Song <> Musical Release Group ## Summary `VW_SONG_MRELG_MAP_DS` provides the mapping between Songs and Musical Release Groups (albums). ## Details | Field Name | Data Type | Description | | ------------- | --------------- | ------------------------------------------------------------------------------------------ | | `SONG_ID` | `VARCHAR` | Unique Luminate ID associated to the MSong | | `MRELG_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Release Group. | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Luminate <> Billboard Song `VW_LUMINATE_BB_SONG_MAP_DS` provides the mapping between Luminate Songs and Billboard Songs. | Field Name | Data Type | Description | | :----------------- | :-------------- | :----------------------------------------------------------------------------------------- | | `LUMINATE_SONG_ID` | `VARCHAR` | Unique Luminate ID associated to the Song | | `BB_SONG_ID` | `VARCHAR` | Unique Billboard ID associated to the Song | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Airplay Station <> Format ## Summary `VW_STATION_FORMAT_MAP_DS` provides the mapping between airplay station and supported airplay formats. Note: Station-to-format assignments are point-in-time, so the mapping can change depending on the timeframe that is being queried. Use the `REPORT_DATE` field to have the correct mapping information. Also, not all station IDs are mapped to a Format ID. Unmapped stations should be grouped into a generic format (e.g. "Others"). ## Details | Field Name | Data Type | Description | | ------------- | --------------- | ------------------------------------------------------------------------------------------ | | `STATION_ID` | `VARCHAR` | Unique ID assigned to the airplay station | | `FORMAT_ID` | `VARCHAR` | Unique ID assigned to the airplay format | | `REPORT_DATE` | `DATE` | The date the station was assigned to the corresponding airplay format | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database. | # Airplay CRG <> Song ## Summary `VW_SONG_AIRPLAY_FORMAT_DS` provides a C/R/G (current, re-current, gold) assignment to song IDs at a weekly level. These assignments are point-in-time and can vary between Billboard and Luminate's methodology. ## Details | Field Name | Data Type | Description | | :------------------ | :-------------- | :----------------------------------------------------------------------------------------------------- | | `SONG_ID` | `VARCHAR` | Unique Luminate ID associated to the Song | | `FORMAT_ID` | `VARCHAR` | Unique ID assigned to the airplay format | | `CRG` | `VARCHAR` | Field that indicates the Current, Re-current, or Gold status for the corresponding Song ID and Week ID | | `CRG_CLIENT_DOMAIN` | `VARCHAR` | CRG assignment as defined by Luminate or Billboard | | `WEEK_ID` | `NUMBER` | ID of chart week in YYYYWW format | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database | # Rights <> IDs ## Summary `VW_RIGHT_HOLDER_DS` will provide a mapping of rights holders to Musical Recording and Musical Product IDs. ## Details | Field Name | Data Type | Description | | :--------------------- | :-------------- | :------------------------------------------------------------------------------------------------------------------------ | | `BUSINESS_UNIT_ID` | `VARCHAR` | Unique ID associated to the Business Unit | | `BUSINESS_UNIT_NAME` | `VARCHAR` | Name corresponding to the Business Unit ID | | `BUSINESS_UNIT_ROLE` | `VARCHAR` | Role of the Business Unit | | `ENTITY_ID` | `VARCHAR` | Luminate ID associated to the claimed entity | | `ENTITY_TYPE` | `VARCHAR` | Indicates the type of entity (MR, MP) associated to the musical right | | `COUNTRY_CODE` | `VARCHAR` | Location in which the right is active | | `DISTRIBUTION_CHANNEL` | `VARCHAR` | The distribution channel attribute represents the channel by which the recording or product was distributed to the market | | `START_DATE` | `DATE` | The first date in which the right was valid | | `END_DATE` | `DATE` | The last date in which the right was valid | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database | # Musical Recording <> Musical Work ## Summary `VW_MR_MW_MAP_DS` provides the mapping between Musical Recordings (ISRCs) and Musical Works (ISWCs). ## Details | Field Name | Data Type | Description | | ------------------ | --------------- | ----------------------------------------------------------------------------------------- | | `MR_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Recording | | `ISRC` | `VARCHAR` | International Standard Recording Code associated to the Musical Recording | | `MW_ID` | `VARCHAR` | Unique Luminate ID associated to the Musical Work | | `ISWC` | `VARCHAR` | International Standard Work Code associated to the Musical Work | | `CONFIDENCE_SCORE` | `NUMBER` | Score (0-100) that rates the accuracy of the MR - MW mapping | | `MODIFIED_AT` | `TIMESTAMP_NTZ` | A timestamp that indicates when the record was last modified within the Luminate database |