Oracle Utilities 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. It includes the following:
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 bill.
C1_OUTAGE_EVT
Outage Event
Used to capture outage event details.
C1_OUTAGE_EVT_CHAR
Outage Event Character
Used to capture outage event character details.
New Indexes
 
Table_Name
Index_Name
CI_PREM
XM174S8
CI_CC
XT057S8
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
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
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_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
Modified 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
Other Database Changes
This release of Oracle Utilities Customer Care and Billing also includes the following database changes: