Energy and Water Organization
Entity
Name: Energy and Water Organization
Instances of these organizations are all involved one way or another in the energy and water domain.
Details
- Industry Domain: Customer
- Relational Table Name: ORGANIZATION
- JSON View Name: ORGANIZATION#JSON
- Ontology Class: ewok:Organization
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object | 
|---|---|---|---|---|---|---|---|
| organization id | string | VARCHAR2 | ORGANIZATION_ID | Yes | Yes | Must match regex pattern | ewok:Organization | 
| organization name | string | VARCHAR2 | ORGANIZATION_NAME | ewok:Organization | |||
| us employer identification number | string | VARCHAR2 | US_EMPLOYER_IDENTIFICATION_NUMBER | core:USEmployerIdentificationNumber | |||
| primary email | string | VARCHAR2 | PRIMARY_EMAIL | Must match regex pattern | core:EmailAddress | ||
| primary email type | string | VARCHAR2 | PRIMARY_EMAIL_TYPE | Must match values in enumerated list from graph | core:AddressType_Email | ||
| primary telephone country code | double | NUMBER | PRIMARY_TELEPHONE_COUNTRY_CODE | core:TelephoneNumber | |||
| primary telephone number | double | NUMBER | PRIMARY_TELEPHONE_NUMBER | core:TelephoneNumber | |||
| primary telephone number type | string | VARCHAR2 | PRIMARY_TELEPHONE_NUMBER_TYPE | Must match values in enumerated list from graph | core:AddressType_Phone | ||
| mailing street address | string | VARCHAR2 | MAILING_STREET_ADDRESS | geo:StreetAddress | |||
| mailing address city | string | VARCHAR2 | MAILING_ADDRESS_CITY | geo:StreetAddress | |||
| mailing address postal code | string | VARCHAR2 | MAILING_ADDRESS_POSTAL_CODE | Must match regex pattern | geo:PostalCode | ||
| mailing address county | string | VARCHAR2 | MAILING_ADDRESS_COUNTY | geo:StreetAddress | |||
| mailing address region code | string | VARCHAR2 | MAILING_ADDRESS_REGION_CODE | Must match regex pattern | geo:Subterritory | ||
| mailing address country code | string | VARCHAR2 | MAILING_ADDRESS_COUNTRY_CODE | Must match values in enumerated list from graph | geo:Country | ||
| mailing street address type | string | VARCHAR2 | MAILING_STREET_ADDRESS_TYPE | Must match values in enumerated list from graph | core:AddressType_Physical | ||
| street address | string | VARCHAR2 | STREET_ADDRESS | geo:StreetAddress | |||
| city | string | VARCHAR2 | CITY | geo:StreetAddress | |||
| postal code | string | VARCHAR2 | POSTAL_CODE | Must match regex pattern | geo:PostalCode | ||
| address county | string | VARCHAR2 | ADDRESS_COUNTY | geo:StreetAddress | |||
| address region code | string | VARCHAR2 | ADDRESS_REGION_CODE | Must match regex pattern | geo:Subterritory | ||
| country code | string | VARCHAR2 | COUNTRY_CODE | Must match values in enumerated list from graph | geo:Country | ||
| street address type | string | VARCHAR2 | STREET_ADDRESS_TYPE | Must match values in enumerated list from graph | core:AddressType_Physical | ||
| eco friendly affinity | string | VARCHAR2 | ECO_FRIENDLY_AFFINITY | Must match values in enumerated list from graph | ewok:EcoFriendlyAffinity | ||
| residency type | string | VARCHAR2 | RESIDENCY_TYPE | Must match values in enumerated list from graph | core:ResidencyType |