Overview | Core Database Schema | All Tables All Columns

Table: OBJECT_CHANGE_LOG

Table Name OBJECT_CHANGE_LOG
Table Description The OBJECT_CHANGE_LOG table contains the list of changes performed on objects, including links to the related user operation and object snapshots.
Tablespace OBJECT_CHANGE_DATA
Database Core Database
Partitioned Yes
Columns
OID
RECORDING_DATE
OBJECT_ID_PART_1
OBJECT_ID_PART_2
OBJECT_ID_PART_3
OBJECT_OID
PARTITION_ID
OBJECT_TYPE
USER_OPERATION_OID
ACTION_TYPE
BEFORE_SNAPSHOT_OID
AFTER_SNAPSHOT_OID

Columns of the Table

The OBJECT_CHANGE_LOG database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Index(es) IX_OBJ_CHGLG_OID
IX_OBJ_CHGLG_OPOID
Column Description The unique identifier of the object change log


Column: RECORDING_DATE

Value Type DATE, NOT NULL
Index(es) IX_OBJ_CHGLG_OID
Column Description The date when the object change log was recorded


Column: OBJECT_ID_PART_1

Value Type VARCHAR(256)
Index(es) IX_OBJ_CHGLG_OPDATE
Column Description 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)


Column: OBJECT_ID_PART_2

Value Type VARCHAR(256)
Column Description 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)


Column: OBJECT_ID_PART_3

Value Type VARCHAR(256)
Column Description 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)


Column: OBJECT_OID

Value Type BIGINT
Column Description The unique identifier of the object for this change log (will be NULL for technical data which is unique in the system)


Column: PARTITION_ID

Value Type SMALLINT, NOT NULL
Index(es) IX_OBJ_CHGLG_OID
Column Description The partition identifier of the object associated to the change log (will be set to -1 for technical objects which are unique in the system or for the objects without partition identifier).


Column: OBJECT_TYPE

Value Type DECIMAL(3), NOT NULL
Column Description The type of the object for this change log. Possible values are:
  • 0: Pricing Macro
  • 1: Translation Table
  • 2: Tier Table
  • 3: Mapping Table Class
  • 4: Mapping Table
  • 7: Product
  • 8: Offer
  • 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
  • 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: Reserved for a future usage
  • 32: Charged Items Aggregation Policy


Column: USER_OPERATION_OID

Value Type BIGINT
Index(es) IX_OBJ_CHGLG_OPOID
Column Description The unique identifier of the related user operation


Column: ACTION_TYPE

Value Type DECIMAL(1), NOT NULL
Column Description The type of action of the object change log. Possible values are:
  • 0: Creation
  • 1: Modification
  • 2: Deletion


Column: BEFORE_SNAPSHOT_OID

Value Type BIGINT
Column Description The unique identifier of the object snapshot before the change (NULL if the action is a creation)


Column: AFTER_SNAPSHOT_OID

Value Type BIGINT
Column Description The unique identifier of the object snapshot after the change (NULL if the action is a deletion)


Top of the list


SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.