DW_EWA_X_EWDI_AMI_A1_FACILITY_USAGE_F

Facility Usage

Details

Module: Device Analytics

Type: Fact

Key Columns

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
D1_UOM_CD VARCHAR2 30 Unit of Measure DW_EWA_X_EWDI_AMI_CI_UOM_D UOM_CD
FACILITY_ID VARCHAR2 14 Facility DW_EWB_X_EWDI_BASE_D1_FACILITY_D FACILITY_ID
MSRMT_DT NUMBER 38 0 Measurement Date
MSRMT_TM NUMBER 38 0 Measurement Time
SOURCE_RECORD_ID VARCHAR2 123 Source Record Id
FACILITY_USAGE NUMBER 16 6 Facility Usage
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6