Customer-Related Database Changes
This chapter provides lists of customer-related database changes in the 22C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
C1_CS_REQ_TYPE_QSTN_RELOBJ
CS Request Type Question Related Object
Child of the CS Request Type Question table, used to store related objects
C1_CS_REQ_TYPE_QUESTION
CS Request Type Question
Used to store configuration data representing questions that can be asked as part of a request type
C1_CS_REQ_TYPE_QUESTION_REL
CS Request Type Question Relationship
Child of the CS Request Type Question table, used to store relationships between questions and other objects
New Indexes
 
Table_Name
Index_Name
C1_CS_REQ_TYPE_QSTN_RELOBJ
C1C167P0
C1_CS_REQ_TYPE_QSTN_RELOBJ
C1C167S1
C1_CS_REQ_TYPE_QUESTION
C1C165P0
C1_CS_REQ_TYPE_QUESTION
C1C165S1
C1_CS_REQ_TYPE_QUESTION
C1C165S2
C1_CS_REQ_TYPE_QUESTION_REL
C1C166P0
C1_MKTMSG_CHG_DTL
C1T137S5
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
C1_BI_FT_VW
XFER_TO_GL_DT
Date
10
C1_CS_REQ_TYPE_QSTN_RELOBJ
CS_REQ_TYPE_CD
VARCHAR
30
C1_CS_REQ_TYPE_QSTN_RELOBJ
MAINT_OBJ_CD
CHAR
12
C1_CS_REQ_TYPE_QSTN_RELOBJ
PK_VALUE1
VARCHAR
254
C1_CS_REQ_TYPE_QSTN_RELOBJ
PK_VALUE2
VARCHAR
254
C1_CS_REQ_TYPE_QSTN_RELOBJ
PK_VALUE3
VARCHAR
254
C1_CS_REQ_TYPE_QSTN_RELOBJ
PK_VALUE4
VARCHAR
254
C1_CS_REQ_TYPE_QSTN_RELOBJ
PK_VALUE5
VARCHAR
254
C1_CS_REQ_TYPE_QSTN_RELOBJ
QSTN_REL_OBJ_SEQ_NUM
NUMB
3
C1_CS_REQ_TYPE_QSTN_RELOBJ
QSTN_REL_OBJ_TYPE_FLG
CHAR
4
C1_CS_REQ_TYPE_QSTN_RELOBJ
QUESTION_APPL_FLG
CHAR
4
C1_CS_REQ_TYPE_QSTN_RELOBJ
SEQ_NUM
NUMB
3
C1_CS_REQ_TYPE_QSTN_RELOBJ
VERSION
NUMB
5
C1_CS_REQ_TYPE_QUESTION
BO_XML_DATA_AREA
XML
1073741824
C1_CS_REQ_TYPE_QUESTION
BUS_OBJ_CD
CHAR
30
C1_CS_REQ_TYPE_QUESTION
C1_ANSWER_CD
VARCHAR
30
C1_CS_REQ_TYPE_QUESTION
C1_QUESTION_CD
VARCHAR
30
C1_CS_REQ_TYPE_QUESTION
CS_REQ_TYPE_CD
VARCHAR
30
C1_CS_REQ_TYPE_QUESTION
CS_REQ_TYPE_QSTN_STAT_FLG
CHAR
4
C1_CS_REQ_TYPE_QUESTION
CUST_CL_CD
CHAR
8
C1_CS_REQ_TYPE_QUESTION
PERS_BUS_QSTN_APPL_FLG
CHAR
4
C1_CS_REQ_TYPE_QUESTION
QUESTION_APPL_FLG
CHAR
4
C1_CS_REQ_TYPE_QUESTION
QUESTION_PLACE_GRP
VARCHAR
254
C1_CS_REQ_TYPE_QUESTION
SEQ_NUM
NUMB
3
C1_CS_REQ_TYPE_QUESTION
SORT_SEQ5
NUMB
5
C1_CS_REQ_TYPE_QUESTION
VERSION
NUMB
5
C1_CS_REQ_TYPE_QUESTION_REL
C1_ANSWER_CD
VARCHAR
30
C1_CS_REQ_TYPE_QUESTION_REL
C1_QUESTION_CD
VARCHAR
30
C1_CS_REQ_TYPE_QUESTION_REL
CS_REQ_TYPE_CD
VARCHAR
30
C1_CS_REQ_TYPE_QUESTION_REL
REL_QSTN_SEQ_NUM
NUMB
3
C1_CS_REQ_TYPE_QUESTION_REL
SEQ_NUM
NUMB
3
C1_CS_REQ_TYPE_QUESTION_REL
VERSION
NUMB
5
C1_QUESTION_ANSWER
CHAR_TYPE_CD
CHAR
8