Stores addresses from installation records and customer information uploads
Grain: One row per unique address
| Column | Business Name | Data Type | Nullable | Description |
|---|---|---|---|---|
| ADDRESSID | Address Identifier | NUMBER(10,0) | No | Unique identifier assigned to each address record. |
| ADDRESSLINE1 | Address Line 1 | NVARCHAR2(200) | Yes | Primary street address line. |
| ADDRESSLINE2 | nan | NVARCHAR2(100) | Yes | nan |
| ADDRESSLINE3 | nan | NVARCHAR2(100) | Yes | nan |
| CITY | City | NVARCHAR2(56) | Yes | City name associated with the address. |
| STATE | nan | NVARCHAR2(40) | Yes | nan |
| ZIP | nan | NVARCHAR2(100) | Yes | nan |