Commerce Service Center uses the following database tables to store audit logging information.
These tables are installed by the <ATG10dir>/CSC10.2/DCS-CSR/sql/
db_components/database-vendor
/DCS-CSR_logging_ddl.sql
script.
The tables described in this section are all used by the agent audit repository. The Nucleus component for this repository is /atg/agent/logging/AuditRepository
.
csr_grant_appease
This table stores log records about the granting of appeasements (store credits).
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
appeasement_id | varchar(40) | null | The ID of the store credit. |
amount | double precision | null | The amount of the store credit. |
csr_price_override
This table stores log records of manual price overrides.
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
order_id | varchar(40) | null | The ID of the order containing the price override. |
component_id | varchar(40) | null | The ID of the order component (item or shipping group) whose price was overridden. |
component_type | varchar(40) | null | The type of the order component whose price was overridden. Possible values: commerceItem, shippingGroup. |
old_price | double precision | null | The previous price of the item or shipping group. |
new_price | double precision | null | The new price of the item or shipping group. |
csr_order_event
This table stores log records about orders that have been modified.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
order_id | varchar(40) | null | The ID of the modified order. |
amount | double precision | null | The total cost of the order. |
csr_return_order
This table stores log records of returned orders.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
ret_req_id | varchar(40) | null | The ID of the return request. |
repl_order_id | varchar(40) | null | The ID of the replacement order (for an exchange). |
csr_recv_rtrn_item
This table stores log records of receipt of returned items.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
item_id | varchar(40) | null | The commerce item ID of the returned item. |
quantity | integer | null | The quantity of the item that was returned. |
csr_claim_item
This table stores log records of the claiming of coupons, gift certificates, and store credits.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
claimable_id | varchar(40) | null | The ID of the coupon, gift certificate, or store credit. |
claimable_type | varchar(40) | null | Type of item claimed (coupon, gift certificate, or store credit). |
csr_ci_event
This table stores log records about changes to the quantities of items in orders.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
item_id | varchar(40) | null | The ID of the commerce item whose quantity was changed. |
old_quantity | integer | null | The previous quantity of the item. |
new_quantity | integer | null | The new quantity of the item. |
csr_pg_event
This table stores log records about changes to payment groups in orders.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
pay_group_id | varchar(40) | null | The ID of the payment group that was changed. |
update_type | one digit | not null | The type of update performed. |
csr_split_sg
This table stores log records about splitting up items in orders among multiple shipping groups.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
src_ship_group_id | varchar(40) | null | The shipping group the item was moved from. |
dest_ship_group_id | varchar(40) | null | The shipping group the item was moved to. |
commerce_item_id | varchar(40) | null | The ID of the commerce item that was moved. |
quantity | integer | not null | The quantity of the item that was moved. |
csr_split_cc
This table stores log records about splitting up item costs among multiple cost centers.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of this log record. |
src_cost_ctr_id | varchar(40) | null | The cost center that the item’s costs were moved from. |
dest_cost_ctr_id | varchar(40) | null | The cost center that the item’s costs were moved into. |
commerce_ident_id | varchar(40) | null | The ID of the commerce item whose costs were moved. |
quantity | integer | not null | The quantity of the item whose costs were moved. |
csr_sg_event
This table stores log records about changes to shipping groups in orders.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
ship_group_id | varchar(40) | null | The ID of the shipping group that was changed. |
update_type | integer | not null | The type of update performed. |
csr_upd_props
This table stores log records about changes to properties of repository items.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
audit_id | varchar(40) | null | The ID of the log record this change is associated with. (For example, if the change is to a shipping group, this value is the ID of the log record in the csr_sg_event table.) |
property_name | varchar(40) | null | The name of the property that was modified. |
old_value | varchar(255) | null | The previous value of the property. |
new_value | varchar(255) | null | The new value of the property. |
version | integer | not null | The GSA version of the modified property. |
csr_order_comment
This table stores log records about order comments submitted by agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
comment_id | varchar(40) | null | The ID of the comment. |
csr_view_card
This table stores log records of agents viewing customers’ credit card information.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
cc_number | varchar(20) | null | The credit card number of the card that was viewed. |
csr_oma_event
This table stores log records about order adjustments submitted by agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
man_adj_id | varchar(40) | null | The unique ID of the manual adjustment. |
adjustment_type | Integer | not null | The type of adjustment. |
update_type | integer | null | The type of update performed. |
reason | one-digit | null | The reason for the adjustment |
csr_schd_event
This table stores log records of scheduled events.
Column | Data Type | Constraint | Description |
---|---|---|---|
id | varchar(40) | not null | The unique ID of the log record. |
sch_order_id | varchar(40) | null | The unique ID of the scheduled order. |
update_type | one-digit | not null | The type of update. |
csr_appr_event
This table stores log records about order approvals requested by agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
approval_id | varchar(40) | not null | The unique ID of the approval request. |
update_type | Integer | null | The type of update performed. |
csr_order_appr_event
This table stores log records about order adjustments requested by agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
order_id | varchar(40) | not null | The unique ID of the order. |
csr_grt_prom_event
This table stores log records about order promotions.
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
promo_id | varchar(40) | null | The unique ID of the promotion. |
csr_ign_prom_event
This table stores log records about order promotions.
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
promo_id | varchar(40) | null | The unique ID of the promotion. |
order_id | varchar(40) | null | The unique ID of the order. |
csr_gl_event
This table stores log records about gift list events.
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | not null | The unique ID of the log record. |
giftlist_id | varchar(40) | null | The unique ID of the gift list. |
event_name | varchar(64) | null | The type of event. |
csr_gi_event
This table stores log records about gift items
Column | Data Type | Constraint | Description |
---|---|---|---|
id (primary key) | varchar(40) | null | The unique ID of the log record. |
catalog_ref_id | varchar(40) | not null | The unique ID of the catalog. |
old_quantity | Integer | not null | The amount of the previous quantity. |
new_quantity | integer | not null | The amount of the new quantity. |