Organization

Entity

Name: Organization

An organization involved one way or another with the energy sector.

Details

Table: 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: ^\S{1,}$ 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: ^[a-zA-Z0-9_.'+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+$ 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: [A-Z]{2}-\S{1,} 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: [A-Z]{2}-[A-Z]{2} 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 geo:PhysicalAddressType
street address string VARCHAR2 STREET_ADDRESS       geo:StreetAddress
city string VARCHAR2 CITY       geo:StreetAddress
postal code string VARCHAR2 POSTAL_CODE     Must match regex pattern: [A-Z]{2}-\S{1,} geo:PostalCode
address county string VARCHAR2 ADDRESS_COUNTY       geo:StreetAddress
address region code string VARCHAR2 ADDRESS_REGION_CODE     Must match regex pattern: [A-Z]{2}-[A-Z]{2} 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 geo:PhysicalAddressType
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