OBJECT_CHANGE_LOG
Definition
The OBJECT_CHANGE_LOG table contains the list of changes performed on objects, including
links to the related user operation and object snapshots
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
OBJECT_CHANGE_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The OBJECT_CHANGE_LOG table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique identifier of the object change log |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_OBJ_CHGLG_OID |
RECORDING_DATE
| Definition |
The date when the object change log was recorder |
| Type |
TIMESTAMP, NOT NULL |
| Available Index |
IX_OBJ_CHGLG_OID |
OBJECT_ID_PART_1
| Definition |
The first part of the object identifier of the object change log (will be NULL for
the object types that do not use this part)
|
| Type |
VARCHAR(256), NULL |
| Available Index |
IX_OBJ_CHGLG_OPDATE |
OBJECT_ID_PART_2
| Definition |
The second part of the object identifier of the object change log (will be NULL for
the object types that do not use this part)
|
| Type |
VARCHAR(256), NULL |
OBJECT_ID_PART_3
| Definition |
The third part of the object identifier of the object change log (will be NULL for
the object types that do not use this part)
|
| Type |
VARCHAR(256), NULL |
OBJECT_OID
| Definition |
The unique identifier of the object for this change log (will be NULL for technical
data which is unique in the SAP CC system)
|
| Type |
DECIMAL(28), NULL |
PARTITION_ID
| Definition |
The partition identifier of the object associated to the change log (will be set to
-1 for technical objects which are unique in the SAP CC system or for the objects
without partition identifier)
|
| Type |
DECIMAL(4), NOT NULL |
| Available Index |
IX_OBJ_CHGLG_OID |
OBJECT_TYPE
| Definition |
The type of the object for this change log |
| Format |
The possible values are:
0: Pricing Macro
1: Translation Table
2: Tier Table
3: Mapping Table Class
4: Mapping Table
5: Range Table Class
6: Range Table
7: Product
8: Offer
9: Chargeable Item Class
10: Charged Item Class
11: Charge Component
12: Charge Plan
13: Refill Item Class
14: Refill Record Class
15: Refill Logic
16: Refill Plan
17: Charged Item Mapping
18: Refill Record Mapping
19: Chargeable Item Mapping
20: User
21: Audit
22: Currencies
23: ISO4217 Currencies
24: Public Holidays
25: Counter Names Dictionary
26: Access
27: Subscriber Account
28: Charging Contract
29: Subscription
30: Subscriber Mapping Table
31: Subscriber Range Table
32: Charged Items Aggregation Policy
33: Allowance Plan
34: Allowance Logic
35: Allowance Interface
36: Allowance Event Class
37: Spending Status Description
38: Monitoring Plan
|
| Type |
DECIMAL(3), NOT NULL |
USER_OPERATION_OID
| Definition |
The unique identifier of the related user operation |
| Type |
DECIMAL(28), NULL |
| Available Index |
IX_OBJ_CHGLG_OPOID |
ACTION_TYPE
| Definition |
The type of action of the object change log |
| Format |
The possible values are:
0: Creation
1: Modification
2: Deletion
|
| Type |
DECIMAL(1), NOT NULL |
BEFORE_SNAPSHOT_OID
| Definition |
The unique identifier of the object snapshot before the change (NULL if the action
is a creation)
|
| Type |
DECIMAL(28), NULL |
AFTER_SNAPSHOT_OID
| Definition |
The unique identifier of the object snapshot after the change (NULL if the action
is a deletion)
|
| Type |
DECIMAL(28), NULL |
Index Details
The following database indexes are available in the
OBJECT_CHANGE_LOG database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_OBJ_CHGLG_OID
| Indexed Column(s) |
RECORDING_DATE,PARTITION_ID,OID |
| Unique |
Yes |
| Partitioned |
Yes |
| Tablespace |
OBJECT_CHANGE_INDX |
IX_OBJ_CHGLG_OPOID
| Indexed Column(s) |
USER_OPERATION_OID |
| Unique |
No |
| Partitioned |
No |
| Tablespace |
OBJECT_CHANGE_INDX |
IX_OBJ_CHGLG_OPDATE
