Table | Name | Description |
C1_CS_REQ_TYPE_REL_UPD | CS Request Type Related Update | Table used to store details about related updates associated with a customer service request type. |
C1_CS_REQ_TYPE_SVC_CRIT | CS Request Type Svc Criteria | Child table of Customer Service Request Type table, used to store criteria used by request types |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | CS Request Type Criteria Algorithm | Child table of CS Request Type Svc Criteria table, used to store algorithms used by request type criteria |
C1_CS_REQ_TYPE_SVC_CRIT_L | CS Request Type Criteria Language | Language table for CS Request Type Svc Criteria |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | CS Request Type Criteria SA Type | Child table of CS Request Type Svc Criteria table, used to store service agreement types used by request type criteria |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | CS Request Type Criteria Start Option | Child table of CS Request Type Criteria SA Type table, used to store service agreement type start opptions used by request type criteria |
Table_Name | Index_Name |
C1_CS_REQ_TYPE_REL_UPD | C1C173P0 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S1 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S2 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S3 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S4 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S5 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S6 |
C1_CS_REQ_TYPE_REL_UPD | C1C173S7 |
C1_CS_REQ_TYPE_SVC_CRIT | C1C168P0 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | C1C170P0 |
C1_CS_REQ_TYPE_SVC_CRIT_L | C1C169P0 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | C1C171P0 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | C1C172P0 |
Table_Name | Column_Name | Data Type | Data Length |
C1_CS_REQ_TYPE_REL_UPD | BO_XML_DATA_AREA | XML | 1073741824 |
C1_CS_REQ_TYPE_REL_UPD | BUS_OBJ_CD | CHAR | 30 |
C1_CS_REQ_TYPE_REL_UPD | CHAR_TYPE_CD | CHAR | 8 |
C1_CS_REQ_TYPE_REL_UPD | CS_REQ_TYPE_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_REL_UPD | CS_REQ_TYPE_REL_UPD | VARCHAR | 254 |
C1_CS_REQ_TYPE_REL_UPD | CS_REQ_TYPE_REL_UPD_SEQ | NUMBER | 3 |
C1_CS_REQ_TYPE_REL_UPD | FLD_NAME | CHAR | 30 |
C1_CS_REQ_TYPE_REL_UPD | REL_UPD_PROC_ALG_CD | CHAR | 12 |
C1_CS_REQ_TYPE_REL_UPD | SEQ_NUM | NUMB | 3 |
C1_CS_REQ_TYPE_REL_UPD | TBL_NAME | CHAR | 30 |
C1_CS_REQ_TYPE_REL_UPD | UPD_ELEM_XPATH | CHAR | 254 |
C1_CS_REQ_TYPE_REL_UPD | UPD_ENT_BUS_OBJ_CD | CHAR | 30 |
C1_CS_REQ_TYPE_REL_UPD | VERSION | NUMBER | 5 |
C1_CS_REQ_TYPE_SVC_CRIT | BO_XML_DATA_AREA | XML | 1073741824 |
C1_CS_REQ_TYPE_SVC_CRIT | BUS_OBJ_CD | CHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT | C1_ANSWER_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT | C1_QUESTION_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT | CRITERIA_BASIS_FLG | CHAR | 4 |
C1_CS_REQ_TYPE_SVC_CRIT | CRITERIA_COMPARISON_VALUE | VARCHAR | 254 |
C1_CS_REQ_TYPE_SVC_CRIT | CRITERIA_OPERATOR_FLG | CHAR | 4 |
C1_CS_REQ_TYPE_SVC_CRIT | CSRT_SEC_FALSE_FLG | CHAR | 4 |
C1_CS_REQ_TYPE_SVC_CRIT | CSRT_SEC_INSUFFICIENT_FLG | CHAR | 4 |
C1_CS_REQ_TYPE_SVC_CRIT | CSRT_SEC_TRUE_FLG | CHAR | 4 |
C1_CS_REQ_TYPE_SVC_CRIT | CS_REQ_TYPE_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT | ELIGIBILITY_CRITERIA_SEQ | NUMBER | 3 |
C1_CS_REQ_TYPE_SVC_CRIT | START_SA_OVRD_SW | CHAR | 1 |
C1_CS_REQ_TYPE_SVC_CRIT | STOP_SA_OVRD_SW | CHAR | 1 |
C1_CS_REQ_TYPE_SVC_CRIT | VERSION | NUMBER | 5 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | ALG_CD | CHAR | 12 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | ALG_ENTITY_FLG | CHAR | 4 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | CS_REQ_TYPE_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | ELIGIBILITY_CRITERIA_SEQ | NUMBER | 3 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | SEQ_NUM | NUMBER | 3 |
C1_CS_REQ_TYPE_SVC_CRIT_ALG | VERSION | NUMBER | 5 |
C1_CS_REQ_TYPE_SVC_CRIT_L | CS_REQ_TYPE_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT_L | DESCR100 | VARCHAR | 100 |
C1_CS_REQ_TYPE_SVC_CRIT_L | DESCRLONG | VARCHAR | 4000 |
C1_CS_REQ_TYPE_SVC_CRIT_L | ELIGIBILITY_CRITERIA_SEQ | NUMBER | 3 |
C1_CS_REQ_TYPE_SVC_CRIT_L | LANGUAGE_CD | CHAR | 3 |
C1_CS_REQ_TYPE_SVC_CRIT_L | VERSION | NUMBER | 5 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | CIS_DIVISION | CHAR | 5 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | CS_REQ_TYPE_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | DEFAULT_SW | CHAR | 1 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | ELIGIBILITY_CRITERIA_SEQ | NUMBER | 3 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | SA_TYPE_CD | CHAR | 8 |
C1_CS_REQ_TYPE_SVC_CRIT_SATY | VERSION | NUMBER | 5 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | CIS_DIVISION | CHAR | 5 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | CS_REQ_TYPE_CD | VARCHAR | 30 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | DEFAULT_SW | CHAR | 1 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | ELIGIBILITY_CRITERIA_SEQ | NUMBER | 3 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | SA_TYPE_CD | CHAR | 8 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | START_OPT_CD | CHAR | 12 |
C1_CS_REQ_TYPE_SVC_CRIT_STOP | VERSION | NUMBER | 5 |
C1_QUESTION | C1_ANSWER_STYLE_FLG | CHAR | 4 |
C1_QUESTION | CHAR_TYPE_CD | CHAR | 8 |
C1_CS_REQ_TYPE_QUESTION | DFLT_ANSWER | VARCHAR | 254 |
Table_Name | Column_Name | Old Data Type | New Data Type |
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) |