Customer Care and Billing Database Changes
This chapter provides lists of database changes in the 25.4 release of Oracle Utilities Customer Care and Billing included with the 25.4 release of Oracle Utilities Customer to Meter. It includes:
New Tables
 
Table
Name
Description
C1_COLL_PROC_ARS_HIST
Collection Process Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for collection processes.
C1_COLL_PROC_SA_ARS_HIST
Collection Process SA Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for collection processes.
C1_OD_PROC_ARS_HIST
Overdue Process Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for overdue processes.
C1_SEV_PROC_ARS_HIST
Severance Process Arrears History
Used to capture a history of arrears amounts and cancellation thresholds for severance processes.
C1_BI_BILL_OVERVIEW
Billing Overview
Used to capture details about a customer’s billing information. Used with Oracle Utilities Analytics Visualization.
C1_OUTAGE_EVT
Outage Event
Used to capture outage events
C1_OUTAGE_EVT_CHAR
Outage Event Characteristics
Used to store characteristic values related to outage events
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
C1_CS_REQ_TYPE_REL_UPD
REL_UPD_RESPONSE_VALUE
VARC
254
C1_CS_REQ_TYPE_REL_UPD
UPDATE_VALUE
VARC
254
CI_RS_L
DESCRLONG
VARCHAR
4000
C1_COLL_PROC_ARS_HIST
ARS_AMT
NUMB
15,2
C1_COLL_PROC_ARS_HIST
ARS_HIST_TYPE_FLG
CHAR
4
C1_COLL_PROC_ARS_HIST
BO_XML_DATA_AREA
XML
1073741824
C1_COLL_PROC_ARS_HIST
BUS_OBJ_CD
CHAR
30
C1_COLL_PROC_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_COLL_PROC_ARS_HIST
COLL_PROC_ID
CHAR
10
C1_COLL_PROC_ARS_HIST
CRE_DTTM
DTTM
26
C1_COLL_PROC_ARS_HIST
DEBT_CLASS_SW
CHAR
1
C1_COLL_PROC_ARS_HIST
ILM_ARCH_SW
CHAR
1
C1_COLL_PROC_ARS_HIST
ILM_DT
DATE
10
C1_COLL_PROC_ARS_HIST
SEQNO
NUMB
5,0
C1_COLL_PROC_ARS_HIST
UNADJ_ARS_AMT
NUMB
15,2
C1_COLL_PROC_ARS_HIST
VERSION
NUMB
5,2
C1_COLL_PROC_SA_ARS_HIST
ARS_AMT
NUMB
15,2
C1_COLL_PROC_SA_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_COLL_PROC_SA_ARS_HIST
COLL_PROC_ID
CHAR
10
C1_COLL_PROC_SA_ARS_HIST
SA_ID
CHAR
10
C1_COLL_PROC_SA_ARS_HIST
SEQNO
NUMB
5,0
C1_COLL_PROC_SA_ARS_HIST
VERSION
NUMB
5,0
C1_OD_PROC_ARS_HIST
ARS_AMT
NUMB
15,2
C1_OD_PROC_ARS_HIST
ARS_AMT_INDT_SW
CHAR
1
C1_OD_PROC_ARS_HIST
ARS_HIST_TYPE_FLG
CHAR
4
C1_OD_PROC_ARS_HIST
BO_XML_DATA_AREA
XML
1073741824
C1_OD_PROC_ARS_HIST
BUS_OBJ_CD
CHAR
30
C1_OD_PROC_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_OD_PROC_ARS_HIST
CRE_DTTM
DTTM
26
C1_OD_PROC_ARS_HIST
ILM_ARCH_SW
CHAR
1
C1_OD_PROC_ARS_HIST
ILM_DT
DATE
10
C1_OD_PROC_ARS_HIST
OD_PROC_ID
CHAR
12
C1_OD_PROC_ARS_HIST
SEQNO
NUMB
5,0
C1_OD_PROC_ARS_HIST
VERSION
NUMB
5,0
C1_RC_CALC_LN_GTT
C1_PERCENTAGE
NUMB
11,8
C1_RC_CALC_LN_GTT
C1_UNIT_PRICE
NUMB
19,8
C1_RC_CALC_LN_GTT
CHARGE
NUMB
19,8
C1_RC_CALC_LN_GTT
SEASON_END_DT
DATE
10
C1_RC_CALC_LN_GTT
SEASON_START_DT
DATE
10
C1_RC_CALC_LN_GTT
STEP_SQ_HIGH_VAL
NUMB
18,4
C1_RC_CALC_LN_GTT
STEP_SQ_LOW_VAL
NUMB
18,4
C1_RC_CALC_LN_GTT
STEP_SQ_SEQ
NUMB
5,0
C1_RC_CALC_LN_GTT
VAL_PERIOD_END_DT
DATE
10
C1_RC_CALC_LN_GTT
VAL_PERIOD_START_DT
DATE
10
C1_SEV_PROC_ARS_HIST
ARS_AMT
NUMB
15,2
C1_SEV_PROC_ARS_HIST
ARS_HIST_TYPE_FLG
CHAR
4
C1_SEV_PROC_ARS_HIST
BO_XML_DATA_AREA
XML
1073741824
C1_SEV_PROC_ARS_HIST
BUS_OBJ_CD
CHAR
30
C1_SEV_PROC_ARS_HIST
CAN_THR_AMT
NUMB
15,2
C1_SEV_PROC_ARS_HIST
CRE_DTTM
DTTM
26
C1_SEV_PROC_ARS_HIST
DEBT_CLASS_SW
CHAR
1
C1_SEV_PROC_ARS_HIST
ILM_ARCH_SW
CHAR
1
C1_SEV_PROC_ARS_HIST
ILM_DT
DATE
10
C1_SEV_PROC_ARS_HIST
SEQNO
NUMB
5,0
C1_SEV_PROC_ARS_HIST
SEV_PROC_ID
CHAR
10
C1_SEV_PROC_ARS_HIST
UNADJ_ARS_AMT
NUMB
15,2
C1_SEV_PROC_ARS_HIST
VERSION
NUMB
5,0
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
C1_OUTAGE_EVT
BO_STATUS_CD
CHAR
12
C1_OUTAGE_EVT
BO_XML_DATA_AREA
XML
1073741824
C1_OUTAGE_EVT
BUS_OBJ_CD
CHAR
30
C1_OUTAGE_EVT
EXT_EVENT_ID
VARC
254
C1_OUTAGE_EVT
ILM_ARCH_SW
CHAR
1
C1_OUTAGE_EVT
ILM_DT
DATE
10
C1_OUTAGE_EVT
IMP_CUST_NBR
NUMB
9,0
C1_OUTAGE_EVT
MESSAGE_REF
VARC
254
C1_OUTAGE_EVT
NT_XID_CD
CHAR
30
C1_OUTAGE_EVT
OTG_END_DTTM
DTTM
26
C1_OUTAGE_EVT
OTG_ERT_DTTM
DTTM
26
C1_OUTAGE_EVT
OTG_EVENT_ID
CHAR
14
C1_OUTAGE_EVT
OTG_START_DTTM
DTTM
26
C1_OUTAGE_EVT
OTG_TYPE_FLG
CHAR
4
C1_OUTAGE_EVT
UPD_DTTM
DTTM
26
C1_OUTAGE_EVT
VERSION
NUMB
5,0
C1_OUTAGE_EVT_CHAR
ADHOC_CHAR_VAL
VARC
254
C1_OUTAGE_EVT_CHAR
CHAR_TYPE_CD
CHAR
8
C1_OUTAGE_EVT_CHAR
CHAR_VAL
CHAR
16
C1_OUTAGE_EVT_CHAR
CHAR_VAL_FK1
VARC
50
C1_OUTAGE_EVT_CHAR
CHAR_VAL_FK2
VARC
50
C1_OUTAGE_EVT_CHAR
CHAR_VAL_FK3
VARC
50
C1_OUTAGE_EVT_CHAR
CHAR_VAL_FK4
VARC
50
C1_OUTAGE_EVT_CHAR
CHAR_VAL_FK5
VARC
50
C1_OUTAGE_EVT_CHAR
OTG_EVENT_ID
CHAR
14
C1_OUTAGE_EVT_CHAR
SEQ_NUM
NUMB
3,0
C1_OUTAGE_EVT_CHAR
SRCH_CHAR_VAL
VARC
50
C1_OUTAGE_EVT_CHAR
VERSION
NUMB
5,0
CI_CC
CC_SRC_FLG
CHAR
4
CI_CC
CC_SUMMARY
VARC
4000
Updated Columns
 
