# View: awal_orch_app_ar_releases

**View Name:** awal_orch_app_ar_releases
**Table Source:** `orchard_app_reporting_v2.art_relations_prod_art_relations.releases`
**File Path:** `DOSC/Financial_Team/awal_summary_streams_separation/views/awal_orch_app_ar_releases.view.lkml`

## Overview

- **File Size:** 8538 bytes
- **Lines of Code:** 342
- **Dimensions:** 39
- **Measures:** 5
- **Dimension Groups:** 5
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `artist_id` | number |
| `subaccount_id` | number |
| `project_id` | number |
| `distribution_format_id` | number |
| `release_genre_id` | number |
| `product_type_id` | number |
| `product_code` | string |
| `p_line` | string |
| `upc` | string |
| `display_upc` | string |
| `manufacturer_upc` | string |
| `release_name` | string |
| `release_title` | string |
| `format` | string |
| `vendor_catalog_number` | string |
| `status` | string |
| `is_deleted` | yesno |
| `not_for_distribution` | string |
| `is_nfd` | yesno |
| `is_active` | yesno |
| `imprint_name` | string |
| `catalog_type` | string |
| `ingestion_type` | string |
| `c_line` | string |
| `deletions` | string |
| `meta_language` | string |
| `new_release_category` | string |
| `delivered_version` | string |
| `version` | string |
| `special_instructions` | string |
| `upc_link` | string |
| `upc_album_art` | string |
| `upc_album_art_expand` | string |
| `upc_linked_image` | string |
| `last_updated_date` | date |
| `compilation` | string |
| `oa_link` | string |
| `physical_release_date` | date |

## Measures

| Name | Type |
|------|------|
| `latest_release_date` | date |
| `first_release_date` | date |
| `first_sales_date` | date |
| `number_of_releases` | count_distinct |
| `number_of_releases_in_label_copy` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `ingestion_completed` | time |
| `release` | time |
| `debut_chart_week` | time |
| `sale_start` | time |
| `preorder` | time |