# View: phonofile_validation_view

**View Name:** phonofile_validation_view
**Table Source:** `Derived from: Dev.Validation_View`
**File Path:** `phonofile_validation_view.view.lkml`

## Overview

- **File Size:** 3557 bytes
- **Lines of Code:** 198
- **Dimensions:** 27
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- " = '' then 0 else to_number("Vol#") end,
- " = '' then 0 else to_number("Trk#") end

## Dimensions

| Name | Type |
|------|------|
| `date` | date |
| `issue_type` | string |
| `company` | number |
| `company_nm` | string |
| `subaccount_nm` | string |
| `display_artist` | string |
| `title` | string |
| `title_version` | string |
| `release_id` | number |
| `upc` | string |
| `product_code` | string |
| `genre` | string |
| `release_dt` | date |
| `active` | string |
| `vol_num` | string |
| `trk_num` | string |
| `isrc` | string |
| `trk_artist` | string |
| `trk_title` | string |
| `trk_ver` | string |
| `trk_id` | string |
| `original_value1` | string |
| `original_value2` | string |
| `taken_from_value` | string |
| `suggested_value1` | string |
| `suggested_value2` | string |
| `notes` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql: SELECT * FROM PHONOFILE.DEV.VALIDATION_VIEW
    ORDER BY "Issue Type" asc, "Company Nm" asc, "Subaccount Nm" asc, "Display Artist" asc, "Title" asc, "UPC" asc,
    CASE When "Vol#" = '' then 0 else to_number("Vol#") end,
    CASE When "Trk#" = '' then 0 else to_number("Trk#") end
      ;;
```