Billing Overview
Module: Customer Analytics
Type: Fact
BILL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BILL_ID | VARCHAR2 | 12 | True | Bill | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACCOUNTING_DT | NUMBER | 38 | 0 | Accounting Date | |||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| ADJ_AMT | NUMBER | 15 | 2 | Current Amount | |||
| APAY_AMT | NUMBER | 15 | 2 | Auto Pay Amount | |||
| APAY_CRE_DT | NUMBER | 38 | 0 | Auto Pay Creation Date | |||
| APAY_STOP_AMT | NUMBER | 15 | 2 | Auto Pay Stop Amount | |||
| APAY_STOP_CRE_DT | NUMBER | 38 | 0 | Auto Pay Stop Creation Date | |||
| APAY_STOP_DT | NUMBER | 38 | 0 | Auto Pay Stop Date | |||
| APAY_STOP_DTTM | TIMESTAMP | 0 | 6 | Auto Pay Stop Date/Time | |||
| APAY_STOP_TM | NUMBER | 38 | 0 | Auto Pay Stop Time | |||
| APAY_STOP_USER_ID | VARCHAR2 | 38 | Auto Pay Stop User Id | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| BILL_AMT | NUMBER | 15 | 2 | Bill Amount | |||
| BILL_CNT | NUMBER | 38 | 0 | Count | |||
| BILL_CYC_CD | VARCHAR2 | 38 | Bill Cycle | DW_EWB_X_EWDI_BASE_CI_BILL_CYC_D | BILL_CYC_CD | ||
| BILL_DT | NUMBER | 38 | 0 | Bill Date | |||
| BILL_EXCP_CNT | NUMBER | 10 | 0 | Bill Exceptions Count | |||
| BILL_STAT_FLG | VARCHAR2 | 2 | Bill Status | ||||
| BKT_COMPL_DAYS_IN_WIN_CD | VARCHAR2 | 38 | Completed in Billing Day Window Bucket | DW_EWC_X_EWDI_CUST_C1_BI_BILL_DAY_IN_WIN_VW | BKT_CONFIG_CD | ||
| BKT_COMPL_DAYS_IN_WIN_SEQ_NUM | NUMBER | 38 | 0 | Completed in Billing Day Window Bucket Seq | DW_EWC_X_EWDI_CUST_C1_BI_BILL_DAY_IN_WIN_VW | SEQ_NUM | |
| BKT_DAYS_WIN_CLOSES_CD | VARCHAR2 | 38 | Days Before Bill Window Closes Bucket | DW_EWC_X_EWDI_CUST_C1_BI_DAYS_B4_WIN_CLOSES_VW | BKT_CONFIG_CD | ||
| BKT_DAYS_WIN_CLOSES_SEQ_NUM | NUMBER | 38 | 0 | Days Before Bill Window Closes Bucket Seq | DW_EWC_X_EWDI_CUST_C1_BI_DAYS_B4_WIN_CLOSES_VW | SEQ_NUM | |
| BSEG_AMT | NUMBER | 15 | 2 | Bill Segments Amount | |||
| BSEG_EXCP_CNT | NUMBER | 10 | 0 | Bill Segment Exceptions Count | |||
| CANCELED_ADJ_CNT | NUMBER | 10 | 0 | Cancelled Adjustments Count | |||
| CANCELED_BSEG_CNT | NUMBER | 10 | 0 | Canceled Bill Segment Count | |||
| COMPLETED_BILL_CNT | NUMBER | 1 | 0 | Completed Bill Count | |||
| COMPLETED_OUTSIDE_WIN_IND | NUMBER | 1 | 0 | Completed Outside Window Indicator | |||
| COMPLETED_WITHIN_WIN_IND | NUMBER | 1 | 0 | Completed Within Window Indicator | |||
| COMPLETE_DT | NUMBER | 38 | 0 | Completion Date | |||
| COMPLETE_DTTM | TIMESTAMP | 0 | 6 | Completion Date/Time | |||
| COMPLETE_TM | NUMBER | 38 | 0 | Completion Time | |||
| CRE_DT | DATE | 0 | Creation Date | ||||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| CR_NOTE_IND | NUMBER | 1 | 0 | Credit Note Indicator | |||
| DAYS_COMPLETED_AFTER_WIN_END | NUMBER | 5 | 0 | Days Completed After Window Ended | |||
| DAYS_COMPLETED_AFTER_WIN_START | NUMBER | 5 | 0 | Days Completed After Window Started | |||
| DAYS_CREATED_AFTER_WIN_START | NUMBER | 5 | 0 | Days Created After Window Started | |||
| DUE_DT | NUMBER | 38 | 0 | Due Date | |||
| ERROR_BSEG_CNT | NUMBER | 10 | 0 | Errored Bill Segments Count | |||
| EST_BSEG_AMT | NUMBER | 15 | 2 | Estimated Bill Segments Amount | |||
| EST_BSEG_CNT | NUMBER | 10 | 0 | Estimated Bill Segments Count | |||
| FREEZABLE_BSEG_CNT | NUMBER | 10 | 0 | Freezable Bill Segments Count | |||
| FROZEN_ADJ_CNT | NUMBER | 10 | 0 | Frozen Adjustments Count | |||
| FROZEN_BSEG_CNT | NUMBER | 10 | 0 | Frozen Bill Segments Count | |||
| HIGH_BILL_CASE_CNT | NUMBER | 10 | 0 | High Bill Complaint Cases Count | |||
| INCOMPLETE_BSEG_CNT | NUMBER | 10 | 0 | Incomplete Bill Segments Count | |||
| LATE_PAYMT_CHARGE_SW | VARCHAR2 | 38 | |||||
| LATE_PAY_CHARGE_DT | NUMBER | 38 | 0 | Late Payment Charge Date | |||
| OFFCYC_BGEN_IND | NUMBER | 1 | 0 | Off Cycle Bill Generator Indicator | |||
| PENDING_BILL_CNT | NUMBER | 1 | 0 | Pending Bill Count | |||
| PEND_CANCEL_BSEG_CNT | NUMBER | 10 | 0 | Pending Cancel Bill Segments Count | |||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| WIN_END_DT | NUMBER | 38 | 0 | Window End Date | |||
| WIN_END_DT_DATE_ | DATE | 0 | |||||
| WIN_START_DT | NUMBER | 38 | 0 | Window Start Date | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |