DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_LOAD_ARCHETYPE_OVERALL_ELEC

AMI Load Curve Archetype

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
CENTROID_INDEX NUMBER 38 0 Centroid Index
EVENING_USER VARCHAR2 50 Evening user
FLAT_USER VARCHAR2 50 Flat user
HOME_DURING_DAY VARCHAR2 50 Home during day
LATE_BEDTIME VARCHAR2 50 Late bedtime
MIDDAY_USER VARCHAR2 50 Midday user
MORNING_USER VARCHAR2 50 Morning user
OVERNIGHT_USER VARCHAR2 50 Overnight user
USAGE_ARCHETYPE VARCHAR2 50 Usage Archetype
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6