DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_PII

Personally Identifiable Information (PII)

Details

Module: Customer Insights

Type: Dimension

Key Columns

ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ID NUMBER 38 0 True Record Identifier
SOURCE_RECORD_ID VARCHAR2 38 Source Record Id
ACCOUNT_NUMBER VARCHAR2 128 Account Number
EMAIL VARCHAR2 196 Email
FIRST_NAME VARCHAR2 196 First Name
FULL_NAME VARCHAR2 196 Full Name
LAST_NAME VARCHAR2 196 Last Name
MAILING_ADDRESS VARCHAR2 256 Mailing Address
MAIL_CITY VARCHAR2 196 Mail City
MAIL_STATE VARCHAR2 196 Mail State
MAIL_STREET VARCHAR2 196 Mail Street
MAIL_ZIP VARCHAR2 196 Mail Zip
PHONE_SMS VARCHAR2 128 Phone Sms
PHONE_VOICE VARCHAR2 128 Phone Voice
PREMISE_ID VARCHAR2 196 Premise Id
SITE_ADDRESS VARCHAR2 256 Site Address
SITE_CITY VARCHAR2 196 Site City
SITE_COUNTRY VARCHAR2 196 Site Country
SITE_LATITUDE NUMBER 38 0 Site Latitude
SITE_LONGITUDE NUMBER 38 0 Site Longitude
SITE_STATE VARCHAR2 196 Site State
SITE_STREET VARCHAR2 196 Site Street
SITE_ZIP VARCHAR2 196 Site Zip
UTILITY_CODE VARCHAR2 20
UTIL_CUSTOMER_ID VARCHAR2 128 Util Customer ID
UTIL_INTERNAL_ID VARCHAR2 128 Util Internal ID
UTIL_INTERNAL_ID_2 VARCHAR2 128 Util Internal ID 2
UTIL_SERVICE_POINT_ID VARCHAR2 128 Util Service Point ID
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6