This article contains the details for all of the mapping views that are available in Luminate's Data Share.

Musical Recording <> Song

Summary

VW_MR_SONG_MAP_DS provides the mapping between Musical Recordings (ISRCs) and Songs.

Details

Field Name	Data Type	Details
`MR_ID`	`VARCHAR`	Unique Luminate ID associated to the Musical Recording.
`SONG_ID`	`VARCHAR`	Unique Luminate ID associated to the Song.
`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	Details
`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	Details
`MR_ID`	`VARCHAR`	Unique Luminate ID associated to the Musical Product.
`MP_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	Details
`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.

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	Details
`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.