Person

Entity

Name: Person

A human being that has attributes unique to the energy and water domain.

Details

Table: Properties

Name General Data Type Oracle Data Type Relational Column Required? Primary Key? Validations Related Graph Object
person id string VARCHAR2 PERSON_ID Yes Yes Must match regex pattern: ^\S{1,}$ ewok:Person
first name string VARCHAR2 FIRST_NAME       ewok:Person
middle name string VARCHAR2 MIDDLE_NAME       ewok:Person
last name string VARCHAR2 LAST_NAME       ewok:Person
name prefix string VARCHAR2 NAME_PREFIX       ewok:Person
name suffix string VARCHAR2 NAME_SUFFIX       ewok:Person
ssn string VARCHAR2 SSN     Must match regex pattern: \d{9} core:SocialSecurityNumber
driver license string VARCHAR2 DRIVER_LICENSE       core:DriverLicenseID
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
language preference string VARCHAR2 LANGUAGE_PREFERENCE     Must match values in enumerated list from graph core:LanguagePreference
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
home street address string VARCHAR2 HOME_STREET_ADDRESS       geo:StreetAddress
home address city string VARCHAR2 HOME_ADDRESS_CITY       geo:StreetAddress
home address postal code string VARCHAR2 HOME_ADDRESS_POSTAL_CODE     Must match regex pattern: [A-Z]{2}-\S{1,} geo:PostalCode
home address county string VARCHAR2 HOME_ADDRESS_COUNTY       geo:StreetAddress
home address region code string VARCHAR2 HOME_ADDRESS_REGION_CODE     Must match regex pattern: [A-Z]{2}-[A-Z]{2} geo:Subterritory
home address country code string VARCHAR2 HOME_ADDRESS_COUNTRY_CODE     Must match values in enumerated list from graph geo:Country
home street address type string VARCHAR2 HOME_STREET_ADDRESS_TYPE     Must match values in enumerated list from graph geo:PhysicalAddressType
birth date dateTime DATE BIRTH_DATE       ewok:Person
income range bottom double NUMBER INCOME_RANGE_BOTTOM       ewok:Person
income range top double NUMBER INCOME_RANGE_TOP       ewok:Person
number of adults in household integer NUMBER NUMBER_OF_ADULTS_IN_HOUSEHOLD       ewok:Person
number of children in household integer NUMBER NUMBER_OF_CHILDREN_IN_HOUSEHOLD       ewok:Person
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
possesses solar pv boolean BOOLEAN POSSESSES_SOLAR_PV       ewok:Person
possesses electric vehicle boolean BOOLEAN POSSESSES_ELECTRIC_VEHICLE       ewok:Person