Energy & Water Organization
Entity
Name: Energy & 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 |