DW_EWDV_X_EWDI_DVC_X1_BI_USG_EXCEPTION_VW

Usage Exceptions

Details

Module: Device Analytics

Type: Fact

Key Columns

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
MDM_SP_ID VARCHAR2 38 MDM Service Point DW_EWB_X_EWDI_BASE_D1_SP_D D1_SP_ID
USAGE_EXCP_ID VARCHAR2 14 Usage Transaction Exception
SOURCE_RECORD_ID VARCHAR2 53 Source Record Id
CCB_ACC_ID VARCHAR2 38 Account DW_EWB_X_EWDI_BASE_CI_ACCT_D ACCT_ID
CCB_BILL_CYC_CD VARCHAR2 38 CCB Bill Cycle DW_EWB_X_EWDI_BASE_CI_BILL_CYC_D BILL_CYC_CD
CCB_SP_ID VARCHAR2 38 CCB Service Point
CUSTOMER_NAME VARCHAR2 254 Customer Name
D1_USAGE_ID VARCHAR2 14 Usage Transaction DW_EWDV_X_EWDI_DVC_D1_USAGE_D D1_USAGE_ID
EXCP_CRE_DT NUMBER 38 0 Exception Creation Date
EXCP_CRE_DTTM TIMESTAMP 0 6 Exception Creation Date/Time
EXCP_CRE_TM NUMBER 38 0 Exception Creation Time
EXCP_SEVERITY_FLG VARCHAR2 4 Exception Severity
EXCP_STATUS_DT NUMBER 38 0 Exception Status Update Date
EXCP_STATUS_TM NUMBER 38 0 Exception Status Update Time
MESSAGE_CAT_NBR NUMBER 5 0 Message Category DW_EWB_X_EWDI_BASE_CI_MSG_D MESSAGE_CAT_NBR
OPEN_CLOSE_FLG VARCHAR2 4 Exception Status
PER_ID VARCHAR2 38 Person DW_EWB_X_EWDI_BASE_CI_PER_D PER_ID
PREM_ID VARCHAR2 38 Premise DW_EWB_X_EWDI_BASE_CI_PREM_D PREM_ID
SA_ID VARCHAR2 38 Service Agreement DW_EWB_X_EWDI_BASE_CI_SA_D SA_ID
SA_TYPE_CD VARCHAR2 38 SA Type
TD_ENTRY_ID VARCHAR2 2 To Do DW_EWDV_X_EWDI_DVC_CI_TD_ENTRY_D TD_ENTRY_ID
TD_TYPE_CD VARCHAR2 2 To Do Type
USG_EXCP_MESSAGE_NBR NUMBER 5 0 Message DW_EWB_X_EWDI_BASE_CI_MSG_D MESSAGE_TXT
USG_EXCP_TYPE_CD VARCHAR2 30 Usage Exception Type DW_EWDV_X_EWDI_DVC_D1_USAGE_EXCP_TYPE_D USAGE_EXCP_TYPE_CD
USG_GRP_CD VARCHAR2 30 Calculation Group DW_EWDV_X_EWDI_DVC_D1_USG_RULE_D USG_GRP_CD
USG_RULE_CD VARCHAR2 30 Calculation Rule DW_EWDV_X_EWDI_DVC_D1_USG_RULE_D USG_RULE_CD
US_ID VARCHAR2 38 Usage Subscription DW_EWB_X_EWDI_BASE_D1_US_D US_ID
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6