Customer-Related Database Changes
This chapter provides lists of customer-related database changes in the 24C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
C1_BI_BILL_OVERVIEW
Billing Overview
Used to capture details about a customer’s billing information. Used with Oracle Utilities Analytics Visualization.
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
C1_BI_BILL_OVERVIEW
ACCOUNTING_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
ACCT_ID
CHAR
10
C1_BI_BILL_OVERVIEW
ADJ_AMT
NUMBER
15,2
C1_BI_BILL_OVERVIEW
APAY_AMT
NUMBER
15,2
C1_BI_BILL_OVERVIEW
APAY_CRE_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
APAY_STOP_AMT
NUMBER
15,2
C1_BI_BILL_OVERVIEW
APAY_STOP_CRE_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
APAY_STOP_DTTM
DTTM
26,0
C1_BI_BILL_OVERVIEW
APAY_STOP_USER_ID
CHAR
8
C1_BI_BILL_OVERVIEW
BILL_AMT
NUMBER
15,2
C1_BI_BILL_OVERVIEW
BILL_CNT
NUMBER
1,0
C1_BI_BILL_OVERVIEW
BILL_CYC_CD
CHAR
4
C1_BI_BILL_OVERVIEW
BILL_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
BILL_EXCP_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
BILL_EXCP_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
BILL_ID
CHAR
12
C1_BI_BILL_OVERVIEW
BILL_STAT_FLG
CHAR
2
C1_BI_BILL_OVERVIEW
BILL_WIN_OPEN_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
BKT_COMPL_DAYS_IN_WIN_CD
VARCHAR2
30
C1_BI_BILL_OVERVIEW
BKT_COMPL_DAYS_IN_WIN_SEQ_NUM
NUMBER
3,0
C1_BI_BILL_OVERVIEW
BKT_DAYS_WIN_CLOSES_CD
VARCHAR2
30
C1_BI_BILL_OVERVIEW
BKT_DAYS_WIN_CLOSES_SEQ_NUM
NUMBER
3,0
C1_BI_BILL_OVERVIEW
BSEG_AMT
NUMBER
15,2
C1_BI_BILL_OVERVIEW
BSEG_EXCP_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
BSEG_EXCP_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
CANCELED_ADJ_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
CANCELED_ADJ_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
CANCELED_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
CANCELED_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
COMPLETED_BILL_CNT
NUMBER
1,0
C1_BI_BILL_OVERVIEW
COMPLETED_OUTSIDE_WIN_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
COMPLETED_WITHIN_WIN_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
COMPLETE_DTTM
DTTM
26,0
C1_BI_BILL_OVERVIEW
CRE_DTTM
DTTM
26,0
C1_BI_BILL_OVERVIEW
CR_NOTE_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
DAYS_BEFORE_BILL_WIN_CLOSES
NUMBER
5,0
C1_BI_BILL_OVERVIEW
DAYS_COMPLETED_AFTER_WIN_END
NUMBER
5,0
C1_BI_BILL_OVERVIEW
DAYS_COMPLETED_AFTER_WIN_START
NUMBER
5,0
C1_BI_BILL_OVERVIEW
DAYS_CREATED_AFTER_WIN_START
NUMBER
5,0
C1_BI_BILL_OVERVIEW
DUE_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
ERRORED_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
ERROR_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
EST_BSEG_AMT
NUMBER
15,2
C1_BI_BILL_OVERVIEW
EST_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
EST_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
FREEZABLE_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
FREEZABLE_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
FROZEN_ADJ_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
FROZEN_ADJ_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
FROZEN_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
FROZEN_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
HIGH_BILL_CASE_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
HIGH_BILL_CASE_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
ILM_ARCH_SW
CHAR
1
C1_BI_BILL_OVERVIEW
ILM_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
INCOMPLETE_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
INCOMPLETE_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
IN_ERROR_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
LATE_PAY_CHARGE_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
LATE_PAY_CHARGE_SW
CHAR
1
C1_BI_BILL_OVERVIEW
OFFCYC_BGEN_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
PENDING_BILL_CNT
NUMBER
1,0
C1_BI_BILL_OVERVIEW
PEND_CANCEL_BSEG_CNT
NUMBER
10,0
C1_BI_BILL_OVERVIEW
PEND_CANCEL_BSEG_IND
NUMBER
1,0
C1_BI_BILL_OVERVIEW
PER_ID
CHAR
10
C1_BI_BILL_OVERVIEW
WIN_END_DT
DATE
10,0
C1_BI_BILL_OVERVIEW
WIN_START_DT
DATE
10,0
 
New Indexes
 
Table_Name
Index_Name
C1_BI_BILL_OVERVIEW
C1T168P0
CI_PAY
XT156S4