Organization

---

Entity

Name: 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:EcoFriendlyAffinityType
residency type	string	VARCHAR2	RESIDENCY_TYPE			Must match values in enumerated list from graph	core:ResidencyType
naics code	string	VARCHAR2	NAICS_CODE			Must match values in enumerated list from graph	core:NAICSCode
sic code	string	VARCHAR2	SIC_CODE				ewok:Organization
possesses solar pv	boolean	BOOLEAN	POSSESSES_SOLAR_PV				ewok:Organization
possesses electric vehicle	boolean	BOOLEAN	POSSESSES_ELECTRIC_VEHICLE				ewok:Organization