# View: sony_applications_data_submit

**View Name:** sony_applications_data_submit
**Table Source:** `Derived from: Prod.Audit_Event_Gda_Submit_Application`
**File Path:** `DOSC/Community_Support/applications_data/views/sony_applications_data_submit.view.lkml`

## Overview

- **File Size:** 4761 bytes
- **Lines of Code:** 196
- **Dimensions:** 28
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `AmazonMusicUrl` | string |
| `Company` | string |
| `CorrelationId` | string |
| `Country` | string |
| `Currency` | string |
| `DeezerFans` | number |
| `DeezerUrl` | string |
| `Email` | string |
| `ExistingLabelParticipants` | string |
| `ExternalTest` | string |
| `FacebookFollowers` | number |
| `FacebookUrl` | string |
| `FirstName` | string |
| `InstagramFollowers` | number |
| `InstagramUrl` | string |
| `Language` | string |
| `LastName` | string |
| `OtherUrl` | string |
| `RecordTypeId` | string |
| `Role` | string |
| `SigningEntity` | string |
| `SoundcloudUrl` | string |
| `SpotifyUrl` | string |
| `TiktokUrl` | string |
| `TwitterUrl` | string |
| `VoucherCode` | string |
| `VoucherCodeOwner` | string |
| `YoutubeUrl` | string |

## Derived Table

```sql
sql:
      select
        replace(record_content:AmazonMusicUrl__c, '"', '') AS AmazonMusicUrl,
        replace(record_content:Company, '"', '') AS Company,
        replace(record_content:CorrelationId__c, '"', '') AS CorrelationId,
        replace(record_content:Country, '"', '') AS Country,
        replace(record_content:Currency__c, '"', '') AS Currency,
        replace(record_content:DeezerUrl__c, '"', '') AS DeezerUrl,
        replace(record_content:Email, '"', '') AS Email,
        replace(record_content:FacebookUrl__c, '"', '') AS FacebookUrl,
        replace(record_content:FirstName, '"', '') AS FirstName,
        replace(record_content:InstagramUrl__c, '"', '') AS InstagramUrl,
        replace(record_content:Language__c, '"', '') AS Language,
        replace(record_content:LastName, '"', '') AS LastName,
        replace(record_content:OtherUrl__c, '"', '') AS OtherUrl,
        replace(record_content:RecordTypeId, '"', '') AS RecordTypeId,
        replace(record_content:Role__c, '"', '') AS Role,
        replace(record_content:SigningEntity__c, '"', '') AS SigningEntity,
        replace(record_content:SoundcloudUrl__c, '"', '') AS SoundcloudUrl,
        replace(record_content:SpotifyUrl__c, '"', '') AS SpotifyUrl,
        replace(record_content:TiktokUrl__c, '"', '') AS TikTokUrl,
        replace(record_content:TwitterUrl__c, '"', '') AS TwitterUrl,
        replace(record_content:VoucherCode__c, '"', '') AS VoucherCode,
        replace(record_content:VoucherCodeOwner__c, '"', '') AS VoucherCodeOwner,
        replace(record_content:YoutubeUrl__c, '"', '') AS YouTubeUrl
      FROM
        FACTS.PROD.AUDIT_EVENT_GDA_SUBMIT_APPLICATION;;
```