Table_Name
Column_Name
From
To
C1_CS_REQ_TYPE_QUESTION
QUESTION_APPL_FLG
NULLABLE
NOT NULLABLE
C1_CS_REQ_SA_SP
USE_PCT
NUMBER(3,0)
NUMBER(5,2)
C1_RC_READ_GTT
USE_PCT
NUMBER(3,0)
NUMBER(5,2)
CI_BCHG_READ
USE_PCT
NUMBER(3,0)
NUMBER(5,2)
CI_BCHG_UP_READ
USE_PCT
NUMBER(3,0)
NUMBER(5,2)
CI_BSEG_READ
USE_PCT
NUMBER(3,0)
NUMBER(5,2)
CI_SA_SP
USE_PCT
NUMBER(3,0)
NUMBER(5,2)
C1_MKTMSG_CHG_DTL
MKT_PRICE_PER_UNIT
NUMB 15,2
NUMB 19,6
Dropped Columns
 
Table_Name
Column_Name
C1_CS_REQ_TYPE_QUESTION
C1_ANSWER_CD
C1_CS_REQ_TYPE_SVC_CRIT
START_SA_OVRD_SW
C1_CS_REQ_TYPE_SVC_CRIT
STOP_SA_OVRD_SW
C1_QUESTION_ANSWER
C1_ANSWER_STYLE_FLG
C1_QUESTION_ANSWER
CHAR_TYPE_CD
C1_CS_REQ_TYPE_QUESTION
C1_ANSWER_CD
New Indexes
 
Table_Name
Index_Name
CI_PREM
XM174S8
CI_CC
XT057S8
C1_ENRL_CONTDET
C1T011S2
CI_PAY_TNDR
XT265S8
C1_COLL_PROC_ARS_HIST
C1T164P0
C1_COLL_PROC_SA_ARS_HIST
C1T165P0
C1_COLL_PROC_SA_ARS_HIST
C1T165S1
C1_OD_PROC_ARS_HIST
C1T167P0
C1_SEV_PROC_ARS_HIST
C1T166P0
CI_CC_LOG
XT281S2
C1_OFFCYC_BGEN_BSEG
C1T160S1
C1_BI_BILL_OVERVIEW
C1T168P0
CI_PAY
XT156S4
C1_OUTAGE_EVT
C1T169P0
C1_OUTAGE_EVT
C1T169S1
C1_OUTAGE_EVT
C1T169S1
C1_OUTAGE_EVT_CHAR
C1T170P0
C1_OUTAGE_EVT_CHAR
C1T170S1
C1_PER_CONTDET
C1T009S3
CI_PER_PHONE
XM172S2
CI_PER
XM169S1
Other Database Changes
This release of Oracle Utilities Customer to Meter also includes the following database changes: