# View: sony_applications_data_unqualified

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

## Overview

- **File Size:** 2680 bytes
- **Lines of Code:** 114
- **Dimensions:** 13
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Company` | string |
| `Consultant` | string |
| `Country` | string |
| `Email` | string |
| `FirstName` | string |
| `Id` | string |
| `LastName` | string |
| `LeadScore` | string |
| `OwnerEmail` | string |
| `OwnerFirstName` | string |
| `OwnerLastName` | string |
| `VoucherCode` | string |
| `VoucherCodeOwner` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `CreatedDate` | time |

## Derived Table

```sql
sql:
      select
        replace(record_content:Company, '"', '') AS Company,
        replace(record_content:Consultant__c, '"', '') AS Consultant,
        replace(record_content:Country, '"', '') AS Country,
        split_part(replace(record_content:CreatedDate, '"', ''), '+', 1) AS CreatedDate,
        replace(record_content:Email, '"', '') AS Email,
        replace(record_content:FirstName, '"', '') AS FirstName,
        replace(record_content:Id, '"', '') AS Id,
        replace(record_content:LastName, '"', '') AS LastName,
        replace(record_content:LeadScore__c, '"', '') AS LeadScore,
        replace(record_content:Owner:OwnerEmail, '"', '') AS OwnerEmail,
        replace(record_content:Owner:OwnerFirstName, '"', '') AS OwnerFirstName,
        replace(record_content:Owner:OwnerLastName, '"', '') AS OwnerLastName,
        replace(record_content:VoucherCode__c, '"', '') AS VoucherCode,
        replace(record_content:VoucherCodeOwner__c, '"', '') AS VoucherCodeOwner

      FROM
        FACTS.PROD.AUDIT_EVENT_GDA_UNQUALIFIED_LEADS;;
```