# View: citizenship_and_residency

**View Name:** citizenship_and_residency
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `views/citizenship_and_residency.view.lkml`

## Overview

- **File Size:** 2332 bytes
- **Lines of Code:** 125
- **Dimensions:** 19
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `ID` | string |
| `Client_Name` | string |
| `US_TAX_NUMBER` | number |
| `TAX_ID_NUMBER` | string |
| `First_Name` | string |
| `Last_Name` | string |
| `Middle_Name_1` | string |
| `Middle_Name_2` | string |
| `Full_Name` | string |
| `Citizenship` | string |
| `Address_1` | string |
| `Address_2` | string |
| `Address_3` | string |
| `Address_4` | string |
| `Address_5` | string |
| `Address_6` | string |
| `US_CITY` | string |
| `US_ZIPCODE` | string |
| `Country` | string |

## Derived Table

```sql
sql:
    SELECT
    IP.ID,
    IP.NAME AS CLIENT_NAME,
    IP.US_PAYEE_TAX_ID_NUMBER,
    IP.FOREIGN_PAYEE_TAX_ID_NUMBER,
    IP.PERSON_FORENAME,
    IP.PERSON_SURNAME,
    IP.PERSON_MIDDLE_1,
    IP.PERSON_MIDDLE_2,
    IP.PERSON_NATIONALITY,
    IPA.ADDRESS_1,
    IPA.ADDRESS_2,
    IPA.ADDRESS_3,
    IPA.ADDRESS_4,
    IPA.ADDRESS_5,
    IPA.ADDRESS_6,
    IPA.US_CITY,
    IPA.US_ZIPCODE,
    T.NAME AS Country
    FROM "AWAL_SAX"."SAX"."INTERESTED_PARTIES" IP
    JOIN "AWAL_SAX"."SAX"."IP_ADDRESSES" IPA ON IP.PRIMARY_ADDRESS_ID = IPA.ID
    JOIN "AWAL_SAX"."SAX"."TERRITORIES" T ON IPA.COUNTRY_ID = T.ID;;
```