Person

Entity

Name: Person

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

Details

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 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 core:SocialSecurityNumber
driver license string VARCHAR2 DRIVER_LICENSE       core:DriverLicenseID
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
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 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 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 core:AddressType_Physical
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:EcoFriendlyAffinity
residency type string VARCHAR2 RESIDENCY_TYPE     Must match values in enumerated list from graph core:ResidencyType